Course Duration - 30Days

Sql Course Contents

Session I
Introduction To Database
  • Data
  • Information
  • Differences Between Data and Information
  • Database
  • Database Management System
Session 2
Introduction To DBMS
  • Drawbacks of File System
  • Advantages of DBMS
  • Types of Databases
Session 3
Data Models
  • Data Model
  • Relational Data Model
  • Schema
Session 4
Introduction To ER Diagram
  • Entity
  • Entity Set
  • Attributes
Session 5
ER Diagrams
  • Relationship
  • Relationship Set
  • Entity-Relationship Diagrams
Session 6
Mapping Constraints
  • One-One Mapping
  • One-Many Mapping
  • Many-Many Mapping
Session 7
Converting ER Diagrams To Tables
  • Primary key
  • Foreign key
  • Relationship Between Tables
Session 8
Creating Relations Using SQL
  • Integrity Constraints
  • Key Constraints
  • Foreign Key Constraints
  • General Constraints
Session 9
Introduction To Views
  • Definition of a View
  • Need of a View
  • Creating a View
Session 10
Views
  • Differences between Table and a View
  • Complex Views
Session 11
DML
  • Dropping a Table
  • Deleting a Table
  • Differences Between Dropping and Deleting
  • Alter
  • Function and stored procedures prototypes
  • Passing arguments to functions and stored procedures
  • Recompiling functions and stored procedures
  • Pinning packages in the SGA with dbms_shared_pool.keep
  • Package forward declaration
  • Package dependency
  • Package overloading
  • Listing package information
Session 12
Introduction to Schema Refinement
  • Problems caused by Redundancy
  • Decomposition
  • Using cursor attributes
  • Analyzing impact of bulk operations
Session 13
Normalization
  • Atomic Domain
  • First Normal Form
  • Functional/ Partial Dependencies
  • Second Normal Form
Session 14
Normalization
  • Third Normal Form
  • Candidate Key
  • BCNF
Session 15
Basic Queries
  • Retrieving data between specified range
  • Retrieving data between a specific time period
  • order by clause
Session 16
Aggregate Operators
  • Count
  • sum
  • avg
  • max
  • min
Session 17
Joins
  • Inner Join
  • Outer Join
  • Retrieving data from multiple tables
Session 18
Group By and having Clause
  • Retrieving data by using Group by and Having Clause
  • aggregate operators in the select clause
Session 19
Nested Queries
  • Query inside another query
  • Null Values
Session 20
PL/SQL
  • Introduction To PL/SQL
  • Building Blocks of PL/SQL
  • Block Structure of PL/SQL
  • Variables and Constants
  • Declaration Block
  • Begin Block
  • Exception Block
  • Declaring Variables
  • Set ServerOutput On
Session 21
PL/SQL Control Structures
  • IF-THEN
  • IF-THEN-ELSE
  • IF-THEN-ELSEIF
Session 22
Iterative Control Structures
  • LOOPS
  • LABELLING LOOPS
  • WHILE-LOOP
  • FOR-LOOP
Session 23
PL/SQL Collections
  • Introduction
  • Abstract Datatypes
  • Creating Abstract Datatypes
  • Inserting Data Into Tables with Abstract Datatypes
  • Creating Nested Tables
Session 24
Cursors
  • Implicit Cursors
  • Explicit Cursors
  • Opening a Cursor
  • Deletion or Updation using Cursors
Session 25
Exception Handling
  • PreDefined Exceptions
  • User Defined Exceptions
  • Handling Exceptions
  • Raise_Application_Error
  • Reraising Exceptions
Session 26
Sub Procedures
  • Introduction to Sub-Procedures
  • PL/SQL Subprograms
  • Procedure
  • Parameter Modes
Session 27
Functions
  • Introduction to Functions
  • PL/SQL Functions
  • Function without Arguments
  • Function with Arguments
Session 28
Database Triggers
  • Introduction to Triggers
  • Types of Triggers
Session 29
Packages
  • Introduction to Packages
  • Package Specification
  • Package Body
  • Private and Public Items in Packages
  • Overloading Packages Subprograms

Enroll Here

Enroll First

Enroll to the desired course to learn by entering required details.

We will contact you ASAP

We will get in touch with you very soon, ASAP on phone or email.

Make Payment Online

You can make the payment online by the secure online payment gateway.

Attend Online Classes

Once we alright with things then we will setup the Online Class environment.