Oracle Database 19c SQL Workshop
Review
Level Basic
Certificate
Abbreviation 19c SQL
Course Description
This course offers an introduction to Oracle 19c database technology. Trainees will learn the concepts of relational databases and the powerful SQL programming language.
The course provides the essential SQL skills that allows developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
A basic knowledge of database and programming concepts.
Course Objectives
Upon completion of this course, trainees should be able to:
- Identify the major components of an Oracle Database
- Understand SQL*Plus environment and its commands
- Retrieve row and column data from tables with the SELECT statements
- Create reports of sorted and restricted data
- Employee SQL functions
Certificate Description
A trainee must complete the course with attendance rate over 80% to obtain a certification in Introduction to Oracle 19c SQL.
Target Attendence
- End Users
- Database Administrators
- Business Analysts
- Application Developers
Introduction
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single Row Functions to Customize Reports
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using SET Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Managing Objects with Data Dictionary Views
Controlling User Access
Manage Schema Objects
Manipulating Large Data Sets
Generating Reports by Grouping Related Data
Managing Data in Different Time Zones
Searching Data Using Advanced Sub queries
Hierarchical Data Retrieval
Performing Regular Expression Support and Case Insensitive
