Contact Us @ +1-210-503-7101

ORACLE PLSQL

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

About Tutor

card image

US IT Training

This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.

US IT Training

This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.This is basic card with image on top, title, description and button.