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

Course fee

Cost: R3 500.00

Deposit : R875.00

Monthly instalment: R875.00 x 3

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.

About the course

Course code: C01160

This course is intended for:

Candidates who want to prove fluency in and a solid understanding of SQL language, data modeling and using SQL to create and manipulate tables in an Oracle Database. Qualified candidates have knowledge of general computing concepts, knowledge of command line interfaces and experience working in command line.

You will learn the following skills:

• Relational Database concepts
• Retrieving Data using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Using Conversion Functions and Conditional Expressions
• Reporting Aggregated Data Using Group Functions
• Displaying Data from Multiple Tables
• Using Subqueries to Solve Queries
• Using SET Operators
• Managing Tables using DML statements
• Managing Indexes Synonyms and Sequences
• Use DDL to manage tables and their relationships
• Managing Views
• Controlling User Access
• Managing Objects with Data Dictionary Views
• Managing Data in Different Time Zones

Modules and topics covered:

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

Admission requirements

Academic grade: No minimum school pass requirements or formal prerequisites but it is recommended that candidates have a basic understanding of SQL and database concepts.

Language: Proficiency in English (course material and support only available in English).

Expertise level: Intermediate.

Equipment: Access to a PC or laptop with a reliable internet connection.

Effort: Self-paced learning online.

Accreditation status

Course type: Industry endorsed

Industry partner: Oracle

Certification: Certificate confirming course completion.

Certification issued by: College SA

Assessment details

• Online assessments via the Skillsoft Learner Management System.
• At the end of the course, students can request a certificate of course completion.
• Students who then opt to proceed with the external industry exam(s) are directed to the relevant vendor.

Exam information:

• External industry exam: 1Z0-071
• Exam format: Multiple choice
• Duration: 120 minutes
• Number of questions: 63
• Passing score: 63%
• Delivery method: Pearson VUE testing centre or online proctored exam.
• Exam fees: Not included in the course fee.

What to expect

Dedicated support team

We understand that students may require guidance and support to navigate the learning journey, and our Client Services team is always ready to assist them in every possible way. Our team is readily available during office hours and can be contacted via email, phone, WhatsApp and social media.

Exam booking assistance

Depending on your chosen course you will either receive advice or assistance in booking certain exams yourself, or our exam team will make a booking on your behalf. Our team will advise you on the venue closest to you, assist with booking a seat, and confirm the time, date and logistics for your exam sitting. College SA also offers discounted exam vouchers for numerous IT certification exams.

Skillsoft Learner Management System (LMS) access

Skillsoft is an online learning management system that offers all students enrolled for any of our IT Academy courses compelling content, interactive videos, quizzes, and mentoring. The platform allows students to learn at their own pace.