SQL Server

SQL Server

Starts From 31st March

Morning

10:00 AM & 11:00 AM Batches

Starts From 28th March

Evening

07:00 PM & 08:00 PM Batches

Database Management
  • Introduction to Relational Databases
  • Understanding SQL Server Architecture
  • Installing SQL Server
  • SQL Server Editions and Features
  • Creating and Managing Databases
  • Managing Tables, Views, and Indexes
  • Data Types in SQL Server
  • Constraints and Keys
  • Transactions and Concurrency
  • Database Snapshots
  • Data Compression and Partitioning
  • Database Backup and Restore
  • Database Mirroring
  • Replication
  • AlwaysOn Availability Groups
  • SQL Server Agent (Jobs and Alerts)
  • Managing Database Security
SQL Language Fundamentals
  • SQL Syntax and Statements
  • Data Query Language (SELECT, FROM, WHERE, JOIN)
  • Data Manipulation Language (INSERT, UPDATE, DELETE)
  • Data Definition Language (CREATE, ALTER, DROP)
  • Working with Functions and Operators
  • Working with Functions and Operators
  • Common Table Expressions (CTEs)
  • Understanding Indexes and Performance Optimization
  • Query Execution Plans
  • Stored Procedures and Functions
  • Triggers and Cursors
  • Dynamic SQL
Advanced SQL Server Concepts
  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Reporting Services (SSRS)
  • Full-Text Search
  • CLR Integration
  • Spatial Data and Geographical Information Systems (GIS)
  • Temporal Tables
  • In-Memory OLTP (Hekaton)
  • JSON Support
  • Graph Databases
Development Tools and Utilities
  • SQL Server Management Studio (SSMS)
  • SQL Server Data Tools (SSDT)
  • SQLCMD and BCP Utilities
  • SQL Server Profiler
  • Extended Events
  • Database Mail and Alerts
  • SQL Server PowerShell
  • Performance Monitor (PerfMon)
  • Dynamic Management Views (DMVs) and Functions (DMFs)
Cloud and Hybrid Solutions
  • Azure SQL Database
  • SQL Server on Azure Virtual Machines
  • Azure SQL Managed Instance
  • SQL Server Stretch Database
  • Hybrid Deployments with Azure Arc
Best Practices and Performance Tuning
  • Database Design Principles
  • Normalization and Denormalization
  • Optimizing SQL Server Configurations
  • Indexing Strategies
  • Query Optimization Techniques
  • Monitoring and Troubleshooting Performance Issues
  • High Availability and Disaster Recovery Strategies
  • Security Best Practices
Certification and Training Resources
  • Microsoft SQL Server Certifications (e.g., MCSA, MCSE)
  • Online Courses and Tutorials
  • Books and Documentation
  • User Communities and Forums
Download PDF
Software File