SQL Course Syllabus

  1. Home
  2. Courses

SQL Training in Hyderabad

Curriculum

      • - 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
    • - 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
    • - Datatypes in SQL
    • - Creating Users & Roles
    • - Granting & Revoking of Roles & privileges
    • 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
    • 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
    • Aggregate Functions

    • -AVG , SUM, MAX, MIN, COUNT
    • Scalar Functions

    • - Character functions
    • - Number (Numeric) functions
    • - Data functions
    • ER-MODELS and Basic Symbols

    • - Conversion functions
    • - TO_NUMBER
    • - TO_DATE
    • - 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
    • - Implicit Indexes
    • - Drop Indexes
    • 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
    • - Full Join
    • - Cross Joins
    • - Set Operations using Unions, Intersect and Except
    • - SQL Using Sequences
    • - Using AUTO_INCREMENT column
    • - Obtain AUTO_INCREMENT Values
    • - Starting a Sequence at a Particular Value
    • - Table Alias
    • - Flashback
    • - Purge Commands
    • Triggers

    • - Introduction to triggers
    • - Constraints vs Triggers