Data Analysis: Investigate with SQL
Walter Shields runs through a made up investigation and uses SQL to solve the case in this LinkedIn Learning. Throughout this video, you are able to follow along and run the queries yourself alongside Shields. He goes over technical terms, while also showing them in use in the queries. Something new I learned from this LinkedIn Learning was the “LIMIT” clause used at the end of the first query that “limits the number of records displayed by the number you specify.” I also learned about the importance of manual data analysis and how it can be used with the results of your query. While a lot of the information stated in this LinkedIn Learning was information I had previously learned in MIS 2502, it was a good refresher on that information and it also allowed me to expand my knowledge of SQL. The exercise used in this LinkedIn Learning helped me improve my understanding of SQL, which well help be successful both in my future MIS classes and also in a professional career of data analysis.