1Z0-071.AO1
[ORACLE PRESS] Oracle Database SQL
Prepare the Oracle SQL Associate role and collect your DREAMS & DATA.
- Practice in 60 Hands-On Labs — nothing to install
- 14 Interactive Lessons and 84 topics mapped to the official exam objectives
- 138 Practice Test Questions and 1 Full Length Tests
Beginner Self-paced · 1 year access
60 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
14Interactive Lessons
84Topics
60LiveLab
138Practice Test Questions
208Flashcards
208Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
Accumulate & Arrange data effortlessly with our SQL training and become a formidable productivity champion!
We provide bite-sized lessons on SQL fundamentals with post-assessment tests to prepare you for your certification exam. If you want your preparation to be fun, we have developed fun gamified tests and hands-on labs where you can practically execute your SQL training.
So, stop wondering, take our Oracle SQL Course Online, surf through piles of data, and become a smart individual desired by every workplace.
- Get equipped with the SQL Query structure: SELECT, FROM, WHERE
- Retrieve Data from an Oracle Database Table.
- Create, Alter & Drop Table.
- Drop & set UNUSED Columns.
- Utilize Data Manipulation Language (DML) to Insert, Delete & Retrieve Data.
- Manage Permission & Access to the Database with Data Control Language (DCL).
- Perform Analytical and Window functions with SQL Programming.
- Get skilled in single-row and other SQL Functions.
- Perform advanced database administration tasks with SQL.
Course Highlights
-
14 Structured Lessons Comprehensive coverage of core course objectives
-
60 Hands-On LiveLabs Interactive guided scenarios with instant evaluation
-
138 Practice Questions Assessment tests with detailed answer rationales
-
1 Year Full Access Self-paced learning accessible anytime on all devices
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
14 Interactive Lessons · 84 topics01 Oracle and Structured Query Language (SQL) 8 topics · 2 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
- Certification Summary
- Two-Minute Drill
2 LiveLab in this lesson — see the labs panel →
02 Using DDL Statements to Create and Manage Tables 9 topics · 7 LiveLab +
- 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
7 LiveLab in this lesson — see the labs panel →
03 Manipulating Data 7 topics · 5 LiveLab +
- Truncate Data
- Insert Rows into a Table
- Update Rows in a Table
- Delete Rows from a Table
- Control Transactions
- Certification Summary
- Two-Minute Drill
5 LiveLab in this lesson — see the labs panel →
04 Restricting and Sorting Data 6 topics · 7 LiveLab +
- 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
7 LiveLab in this lesson — see the labs panel →
05 Using Single-Row Functions to Customize Output 4 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
- Certification Summary
- Two-Minute Drill
7 LiveLab in this lesson — see the labs panel →
06 Using Conversion Functions and Conditional Expressions 5 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
- Certification Summary
- Two-Minute Drill
6 LiveLab in this lesson — see the labs panel →
07 Reporting Aggregated Data Using the Group Functions 5 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
- Certification Summary
- Two-Minute Drill
2 LiveLab in this lesson — see the labs panel →
08 Displaying Data from Multiple Tables 6 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
- Certification Summary
- Two-Minute Drill
4 LiveLab in this lesson — see the labs panel →
09 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 →
10 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 →
11 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 →
12 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 →
13 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 →
14 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
60 LiveLabs- 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
Labs run in your browser — nothing to install.
03 / FAQs
Questions before you start
What is the Oracle 1Z0-071 certification exam?+
This certification exam is conducted by Orcale to check an individual’s proficiency in SQL on the Oracle database. Our preparation course provides you access to bite-sized lessons and post-assessment questions to effectively pass the Oracle 1Z0-071 exam. Prepare with us to become an Oracle Database SQL Certified Associate.
What is Oracle SQL used for?+
Oracle SQL is the language of Database that makes it possible to interact with Oracle databases. It helps implement various functions related to data. Find files, add columns, remove rows, and do more with SQL.
Who is this course suitable for?+
This course is built for all individuals who plan on working in Structured Query Language (SQL) with Oracle Database. This course will help the following individuals:
- Beginners or Graduates
- Potential Database Developers
- Software Developers
- Data scientists
- IT Professionals
Can I optimize SQL queries after this course?+
Yes, you’ll be able to optimize SQL queries by the end of the course. You can leverage this course to perform the following:
- Solve single-row and multi-row queries.
- Utilize subqueries to solve complex data retrieval problems.
- Most importantly, you’ll get access to our Hands-on Labs to practice what you learn before your certification
How can this course help my career?+
Oracle SQL Course can be a game changer for your resume in the following ways:
- For Beginners, it opens opportunities in various Data Management fields.
- For Seasoned Professionals, it can be the next step on the corporate ladder for career advancement.
- For Entrepreneurs, it can be a valuable skill that saves money & time.
Design, Develop & Deploy Database
Get skilled & grab SQL Database projects with the help of our Oracle SQL Training.
- 1 year of full access
- 60 LiveLab included
- Certificate of completion
No credit card required