- : +91 9021525877
- : contact@dotnetstudio.com
Ms SQL Server
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
No reviews yet
Student feedback will appear here once reviews are available.

