Your cart is currently empty.
Our Oracle PL/SQL certification master's training program lets you gain proficiency in Oracle Database. We provide the best online training classes to help you learn SQL commands, DBA commands, schema management, database structure, integrity and security. As part of this program, you will work on real-world industry projects.
This is a combo training course that provides you full proficiency in working with Oracle Database. This includes understanding the PL/SQL, subprogram, section and syntax query, DML and advanced DML with scripting. You will study Oracle DBA architecture, database structures, security schema objects and more in this course.
Having a prior knowledge of SQL is beneficial but not mandatory for learning Oracle Database.
Upon the completion of this combo training course, you will be able to apply for high-paying jobs in large MNCs, thanks to the comprehensive training that you will get through this combo course. The role of a DBA is crucial in managing huge volumes of data. PL/SQL is a processing language that is used for the high-performance transaction that works seamlessly across OS and front-end tools. Together, this combo training will help you work on the Oracle 11g Database with effortless ease and take up high-paying jobs.
Talk To Us
We are happy to help you 24/7
Information Technology Executive | Bengaluru, Karnataka
The training helped me gain the necessary skills and knowledge to begin my career as an IT executive. Coming from a recruiting background, it was tough to understand concepts but the trainers made it easier for me to grasp.
US IT Recruiter
Information Technology Executive
Big Data Developer | Dallas
The training helped me make a career transition from Computer Technical Specialist to Big Data developer with a 60% hike. The online sessions are engaging like any physical class and the trainers make the sessions interactive.
Computer Technical Specialist
Big Data Developer
ETL Developer | Maharashtra
Thanks to Intellipaat I was able to make a transition from Consultant to ETL Developer. The rich content has helped me get to this role. I am extremely satisfied with my career today. This is the best online training so far.
Sr. Software Engineer | Hyderabad
Even after being from a non-tech field, I attained the necessary skills to become a Senior Software Engineer through this program. The major concepts were taught with ease and in lucid language, along with real-life projects.
Sr. Software Engineer
Senior Software Engineer | Gurgaon
Senior Software Engineer
60% Average Salary Hike
$1,20,000 Highest Salary
1500+ Career Transitions
500+ Hiring Partners
Self Paced Training
Online Classroom Preferred
Introduction to Oracle SQLPreview
What is RDBMS, Oracle versions, Architecture of Oracle Database Server, Installation of Oracle 12c
Hands-on Exercise – Install Oracle 12c
Using DDL Statements to Create and Manage TablesPreview
Categorize the main database objects, Review the table structure, List the data types that are available for columns, Create a simple table, Explain how constraints are created at the time of table creation, Describe how schema objects work
Hands-on Exercise – Create a database table Person with two column (Name, Age) with constraint on age not greater than 100, Insert records using insert query
Retrieving Data Using the SQL SELECT StatementPreview
List the capabilities of SQL SELECT statements, Execute a basic SELECT statement
Hands-on Exercise – Use a basic select statement to retrieve all the records in the Person table
Restricting and Sorting DataPreview
Limit the rows that are retrieved by a query, Sort the rows that are retrieved by a query, Ampersand substitution to restrict and sort output at runtime
Hands-on Exercise – Write a select query to retrieve records where age is more than 60 yrs, Write a select query to sort the records by name, Write a select query to sort the records by age in descending order, Use ampersand substitution to restrict and sort output at runtime
The general functions in SQL, working with any data type and handling Null values, using COALESCE() and Null function, Constructing and executing SQL query that applies the NUL, NUL1, NUL2 and COALESCE()
Hands-on Exercise – Use NULL function to deal with null values in data
Using Single-Row Functions to Customize OutputPreview
Describe various types of functions (character, number, date, string etc.) available in SQL
Hands-on Exercise – Create a table with columns of type char, number and date, Use character, number, and date functions in SELECT statements
Large Object FunctionsPreview
Large object functions – BFILENAME, EMPTY_BLOB, EMPTY_CLOB, Aggregate or Group functions – COUNT, COUNT(*),MIN,MAX,SUM,AVG,etc…,Group BY Clause, HAVING Clause
Hands-on Exercise – Count records based on a condition, Use Count(*) to know the count of all records, Find Max, Min, Sum, Avg
The various OLAP functions, cube, model clause, roll up and grouping functions
Hands-on Exercise – Working with OLAP commands – Cube, Roll Up, etc.
Using Conversion Functions and Conditional ExpressionsPreview
Describe various types of conversion functions that are available in SQL, Conditional expressions in a SELECT statement
Hands-on Exercise – Group data by using the GROUP BY clause, Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple TablesPreview
Joins, Inner Join, Outer Join, Left Join, Right Join, Equijoins and Non-equijoins
Hands-on Exercise – Write SELECT statements to access data from more than one table using equijoins and non equijoins, Join a table to itself by using a self-join, View data that generally does not meet a join condition by using outer joins, Generate a Cartesian product of all rows from two or more tables
Using Subqueries to Solve QueriesPreview
Define subqueries, Describe the types of problems that the subqueries can solve, List the types of subqueries
Hands-on Exercise – Write single-row and multiple-row subqueries
Using the Set OperatorsPreview
Describe set operators, UNION [ALL], INTERSECT, MINUS Operators
Hands-on Exercise – Use a set operator to combine multiple queries into a single query Control the order of rows returned
Manipulating Data using SQLPreview
Describe data manipulation language (DML) statement, Insert, Update, Delete Statements, Control transactions
Hands-on Exercise – Insert rows into a table, Update rows in a table, Delete rows from a table
What is a database transaction, Properties of a transaction (Atomic, Consistent, Isolated, Durable – ACID), Avoiding error/fault in manipulating database records using transaction
Hands-on Exercise – Begin a transaction, Execute queries to update or insert or delete records, If no error, commit the transaction Else roll back the transaction and end it
Creating Other Schema ObjectsPreview
Views – simple and complex, Sequences, Index, Synonym
Hands-on Exercise – Create simple and complex views, Retrieve data from views, Create, maintain, and use sequences, Create and maintain indexes, Create private and public synonyms
Writing Cursor and Conditional StatementPreview
SQL Cursor, SQL Cursor Attributes., Controlling PL/SQL flow of executions, IF Statement, Simple IF Statement, IF-THAN-ELSE Statement Execution Flow, IF-THAN-ELSE Statement, IF-THAN-ELSIF Statement, Logic Tables, Boolean Conditions., Iterative controlling loop statement, Nested Loops and Labels.
Hands-on Exercise – Use Boolean condition on a select query, Use logic table, Create nested loops and labels
Introduction to Explicit CursorPreview
Writing Explicit cursors, About cursors, Explicit cursor functions, Controlling explicit cursor, Opening the cursor, Fetching Data cursor, Cursor and records, Cursor for loop using sub queries
Hands-on Exercise – Write an explicit cursor, Use cursor function, Fetch data cursor
Advance concepts of explicit CursorPreview
Advance Explicit cursor, Cursor with parameters, For update Clause, Where current of Clause, Cursor with sub queries
Hands-on Exercise – Use cursor with subquery, Use Where Current clause to retrieve data
Handling Exception, Handling Exception with PL/SQLPredefined Exceptions, User Defined Exceptions, Non-Predefined Error, Function for trapping Exception, Trapping user-defined Exception, Raise Application Error Procedure
Hands-on Exercise – Use Predefined exception, Write user defined exception, Generate and handle exception, Use a function for trapping an exception
Writing Subprogram, Procedure and passing parametersPreview
Overview of subprograms, PL/SQL Subprograms, What is Procedure, Syntax for creating Procedure, Creating Procedure with parameter, Example of Passing parameters, Referencing a public variable from a standalone procedure, Declaring Subprogram
Hands-on Exercise – Create a parameterized procedure, Pass parameters in a procedure call, Access a public variable from a standalone procedure
Creating PL/SQL PackagePreview
PL/SQL records, Using Pl/SQL Table method and example, Creating PL/SQL Table, Packages – Objective, overview, component, developing, removing, advantages, Creating the package specification/example, Declaring Public construct, Public and private construct, Invoking package construct, Guide lines for deploying packages
Hands-on Exercise – Create a package, Deploy the created package
Advance Package Concepts and functionsPreview
Overloading, Using forward declaration, One time only procedure, Package functions, User define package function, Persistent state of package function, Persistent state of package variable, Controlling the persistent state of package cursor, Purity end, Using supplied package, Using native dynamic SQL, Execution flow, Using DBMS-SQL package, Using DBMS-DDL package, Submitting jobs, Interacting with operating system links
Hands-on Exercise – Use supplied package, Use native dynamic SQL, Use DBMS-SQL package, Use DBMS-DDL package, Submit a job
Introduction and writing TriggersPreview
Triggers – Definition, objective and its event type, Application & database triggers, Business application scenarios for implementing triggers, Define DML triggers, Define Non – DML triggers, Triggers event type & body, Creating DML triggers using the create triggers statement, Define statement level triggers v/s low level triggers, Triggers firing sequence: single row manipulation, Creating a DML statement triggers, Using old and new qualifiers, Old and new qualifiers, Instead of triggers, Managing triggers using the alter & drop SQL statement, Testing triggers
Hands-on Exercise – Create a DML statement trigger, Use old and new qualifiers, Manage a trigger using the alter & drop SQL statement, Test the created triggers
Viewing trigger information, Describe user triggers, What is a compound trigger and working with it, Compound trigger structure for tables, Timing-point sections of a table compound trigger, Compound trigger structure for views, Trigger restrictions on mutating tables, Compound trigger restrictions, Using a compound trigger to resolve the mutating table error, Creating triggers on system events, LOGON and LOGOFF triggers example, Call statements in triggers, Benefits of database-event triggers, System privileges required to manage triggers
Hands-on Exercise – View a trigger’s information, Use a compound trigger structure for views, Use a compound trigger to resolve the mutating table error, Create triggers on system events, Use LOGON and LOGOFF triggers, Call statements in triggers
Working with Dynamic SQLPreview
Dynamic SQL-objectives, Describe execution flow of SQL statements, Dynamic SQL with a DDL statement-example, Working with dynamic SQL, Native Dynamic SQL(NDS), Using the executive immediate statement-example, Using native dynamic SQL to compile PL/SQL code, Using DBMS-SQL with a DML statement, Using the DBMS-SQL package subprograms, Parameterized DML statement
Hands-on Exercise – Use the executive immediate statement, Use native dynamic SQL to compile PL/SQL code, Create DBMS-SQL with a DML statement, Create a DBMS-SQL package subprograms
Advance level- ScriptingPreview
Managing Dependencies, Objectives, overview of schema object dependencies, Direct local dependencies, Querying direct object dependencies, Displaying direct and indirect dependencies, Fine-Grained dependency management, Changes to synonym dependencies, Maintaining valid PL/SQL program units and views, Object re-validation, Concepts of remote dependencies, Setting the remote dependencies mode parameter, Recompiling PL/SQL program unit, Packages and Dependencies, Successful and unsuccessful recompilation, Recompiling procedures
Hands-on Exercise – Query direct object dependencies, Display direct and indirect dependencies, Set the remote dependencies mode parameter, Recompile PL/SQL program unit, Edit a procedure and recompile it
What is the Oracle database? How it functions? pre-requisites, oracle database, multiple non-CDB’s share nothing, oracle database 12c installation, multi-tenant architecture, non-CDB oracle system data mixed with user data, multitenant container database, pluggable database.
Oracle Database 12c ArchitecturePreview
The Architecture of Oracle server, the key components – Oracle Instance and Oracle Database, the various file types – data files, control files, redo log files, benefits of CDB, easier management of database, support for oracle database resource manager, pluggable database (PDB), database instance, contents of CDB and pluggable DB, control files and redo log files, shared oracle supplied metadata, root container, data dictionary, creation of PDB’s, seed PDB, limit PDB
Oracle Storage StructuresPreview
The basics of Oracle Storage structures, logical storage units like tablespaces, data blocks, extents and segments, database Schemas, Schema Objects, Operating System blocks, table statement and way to check “create table”, the instance, the CDB, containers, root containers, PDB, local user and common user, local privileges and common privileges, steps to create a container database, creating a container database using sqlplus, database configuration assistance
Memory & Process ArchitecturePreview
The Oracle Instance consists of background processes and memory structures, learn about the Oracle process and memory architecture, shared pool, redo log buffer, and buffer cache, different methods of creating PDB, steps involved in PDB, using PDB$SEED, without FILE_NAME_CONVERT, synchronization, plug a non-CDB to CDB, plug a non-CDB into CDB using DBMS_PDB, clone PDBS, plug and un-plug, plug unplugged CDB in to CDB
Alert & Trace filesPreview
The Oracle background process errors can be monitored using the Trace Files and Alert Logs, learn how this can be deployed for Oracle Administration and support.
Database Startup & User RequestsPreview
The methodology of starting a database instance, initializing parameter files, preparing for startup, serving user requests, understanding of the Server process and user process, administrative activities on PDB, new views associated with PDBS, determining which PDB you are in, four functions, opening, closing, and altering the open mode of PDBS, setting the default and temporary tables places for a PDB, using the alter system command from within a PDB, instance parameter change impact
Managing data with ILMPreview
Automatic data optimization, ILM components, ILM challenges, what is automatic data optimization, heat map and ADO, DBA heat map segment view, monitoring statistics, creating compression polices, creating storage tiering policy, preparing evolution and execution
Hands on Lab :- Automatic Data Optimization, Reduction Policies, Alter Policy
Learn about the powerful Oracle database security features, data privacy, regulatory compliance, “create user” process, altering and dropping users, generating profiles and limiting resources, auditing, activity monitoring and blocking.
Database Schema ObjectsPreview
Understanding of Database Schema objects, the various types available like views, tables, clusters, indexes, sequence, database links, packages and procedures, learning how data is stored in database tables, creating of temporary tables and external tables.
Database Resource ManagerPreview
Resource manager. Resource manager and pluggable database, managing resource between PDBs, CDB resource plan basics:share, CDB resource plan basics:Limits, creating a CDB resource plan, creating a CDB resource plan:SQL example, enabling a CDBresource plan, managing PDB resource plan
Deep dive into Schema ObjectsPreview
Mastering the database Schema objects, learning Materialized View, deploying user-generated schema object for generating sequence, the balanced search tree index structure for placing and locating files, learn about data concurrency and data consistency in multi-user databases, the concepts of Locking and Deadlocks.
Oracle Network EnvironmentPreview
Study the client/server Network Environment, configuring the network, connecting to the database, the Oracle Network Environment and database link, starting up a instance, SHOUT DOWN, NOMOUNT, MOUNT, OPEN, PDB, OPEN, clone PDBS.
Oracle Backup & RecoveryPreview
Understand how Oracle database ecosystem backup and recovery is deployed, the database testing, database standby, Media recovery options, backup in offline mode, CDB backup and recover, archiving challenges and solutions, in data base archiving, security and performance: audit architecture, consolidation: unique audit trail, extended audit information, data pump audit policy, new administrative privileges, new administrative privileges:SYSBACKUP, new administrative privileges:SYSDG, new administrative privileges:SYSKM
Oracle Recovery Manager (RMAN)Preview
Learn the significance of Oracle Recovery Manager, how it deploys performance, management and restoration of entire databases, learn about SQL Loader, Oracle Data Pump for import and export and support for External Table.
Data Dictionary & Dynamic Performance TablesPreview
The Oracle Data Dictionary contains information related to database privileges, objects, users, and roles, learn Dynamic Performance Table for identifying instance-level problems, get complete knowledge to work with Oracle DBA, connection access DBA, data dictionary views, after CDB creation, alert log file, provisioning new pluggable databases NOARCHIVELOG mode, media failure, flashback CDB, data dictionary views
Understanding what is database tuning, skills needed to lower response time, increase throughput for time-sensitive applications, how to optimize the storage space, deploy SQL scripts, Index Statistics and Selectivity, how to tune the database, what is a Chained Row and Lock in Oracles.
Free Career Counselling
We are happy to help you 24/7
Practice Essential Tools
Designed By Industry Experts
Get Real-world Experience
Performing DML operations on database
The project will enable you to primarily focus majorly on Data Manipulation Language (DML). You will understand more about DML triggers. You will get to learn various DML operations such as INSERT, UPDATE, and DELETE.
Tuning of the database
In this project you will be involved in the deployment of database performance in Oracle Database. This involves optimizing and homogenizing the database performance. You will be involved on various other related tasks in real time.
Via Intellipaat PeerChat, you can interact with your peers across all classes and batches and even our alumni. Collaborate on projects, share job referrals & interview experiences, compete with the best, make new friends – the possibilities are endless and our community has something for everyone!
This course is designed to clear the following certification exams:
The entire course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in top MNCs.
As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly.
At the end of this training program, there will be quizzes that perfectly reflect the type of questions asked in the certification exams and help you score better marks.
Intellipaat Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
Through my experience, I can confidently say that this is one of the best courses I have come across in a while. The course is excellent as it provides comprehensive explanation of each topic.
The course gives an extensive understanding of all topics. The course is indeed an excellent choice to gain deep knowledge on various topics involved in Oracle PL/SQL and DBA Training.
This Intellipaat PL/SQL and DBA combo training provides you proficiency in working with Oracle PL/SQL and Oracle DBA, mastering DML and advanced DML and learning about subprograms, database structures, security schema objects and more. This entire course content is in line with the requirements of clearing the Oracle PL/SQL Developer Certified Associate Exam and the Oracle Database Administrator Certified Associate Exam.
You will be working on real-time Oracle PL/SQL and DBA projects and step-by-step assignments that have high relevance in the corporate world, and the course curriculum is designed by industry experts. Upon the completion of the training course, you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 support and course material upgrading to the latest version at no extra fee. Hence, it is clearly a one-time investment.
At Intellipaat, you can enroll in either the instructor-led online training or self-paced training. Apart from this, Intellipaat also offers corporate training for organizations to upskill their workforce. All trainers at Intellipaat have 12+ years of relevant industry experience, and they have been actively working as consultants in the same domain, which has made them subject matter experts. Go through the sample videos to check the quality of our trainers.
Intellipaat is offering 24/7 query resolution, and you can raise a ticket with the dedicated support team at any time. You can avail of email support for all your queries. If your query does not get resolved through email, we can also arrange one-on-one sessions with our support team. However, 1:1 session support is provided for a period of 6 months from the start date of your course.
Intellipaat is offering you the most updated, relevant, and high-value real-world projects as part of the training program. This way, you can implement the learning that you have acquired in real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning, and practical knowledge, making you completely industry-ready.
You will work on highly exciting projects in the domains of high technology, ecommerce, marketing, sales, networking, banking, insurance, etc. After completing the projects successfully, your skills will be equal to 6 months of rigorous industry experience.
Intellipaat actively provides placement assistance to all learners who have successfully completed the training. For this, we are exclusively tied-up with over 80 top MNCs from around the world. This way, you can be placed in outstanding organizations such as Sony, Ericsson, TCS, Mu Sigma, Standard Chartered, Cognizant, and Cisco, among other equally great enterprises. We also help you with the job interview and résumé preparation as well.
You can definitely make the switch from self-paced training to online instructor-led training by simply paying the extra amount. You can join the very next batch, which will be duly notified to you.
Once you complete Intellipaat’s training program, working on real-world projects, quizzes, and assignments and scoring at least 60 percent marks in the qualifying exam, you will be awarded Intellipaat’s course completion certificate. This certificate is very well recognized in Intellipaat-affiliated organizations, including over 80 top MNCs from around the world and some of the Fortune 500companies.
Apparently, no. Our job assistance program is aimed at helping you land in your dream job. It offers a potential opportunity for you to explore various competitive openings in the corporate world and find a well-paid job, matching your profile. The final decision on hiring will always be based on your performance in the interview and the requirements of the recruiter.