DotNet Studio - .NET Full Stack, Web, AI and Cloud learning platform

Ms SQL Server

C# is a modern, object-oriented, and type-safe programming language. C# enables developers to build many types of secure and robust applications that run in .NET

Last Update : 01/06/2026

17 Chapters 10 Hours

Getting Started with SQL Server

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

Master SQL Server database design and management.
Write optimized T-SQL queries for complex scenarios.
Implement security, backup, and recovery strategies.
Build high-availability and disaster recovery solutions.
Integrate SQL Server with .NET applications.
Optimize database performance and troubleshoot issues.
Prepare for SQL Server certification exams.

Total 0 Ratings

9000 ₹ 10000 ₹

Duration 10 Hours
Level Expert
Chapters 17 Chapters

Book a Demo

PostgreSQL
Price 9000 ₹
Mongo DB
Price 9000 ₹

Ms SQL Server

Releted Courses

PostgreSQL

Mongo DB

Useful Links

Support

Terms