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.
Do you provide handout for the training course?
We do provide soft copies of notes and handout of the classes for the benefit of students.
Can your courses lead to global certificates?
Yes we have selective courses which lead to global certifications.
After completion of courses do you provide certificates?
We do provide certificates to the students on the basis of periodic evaluation test conducted during training..
Get Updates Straight to your Inbox.
Get In Touch

EN-37 Advantage Tower,

    Salt Lake, Sector V,

    Kolkata700091,India

+91 9674677052

180-0212-5575

enquiry@k2n.education

k2n.education

Popular Links

Home

About Us

Registration

Enquiry

Blog

Training

Credentials