Course Content

Structured Query Language(SQL)

• Introduction to SQL
• Predefined Data Types
• Introduction to database objects
• Table,View

 Commands in SQL

• Data Defination Language(DDL)
• Data Manipulation Language(DML)
• Data Control Language(DCL)
• Transaction Control Language(TCL)
• Database Security and Privileges(DCL)

 Working with DDL,DML,TCL Commands

• Operators
• Conditional,Logical,Comparison,SET
• Functions
• Date,Number,Character,String,Group,Group by,Having clause
• Transformation Functions
• DECODE,TRANSLATE
• NVL,NVL2(9i)
• Aggregate Functions

 Integrity Constraints

• Different Types of Integrity Constraint
• Use of Integrity Constraint in table

 Joins

• Usage of Joins
• Different Types of Joins
• Equi Join
• Cartesian join
• Self Join
• Outer join

 Sub Queries

• Need of Sub Queries
• Nested Sub queries
• Co-related Sub Quries
• Flash Back Queries (9i)

 View

• Importance of views
• Creating,Manipulating Views
• Materialized views(9i)

 Working with database objects

• Sequences and synonyms
• Index,Cluster,Creating cluster table

 Using External Tables(9i)

• System Privileges
• Table Privileges

 Locks and SQL Plus editor commands 
 PL/SQL

• Introduction to PL/SQL
• Advantage of PL/SQL
• Data Types in PL/SQL
• Variables and Constants
• Referencing NON-PL/SQL Variable
• Using built in Functions
• Conditional and iterative Statements
• SQL in PL/SQL
• Composite Data Types
• Cursors
• Exceptions:-Predefined ,User Defined
• Records and PL/SQl table types

 Advanced PL/SQL

• Introduction to Triggers
• Types of Triggers : - Row level,Statement Level
• Before and After ,Instead of Triggers
• Procedures,Functions in PL/SQL
• User Defined Packages
• Dropping triggers,Procedures,Functions