Oracle SQL Basic and Advanced

ByAT-Manager

Curriculum

Introduction to Oracle Database :
Retrieve Data using the SQL SELECT Statement
Learn to Restrict and Sort Data
Usage of Single-Row Functions to Customize Output
Invoke Conversion Functions and Conditional Expressions
Aggregate Data Using the Group Functions
Display Data From Multiple Tables Using Joins
Use Sub-queries to Solve Queries
The SET Operators
Data Manipulation Statements
Use of DDL Statements to Create and Manage Tables
Other Schema Objects
Control User Access
Management of Schema Objects
Manage Objects with Data Dictionary Views
Manipulate Large Data Sets
Data Management in Different Time Zones
Retrieve Data Using Sub-queries
Analytical Functions
- Cume_Dist
- Dense_rank
- First_value
- Lag
- Last_value
- Lead
- Nthvalue
- NTILE
- Percent_rank
- Rank
- Row_number

Overview

This Oracle Database 19c: SQL Basics– This Course is designed to teach you the
fundamentals of SQL using Oracle Database 19c database technology. Using the powerful
Structured Query Language (SQL), the data contained within relational databases can be
retrieved, managed and manipulated.

Learn To:

 Develop essential SQL skills that enable developers to write queries against single and
multiple tables.
 Manipulate data in tables.
 Create database objects.
 Use single row functions to customize output.
 Work with group functions and Analytical Functions to report aggregated data.
 Use conversion functions and conditional expressions.
 Manipulate queries to return required data.
 Administer database objects

Audience:

• Administrator
• Database Tester
• Database Administrator
• Developer

Objectives:

• To identify the concepts and components of an Oracle Database 19c database,
recognize how to retrieve information from it using SQL, and identify the steps for sorting,
limiting
• To recognize the steps for writing queries that convert data from one type to another,
specify conditions, perform calculations on groups of rows or even tables, and return value
• To identify the steps for manipulating queries to return the data you need, using
subqueries and set operators, and also for manipulating the actual data using INSERT,
UPDATE
• To recognize the steps for creating, defining, and dropping tables, manipulating how
their data can be viewed, and using schema objects to generate integers, improve queries

Course Content :

• Oracle Database 19c Using SQL to Query Your Database o Using SQL in Oracle
Database 19c
• Retrieving, Restricting and Sorting Data
• Using Single-Row Functions
• Oracle Database 19c: Conversion Functions, Group Functions, Analytical Functions
and Joins Conversion Functions and Conditional Expressions
• Group Functions and Joins
• Oracle Database 19c: Subqueries, Set Operators, and Data Manipulation of Using
Subqueries and Set Operators
• Manipulating Data
• Oracle Database 19c: Using DDL, Views, Sequences, Indexes, and Synonyms o Using
DDL Statements to Create and Manage Tables
• Creating Other Schema Objects

Certification

Benfits of NSDC certification

The course content has been vetted and approved by the NSDC, meaning it aligns with industry standards and has a good chance of leading to employment.
The training center has met certain quality standards, such as having a certain number of trainers and equipment.
You may be eligible for a loan from the NSDC to pay for the course.
You may be able to get a certificate recognized by the government and industry.
You may be able to get placement assistance after completing the course