✦ About Program
CERTIFICATE IN CERTIFICATE IN SQL SERVER LITE is a comprehensive 1-month program (30 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 Database
- Basics of DBMS
- Types of Databases
- Introduction to SQL Server
- Installation of SQL Server & SSMS
2
SQL Basics
- SQL Commands: DDL (CREATE, ALTER, DROP) DML (INSERT, UPDATE, DELETE) DQL (SELECT)
- Data Types
- Creating Database & Tables
3
Data Handling
- INSERT, UPDATE, DELETE
- SELECT Queries
- WHERE Clause
- ORDER BY
- DISTINCT
4
Joins & Functions
- Joins: INNER JOIN LEFT JOIN
- Aggregate Functions: COUNT(), SUM(), AVG()
- GROUP BY
5
Intermediate Concepts
- Subqueries
- Views
- Basic Index Concept
- Introduction to Stored Procedures
6
Practical & Mini Project
- Create Small Database Project
- Writing Real-time Queries
- Data Analysis Practice