Oracle Database 12c Administration Online Training

The 1Z0-072 was retired. However, this course still retains value as a training resource.

In this intermediate Oracle skills training, Ben Finkel covers the essential Oracle skills you’d find in the 1Z0-071 and 1Z0-072 exams, which are the two required exams to earn the Oracle Database 12c R2 Administration Certified Associate certification.

Oracle is particularly popular among the largest companies in the world, but you’ll find Oracle databases in organizations of all sizes across industries. For that reason, certified Oracle database professionals are in high demand — and that includes proficiency with SQL.

After finishing this Oracle skills training, you'll know how to implement Oracle databases, create tablespaces, migrate data, manage user access, and monitor your database performance. If you’re already comfortable with SQL, this Oracle course will familiarize you with essential Oracle operations.

For anyone who manages their Oracle training, this Oracle training can be used for 1Z0-073 exam prep, onboarding new Oracle administrators, individual or team training plans, or as a Oracle reference resource.

Oracle Database 12c Administration: What You Need to Know

This Oracle Database 12c R2 Administration Certified Associate training maps to the 1Z0-073 database 12c exam objectives, and covers topics such as:

Using relational databases, Oracle SQL, and PL/SQL
Upgrading to Oracle 12c manually or by using the Database Upgrade Assistant (DBUA)
Configuring net services, listeners, and local naming for connections
Using SQL*Plus to create, alter, and drop tablespaces
Creating, granting, or revoking users, privileges, roles, profiles, and quotas
Understanding backup types, incomplete and complete recovery, and data protection
Moving data and populating Oracle tables with Oracle Data Pump and SQL*Loader
Creating, managing, backing up, and restoring Oracle Database Cloud Service (DBCS) databases

Who Should Take Oracle Database 12c Administration Training?

This Oracle Database 12c Administration training is considered administrator-level Oracle training, which means it was designed for Oracle administrators. This database 12c skills course is valuable for new IT professionals with at least a year of experience with database languages and experienced Oracle administrators looking to validate their Oracle skills.

New or aspiring Oracle administrators. Database administration is a growing and in-demand role. Completing this training will allow aspiring database administrations to learn fundamental Oracle 12c database concepts. Additionally, the training covers all the 1Z0-073 exam’s 12c database requirements. As a result, this training can both help you prepare for certification and make yourself more marketable.

Experienced Oracle administrators. The Oracle Database 12c Administration covers the fundamentals of Oracle 12c databases and allows you to get hands-on with virtual labs. Additionally, the training covers the 12c portion of the 1Z0-073 exam. As a result, completing this training can help prepare you fulfill that Oracle Database 12c R2 Administration Certified Associate certification requirement.

Skill:
Oracle Database 12c: SQL Fundamentals (1Z0-071)
- 1. Relational DBs, Oracle, and SQL: What is a Relational Database?
  6 mins
- 2. Relational DBs, Oracle, and SQL: Tables, Views, and Queries
  4 mins
- 3. Relational DBs, Oracle, and SQL: Modeling Data With Entity Relationship Diagrams (ERD)
  5 mins
- 4. Relational DBs, Oracle, and SQL: Normalizing Databases (3NF)
  6 mins
- 5. Relational DBs, Oracle, and SQL: What is Structured Query Language (SQL)?
  5 mins
- 6. Relational DBs, Oracle, and SQL: ANSI SQL, Oracle SQL, and SQL*Plus
  5 mins
- 7. Relational DBs, Oracle, and SQL: DDL, DML, and TCL
  4 mins
- 8. Relational DBs, Oracle, and SQL: Installing Oracle Database 12c
  5 mins
- 9. Relational DBs, Oracle, and SQL: Your First SQL Statement
  5 mins
- 10. Data Definition Language (DDL): Oracle Database Structure and Schema
  4 mins
- 11. Data Definition Language (DDL): Unique Names and Namespaces
  4 mins
- 12. Data Definition Language (DDL): Creating a Table with DDL
  6 mins
- 13. Data Definition Language (DDL): Data Types for Fields
  7 mins
- 14. Data Definition Language (DDL): Creating a Constraint on a Table
  4 mins
- 15. Data Definition Language (DDL): Types of Constraints
  6 mins
- 16. Data Definition Language (DDL): Dropping Columns
  5 mins
- 17. Data Definition Language (DDL): External Tables
  6 mins
- 18. Data Definition Language (DDL): Lab
  14 mins
- 19. Data Manipulation Language (DML): Inserting Data into a Table
  5 mins
- 20. Data Manipulation Language (DML): Updating Data in a Table
  4 mins
- 21. Data Manipulation Language (DML): Selecting Data From a Table
  5 mins
