Pl Sql

eGlobalSystems  Offering  pl sql  Online Training Classes For Weekend And Regular Batches For Individuals And Professionals. eGlobalSystems   Offering Free DEMO/ Seminar On  pl sql Access Control By Real Time Expert. Once Experience Our Free Sessions And Decide Further.

Locations: Hyderabad, India, USA, UK, Australia, New Zealand, UAE, Saudi Arabia,Pakistan, Singapore, Kuwait  Etc…

SQL – PL/SQL

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