Oracle SQL Basic and Advanced

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
User AvatarByAT-Manager

Oracle SQL Basic and Advanced

Curriculum

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

Instructor

User Avatar
  • Duration14 Hours
  • Students370
  • Lessons113
  • Skill levelAll Levels
  • LanguageEnglish
  • Quizzes0
  • CertificationsYes
  • Pass Percentage80%
  • Deadline25 Dec, 2023