• No products in the cart.

ratings 

Oracle 19C SQL Fundamentals Is a three-day, hands-on course designed to equip you with the fundamental skills needed to set up, run and manage SQL databases using Oracle Database Technology. You will also be discovering all the tools and concepts required to organize data efficiently.

PRIVATE
Course Access

Unlimited Duration

Last Updated

March 4, 2021

Students Enrolled

Total Reviews

Posted by
Certification


Course Curriculum

    • The building blocks of a database. 00:00:00
    • How to add data to the database. 00:00:00
    • The process of retrieving data using SQL functions. 00:00:00
    • Multiple methods of sorting and organizing data. 00:00:00
    • Using SQL functions to get the required simple to complex output. 00:00:00
    • Various strategies for using functions and conditions to organize data. 00:00:00
    • Consolidating data using multiple functions and group operators. 00:00:00
    • Fetching intelligent data reports using simple functions. 00:00:00
    • Fetching data from multiple sources in the tables. 00:00:00
    • Using Subqueries to compile data as required. 00:00:00
    • Using Set operators to create smart data reports 00:00:00
    • Describing and managing data transaction using Data Definition Language. 00:00:00
    • Categorize and review data tables using Data Definition Language. 00:00:00
    • How to manage and query Data Dictionary Views. 00:00:00
    • The process of creating and using Sequences 00:00:00
    • How to create various types of Synonyms and Indexes. 00:00:00
    • Creating simple and complex views and retrieving data. 00:00:00
    • Core concept and application of Schema Objects. 00:00:00
    • Fetching required data with Subqueries. 00:00:00
    • Using Subqueries to organize Data in SQL. 00:00:00
    • Assigning and revoking data access. 00:00:00
    • Managing data access control according to user levels. 00:00:00
    • Using advanced functions and performing data queries. 00:00:00
    • Creating and managing time zone-based databases 00:00:00

Course Reviews

Profile Photo
ashar hafeez
0
61

Students

About Instructor

Pak

Course Events

[wplms_eventon_events]

More Courses by Insturctor

© 2021 Ernesto.  All rights reserved.  
X