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
1Practice Exam
7h 1mTotal
63 videos6 labs1 exam

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.

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
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Data Manipulation Language (DML)49m
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Restricting and Sorting Query Results1h 7m
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Single-Row and Conversion Functions1h 1m
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Retrieving Data from Multiple Tables24m
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Subqueries38m
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Aggregating Data38m
  • Premium skill.Oracle Database 12c: SQL Fundamentals (1Z0-071): Advanced Schema Operations22m

Certification

Oracle Database SQL Certified Associate

The Oracle Database SQL Certified Associate certification validates a candidate's skills in writing subqueries, managing database objects, and using SQL to manage data. This certification is ideal for database administrators, developers, and analysts...

Exam 1Z0-071Level AssociateDifficulty BeginnerCost $245
SQL fundamentalsData retrievalData manipulationData definition languageData control languageRelational database concepts
Official certification page

Pre-Assessment

Take a skills-gap assessment to evaluate your team's readiness for the Oracle Database SQL Certified Associate certification before starting this course.

Coming soon.

This course is included with every subscription

Get your team access to all 700+ 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

Need access for just one person? See individual options

Trusted by 23,000+ organizations

Ready to upskill your team?

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