SkillManthan Logo - Best IT Training Institute in Lucknow
Loading your future skills...
+91-6392-361-443,+91-9120-341-047
theskillmanthan@gmail.com
Development Website
Our Placements Download Brochure
Register Now Skill Test
Verify Certificate Register Now
Download Courses - SkillManthan Technologies Pvt Ltd
MSSQL Course Banner

MS SQL Server (MSSQL)

Learn Microsoft SQL Server from basics to advanced — manage enterprise databases, write powerful queries, and handle large-scale data systems efficiently.

Course Description

This course provides in-depth knowledge of Microsoft SQL Server including database design, T-SQL programming, stored procedures, performance tuning, and real-world database management used in enterprise applications.

Detailed Course Syllabus

L.N. Contents Hours
1
  1. Introduction to Database & SQL Server
  2. DBMS vs RDBMS
  3. Installing SQL Server & SSMS
  4. Overview of SQL Server Tools
 2
2
  1. SQL Basics (T-SQL)
    • Data Types
    • CREATE, ALTER, DROP
    • Primary & Foreign Keys
 2
3
  1. Data Manipulation
    • INSERT
    • UPDATE
    • DELETE
    • SELECT Queries
 2
4
  1. Filtering & Sorting
    • WHERE Clause
    • ORDER BY
    • TOP Clause
 2
5
  1. Joins
    • INNER JOIN
    • LEFT JOIN
    • RIGHT JOIN
    • FULL JOIN
 2
6
  1. Aggregate Functions
    • COUNT, SUM, AVG
    • GROUP BY
    • HAVING
 2
7
  1. Views & Indexes
    • Creating Views
    • Clustered & Non-Clustered Index
    • Performance Basics
 2
8
  1. Stored Procedures & Functions
    • Creating Procedures
    • User Defined Functions
    • Triggers
 2
9
  1. Transactions & Error Handling
    • BEGIN, COMMIT, ROLLBACK
    • TRY...CATCH
 2
10
  1. Backup & Restore
    • Database Backup
    • Recovery Models
    • Restore Techniques
 2
11
  1. Security & User Management
  2. Final Project
  3. Interview Preparation
 2