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:
* Identify the major components of an Oracle Database
* Retrieve row and column data from tables with the SELECT statements
* Create reports of sorted and restricted data
* Employee SQL functions
Introduction
Retrieving Data using the SQL Select Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversation 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 Advances Queries
Managing Data in different Time Zones
Conclusion