✦ About Program
CERTIFICATE IN CERTIFICATE IN SQL SERVER is a comprehensive 3-month program (60 hours) designed to equip students with practical skills and industry-relevant knowledge. The curriculum covers fundamental to advanced concepts with hands-on training, assignments, and project work. Upon successful completion, students receive a recognized certificate certificate from TNCS Computer Education.
✦ Course Curriculum
1
Introduction to Databases & SQL Server
- Basics of Database & DBMS
- Types of Databases (RDBMS, NoSQL)
- Introduction to Microsoft SQL Server
- SQL Server Editions & Features
- Installation of SQL Server & SSMS
- Database Architecture (Tables, Rows, Columns)
2
SQL Fundamentals (T-SQL Basics)
- Introduction to SQL Language
- Types of SQL Commands: DDL (CREATE, ALTER, DROP) DML (INSERT, UPDATE, DELETE) DQL (SELECT) DCL (GRANT, REVOKE) TCL (COMMIT, ROLLBACK)
- Data Types in SQL Server
- Creating & Managing Databases
3
Working with Tables
- Creating Tables
- Constraints: Primary Key Foreign Key Unique, Not Null, Check
- Altering Tables
- Deleting Tables
4
SQL Queries & Data Retrieval
- SELECT Statement
- WHERE, ORDER BY, DISTINCT
- Logical Operators (AND, OR, NOT)
- Filtering & Sorting Data
- Aliases
5
Joins & Relationships
- Types of Joins: INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN
- Table Relationships
- Keys (Primary & Foreign Keys)
6
Functions & Aggregation
- Aggregate Functions: COUNT(), SUM(), AVG(), MIN(), MAX
- GROUP BY & HAVING
- String Functions
- Date Functions
7
Subqueries & Advanced Queries
- Subqueries
- Nested Queries
- Correlated Subqueries
- Common Table Expressions (CTE)
8
Indexes & Performance Optimization
- Types of Indexes
- Creating Indexes
- Query Optimization Techniques
- Execution Plans
9
Stored Procedures & Triggers
- Stored Procedures
- User Defined Functions (UDF)
- Triggers (INSERT, UPDATE, DELETE)
- Views
10
Transactions & Concurrency
- ACID Properties
- Transaction Control
- Locking & Isolation Levels
- Error Handling
11
Database Security
- User Authentication
- Roles & Permissions
- Encryption Basics
- SQL Injection Prevention
12
Backup & Recovery
- Backup Types
- Restore Database
- Disaster Recovery Techniques
13
SQL Server Tools & Utilities
- SQL Server Management Studio (SSMS)
- Import & Export Data
- SQL Server Agent
- Profiler & Monitoring Tools
14
Introduction to Business Intelligence (Optional Advanced)
- Basics of BI
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- Data Warehousing Concepts
15
Practical / Project Work
- Create Real-Time Database Project
- Employee Management System / Hospital DB
- Writing Complex Queries
- Report Generation