Welcome to the SQL Course!
In this course, we will be practicing using Microsoft SQL Server, and you need to download SSMS (Microsoft SQL Server Management Studio) to connect to the database and practice SQL with me throughout the course.
All chapters will utilize a very simple dataset that I've created specifically for this course, covering all the functions and concepts you'll learn (See Download Course Data).
Only for the last chapter SQL Analytical Project we need to work with a larger dataset, and there is nothing better than using the sample database from Microsoft AdventureWorks. It is a large dataset that is very similar to real projects (See Download Project Data).
Throughout the course, you will learn, step by step, how to download and install SSMS and how to import the databases. Please place the files in the following path. It should work if you downloaded the same version, and you didn't change the installation path, otherwise, you have to find the path on your own 😅
Note: Make sure to place the downloaded databases in the following path:
C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Backup
Download SQL Server Express (Free), which is the server where the database will live.
Download SSMS (Microsoft SQL Server Management Studio) which is graphical user interface for interacting with a database.
Download the Sales Dataset. It is a straightforward dataset designed for practicing SQL throughout the entire course.
Data Model of Sales dataset that is used in all chapters.
Download Sales Dataset. It is very simple dataset to practice SQL functions and task through the whole course.
Data Model of Microsoft AdventureWorks data warehouse database.
Data Model of Microsoft AdventureWorks OLTP database.