Microsoft SQL Server
Full Microsoft SQL Server course — 58 topics from the basics to advanced use.
Lessons
- JSON, XML and Special Data Types
- Temporal, Ledger and Graph Tables
- Change Tracking and Change Data Capture
- Full-Text Search
- Sequences, Synonyms and Other Objects
- Storage Internals and Architecture
- Indexing in Depth
- Statistics
- Execution Plans and Query Tuning
- Query Store and Intelligent Query Processing
- Partitioning
- Columnstore Indexes
- In-Memory OLTP
- TempDB
- Introduction to Databases and SQL Server
- Installation, Tools and Environment Setup
- Creating and Managing Databases
- Data Types
- DDL: Tables and Constraints
- DML: Inserting, Updating and Deleting Data
- Basic Querying with SELECT
- Built-in Functions
- Security
- Backup and Restore
- High Availability and Disaster Recovery
- Replication
- SQL Server Agent and Automation
- Monitoring and Troubleshooting
- Database Maintenance and DBCC
- Resource Governor and Server Configuration
- Data Integration
- Business Intelligence Stack
- SQL Server on Linux and Containers
- Azure SQL and Microsoft Fabric
- What's New in SQL Server 2022 and 2025
- Database DevOps, Testing and Source Control
- Application Connectivity
- Best Practices and Coding Standards
- Appendices: Projects, Interview Questions, Cheat Sheet & Certification
- Aggregation and Grouping
- Joins
- Set Operators
- Subqueries
- Common Table Expressions (CTEs)
- Window Functions
- PIVOT, UNPIVOT and Data Reshaping
- Views
- Database Design and Normalization
- T-SQL Programming Fundamentals
- Stored Procedures
- User-Defined Functions
- Triggers
- Error Handling
- Transactions
- Concurrency, Locking and Isolation Levels
- Cursors
- Dynamic SQL
- Course Overview