COURSES

SQL

Course Highlights
Category
IT
Schedule
Flexible
Level
Advanced
Duration
1 Month
Price
₹17000 ₹15000
SQL

Best SQL training in Chennai

Module 1: Introduction

  • Understanding SQL Server

  • SQL Server Version History

  • Advantage of SQL Server

  • DBMS and RDBMS

Module 2: Types of SQL Commands

  • Creating Database

  • Altering Database

  • Deleting Database

  • Creating Table

  • Altering Table

  • Deleting Table

Module 3: SQL Keys, Commands and Clauses

  • Types of SQL Keys

  • Using SQL Commands

  • SQL Operators

  • SQL Clauses

  • DDL & DML

  • TCL & TQL

  • Querying Database

  • Delete vs. Truncate

Module 4: SQL Joins

  • Types of Joins

  • Inner Join

  • Outer Join

  • Cross Join

  • Self-Join

Module 5: Views

  • Understanding Views

  • Need of Views

  • Creating, Altering and Dropping Views

  • Simple and Complex Views

 

Module 6: Functions

  • Built-In Functions

  • Scalar Functions

  • Aggregate Functions

  • Creating, Altering and Dropping Fun

  • Single row function

  • Multi row function

Module 7: Stored Procedures

  • Creating, Altering and Dropping Procedure

  • Optional Parameters

  • Input and Output Parameters

Module 8: Triggers

  • Understanding Triggers

  • Stored Procedures VS Functions VS Triggers

  • Types of Triggers

  • Creating, Altering and Dropping Triggers

Module 9: Normalization

  • Normalization of Database Concept

  • First Normal Form (1NF)

  • Second Normal Form (2NF)

  • Third Normal Form (3NF)

  • Boyce-Codd Normal Form (BCNF)

  • Fourth Normal Form (4NF)

  • Fifth Normal Form (5NF)

 

Back to Courses
DEMO