Skip to content
CBT Nuggets

Oracle Database SQL Certified Associate (1Z0-071)

This Oracle Database SQL Certified Associate (1Z0-071) training covers how to use the fundamental SQL necessary to work with an Oracle Database server. This Oracle training is actually a SQL course that anyone can use to learn the SQL flavor called Oracle SQL. Follow along in the Oracle virtual labs to learn Oracle’s flavor of the popular query language SQL.

Updated November 2019

9Skills
63Videos
6Virtual Labs
7h 1mTotal
63 videos6 labs7h 1m

Who This Course Is For

This Database Associate training is considered associate-level Oracle training, which means it was designed for data analysts, database administrators, and anyone who needs to learn the Oracle SQL query language. This 1Z0-071 course is valuable for new IT professionals with at least a year of experience with Oracle databases and experienced data professionals looking to validate their Oracle skills.

Skills Your Team Will Gain

  • Learn about Relational Databases
  • Tables, views, and queries in Relational DBs
  • Introduction to Structured Query Language (SQL)
  • Oracle Database Structure and Schema
  • Aggregating, Manipulating, and Retrieving Data
  • Restricting and sorting query results

Course Curriculum

  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Relational DBs, Oracle, and SQL54m
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Data Definition Language (DDL)1h 9m + 1 lab
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Data Manipulation Language (DML)49m + 1 lab
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Restricting and Sorting Query Results1h 7m + 1 lab
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Single-Row and Conversion Functions1h 1m + 1 lab
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Retrieving Data from Multiple Tables24m
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Subqueries38m + 1 lab
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Aggregating Data38m + 1 lab
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Advanced Schema Operations22m

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT Directors use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own lesson transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes

Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one? Create an Adept account.

This course is included with every subscription

Get your team access to all 559 courses, virtual labs, and practice exams.

Most Popular

Team

$749per seat / year

5+ learner seats

Get Started

Enterprise

Customannual contracts

Any size

Contact Enterprise Sales
Calculate the ROI of training your team

Trusted by 23,000+ organizations

Frequently Asked Questions

Ready to upskill your team?

Talk to our sales team to find the right plan for your organization.