From zero to confident. Install SQL Server & SSMS, write T-SQL, design tables, optimize queries, and manage databases—explained like you're 5, with animations, screenshots, and hands-on practice!
12 teaching modules, 5 practice files, and a free course practice. Meet SQL Server is free. The other teaching pages are Pro.
What is SQL Server? Install it, open SSMS, create your first database.
What is a database? What is SQL Server? Editions (Developer, Express, Enterprise), DDL/DML/TCL, and why companies use it.
Download SQL Server Developer/Express and SQL Server Management Studio. Install step-by-step, connect for the first time.
Object Explorer, query window, Execute button. Create your first database and run your first T-SQL command.
Data Definition (DDL), Data Manipulation (DML), and Transaction Control (TCL). The three languages of SQL.
Create tables, run SELECT queries, filter and sort, then join tables together.
CREATE TABLE, column names, data types (INT, VARCHAR, DATE, DECIMAL), PRIMARY KEY, and NOT NULL.
Query data with SELECT, filter with WHERE, sort with ORDER BY. Comparison operators and multiple conditions.
INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN. Combine data from multiple tables with keys.
COUNT, SUM, AVG, MIN, MAX. Group results with GROUP BY and filter groups with HAVING.
Subqueries, CTEs, indexes, and performance tuning.
Nested queries, WITH (Common Table Expressions), and readable complex queries.
What are indexes? Clustered vs nonclustered. When to add them and how to measure query performance.
Backup, restore, and secure your databases.
Full backup, differential, log backup. Restore to a point in time. Best practices.
Logins, users, roles. Grant and revoke permissions. Windows vs SQL authentication.
Test your knowledge with 60+ questions covering every module. Earn your SQL Server certificate!
60+ questions across all 12 modules. Practice mode, timed exam, and instant scoring. 70% to pass!
Start from Module 1 and work your way through. Each module has Learn, Visual, Code, Practice, and Quiz tabs to keep you engaged!
Begin Module 1