.jpg){kind=logo}
STY-CIS376.AO2
CIS376: Oracle SQL 1
Self-paced · 1 year access
41 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 · 42 topics01 Oracle and Structured Query Language (SQL) 7 topics · 3 LiveLab +
- The Exam: An Overview
- Identify the Connection Between an ERD and a Relational Database
- Explain the Relationship Between a Database and SQL
- Describe the Purpose of DDL
- Describe the Purpose of DML
- Build a SELECT Statement to Retrieve Data from an Oracle Database Table
- Two-Minute Drill
3 LiveLab in this lesson — see the labs panel →
02 Using DDL Statements to Create and Manage Tables (Part 1) 4 topics · 5 LiveLab +
- Categorize the Main Database Objects
- Create a Simple Table
- Review the Table Structure
- List the Data Types That Are Available for Columns
5 LiveLab in this lesson — see the labs panel →
03 Using DDL Statements to Create and Manage Tables (Part 2) 4 topics · 2 LiveLab +
- Explain How Constraints Are Created at the Time of Table Creation
- Drop Columns and Set Column UNUSED
- Create and Use External Tables
- Two-Minute Drill
2 LiveLab in this lesson — see the labs panel →
04 Manipulating Data 6 topics · 5 LiveLab +
- Truncate Data
- Insert Rows into a Table
- Update Rows in a Table
- Delete Rows from a Table
- Control Transactions
- Two-Minute Drill
5 LiveLab in this lesson — see the labs panel →
05 Restricting and Sorting Data (Part 1) 2 topics · 3 LiveLab +
- Sort the Rows That Are Retrieved by a Query
- Limit the Rows That Are Retrieved by a Query
3 LiveLab in this lesson — see the labs panel →
06 Restricting and Sorting Data (Part 2) 3 topics · 4 LiveLab +
- Use Ampersand Substitution to Restrict and Sort Output at Run Time
- Use the SQL Row Limiting Clause
- Two-Minute Drill
4 LiveLab in this lesson — see the labs panel →
07 Using Single-Row Functions to Customize Output 3 topics · 7 LiveLab +
- Use Various Types of Functions That Are Available in SQL
- Use Character, Number, Date, and Analytical (PER...TDDEV, LAG, LEAD) Functions in SELECT Statements
- Two-Minute Drill
7 LiveLab in this lesson — see the labs panel →
08 Using Conversion Functions and Conditional Expressions 4 topics · 6 LiveLab +
- Describe Various Types of Conversion Functions
- Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
- Apply General Functions and Conditional Expressions in a SELECT Statement
- Two-Minute Drill
6 LiveLab in this lesson — see the labs panel →
09 Reporting Aggregated Data Using the Group Functions 4 topics · 2 LiveLab +
- Describe the Use of Group Functions
- Group Data by Using the GROUP BY Clause
- Include or Exclude Grouped Rows by Using the HAVING Clause
- Two-Minute Drill
2 LiveLab in this lesson — see the labs panel →
10 Displaying Data from Multiple Tables 5 topics · 4 LiveLab +
- Describe the Different Types of Joins and Their Features
- Use SELECT Statements to Access Data from More Than One Table Using Equijoins and Non-Equijoins
- Join a Table to Itself by Using a Self-Join
- View Data That Generally Does Not Meet a Join Condition by Using Outer Joins
- Two-Minute Drill
4 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
41 LiveLabs- SandBox Lab
- Normalizing a Table
- Creating a Table and Inserting Records in it
- Altering the Table
- Adding a Foreign Key
- Dropping a Primary Key and Adding a Unique Key
- Viewing the Table Structure
- Creating a Table Using the CLOB Data Type
- Creating a Table Using Constraints
- Dropping a Column
- Truncating a Table
- Inserting Records in the Existing Table
- Updating a Record in the Table
- Deleting a Record from the Table
- Using the Commit and Rollback Statements
- Sorting the Result
- Using the Boolean Operator
- Using the LIKE Operator
- Using the ACCEPT and PROMPT Statements
- Using the Fetch Statement
- Using the WITH TIES Clause
- Using the OFFSET-FETCH Clause
- Using the INITCAP Function
- Using the STDDEV Function
- Using the LEAD and LAG Functions
- Using the REMAINDER Function
- Using the SUBSTR Function
- Using the RTRIM Function
- Using the CONCAT Function
- Using the Implicit and Explicit Conversions
- Using the TO_DATE Function
- Using the TO_CHAR Function
- Using the TO_NUMBER Function
- Using the NVL Function
- Using the Case Statement
- Using the GROUP BY Clause
- Using the HAVING Clause
- Using the INNER JOIN Operation
- Creating a Table Using Records of Another Table
- Using the NATURAL JOIN Operation
- Using the LEFT OUTER JOIN and RIGHT OUTER JOIN Operation
Labs run in your browser — nothing to install.
03 / 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 CIS376: Oracle SQL 1
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
- 41 LiveLab included
- Certificate of completion
No credit card required