PL/SQL Online Training

eGlobalSystems  Offering  pl /sql  Real-time 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 Fturher.

SQL – PL/SQL:

Sql Course Contents
Session I
Introduction To Database
·       Data
·       Information
·       Differences Between Data and Information
·       Database
·       Database Management System
Session 2
·       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
·       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
·       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
·       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
·       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
·       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

No comments:

Post a Comment