Course Syllabus

1. DBMS Concepts
• What is Database?
• What is Database System?
• E.F.CODD’s Rules
• Difference Between DBMS, RDBMS & ORDBMS

2. SQL

• What is SQL?
• DDL Commands
• Create, Alter, Drop
• Truncate, Rename
• DML Command – Insert

SQL SELECT statements

a. Order by Clause
b. Distinct Clause
c. Where Clause
d. Operators
e. Comparison Conditions

a. Primary Key Constraint
b. Unique Constraint
c. Not Null Constraint
d. Foreign Key Constraint
e. Check Constraint
f. Cascade Constraints

a. What is a Join?
b. Cartesian Join
c. Equi Join
d. Non – Equi Join
e. Self Join
f. Outer Join
g. Left Outer Join
h. Right Outer Join
i. Full Outer Join
j. Pseudo Columns

a. Numeric Functions
b. Character Functions
c. Date Functions
d. Conversion Functions
e. General Functions
f. Aggregating Data Using Group Functions

Sub Queries
a. Simple Sub Queries
b. Multiple Row Sub Queries

a. Data Updating
b. Updating data using Sub Queries

a. Deleting Data
b. Deleting data using Sub Queries
c. Deleting data using join

Transaction Control Language (TCL)
a. Commit
b. Roll back
c. Save point

Database Objects
a. View
b. Synonym
c. Sequence
d. Index
e. Privileges

a. Simple View
b. Complex View
c. In Line View

a. Private Synonym
b. Public Synonym

a. Grant
b. Revoke


• Block Structure of PL/SQL
• Data Types, Variables & Constants
Flow Control Statements
a. Simple IF
b. IF-THEN-ELSE Statements
c. IF-THEN-ELSIF Statements

Iterative Statements
a. Simple Loop
b. While Loop
c. For Loop

Attribute Data Types
a. %type
b. %Rowtype

Cursor Management
a. What is Cursor?
b. Implicit Cursor
c. Explicit Cursor
d. Cursor with parameters
e. Cursor with For Loop

a. What is an Exception?
b. Predefined Exception
c. User defined Exception

Sub Programs
a. Named PL/SQL Block
b. Stored Procedures
c. Types of Parameters
d. Stored Function
e. Difference between Function and Procedure
a. What is package?
b. Importance of package
a. What is a Trigger?
b. Row Level Trigger
c. Table Level Trigger
d. Instead of Trigger
e. DML Triggers
f. System Triggers


live Chat