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

R3 328.50

Become an Oracle Database SQL Certified Associate and demonstrate understanding of fundamental SQL concepts needed to undertake any database project. Gain a working knowledge of queries, SQL statements, Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization.

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

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.

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

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.

Course type: Industry endorsed

Industry partner: Oracle

Certification: Certificate confirming course completion.

Certification issued by: Optimi College

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: 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.

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. Optimi College 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, mentoring and practical simulations/virtual labs. The platform allows students to learn at their own pace.

Skillsoft app access

Improve yourself in minutes a day, any time, anywhere. Access content across a variety of topics including business, personal development, desktop software and IT. Stay current with courses and video from world-class experts. All students enrolled for any of our IT Academy courses will be able to access the app.

"*" indicates required fields

Are you still in school?*
When do you want to start?*
Do you require financial assistance?
Optimi College is in partnership with Student Hero. By selecting “yes” you consent to share your name and contact information with Student Hero so that they can assist you with seeking financial aid.
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
This field is hidden when viewing the form
*Selected IT classes at the Bellville campus (Cape Town) only
This field is for validation purposes and should be left unchanged.

Similar courses

Register now