Oracle Database 19c: SQL Workshop
ENDED
Online Training by
DBQuest, Inc.
Inquire Now
Online
/ Training
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
- Top Oracle Approved Education Center (OAEC) for FY 2017
- Top Oracle University Reseller for FY 2017
- Top Oracle Approved Education Center (OAEC) FY 2016
- Top University Reseller for FY 2015