Back to Previous

Oracle Database 19c: SQL Workshop

ENDED

Online Training by DBQuest, Inc.

Inquire Now

Online / Training

Inquire for Price

Inquire Enroll Now

RESPONSE RATE

Details
Outline
About the Provider

Enroll Now

Inquire

Details

The Oracle Database 19c: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. 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.

Objectives:

Understand the basics of relational databases.
Create sorted and limited data reports.
Execute data manipulation instructions
Control database access for specific objects.
Manage schema objects.
Manage objects with data dictionary views.
Retrieve rows and columns of data from tables.
Control object and system level rights.
Create indexes and constraints; modify existing schema objects.
Create and query external tables.

Note: Applicable for 11g, 12c & 18c users

Outline

Topics

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 the SET Operators
Managing Tables using DML statements
Introduction to Data Definition Language
Introduction to Data Dictionary Views
Creating Sequences, Synonyms, Indexes
Creating Views
Managing Schema Objects
Retrieving Data by Using Subqueries
Manipulating Data by Using Subqueries
Controlling User Access
Manipulating Data
Managing Data in Different Time Zones

Reviews

Be the first to write a review about this course.

Write a Review

DBQuest, Inc. is an Oracle Training Provider and an Approved Training Partner of Lithan. We are one of the Authorized Training Center of Oracle University here in the Philippines with over 10 years of delivering high quality Education. Recently, we partners with Lithan, an eduCLaaS Digital Skills Accelator in Singapore to deliver International Degree Programs and Certification Skills Programs.

AWARDS AND RECOGNITIONS