.jpg){kind=logo}
STY-CIS377.AO1
CIS377: 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
10 Interactive Lessons · 32 topics01 Week 1: Using Subqueries to Solve Queries Part I 6 topics · 1 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
- Summary
1 LiveLab in this lesson — see the labs panel →
02 Week 2: Using Subqueries to Solve Queries Part II 4 topics · 2 LiveLab +
- Use the EXISTS and NOT EXISTS Operators
- Use the WITH Clause
- Write Single-Row and Multiple-Row Subqueries
- Summary
2 LiveLab in this lesson — see the labs panel →
03 Week 3: Managing Schema Objects Part I 3 topics · 2 LiveLab +
- Describe How Schema Objects Work
- Create Simple and Complex Views with Visible/Invisible Columns
- Summary
2 LiveLab in this lesson — see the labs panel →
04 Week 4: Managing Schema Objects Part II 3 topics · 4 LiveLab +
- Create, Maintain, and Use Sequences
- Create and Maintain Indexes Including Invisible Indexes and Multiple Indexes on the Same Columns
- Summary
4 LiveLab in this lesson — see the labs panel →
05 Week 5: Managing Schema Objects Part III 2 topics · 3 LiveLab +
- Perform Flashback Operations
- Summary
3 LiveLab in this lesson — see the labs panel →
06 Week 6: Using the Set Operators 4 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
1 LiveLab in this lesson — see the labs panel →
07 Week 7: Managing Objects With Data Dictionary Views 2 topics · 1 LiveLab +
- Query Various Data Dictionary Views
- Certification Summary
1 LiveLab in this lesson — see the labs panel →
08 Week 8: Manipulating Large Data Sets 3 topics · 2 LiveLab +
- Describe the Features of Multitable INSERTs
- Merge Rows into a Table
- Certification Summary
2 LiveLab in this lesson — see the labs panel →
09 Week 9: Controlling User Access Part I 3 topics · 3 LiveLab +
- Differentiate System Privileges from Object Privileges
- Grant Privileges on Tables and on a User
- Summary
3 LiveLab in this lesson — see the labs panel →
10 Week 10: Controling User Access Part II 2 topics · 1 LiveLab +
- Distinguish Between Privileges and Roles
- Summary
1 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 Select Statement to Retrieve Data
- Creating a View
- Dropping a View
- Creating and Using a Sequence
- Creating an Implicit Index
- Creating a Unique Index
- Altering a Unique Index
- Dropping a Unique Index
- Dropping a Table
- Restoring the Table Using Flashback
- Using the UNION Operator
- Adding the Comment on a Table
- Using the Conditional Multitable INSERT Statement
- Using the Multitable INSERT Statement
- Creating a Database User and Granting Privileges
- Revoking Privileges from a User
- Dropping the Database User
- Granting Public Synonym Privileges to a User
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 CIS377: 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