SQL for Data Analysis

In today’s professional world, data influences nearly all of what we see, learn, or do. The ability to mine that data for insights proves not only an interesting specialty but a highly in-demand skill, sought after by employers in nearly all lines of work. SQL continues to be one of the most popular languages for handling data because of its straightforward syntax and design, but real world problems are rarely solved by the simple SELECT, FROM, WHERE commands found in introductory SQL materials. More complicated data analyses, like those covered by this course, can also be performed with SQL, saving time and computational resources while addressing more complicated problems.

Course instructor, Kimberly Fessel, helps you develop strategies for analyzing data directly with SQL, a language optimized for such calculations. Through concise demonstrations and interactive assessments, learn how to get the most out of SQL including how to query the results of a query, do advanced table joins, and aggregate over data partitions with window functions. If you’ve found that your work requires more advanced computations than your current SQL knowledge allows, or if you want to incorporate SQL into your current Python or R workflow, this SQL data analysis course is for you.

What you’ll learn and how to apply it

By the end of this course, the learner will be able to:

• Use SQL to clean data and perform advanced SQL joins.
• Query the results of a SQL query.
• Do complex aggregations over partitions of data.
• Determine when to use SQL versus other platforms for data analysis tasks and how to incorporate SQL commands into a Python or R workflow.

This course is for you because…

• You want to become more proficient working with data in SQL.
• You're an analyst or data scientist seeking to improve your SQL skills and to better incorporate it into your workflow.
• You're currently a professional who does some quantitative work but wants to move into a full-time data analyst or data scientist role.
• You often find yourself exporting data from SQL to analyze it with some other programming language like Python or R.

Prerequisites:

• General knowledge about what SQL is, why it is used, and how it can be applied to create, read, update, and delete data
• Familiarity with basic SQL query commands (SELECT, FROM, WHERE, etc.)
• The ability to perform basic SQL joins including inner, outer, and left joins
• Access the course Github repository for the course database and database diagram