Microsoft SQL Server – DBA & T-SQL Development

Module 1: Introduction to Microsoft SQL Server

• SQL Server overview: editions, components, and use cases
• SQL Server architecture: database engine, SQL Agent, and SSRS
• Installing SQL Server and SSMS: configuration and initial setup
• SQL Server databases: system and user databases overview

Module 2: T-SQL Fundamentals

• SELECT: filtering, sorting, and aliasing result sets
• Joins: INNER, LEFT, RIGHT, FULL OUTER, and CROSS joins
• Aggregation: GROUP BY, HAVING, COUNT, SUM, AVG, MIN, and MAX
• Subqueries and CTEs: correlated subqueries and WITH clause

Module 3: Advanced T-SQL

• Window functions: ROW_NUMBER, RANK, DENSE_RANK, and NTILE
• LEAD, LAG, FIRST_VALUE, and LAST_VALUE analytical functions
• PIVOT and UNPIVOT: rotating data for reporting
• Dynamic SQL: building and executing SQL strings with EXEC and sp_executesql

Module 4: Stored Procedures, Functions, and Triggers

• Stored procedures: creating, altering, and executing with parameters
• User-defined functions: scalar, inline table, and multi-statement table UDFs
• Triggers: AFTER and INSTEAD OF triggers for DML and DDL events
• Error handling: TRY-CATCH, RAISERROR, and THROW in T-SQL

Module 5: SQL Server Administration

• Database creation: filegroups, data files, and log file configuration
• Logins and users: SQL Server and Windows authentication
• Roles and permissions: fixed server roles, database roles, and GRANT
• SQL Server Agent: creating and scheduling jobs and alerts

Module 6: Indexing and Query Optimisation

• Index types: clustered, non-clustered, filtered, and columnstore indexes
• Execution plans: reading and interpreting graphical execution plans
• Query optimisation: index hints, statistics, and query rewrites
• Database Engine Tuning Advisor: automated index recommendations

Module 7: Backup, Recovery, and High Availability

• Backup types: full, differential, and transaction log backups
• Restore strategies: point-in-time and tail-log restore
• Always On Availability Groups: HA and DR with readable secondaries
• Database mirroring and log shipping: legacy HA technologies

Module 8: Capstone Project and Assessment

• T-SQL development: stored procedures, functions, and triggers project
• Query optimisation: indexing and execution plan analysis exercise
• Backup strategy and Always On Availability Group configuration
• Final assessment and course certification

Experience in the Industry Learn from Microsoft SQL Server DBAs and T-SQL developers who have designed and managed SQL Server databases for ERP, CRM, data warehousing, and OLTP applications across retail, finance, and healthcare sectors.

Backgrounds at the Top Our SQL Server trainers have worked at Microsoft partner organisations and enterprise database teams managing large SQL Server estates with high availability, performance tuning, and security requirements.

Clear & Effective Teaching SQL Server architecture, T-SQL fundamentals, advanced SQL, stored procedures, indexing, query optimisation, backup and recovery, and Always On Availability Groups are explained with real DBA and development examples.

Hands-On Learning Focus Students write T-SQL queries, build stored procedures and functions, create indexes, read execution plans, configure backups, and set up Always On through structured hands-on SQL Server lab exercises.

Up-to-Date Knowledge Trainers keep content current with the latest SQL Server and Azure SQL releases, Azure SQL Managed Instance, and evolving Microsoft database administration and T-SQL development best practices.