SQL Training Institute in Hyderabad

Home
Courses

SQL Training course Curriculum

Our SQL course syllabus is framed by our Industry Expert Ms. Sridevi, This SQL course content covers all the Latest Topics from Basics to Advanced Level.

Module 1: Introduction to Basic Database Concepts
- Data, Information, Table, Field, Record.
- Database and database Types.
- Introduction to DBMS and RDBMS.
- Limitations of File Management System.
- Advantages of Data Base Approach.
- Understanding Client and Server Architecture.
- Database Administrator (DBA)
- Exploring Relational DBMS

Module 2: E-R Modelling and Normalization
- Attribute and Types of Attributes
- Entity and Types of Entity's
- Anomaly and Types of Anomalies
- Relationship and Types of Relationships
- Degree of Relationships and Types
- Key and Types of Keys
- ER-MODELS and Basic Symbols
- Conversion of E-R Diagrams into Tables
- Dependency and Types of Database Dependencies

Normalization:
- First Normal Form
- Second Normal Form
- Third Normal Form
- Boyce-Codd Normal Form (BCNF)
- Fourth Normal Form Practically Normalizing Tables

Module 3: Introduction to SQL
- What is SQL? Why SQL? History of SQL.
- How to Install and Run SQL[ORACLE]
- Datatypes in SQL
SQL Commands:
- DDL - Data Definition Language
- DML - Data Manipulation Language
- DCL - Data Control Language
- DQL - Data Query Language
- TCL - Transaction Control Language

Create Database using ORACLE
- SQL CREATE TABLE Statement
- SQL ALTER TABLE Statement
- SQL INSERT INTO Statement
- SQL UPDATE Statement
- SQL SELECT Statement
- Datatypes in SQL
- Creating Users & Roles
- Granting & Revoking of Roles & privileges

Module 4: INTEGRITY CONSTRAINTS
SQL Constraints
- NOT NULL Constraint
- DEFAULT Constraint
- Drop Default Constraint
- UNIQUE Constraint
- DROP a UNIQUE Constraint
- Primary Key
- Default Check Foreign Key

SQL Data Integrity
- Entity integrity
- Domain integrity
- Referential integrity
- Types of constraints
- Data Integrity

Module 5: Implementation of SQL Clauses and Data integrity
SQL Clauses
- SQL DISTINCT Clause
- SQL WHERE Clause
- SQL AND/OR Clause
- SQL IN Clause
- SQL BETWEEN Clause
- SQL Like Clause
- SQL ORDER BY Clause
- SQL GROUP BY Clause
- SQL COUNT Claus
- SQL HAVING Clause

Data integrity
- Entity integrity
- Domain integrity
- Referential integrity
- Types of constraints
- Data Integrity

Module 6: SQL Functions
Aggregate Functions
- AVG
- SUM
- MAX
- MIN
- COUNT

Scalar Functions
- Character functions
- Number (Numeric) functions
- Data functions
Conversion functions
- TO_CHAR
- TO_NUMBER
- TO_DATE

Module 7: Implementing SQL Views and SQL Indexes
- Introduction & Advantages of Views
- Creating, Altering, Dropping Views
- Inserting Rows into a View
- Deleting Rows into a View
- Dropping Views
- Advance Options while Creating a View
- SQL Views With CHECK OPTION

SQL Indexes
- The Create Index
- Single-Column Indexes
- Unique Indexes
- Composite Indexes
- Implicit Indexes
- Drop Indexes

Module 8: Sub Queries and Joins
SQL Sub Queries
- Single Row Sub Queries
- Multi Row Sub Queries
- Subqueries with the SELECT Statement
- Subqueries with the INSERT Statement
- Subqueries with the UPDATE Statement
- Subqueries with the DELETE Statement

Introduction to Joins and SQL Join Types
- Inner Join
- Outer Join
- Self - Join
- Left JOIN
- Right Join
- Full Join
- Cross Joins
- Set Operations using Unions, Intersect and Except

Module 9: Implementing Sequences and Synonyms
- SQL Using Sequences
- Using AUTO_INCREMENT column
- Obtain AUTO_INCREMENT Values
- Starting a Sequence at a Particular Value

Module 10: Table Alias, Triggers and Flashback and Purge Commands
- Table Alias
- Flashback
- Purge Commands

Triggers
- Introduction to triggers
- Constraints vs Triggers