Oracle Database 23ai: SQL Workshop
Course code
D1106069GC10
Duration
5 Days, 40 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview
This course is targeted at Developers and Database Administrators and begins with the concepts of a relational database and the SQL programming language. It includes writing queries against single and multiple tables, manipulate data in tables, and create database objects. You will also learn how to create sequences, synonyms, indexes, and views, manage schema objects, and manage data using subqueries. Additionally, the course covers controlling User Access and managing data in different time zones
Objectives
Prerequisites
Course Outline
1 Introduction
2 Retrieving Data Using the SQL SELECT Statement
3 Restricting and Sorting Data
4 Using Single-Row Functions to Customize Output
5 Using Conversion Functions and Conditional Expressions
6 Reporting Aggregated Data Using the Group Functions
7 Displaying Data from Multiple Tables Using Joins
8 Using Subqueries to Solve Queries
9 Using Set Operators
10 Managing Tables Using DML Statements
11 Introduction to Data Definition Language
12 Introduction to Data Dictionary Views
13 Creating Sequences, Synonyms, and Indexes
14 Creating Views
15 Managing Schema Objects
16 Retrieving Data by Using Subqueries
17 Manipulating Data by Using Subqueries
18 Controlling User Access
19 Manipulating Data Using Advanced Queries
20 Managing Data in Different Time Zones
A Table Descriptions
B Using SQL Developer
C Using SQL*Plus
D Commonly Used SQL Commands
E Generating Reports by Grouping Related Data
F Hierarchical Retrieval
G Writing Advanced Scripts
H Oracle Database Architectural Components
I Regular Expression Support
J MySQL Syntax
