FB

Introduction to Oracle SQL

This course will teach you the basics of SQL using an Oracle database.


You'll learn:

  • What SQL is and why it's good to learn
  • How to set up an Oracle database for you to practice with
  • How to add, update, and delete data
  • How to view data using all of the basic SQL commands and keywords

Get Access to All Courses Now

Access this course and all other courses (and more) in Database Star Academy instantly:

Course Topics:

Introduction & Setup

  • Welcome
  • Oracle Express Download and Install
  • SQL Developer Download
  • Set Up a Connection in SQL Developer
  • Our Sample Database
  • Setting Up Our Sample Data

Viewing Data with SELECT

  • How to View Data with the SELECT Statement
  • Selecting Individual Columns
  • Filtering Data with WHERE
  • Comparison Operators
  • Filtering on Partial Values with LIKE
  • Filtering on Date Values
  • Using Two Filters
  • More Than Two Filters
  • What is NULL?
  • Getting Unique Records with DISTINCT
  • (Quiz)

More Operators

  • IN and NOT IN
  • BETWEEN and NOT BETWEEN
  • ALL Keyword
  • ANY Keyword
  • (Quiz)

Sorting Data

  • Sorting Results with the ORDER BY Clause
  • Ordering By Multiple Columns
  • (Quiz)

Set Operators

  • Set Operators and UNION
  • UNION ALL Operator
  • INTERSECT Operator
  • MINUS Operator
  • Three or More Sets at Once
  • (Quiz)

Aggregate Functions and Grouping

  • What Are Functions?
  • Counting Data
  • Using COUNT in Other Ways
  • Counting Data Within Groups with GROUP BY
  • GROUP BY with WHERE and ORDER BY
  • GROUP BY with Multiple Columns
  • GROUP BY with HAVING
  • The SUM Function
  • Using the MAX and MIN Functions
  • Using the AVG Function
  • (Quiz)

Joins

  • What are Table Aliases?
  • What are Column Aliases?
  • What are Joins?
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Natural Join
  • Cartesian or Cross Join
  • Self Join
  • Joining Many Tables
  • Alternative Join Syntax
  • (Quiz)

Functions

  • String Functions
  • Nesting Functions Within Functions
  • Number Functions
  • Date Functions
  • Data Types and Conversion Functions
  • The CASE Statement
  • (Quiz)

Subqueries

  • What Are Subqueries?
  • Single Row Subqueries
  • Multi Row Subqueries
  • (Quiz)

Inserting, Updating, and Deleting Data

  • Inserting Data
  • Inserting Data from Another Table
  • Updating Data
  • Deleting Data
  • COMMIT and ROLLBACK
  • Truncating Data
  • (Quiz)

Creating, Altering, and Dropping Tables

  • Create a Table
  • Alter a Table
  • Drop a Table
  • Conclusion
  • (Quiz)

© 2019 Database Star | Privacy | Terms of Service