Due to COVID - 19 Pandemic, our offices are closed. We are all working from our respective homes and all our services are available online. Call/Email/Whastapp us for anything and everything. Stay at home, and Stay safe.
Oracle SQL and PL SQL

Oracle SQL and PL SQL

   12231+ satisfied learners

Ardent's Oracle SQL and PL/SQL instructor led training course is designed to give a firm foundation on Oracle Database that will cover SQL and PL/SQL concepts which are required to create database objects like Tables, Views, Stored procedures, Functions, Triggers etc. and also gives idea about writing Queries and Sub-queries with Joins.

After the completion of the Oracle Course at Ardent, you should be able to:

  • Learn how to write basic SQL queries, sorting and filtering data.
  • Write DDL and DML queries to create and manage database tables.
  • Explore different types of functions available in SQL.
  • Apply different joining techniques to database tables and sub quires Exploit the concepts like view, sequence, index synonym.
  • Utility of TCL Command and DCL Command Understand the need of PL/SQL. Create cursors and deal with exceptions.
  • Learn to use procedures and functions. Create packages and triggers. Concept of ORDBMS. Handling LOB Data Type.
None.

Course Modules

  • Industrial


    1. Duration - 60 hours
    2. Daily / Weekly Classes
    3. 2 Case Studies & 1 Live Project
    4. Industrial Courses are only for students. You can avail this by producing valid proof of studentship
    5. Download Content
    6. Save 46%

      15000 6900

  • Professional


    1. Duration - 80 hours
    2. Daily / Weekly Classes
    3. 4 Case Studies & 1 Live Project
    4. Professional Courses are only for the working professionals / experienced candidates
    5. Download Content
    6. Save 46%

      27500 12650

Provide your rating

Current rating:

Reviews

Priya Mitra says
"Very Nice"
Vishal Kumar says
"Lovely"
Bijaya Mandal says
"GOOD"
Bijaya Mandal says
"Good"
Bijaya Mandal says
"Good"
Dibyendu jana says
"It was a great achievement "
Parna Dey says
"It was good"
Parna Dey says
"It was good "
Priya Singh says
"Excellent"
AMIT DEY says
"good"
BIKRAM SARKAR says
"Good"
Sougata Roy says
"Good"
Abhrajit Das says
"Good"
Mrinmoy Ghosh says
"EXCELLENT "
SWIKRITI DEBNATH says
"THE AUDIO WAS SOMETIMES GETTING STUCK. THIS IS THE ONLY THING WHICH WAS FELT A BIT LOSS. REST EVERYTHING IS GREAT. :-)"
Arpan Chakraborty says
"NA"
Swarnali Ghosh says
"It's Wii be better"
Joykishan Sharma says
"If the duration of this session is more, it would be better for us. 1hr 30 min is not enough I think. Overall, the workshop is very good and understandable. Thank you. "
Goutam Satpathy says
"Good"
Sudip Kuila says
"Needs a bit more engaging explaination "
Argha Majumder says
"Physical interaction is not more prefable than online because due to network lag i am facing trouble..."
SAMRAT KARMAKAR says
"Class is good and instructor was full of knowledge . Its a good learning session. "
ritwik ghosh says
"Project based training done here."