SQL for Data Analysis – with SQL Server

The most direct path to mastering the SQL skills you'll actually use on the job

Created by: Travis Cuzick
Data Solutions Engineer

What Will I Learn?

• Use SQL to apply complex criteria and transformations to database data
• Master SQL functions for sophisticated data manipulation
• Leverage an understanding of relational database design to link together data stored across multiple tables
• Use aggregate queries to produce summarized views and analysis
• Be comfortable putting SQL and SQL Server on your resume
• Gain experience with the kind of SQL coding problems you are likely to encounter in an interview

Requirements

• Access to a Windows 10 operating system (SQL Server only runs on Windows); there are known compatibility issues between Windows 11 and SQL Server 2019, so I STRONGLY recommend Windows 10 for this course. If you only have access to a Windows 11 machine, you can install SQL Server 2022 instead.
• Microsoft SQL Server 2019 and SQL Server Management Studio; these are both available for free, and I’ll walk you through installation and setup.

Target audience

• Aspiring Data Analysts or Business Intelligence Analysts looking to break into these fields by learning SQL
• Data Scientists trying to improve their data cleaning and transformation skills by learning SQL
• Non-technical business professionals such as business analysts and project managers trying to gain a better understanding of the technical domains they interact with