Oracle 21C SQL for Beginners 1

Programming

COURSE OVERVIEW

The main objective is to understand the concepts of relational databases using Oracle 21 SQL language. Also, this course aims to learn how to write queries against single and multiple tables, manipulate data in tables and create database objects. This will also help trainees how to use SQL Plus and SQL Developer to deal with the SQL scripts.

Duration: 3 Days / 24 Hours

Delivery Method: Classroom-based, Virtual Instructor Led Training

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 the Set Operators

10. Managing Tables Using DML Statements

11. Introduction to Data Definition Language

REGISTER NOW