Oracle

CIS377: Oracle SQL 2

(STY-CIS377.AO1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Week 1: Using Subqueries to Solve Queries Part I

  • 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
  • Summary
2

Week 2: Using Subqueries to Solve Queries Part II

  • Use the EXISTS and NOT EXISTS Operators
  • Use the WITH Clause
  • Write Single-Row and Multiple-Row Subqueries
  • Summary
3

Week 3: Managing Schema Objects Part I

  • Describe How Schema Objects Work
  • Create Simple and Complex Views with Visible/Invisible Columns
  • Summary
4

Week 4: Managing Schema Objects Part II

  • Create, Maintain, and Use Sequences
  • Create and Maintain Indexes Including Invisible Indexes and Multiple Indexes on the Same Columns
  • Summary
5

Week 5: Managing Schema Objects Part III

  • Perform Flashback Operations
  • Summary
6

Week 6: 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
7

Week 7: Managing Objects With Data Dictionary Views

  • Query Various Data Dictionary Views
  • Certification Summary
8

Week 8: Manipulating Large Data Sets

  • Describe the Features of Multitable INSERTs
  • Merge Rows into a Table
  • Certification Summary
9

Week 9: Controlling User Access Part I

  • Differentiate System Privileges from Object Privileges
  • Grant Privileges on Tables and on a User
  • Summary
10

Week 10: Controling User Access Part II

  • Distinguish Between Privileges and Roles
  • Summary

1

Week 1: Using Subqueries to Solve Queries Part I

  • Deleting Rows Using a Correlated Subquery
2

Week 2: Using Subqueries to Solve Queries Part II

  • Using the WITH Clause
  • Using the Multiple Select Statement to Retrieve Data
3

Week 3: Managing Schema Objects Part I

  • Creating a View
  • Dropping a View
4

Week 4: Managing Schema Objects Part II

  • Creating and Using a Sequence
  • Creating an Implicit Index
  • Creating a Unique Index
  • Altering a Unique Index
5

Week 5: Managing Schema Objects Part III

  • Dropping a Unique Index
  • Dropping a Table
  • Restoring the Table Using Flashback
6

Week 6: Using the Set Operators

  • Using the UNION Operator
7

Week 7: Managing Objects With Data Dictionary Views

  • Adding the Comment on a Table
8

Week 8: Manipulating Large Data Sets

  • Using the Conditional Multitable INSERT Statement
  • Using the Multitable INSERT Statement
9

Week 9: Controlling User Access Part I

  • Creating a Database User and Granting Privileges
  • Revoking Privileges from a User
  • Dropping the Database User
10

Week 10: Controling User Access Part II

  • Granting Public Synonym Privileges to a User

Related Courses

All Courses