Need help choosing a course?Talk to us

Ms SQL Server

5.0 out of 5

Build a practical foundation in SQL Server. Design relational tables and write T-SQL queries. Use joins, stored procedures and indexes to work with business data. Explore database security, backup and recovery.

Last Update : 22/11/2026

Preview: Topics below are for preview only and may vary based on your course enrollment.

  • Introduction to SQL Server
  • SQL Server Architecture
  • Installation and Setup
  • Connecting to SQL Server

  • Creating Databases
  • Data Types in SQL Server
  • Creating and Managing Tables
  • Indexes and Keys

  • Basic SELECT Statements
  • WHERE Clause and Filtering
  • ORDER BY and DISTINCT
  • LIMIT and OFFSET (TOP)

  • INNER JOIN
  • LEFT, RIGHT, and FULL OUTER JOINs
  • CROSS JOIN and Self Joins
  • Multiple JOINs and Complex Queries

  • Aggregate Functions
  • GROUP BY Clause
  • HAVING Clause
  • GROUP BY with Multiple Columns

  • Scalar Subqueries
  • Multiple-Row Subqueries
  • Common Table Expressions (CTEs)
  • Derived Tables and Inline Views

  • INSERT Statements
  • UPDATE Statements
  • DELETE Statements
  • Transactions and Error Handling

  • Creating and Managing Views
  • Stored Procedures Basics
  • Control Flow in Stored Procedures
  • Functions and User-Defined Functions

  • Window Functions
  • PIVOT and UNPIVOT
  • Set Operations
  • Date and String Functions

  • Understanding Indexes
  • Query Execution Plans
  • Statistics and Query Hints
  • Performance Tuning

  • DML Triggers
  • DDL Triggers and Event Notifications
  • Full-Text Search
  • XML Support in SQL Server

  • Authentication and Logins
  • Database Users and Roles
  • Granting and Revoking Permissions
  • Encryption and Data Protection

  • Backup Strategies
  • Recovery Models
  • Database Restore Operations
  • Maintenance Plans and Health Checks

  • Introduction to Replication
  • Always On Availability Groups
  • Log Shipping and Mirroring
  • Monitoring Replication Health

  • ADO.NET and Connections
  • Entity Framework Core
  • Dapper and Micro-ORMs
  • Async Programming and Performance

  • SQL Server Agent and Jobs
  • Database Mail Configuration
  • Monitoring and Management
  • Troubleshooting Common Issues

  • Database Design Case Study
  • Performance Optimization Case Study
  • Migration and Upgrade Scenarios
  • SQL Server Best Practices

What you'll gain from Ms SQL Server

  • Turn business questions into reports with joins, aggregations and T-SQL.
  • Design relational databases and reusable stored procedures.
  • Improve queries with indexes and protect data with access, backup and recovery practices.
  • AI-assisted development: use AI tools to draft T-SQL queries and explore alternative query plans; review and test generated suggestions.
  • Security: apply least-privilege access and parameterized queries to protect business data.
  • Database: design SQL Server schemas, relationships and stored procedures.
  • Performance and optimization: use indexes and execution plans to investigate slow queries.
  • Deployment: plan database releases, schema migrations, backups and recovery.
  • Interview preparation: practise explaining concepts, solving technical problems and discussing practical examples from this course.
  • Salary increment opportunities: strengthen your case for a salary increase or a better-paying role with practical skills you can demonstrate.

Certificate preview

Sample
Sample certificate design with a placeholder recipient name
Sample certificate for illustration. View full size (opens in a new tab)

No reviews yet

Student feedback will appear here once reviews are available.