Course Name

Oracle Database 19c: PL/SQL Workshop

Course Introduction

The Oracle Database: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service.

In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

  • Administrator
  • Developer
  • Database Designers
  • Support Engineers

Course Objectives

Identify what a SQL statement is. Understand the Oracle Relational Database. Use SQL Developer. Write reports using SQL Statements. Manipulate data in relational tables and save the data.

Course Content

  • Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using Set Operators
  • Managing Tables Using DML Statements in Oracle
  • Introduction to Data Definition Language in Oracle
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, and Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data Using Advanced Queries
  • Managing Data in Different Time Zones
  • Conclusion

Course Associated Exam and Certification

1Z0-071

L ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Get in touch

Contact the Impactful team if you need any assistance.

Course Introduction

The Oracle Database: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service.

In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

  • Administrator
  • Developer
  • Database Designers
  • Support Engineers

Course Objectives

Identify what a SQL statement is. Understand the Oracle Relational Database. Use SQL Developer. Write reports using SQL Statements. Manipulate data in relational tables and save the data.

Course Content

  • Introduction
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using Set Operators
  • Managing Tables Using DML Statements in Oracle
  • Introduction to Data Definition Language in Oracle
  • Introduction to Data Dictionary Views
  • Creating Sequences, Synonyms, and Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data Using Advanced Queries
  • Managing Data in Different Time Zones
  • Conclusion

Course Exam And Certification

1Z0-071

Are you ready to start?

Certified global best practices in the new technologies…

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions