eglobalsystems_logo

plsql online training

 eglobalsystems

 

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

Session 12

Introduction to Schema Refinement

  • Problems caused by Redundancy
  • Decomposition

 

 

 

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

         

 

  • Thanks, for helping me in gaining the knowledge in ASP.NET. By Your method of teaching in easy and simple manner it has been easy for me to understand now if not, I would never have understood the concept.-suriigisrinivas@gmail.com

  • The training recieved from Parikshit is informative and helpful. Thanks to eGlobalSystems and Parikshit for an incredible experience.-ailaveniramesh@gmail.com

  • The training recieved from Parikshit is informative and helpful. Thanks to eGlobalSystems and Parikshit for an incredible experience.-ailaveniramesh@gmail.com

Drop A Query

Contact us for help, additional info or assistance and we'll be with you in no time!

Enter your name
Enter your email
Enter your Mobile
Your message