- 22. Data Manipulation Language (DML): Deleting Data From a Table
  3 mins
- 23. Data Manipulation Language (DML): Truncating Data From a Table
  4 mins
- 24. Data Manipulation Language (DML): Managing Transactions with TCL
  6 mins
- 25. Data Manipulation Language (DML): Lab
  12 mins
- 26. Restricting and Sorting Query Results: Using the ORDER BY Clause
  4 mins
- 27. Restricting and Sorting Query Results: Sorting on Expressions and Aliases
  5 mins
- 28. Restricting and Sorting Query Results: Filtering with WHERE
  5 mins
- 29. Restricting and Sorting Query Results: Wildcard Comparisons Using LIKE
  3 mins
- 30. Restricting and Sorting Query Results: Boolean Logic in the WHERE Clause
  5 mins
- 31. Restricting and Sorting Query Results: IN, BETWEEN, and IS
  5 mins
- 32. Restricting and Sorting Query Results: Limiting Results with FETCH
  5 mins
- 33. Restricting and Sorting Query Results: Ampersand Substitution
  6 mins
- 34. Restricting and Sorting Query Results: Prompt, Accept, and Define
  5 mins
- 35. Restricting and Sorting Query Results: Lab
  10 mins
- 36. Single-Row and Conversion Functions: Single-Row Functions
  5 mins
- 37. Single-Row and Conversion Functions: Character Functions
  6 mins
- 38. Single-Row and Conversion Functions: Numeric Functions
  4 mins
- 39. Single-Row and Conversion Functions: Date Functions
  4 mins
- 40. Single-Row and Conversion Functions: Analytical Functions
  5 mins
- 41. Single-Row and Conversion Functions: Partition, Lag, and Lead
  3 mins
- 42. Single-Row and Conversion Functions: Conversion Functions
  6 mins
- 43. Single-Row and Conversion Functions: General Functions
  4 mins
- 44. Single-Row and Conversion Functions: Lab
  12 mins
- 45. Retrieving Data from Multiple Tables: Types of Joins
  5 mins
- 46. Retrieving Data from Multiple Tables: Inner Joins
  5 mins
- 47. Retrieving Data from Multiple Tables: Outer Joins
  6 mins
- 48. Retrieving Data from Multiple Tables: Alternative Join Types
  5 mins
- 49. Subqueries: Introduction
  4 mins
- 50. Subqueries : Correlated Subqueries
  4 mins
- 51. Subqueries: EXISTS, NOT EXISTS, and WITH
  3 mins
- 52. Subqueries: Single-Row and Multi-Row Subqueries
  5 mins
- 53. Subqueries: Lab
  12 mins
- 54. Aggregating Data: Aggregate Functions
  4 mins
- 55. Aggregating Data: Grouping with GROUP BY
  4 mins
- 56. Aggregating Data: HAVING
  3 mins
- 57. Aggregating Data: Set Operators
  4 mins
- 58. Aggregating Data: Set Output Order
  3 mins
- 59. Aggregating Data: Lab
  9 mins
- 60. Advanced Schema Operations: Objects
  6 mins
- 61. Advanced Schema Operations: Creating Views
  4 mins
- 62. Advanced Schema Operations: Creating and Using Sequences
  4 mins
- 63. Advanced Schema Operations: Creating and Maintaining Indexes
  5 mins
Skill:
Oracle Database Architecture
- 1. Installing Oracle Server
  8 mins
- 2. Oracle SQL and PL/SQL
  4 mins
- 3. Oracle Database Tools
  7 mins
- 4. Oracle Supplied User Accounts
  6 mins
- 5. Connecting to an Oracle Database
  5 mins
- 6. Querying the Data Dictionary
  5 mins
- 7. Relational Database Models
  7 mins
- 8. Installing Oracle Database Lab
  2 mins
Skill:
Oracle Network Environment Configuration
- 1. Oracle Net Services
  4 mins
- 2. Configuring Oracle Net Listener
  7 mins
- 3. Configuring Dynamic Registration
  7 mins
- 4. Configuring Local Naming
  7 mins
- 5. Testing Connectivity
  4 mins
- 6. Oracle Net Services Lab
  3 mins
Skill:
Creating and Managing Tablespaces
- 1. Understanding Oracle Tablespaces
  5 mins
- 2. Creating Tablespaces
  4 mins
- 3. Altering Tablespaces
  6 mins
- 4. Viewing Tablespace Information
  4 mins
- 5. Implementing Oracle Managed Files
  6 mins
- 6. Moving Online Data Files
  3 mins
- 7. Creating and Managing Tablespaces Lab
  1 min
Skill:
Managing UNDO Data
- 1. Oracle Undo Data
  4 mins
- 2. Configuring Undo Retention
  4 mins
- 3. Undo Retention Guarantee
  4 mins
- 4. Viewing Undo Information
  4 mins
- 5. Managing Undo Data Lab
  1 min
Skill:
Backup and Recovery Concepts
- 1. Categories of Failure
  5 mins
- 2. Backup and Recovery Strategies and Tools
  6 mins
- 3. Complete and Incomplete Recovery
  8 mins
- 4. Oracle Flashback Technology
  7 mins
- 5. Backup and Recovery on DBCS
  5 mins
- 6. Backup and Recovery Concepts Lab
  1 min
Skill:
Managing Database Instances
- 1. Initialization Parameters
  5 mins
- 2. Shutting Down and Starting Up Instances
  5 mins
- 3. Dynamic Performance Views
  3 mins
- 4. Database Configuration Assistant (DBCA)
  3 mins
- 5. DBCA Templates
  4 mins
- 6. Managing Database Instances Lab
  1 min
Skill:
Administering User Security
- 1. Creating Users
  3 mins
- 2. Granting Privileges
  5 mins
- 3. Creating and Granting Roles
  7 mins
- 4. Password Profiles
  5 mins
- 5. Authenticating Users
  4 mins
- 6. Default Tablespaces and Quotas
  5 mins
- 7. Administering User Security Lab
  1 min
Skill:
Manage Storage Space with Oracle
- 1. Segments and Extents
  8 mins
- 2. Deferred Segment Creation
  3 mins
- 3. Monitoring Space Usage
  5 mins
Skill:
Moving Data
- 1. Oracle Data Pump and SQL*Loader
  5 mins
- 2. Oracle Data Pump
  6 mins
- 3. Exporting and Importing with Data Pump
  5 mins
- 4. Oracle SQL*Loader
  5 mins
- 5. Demonstrating SQL*Loader
  6 mins
- 6. External Tables
  5 mins
- 7. Moving Data Lab
  1 min
Skill:
Monitoring and Tuning Database Performance
- 1. Performance Monitoring
  6 mins
- 2. Maintenance Windows
  6 mins
- 3. Maintenance Tasks
  4 mins
- 4. Memory Management
  6 mins
- 5. SQL Tuning Process
  7 mins
- 6. Upgrading your Database with DBUA
  5 mins
- 7. Upgrading your Database Manually
  5 mins
Skill:
Using Oracle Database Cloud Service
- 1. Oracle Database Cloud Service (DBCS) Offerings
  4 mins
- 2. DBCS Architecture
  5 mins
- 3. DBCS Deployment
  4 mins
- 4. Network Access to DBCS
  6 mins
- 5. Connecting to DBCS
  5 mins

No Transcript Available

Relational DBs, Oracle, and SQL: What is a Relational Database?

Access all premium content with a free week!

Start a free week

Course overview

11 HOURS OF TRAINING

12 SKILLS

130 VIDEOS

6 VIRTUAL LABS

0 PRACTICE EXAMS

Ben Finkel

Nugget trainer since 2014

Read the full bio

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT

Read Reviews

Oracle Database 12c Administrator Certified Associate (1Z0-071 & 1Z0-072) FAQs: Cost, Training, Value

What will you learn in this Oracle database administrator (1Z0-071 & 1Z0-072) training?

After this course, you won't just have a strong understanding of Oracle databases and their administration – you'll have experience actually doing the steps that go into keeping them configured and optimized. That's because this course is full of different chances to practice Oracle database administration and configuration.

Who should take this Oracle Certified Database Administrator course?

This course is meant for brand new database administrators or IT professionals who want to eventually become database administrators. But it's also a great way for current database administrators to "kick the tires" of their own skills and knowledge since it's a thorough exploration of basic and intermediate Oracle administration.

Is this Oracle database administrator (1Z0-071 & 1Z0-072) training associated with any certifications?

No, although when it was originally developed, this Oracle Database Administrator training was a training resource for an Oracle certification, that exam has been retired. The material on this course was designed for Oracle exams 1Z0-071 and 1Z0-072, and while it's still useful information, the tests have changed.

What certification should you consider after taking this Oracle Database Administrator Certified Associate course?

After you take this Oracle database administration training, you might want to explore certifications that can help you advance your career. The best bet would be the current version of the Oracle Database 12c Administrator Certified Associate that this course was originally designed to prepare learners for.

Why should you take this (1Z0-071 & 1Z0-072) Oracle database administrator training?

You should take this Oracle database administrator training because it provides much more than just theory and videos that explain database administration. After all the virtual simulations and practice environments where you actually run the commands and configure (virtual) devices, you'll understand what makes Oracle unique in the database world.

SQL for Data Practitioners

Microsoft Azure Data Fundamentals (DP-900)