Oracle Database 19c: SQL Workshop

Price
$4,000.00 USD

Duration
5 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Course Overview

The Oracle Database 19c: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Course Objectives

  • Identify the major components of an Oracle Database
  • Retrieve row and column data from tables with the SELECT statements
  • Create reports of sorted and restricted data
  • Employee SQL functions
  • Who Should Attend?

    • Developer
    • Database Administrators
    • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
    • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
    • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
    • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
    • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
    • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

    Course Prerequisites

    There are no prerequisites for this course.

    Agenda

    1 - Outline

    • 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 the Set Operators
    • Manipulating Data
    • Introduction to Data Definition Language
    • Introduction to Data Dictionary Views
    • Creating Sequences, Synonyms, and Indexes
    • Creating Views
    • Managing Schema Objects
    • Retrieving Data by Using Subqueries
    • Controlling User Access
    • Manipulating Data Using Advanced Queries
    • Managing Data in Different Time Zones
     

    Upcoming Class Dates and Times

    Mar 11, 12, 13, 14, 15
    8:00 AM - 4:00 PM
    ENROLL $4,000.00 USD
    May 13, 14, 15, 16, 17
    8:00 AM - 4:00 PM
    ENROLL $4,000.00 USD
    Aug 12, 13, 14, 15, 16
    8:00 AM - 4:00 PM
    ENROLL $4,000.00 USD
    Nov 11, 12, 13, 14, 15
    9:00 AM - 5:00 PM
    ENROLL $4,000.00 USD
     



    Do You Have Additional Questions? Please Contact Us Below.

    contact us contact us 
     
    Contact Us about Starting Your Business Training Strategy with New Horizons