Microsoft SQL Server Intermediate Course

Duration: 6 weeks

Price: $150 regular price, $100 sale price

Level: Intermediate

This practical course helps learners move beyond basic SQL and build stronger database solutions using joins, grouping, reusable database objects, transactions, and reporting queries.

Course Outline

• Review of SQL Server fundamentals
• Advanced joins: self join, cross join, full outer join, and multi-table joins
• Grouping data with GROUP BY and HAVING
• Subqueries and nested queries
• Common Table Expressions, also called CTEs
• Views and practical reporting use cases
• Stored procedures with parameters
• User-defined functions
• Transactions, TRY CATCH, and error handling
• Indexes and query performance basics
• Data normalization and relationship design
• Backup and restore basics
• Users, roles, and permissions
• Project: sales reporting database

What You Shall Learn

• How to write professional multi-table queries
• How to summarize and report data accurately
• How to use views, stored procedures, functions, and CTEs
• How to protect data changes with transactions
• How indexes affect performance
• How to build a practical SQL Server reporting database