Oracle

Oracle SQL 2

(STY-CIS)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Using Subqueries to Solve Queries

  • Define Subqueries
  • Describe the Types of Problems Subqueries Can Solve
  • Describe the Types of Subqueries
  • Query Data Using Correlated Subqueries
  • Update and Delete Rows Using Correlated Subqueries
  • Use the EXISTS and NOT EXISTS Operators
  • Use the WITH Clause
  • Write Single-Row and Multiple-Row Subqueries
  • Certification Summary
  • Two-Minute Drill
2

Managing Schema Objects

  • Describe How Schema Objects Work
  • Create Simple and Complex Views with Visible/Invisible Columns
  • Create, Maintain, and Use Sequences
  • Create and Maintain Indexes Including Invisible Indexes and Multiple Indexes on the Same Columns
  • Perform Flashback Operations
  • Certification Summary
  • Two-Minute Drill
3

Using the Set Operators

  • Describe Set Operators
  • Use a Set Operator to Combine Multiple Queries into a Single Query
  • Control the Order of Rows Returned
  • Certification Summary
  • Two-Minute Drill
4

Managing Objects with Data Dictionary Views

  • Query Various Data Dictionary Views
  • Certification Summary
  • Two-Minute Drill
5

Manipulating Large Data Sets

  • Describe the Features of Multitable INSERTs
  • Merge Rows into a Table
  • Certification Summary
  • Two-Minute Drill
6

Controlling User Access

  • Differentiate System Privileges from Object Privileges
  • Grant Privileges on Tables and on a User
  • Distinguish Between Privileges and Roles
  • Certification Summary
  • Two-Minute Drill

1

Using Subqueries to Solve Queries

  • Deleting Rows Using a Correlated Subquery
  • Using the WITH Clause
  • Using the Multiple-Row Subquery
2

Managing Schema Objects

  • Creating a View
  • Dropping a View
  • Creating and Using a Sequence
  • Restoring the Table Using Flashback
  • Dropping a Table
  • Dropping a Unique Index
  • Altering a Unique Index
  • Creating a Unique Index
  • Creating an Implicit Index
3

Using the Set Operators

  • Using the UNION Operator
4

Managing Objects with Data Dictionary Views

  • Adding the Comment to a Table
5

Manipulating Large Data Sets

  • Using the Multitable INSERT Statement
  • Using the Conditional Multitable INSERT Statement
6

Controlling User Access

  • Creating a Database User and Granting Privileges
  • Granting Public Synonym Privileges to a User
  • Revoking Privileges from a User
  • Dropping the Database User

Related Courses

All Courses