SQL and SQL Server for Beginners - Learn SQL from Scratch!

Name: SQL and SQL Server for Beginners - Learn SQL from Scratch!
Rating: 4.4 (28 reviews)

Master Microsoft SQL Server. Go from beginner to designing databases, writing queries, and building real projects.

Created byCloud Trader Academy

Last updated 7/2026

English

English [Auto],

What you'll learn

Install, set up, and configure SQL Server and SQL Server Management Studio
Create your own databases, tables, schemas, and relationships
Insert, update, and delete data to manage database content
Import sample databases into SQL Server for hands on practice
Query data using SELECT, FROM, WHERE, ORDER BY, GROUP BY, and HAVING
Join multiple tables using INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and UNION
Use aggregate functions such as COUNT, SUM, AVG, MIN, and MAX to analyze data
Write advanced queries using Common Table Expressions and Views
Build and filter reports with GROUP BY and HAVING conditions
Modify database structures using ALTER TABLE and other DDL commands
Delete tables, rows, and entire databases safely and correctly
Understand database concepts that support data analysis, BI, and software development

Course content

5 sections • 42 lectures • 9h 2m total length

Introduction to the Course9:22
Intro to our Tech Stack (SQL Server and SSMS)6:43
What is a Database & Relational vs Non-Relational Databases28:02
Define what a database is and contrast relational and non-relational databases. See how tables, columns, rows, and keys—primary and foreign—shape data in SQL Server using SSMS.
Join the Discord!0:03
Access all Cloud Trader Academy Tech Courses Here0:09

Navigating SSMS - Watch if new to SSMS11:40
Heads up on Case Sensitivity in SSMS0:27
Learning SELECT with Alias's and FROM statements16:06
Practice SELECT & FROM Statements0:07
SELECT & FROM Statements Solution4:27
WHERE Statement Part 1 (Operators =, >, <, <>, >=, <=, NOT IN)20:59
WHERE Statement Part 2 (Continued AND, OR, LIKE)27:26
WHERE Statement Part 3 (IS NULL / Handling NULL's)6:47
DISTINCT SELECT and FROM with WHERE5:17
Learn to use distinct with select from where to return unique values and avoid duplicates, including card type, card number, and expiration year and month for unique rows.
Sorting Data with ORDER BY (and using the Format function)13:45
Grouping Data with GROUP BY and Aggregate Functions (SUM and COUNT)36:42
Explore grouping data with group by and aggregate functions in SQL Server, using sum, count, min, max, and average to compute revenue per product, distinct territories, and inventory by location.
Grouping Data with GROUP BY and Aggregate Functions (AVG, MIN, and MAX)22:24
Using the HAVING keyword with Aggregate Functions35:26
Let's Explore what Joins are (Inner, Left/Right, Outer, etc.)22:37
Learn how to join two tables using left, right, inner, and full outer joins and union. See how employee and department tables yield department names or nulls in the result.
Joining Tables with INNER JOIN43:17
Master inner joins in SQL Server by joining sales order detail with product data, selecting specific fields, using aliases, and understanding how product ID links the tables.
Left and Right Joins16:26
Full Outer Joins11:22
Master full outer joins, a union of left and right joins, returning all rows from two tables and filling unmatched cells with nulls, using examples of customers, orders, and products.
Combining Results with UNION16:40

Introduction to Database Design (Theory Essentials)15:20
Link to dbdiagram
Building an ERD (Entity Relationship Diagram)23:25
Microsoft Documentation on Creating Tables and Databases0:04
Creating Your First Database (SSMS GUI and T-SQL)6:17
Creating Tables (SSMS GUI and T-SQL)13:50
Create tables using the GUI or using SQL
Adding Constraints to our Tables and Altering/Dropping our Tables9:50
Inserting, Updating, and Deleting Data in our Tables17:01
Planning the Ski & Snowboard Shop Database (Creating our ERD)16:20
Creating All Final Project Database and Tables (Step-by-Step)8:33
If you mess up your Data Insertion, follow this guide.1:00
Entering Data & Querying our Tables12:51
Enter data into a SQL Server database and practice querying across multiple tables with joins, using a practical final project for a snowboard and ski shop dataset.
Congratulations!0:18

Requirements

This is for complete beginners, basic knowledge on Databases is helpful but not necessary.

Description

Are you ready to step into the world of data and master Microsoft SQL Server from scratch?

Data is the backbone of modern technology, and SQL is the most critical skill required to interact with it. This comprehensive, project-based course transforms you from a complete beginner into a confident, job-ready data professional. You won't just memorize commands or copy syntax; you will step into the shoes of a Database Administrator and Data Analyst to solve real-world business problems from day one.

We start at the absolute beginning by setting up your environment with SQL Server Management Studio. From there, you will learn how databases operate behind the scenes and quickly progress to writing production-grade queries.

What You Will Master in This Course:

Real-World Database Design: Build fully functional relational databases from the ground up and master Entity-Relationship Diagrams (ERDs) to structure data efficiently.
Advanced Querying Skills: Learn how to filter, aggregate, sort, and manipulate complex data cleanly using industry-standard best practices.
Complex Data Joining: Seamlessly combine data across multiple tables using various JOIN operations to extract deep business insights.
Hands-On Portfolio Experience: Apply everything you learn immediately through practical, real-world SQL Server projects that you can confidently showcase to employers.

Stop guessing your way through data or feeling intimidated by databases. Whether you are looking to advance your current career, break into tech, or build backend systems, this course gives you the practical SQL skills required to build, manage, and query databases with absolute confidence. Enroll today and take control of your data journey!

Who this course is for:

This is for complete beginners to SQL and SQL Server

SQL and SQL Server for Beginners - Learn SQL from Scratch!

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 44min

Databases & SQL Fundamentals & Environment Setup4 lectures • 32min

Writing SQL Queries: Beginner to Intermediate18 lectures • 5hr 12min

Writing SQL Queries: Advanced SQL2 lectures • 30min

Building a Complete SQL Database From Scratch (Ski & Snowboard Shop Project)13 lectures • 2hr 5min

Requirements

Description

Who this course is for: