PC Build

Basics

• Relational Databases
• Install SQL Server
• Basic SQL Statements
• SQL -DDL
• SQL -DML
• Basic Data Retrieval
• Simple Functions

Intermediate

• Joins
• Subqueries
• Common Table Expressions
• Filtering
• Grouping
• Views
• Transactions
• Indexing

Advanced

• Window Functions
• Stored Procedures
• Triggers
• Query Optimization
• Working with Different SQL Dialects