.jpg){kind=logo}
STY-CIS
Oracle SQL 2
Self-paced · 1 year access
20 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
6 Interactive Lessons · 34 topics01 Using Subqueries to Solve Queries 10 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
02 Managing Schema Objects 7 topics · 9 LiveLab +
- 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
9 LiveLab in this lesson — see the labs panel →
03 Using the Set Operators 5 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
04 Managing Objects with Data Dictionary Views 3 topics · 1 LiveLab +
- Query Various Data Dictionary Views
- Certification Summary
- Two-Minute Drill
1 LiveLab in this lesson — see the labs panel →
05 Manipulating Large Data Sets 4 topics · 2 LiveLab +
- Describe the Features of Multitable INSERTs
- Merge Rows into a Table
- Certification Summary
- Two-Minute Drill
2 LiveLab in this lesson — see the labs panel →
06 Controlling User Access 5 topics · 4 LiveLab +
- Differentiate System Privileges from Object Privileges
- Grant Privileges on Tables and on a User
- Distinguish Between Privileges and Roles
- Certification Summary
- Two-Minute Drill
4 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
20 LiveLabs- Deleting Rows Using a Correlated Subquery
- Using the WITH Clause
- Using the Multiple-Row Subquery
- 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
- Using the UNION Operator
- Adding the Comment to a Table
- Using the Multitable INSERT Statement
- Using the Conditional Multitable INSERT Statement
- Creating a Database User and Granting Privileges
- Granting Public Synonym Privileges to a User
- Revoking Privileges from a User
- Dropping the Database User
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
![1Z0-071.AO1: [ORACLE PRESS] Oracle Database SQL_Image](http://d3hu3i8dxloald.cloudfront.net/images/new/MHE-1Z0-071_pro.png?202608009V)
Prepare for Oracle SQL 2
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 20 LiveLab included
- Certificate of completion
No credit card required