1Z0-071.AO1
[ORACLE PRESS] Oracle Database SQL
Prepare the Oracle SQL Associate role and collect your DREAMS & DATA.
- Practice in 60 Laboratorios prácticos — nothing to install
- 14 Lecciones interactivas y 84 topics mapped to the official exam objectives
- 138 Preguntas del examen de práctica y 1 Pruebas completas
Beginner A tu propio ritmo · 1 año de acceso
60 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
14Lecciones interactivas
84Topics
60Laboratorio en vivo
138Preguntas del examen de práctica
208Tarjetas didácticas
208Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
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 Lecciones estructuradas Cobertura completa de los objetivos principales del curso
-
60 LiveLabs prácticos Escenarios interactivos guiados con evaluación instantánea
-
138 Preguntas de práctica Pruebas de evaluación con justificaciones de respuesta detalladas
-
1 año de acceso completo Aprendizaje a tu propio ritmo, accesible en cualquier momento y en todos los dispositivos
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
14 Lecciones interactivas · 84 topics01 Oracle and Structured Query Language (SQL) 8 topics · 2 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
02 Using DDL Statements to Create and Manage Tables 9 topics · 7 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
03 Manipulating Data 7 topics · 5 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
04 Restricting and Sorting Data 6 topics · 7 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
05 Using Single-Row Functions to Customize Output 4 topics · 7 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
06 Using Conversion Functions and Conditional Expressions 5 topics · 6 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
07 Reporting Aggregated Data Using the Group Functions 5 topics · 2 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
08 Displaying Data from Multiple Tables 6 topics · 4 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
09 Using Subqueries to Solve Queries 10 topics · 3 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
10 Managing Schema Objects 7 topics · 9 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
11 Using the Set Operators 5 topics · 1 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
12 Managing Objects with Data Dictionary Views 3 topics · 1 Laboratorio en vivo +
- Query Various Data Dictionary Views
- Certification Summary
- Two-Minute Drill
1 Laboratorio en vivo in this lesson — see the labs panel →
13 Manipulating Large Data Sets 4 topics · 2 Laboratorio en vivo +
- Describe the Features of Multitable INSERTs
- Merge Rows into a Table
- Certification Summary
- Two-Minute Drill
2 Laboratorio en vivo in this lesson — see the labs panel →
14 Controlling User Access 5 topics · 4 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
Laboratorios prácticos Our edge
60 Laboratorio en vivos- 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
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
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 año de acceso completo
- 60 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito