[ORACLE PRESS] Oracle Database SQL
(1Z0-071.AO1)
/ ISBN: 978-1-64459-435-3
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
[ORACLE PRESS] Oracle Database SQL
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
- 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
×