Course Contents

Overview of DBMS. Introduction of RDMS.
Sub Language Commands. Introduction to SQL Database object.
Oracle Built in Functions. Grouping the result with Query. Working with Integrity Constraints. REF Constraints
Querying multiple Tables using Joins.
Working with Sub queries.
Working with DCL, TCL commands
Maintaining Database objects. Views creations and its benefits.
Working with Sequence, Synonyms. Working with Indexes and Clusters.
Data Partitions and Parallel processing. Locks , SQL * Loader.
Procedural Language overview. PLSQL Architecture. Advantages of PLSQL. PLSQL Data types and Constants.
PLSQL Built in Functions. Conditional statements and Iterations, Cursors and its Attributes. Types of Cursors.
Basic DBA commands

Need Counselling ?

Frequently Asked Questions

K2N Academy's courses are designed with inputs from corporate houses as Industry Ready programs which have ready acceptance in Industries.
We do provide soft copies of notes and handout of the classes for the benefit of students.
Yes we have selective courses which lead to global certifications.
We do provide certificates to the students on the basis of periodic evaluation test conducted during training..