Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Oct 7, 2024 | 09:00 | 05:00 | EDT | Live Virtual Class | 5 | $4,000 USD | Purchase |
Dec 2, 2024 | 11:00 | 07:00 | EST | Live Virtual Class | 5 | $4,000 USD | Purchase |
Oracle Database 23ai: SQL Workshop Live Class
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'll 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.
Duration: 5 Days
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 Set Operators
- Managing Tables Using DML Statements
- 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 Advanced Queries
- Managing Data in Different Time Zones
- Table Descriptions
- Using SQL Developer
- Using SQL*Plus
- Commonly Used SQL Commands
- Generating Reports by Grouping Related Data
- Hierarchical Retrieval
- Writing Advanced Scripts
- Oracle Database Architectural Components
- Regular Expression Support
- MySQL Syntax