Beginner

SQL Server Fundamentals

Build a rock-solid foundation in relational databases and SQL Server. Learn to write queries, manage data, and navigate SQL Server Management Studio with confidence.

🕒 8 Hours 📜 42 Lessons ★ 4.9/5 (1,240 reviews) 🎓 Certificate
$49
One-time payment • Lifetime access
  • 8 hours of video content
  • 42 hands-on lessons
  • Downloadable lab scripts
  • Practice datasets included
  • Certificate of completion
  • Community forum access
Enroll Now

30-day money-back guarantee

What You Will Learn

  • Understand relational database concepts and terminology
  • Install and configure SQL Server and SSMS
  • Write SELECT queries with filtering and sorting
  • Use JOINs to combine data from multiple tables
  • Aggregate data with GROUP BY and HAVING
  • Create and modify tables, views, and indexes
  • Insert, update, and delete data safely
  • Work with SQL Server data types effectively
  • Use built-in functions for strings, dates, and math
  • Write subqueries and common table expressions

Course Curriculum

Module 1: Introduction to Databases and SQL Server 5 lessons
  • What is a relational database?
  • SQL Server editions and choosing the right one
  • Installing SQL Server Developer Edition
  • Navigating SQL Server Management Studio
  • Creating your first database
Module 2: Writing Your First Queries 7 lessons
  • The SELECT statement explained
  • Filtering rows with WHERE
  • Sorting results with ORDER BY
  • Using DISTINCT and TOP
  • Comparison and logical operators
  • Working with NULL values
  • Lab: Querying an employee database
Module 3: Joining Tables 6 lessons
  • Understanding table relationships
  • INNER JOIN in practice
  • LEFT, RIGHT, and FULL OUTER JOINs
  • CROSS JOIN and self-joins
  • Joining more than two tables
  • Lab: Building a sales report with joins
Module 4: Aggregation and Grouping 5 lessons
  • COUNT, SUM, AVG, MIN, MAX
  • GROUP BY fundamentals
  • Filtering groups with HAVING
  • Combining aggregation with joins
  • Lab: Sales analytics dashboard queries
Module 5: Data Types and Table Design 6 lessons
  • Numeric, string, and date data types
  • Choosing the right data type
  • Creating tables with constraints
  • Primary keys and foreign keys
  • ALTER TABLE operations
  • Lab: Designing a product catalog schema
Module 6: Data Manipulation 5 lessons
  • INSERT statements and bulk inserts
  • UPDATE with conditions
  • DELETE vs TRUNCATE
  • Transaction basics (BEGIN, COMMIT, ROLLBACK)
  • Lab: Managing an inventory system
Module 7: Built-in Functions 4 lessons
  • String functions (LEN, SUBSTRING, REPLACE, CONCAT)
  • Date functions (GETDATE, DATEDIFF, DATEADD, FORMAT)
  • Mathematical and conversion functions
  • Lab: Data cleaning and transformation
Module 8: Subqueries and Views 4 lessons
  • Subqueries in WHERE, FROM, and SELECT
  • Correlated subqueries
  • Creating and using views
  • Final project: Complete reporting solution

Your Instructor

MR

Michael Roberts

Lead Instructor & Founder

Michael has over 20 years of experience as a SQL Server DBA and developer. A former Microsoft MVP, he has trained thousands of database professionals across Fortune 500 companies and startups alike. His teaching style focuses on practical, real-world skills you can apply immediately.

Prerequisites

This course is designed for complete beginners. All you need is:

Start Your SQL Server Journey Today

Join 3,200+ students who started here and built successful database careers.

Enroll for $49