Oracle

[ORACLE PRESS] Oracle Database SQL

Prepare the Oracle SQL Associate role and collect your DREAMS & DATA.

(1Z0-071.AO1) / ISBN : 978-1-64459-435-3
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

About This Course

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. 

Skills You’ll Get

  • 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. 
Download Course Outline

1

Oracle and Structured Query Language (SQL)

  • 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

Using DDL Statements to Create and Manage Tables

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

Manipulating Data

  • Truncate Data
  • Insert Rows into a Table
  • Update Rows in a Table
  • Delete Rows from a Table
  • Control Transactions
  • Certification Summary
  • Two-Minute Drill
4

Restricting and Sorting Data

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

Using Single-Row Functions to Customize Output

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

Using Conversion Functions and Conditional Expressions

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

Reporting Aggregated Data Using the Group Functions

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

Displaying Data from Multiple Tables

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

Using Subqueries to Solve Queries

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

Managing Schema Objects

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

Using the Set Operators

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

Managing Objects with Data Dictionary Views

  • Query Various Data Dictionary Views
  • Certification Summary
  • Two-Minute Drill
13

Manipulating Large Data Sets

  • Describe the Features of Multitable INSERTs
  • Merge Rows into a Table
  • Certification Summary
  • Two-Minute Drill
14

Controlling User Access

  • Differentiate System Privileges from Object Privileges
  • Grant Privileges on Tables and on a User
  • Distinguish Between Privileges and Roles
  • Certification Summary
  • Two-Minute Drill

1

Oracle and Structured Query Language (SQL)

  • Normalizing a Table
  • Creating a Table and Inserting Records in it
2

Using DDL Statements to Create and Manage Tables

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

Manipulating Data

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

Restricting and Sorting Data

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

Using Single-Row Functions to Customize Output

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

Using Conversion Functions and Conditional Expressions

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

Reporting Aggregated Data Using the Group Functions

  • Using the GROUP BY Clause
  • Using the HAVING Clause
8

Displaying Data from Multiple Tables

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

Using Subqueries to Solve Queries

  • Deleting Rows Using a Correlated Subquery
  • Using the WITH Clause
  • Using the Multiple-Row Subquery
10

Managing Schema Objects

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

Using the Set Operators

  • Using the UNION Operator
12

Managing Objects with Data Dictionary Views

  • Adding the Comment to a Table
13

Manipulating Large Data Sets

  • Using the Multitable INSERT Statement
  • Using the Conditional Multitable INSERT Statement
14

Controlling User Access

  • Creating a Database User and Granting Privileges
  • Granting Public Synonym Privileges to a User
  • Revoking Privileges from a User
  • Dropping the Database User

Any questions?
Check out the FAQs

Still have questions about the Oracle SQL course? Find out more here.

Contact Us Now

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.

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.

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

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

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.

Related Courses

All Course