Learn SQL Server

Learn the fundamentals of querying data with SELECT in SQL Server, including column selection, aliases, and TOP clauses.

Master the WHERE clause to filter rows using comparison operators, LIKE, IN, BETWEEN, and NULL checks.

Learn how to add, modify, and remove data in SQL Server tables using DML statements.

Understand how to define tables with columns, data types, primary keys, and constraints in SQL Server.

Learn INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN to combine data from multiple tables.

Aggregate data with GROUP BY and filter grouped results using HAVING for powerful data summaries.

Create reusable T-SQL stored procedures with parameters, variables, and error handling.

Explore essential string functions like LEN, SUBSTRING, CHARINDEX, REPLACE, CONCAT, and STRING_AGG.

Handle date and time values with GETDATE, DATEADD, DATEDIFF, FORMAT, and date type conversions.

Improve query performance with clustered, non-clustered, and covering indexes in SQL Server.

Create views to simplify queries and triggers to automate actions on data changes.

Master ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, and running totals with OVER clauses.

Use Common Table Expressions for readable queries and recursive CTEs for hierarchical data.

Read and interpret execution plans to identify bottlenecks, missing indexes, and optimize queries.

Build and execute dynamic T-SQL safely with sp_executesql, parameterized queries, and best practices.