[ORACLE PRESS] Oracle Database SQL

(1Z0-071.AO1)
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
MHE-1Z0-071_pro MHE-1Z0-071_pro
Try this course Pre-Assessment and first two Lessons free No credit card required
Are you an instructor? Teach using uCertify products
Request a free evaluation copy

[ORACLE PRESS] Oracle Database SQL

Here's what you will get

Lessons
  • 14+ Lessons
  • 211+ Quizzes
  • 208+ Flashcards
  • 208+ Glossary of terms
TestPrep
  • 1+ Full Length Tests
  • 78+ Practice Test Questions
LiveLab
  • 60+ LiveLab
  • 121+ Video tutorials
  • 02:06+ Hours
Here's what you will learn
Download Course Outline
  • 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
  • Certification Summary
  • Two-Minute Drill
  • Categorize the Main Database Objects
  • Create a Simple Table
  • Review the Table Structure
  • List the Data Types That Are Available for Columns
  • Explain How Constraints Are Created at the Time of Table Creation
  • Drop Columns and Set Column UNUSED
  • Create and Use External Tables
  • Certification Summary
  • Two-Minute Drill
  • Truncate Data
  • Insert Rows into a Table
  • Update Rows in a Table
  • Delete Rows from a Table
  • Control Transactions
  • Certification Summary
  • Two-Minute Drill
  • Sort the Rows That Are Retrieved by a Query
  • Limit the Rows That Are Retrieved by a Query
  • Use Ampersand Substitution to Restrict and Sort Output at Run Time
  • Use the SQL Row Limiting Clause
  • Certification Summary
  • Two-Minute Drill
  • Use Various Types of Functions That Are Available in SQL
  • Use Character, Number, Date, and Analytical (PER...TDDEV, LAG, LEAD) Functions in SELECT Statements
  • Certification Summary
  • Two-Minute Drill
  • 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
  • Certification Summary
  • Two-Minute Drill
  • Describe the Use of Group Functions
  • Group Data by Using the GROUP BY Clause
  • Include or Exclude Grouped Rows by Using the HAVING Clause
  • Certification Summary
  • Two-Minute Drill
  • 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
  • Certification Summary
  • Two-Minute Drill
  • 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
  • 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
  • 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
  • Query Various Data Dictionary Views
  • Certification Summary
  • Two-Minute Drill
  • Describe the Features of Multitable INSERTs
  • Merge Rows into a Table
  • Certification Summary
  • Two-Minute Drill
  • Differentiate System Privileges from Object Privileges
  • Grant Privileges on Tables and on a User
  • Distinguish Between Privileges and Roles
  • Certification Summary
  • Two-Minute Drill

Hands on Activities (Live Labs)

  • 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
  • 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
×