SQL Server for Beginners | A Complete Guide | Theory, Set Up, Practice Datasets & Querying

A complete guide to SQL for beginners: this tutorial can act as a one stop shop for understanding SQL background, how to actually start writing SQL in a database management system, getting a huge array of free data that simulates real world datasets & data models and learning the core and most widely used SQL querying functionality, as well as creating your own tables.

The specific areas I cover in this ~3 hour tutorial are as follows:

- What is SQL?
- What is SQL Server?
- Getting Started with SQL Server & SQL Server Management Studio (SSMS)
- Downloading & Importing the AdventureWorks sample database (over 50 tables)
- Navigating SSMS
- Functions for selecting, filtering and ordering data from your database
- Sampling data, commenting your code and working with NULL values
- Essential string functions
- Mathematical Operators
- Conditional logic using the CASE expression
- Grouping, aggregating, subqueries
- Creating tables and inserting & updating data

These concepts will be cemented with real world examples and commentary around applying this knowledge to data roles.

Enjoy!

🤝 Want 1:1 mentorship, data career guidance or interview prep?

🤝 Connect with me on LinkedIn:

[thatnumbersgirl]

Thank you James! Time stamps would be amazing for this video!

[JimRohn-uc]

This is amazing! I hope you make one of these for PostgreSQL too! It’s starting to get used a lot for many Applications.