Course Description

Structure Query Language(SQL) is a database query language used for storing and managing data in Relational DBMS. This course offers you an introduction to the Oracle Database technology. Completing this course will equip you with essential SQL skills. Some of the tasks you can do with these skills include querying single and multiple tables, inserting data in tables, creating tables, and querying metadata.

Prerequisites

Required: Basic computer skills, internet access, basic analytic or programming skills.

Number of Days & Format

Download Outline


Number of Days: Three training days.

Format: Instructor lead (in person), remote, or training-on-demand.

Course curriculum

  • 1
    Introduction
    • Introduction Part 1
    • Introduction Part 2
    • Introduction Part 3
    • Practices for Lesson 1: Overview
    • Practice 1-1: Introduction
  • 2
    Retrieving Data Using the SQL SELECT Statement
    • Retrieving Data Using the SQL SELECT Statement Part 1
    • Retrieving Data Using the SQL SELECT Statement Part 2
    • Practices for Lesson 2: Overview
    • Practice 2-1: Retrieving Data Using the SQL SELECT Statement
  • 3
    Restricting and Sorting Data
    • Restricting and Sorting Data Part 1
    • Restricting and Sorting Data Part 2
    • Restricting and Sorting Data Part 3
    • Practices for Lesson 3: Overview
    • Practice 3-1: Restricting and Sorting Data
  • 4
    Using Single-Row Functions to Customize Output
    • Using Single-Row Functions to Customize Output Part 1
    • Using Single-Row Functions to Customize Output Part 2
    • Using Single-Row Functions to Customize Output Part 3
    • Practices for Lesson 4: Overview
    • Practice 4-1: Using Single-Row Functions to Customize Output
  • 5
    Using Conversion Functions and Conditional Expressions
    • Using Conversion Functions and Conditional Expressions Part 1
    • Using Conversion Functions and Conditional Expressions Part 2
    • Practices for Lesson 5: Overview
    • Practice 5-1: Using Conversion Functions and Conditional Expressions
  • 6
    Reporting Aggregated Data Using the Group Functions
    • Reporting Aggregated Data Using the Group Functions Part 1
    • Reporting Aggregated Data Using the Group Functions Part 2
    • Practices for Lesson 6: Overview
    • Practice 6-1: Reporting Aggregated Data by Using Group Functions
  • 7
    Displaying Data from Multiple Tables Using Joins
    • Displaying Data from Multiple Tables Using Joins Part 1
    • Displaying Data from Multiple Tables Using Joins Part 2
    • Practices for Lesson 7: Overview
    • Practice 7-1: Displaying Data from Multiple Tables by Using Joins
  • 8
    Using Subqueries to Solve Queries
    • Using Subqueries to Solve Queries Part 1
    • Using Subqueries to Solve Queries Part 2
    • Practices for Lesson 8: Overview
    • Practice 8-1: Using Subqueries to Solve Queries
  • 9
    Using Set Operators
    • Using Set Operators Part 1
    • Using Set Operators Part 2
    • Practices for Lesson 9: Overview
    • Practice 9-1: Using Set Operators
  • 10
    Managing Tables Using DML Statements
    • Managing Tables Using DML Statements Part 1
    • Managing Tables Using DML Statements Part 2
    • Managing Tables Using DML Statements Part 3
    • Practices for Lesson 10: Overview
    • Practice 10-1: Managing Tables by Using DML Statements
  • 11
    Introduction to Data Definition Language
    • Introduction to Data Definition Language Part 1
    • Introduction to Data Definition Language Part 2
    • Introduction to Data Definition Language Part 3
    • Practices for Lesson 11: Overview
    • Practice 11-1: Introduction to Data Definition Language
    • Course Survey
  • 12
    Oracle Cloud Overview
    • Oracle Cloud Overview Part 1
    • Oracle Cloud Overview Part 2
    • Additional Practices
    • Practice 1-1: Additional Practice

Instructor(s)