Oracle 19c : Learn SQL & PL/SQL
PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. This tutorial will give you great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts.
Course Overview
What will you learn?
- Identify the major structural components of the Oracle Database 12c
- Create reports of aggregated data
- Write SELECT statements that include queries
- Retrieve row and column data from tables
- Run data manipulation statements (DML) in Oracle Database 12c
- Create tables to store data
- Utilize views to display data
- Control database access to specific objects
- Manage schema objects
- Display data from multiple tables using the ANSI SQL 99 JOIN syntax
- Manage objects with data dictionary views
- Write multiple-column sub-queries
- Employ SQL functions to retrieve customized data
- Use scalar and correlated sub-queries
- Create reports of sorted and restricted data
Who should go for this training?
The following professionals can go for this course:
- Administrator
- Analyst
- Developer
- Systems Administrator
What are the pre-requisites for this Course?
- Basic Computer Knowledge
Course Content
Modes of Training
Classroom Training
Live interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.
Online Training
Learn from anywhere over the internet, joining the live sessions delivered by our expert trainers.
Self-Pace Training
Learn through pre-recorded video sessions delivered by experts at your own pace and timing.