Oracle (OCA) Database 12c R2: SQL Fundamentals (1Z0-071)

R3 328.50

The 1Z0-071 course is targeted at IT professionals who are working towards becoming an Oracle Database 12c SQL Certified Associate.

Online books Digital learning
Clock Start anytime
Study duration (Months)
Computer Skillsoft LMS access
People Industry partner: Oracle
Certificate Certified by Optimi College

Course code: C01160

 

Subjects:

Oracle (OCA) Database 12c R2: SQL Fundamentals (1Z0-071)

Oracle Database 12c R2 SQL: Data Manipulation Language and Transaction Control Language
Oracle Database 12c R2 SQL: Using Basic SELECT statements
Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Oracle Database 12c R2 SQL: Conversion Functions and Conditional Expressions
Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Oracle Database 12c R2 SQL: Using the Set Operators
Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Oracle Database 12c R2 SQL: SQL*Plus
Oracle Database 12c R2 SQL: Restricting and Sorting Data
Oracle Database 12c R2 SQL: Managing Schema Objects
Oracle Database 12c R2 SQL: Data Definition Language (DDL)
Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
Oracle Database 12c R2 SQL: Reporting Aggregated Data Using the Group Functions
Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
Oracle Database 12c R2 SQL: Creating Other Schema Objects
Oracle Database 12c R2 SQL: Controlling User Access
Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
TestPrep 1Z0-071 Oracle Database SQL

The ability to read and write in English.

Learners must be at least 16 years of age.

Expertise level: Intermediate

Course type: Industry endorsed

Industry partner: Oracle

Certification: Certificate confirming course completion.

Certification issued by: Optimi College

Assessment information:

Online assessments

 

Exam information:

  • External industry exam.
  • Exam fees are not included in the course fee.

Course fee: R3 328.50

Deposit : R1 667.40

Monthly instalment: R553.70

Payment duration: 3 months

Study duration: You will have course access for 12 months. To complete the course, we recommend a total of 30 hours of study, e.g. study 1 hour per day and complete your course in 1 month.

Dedicated support team

Online Skillsoft mentor

Exam booking assistance

Skillsoft Learner Management System (LMS) access

Skillsoft app access