Center for IT Education, Spoken English & CAD

SQL Training Course Syllabus

RDBMS Concepts
Introduction to RDBMS, The Role of data, DBMS Concepts, Relational Model, RDBMS & SQL Server, Designing a database, Entity relationship model/diagram, Tables
Introduction
What is SQL, why SQL, working with MySQL & SQL Server , SQL Server Architecture, Client/Server database system,
Basic Query
How to create / Drop database & Table, Data types in SQL,Select, Insert, delete, Update & alter
Operator & Functions
Working with Operator in SQL Query, Distinct , Between , Limit Keyword, auto increment, Using Aggregate functions in Queries, String Function in Queries
Managing Tables and Joins
Primary key,Foreign Key , Introduction to joins, types of join- inner join, outer join, self join & Join Relationship and Union
Various Clause
Where, Like, Order By, Group By , execute sql queries with various clause
Index & Views
What is index , create index, what is views, update view & drop views,
Implementing Stored Procedures
Introduction to variables, Stored Procedures, Defining Stored Procedures, Executing Stored Procedures, Using Parameters in Stored Procedures
Implementing Triggers
What is Triggers,Types of Triggers, Creating Triggers, Benefits & Limitations, Triggers and Performance
TCL Commands & Database Backup & Restore
Commit, Rollback, Savepoint SQL commands, Backup & Restored in SQL
Case study in SQL

01 Months ( 2 Hour Daily )
02 Months ( 1 Hour Daily )

10^th Qualified