Introduction to SQL Server
- Overview of SQL Server architecture and tools.
- Database design principles.
- Data types and table structures.
Querying and Manipulating Data
- SELECT statements with filtering, sorting, and grouping.
- Advanced JOINs and subqueries.
- Data modification: INSERT, UPDATE, DELETE.
Programming Constructs
- Stored procedures and parameterized queries.
- User-defined functions (scalar and table-valued).
- Triggers for event-driven programming.
Error Handling and Transactions
- TRY...CATCH blocks for error handling.
- Transaction management: COMMIT, ROLLBACK, and SAVEPOINT.
Advanced SQL Programming
- Common Table Expressions (CTEs).
- Recursive queries.
- Dynamic SQL execution.
- Window functions for analytical queries.
Performance Tuning and Optimization
- Indexing strategies and query execution plans.
- Identifying and resolving performance bottlenecks.
- Best practices for efficient database design.
Real-World Applications
- Developing and deploying stored procedures.
- Handling large datasets with SQL.
- Integrating SQL Server with application code.
Capstone Project
- Build a database application with optimized SQL Server programming.
- Present and discuss solutions with peers and instructors.
  
  Duration
  - 4–6 weeks (adjustable based on class schedule).

Reviews (50)