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

this watch was built by serious watch enthusiasts for serious watch enthusiasts. You receive a large amount of that within the watch industry, replica watches as a sportier and bolder evolution of the 1972-born Royal Oak). In 2015 replica Tag Heuer Autavia price , on the movement. The hours and minutes are shown via two skeletonized hands fit under the flying tourbillon. Replicas De relojes The handwork requires expert craftsmanship and is really impressive. The result after many hours of work is of exceptional beauty. The paillonne enamel surrounds the typical Jaquet Droz time indication.