FB

Advanced Oracle SQL

This course will teach you more advanced topics of Oracle SQL, now that you know the basics.


You'll learn:

  • How to use some of the other database objects to improve your database (sequences, synonyms, temp tables)
  • What the WITH clause is and how to use it
  • More topics such as advanced subqueries, hierarchical queries, views, working with dates and times, and more.

Get Access to All Courses Now

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

Course Topics:

Introduction

  • Introduction
  • Oracle Express Download and Install
  • SQL Developer Download
  • Set Up a Connection in SQL Developer
  • Set Up Database Tables

Other Database Objects

  • Synonyms
  • Sequences
  • Indexes
  • Index Examples
  • Temporary Tables
  • Introduction to the Data Dictionary
  • Useful Data Dictionary Queries
  • (Quiz)

Subqueries

  • Subquery Review
  • Subquery Options
  • Updating Data with a Subquery
  • Inserting Data using a Subquery
  • Deleting Data using a Subquery
  • (Quiz)

Views

  • Overview of Views
  • Inserting and Updating Data in Views
  • Materialized Views
  • Inline Views
  • View Options
  • (Quiz)

Hierarchical Queries

  • What is a Hierarchical Query?
  • Writing a Hierarchical Query
  • LEVEL Pseudocolumn
  • START WITH and ORDER BY
  • More Hierarchical Query Keywords
  • (Quiz)

WITH Clause

  • The WITH Clause
  • Recursive WITH Clause
  • Hierarchical Concepts
  • SEARCH and SET Operators
  • Cycle Clause
  • (Quiz)

Dates and Times

  • Timezone Concept
  • Date and Time Functions
  • Interval Data Types
  • (Quiz)

Transactions

  • Overview of Transactions
  • COMMIT and ROLLBACK
  • Conclusion

© 2019 Database Star | Privacy | Terms of Service