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

Course fee

Cost: R2 926.00

Deposit : R731.50

Monthly instalment: R731.50 x 3

Duration: You will have Skillsoft access to this course for 12 months. The average time required to work through the syllabus is:

• 17 courses (16h 29m) / 3 others (2h)
• Optional additional resources are available to enhance your learning in your own time.

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

Assessment information:

• 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 format: A combination of multiple choice and performance-based questions.
• 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, and social media.

Exam booking assistance

Depending on the course you are registered for, you will either receive guidance on how to book your exam yourself or, in some cases, our exam team will assist with the booking process. We will advise you on available venues, help secure a seat, and provide confirmation of the date, time, and exam logistics.

Please note that College SA provides discounted exam vouchers for CompTIA exams. For other external exams, we can offer advice, but you will need to book and manage these independently

Skillsoft Learner Management System (LMS) access

Skillsoft is an online learning platform that offers engaging content, including interactive videos and quizzes, designed to support real-world learning. Students can study at their own pace while developing practical, career-focused skills.