Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
South Africa 1684

You are here

Oracle 12c OCP 1Z0-061: SQL Fundamentals


Oracle 12c OCP 1Z0-061: SQL Fundamentals

Practical exercises in a live environment to help you get real-world, hands-on experience.


The 1Z0-061 Practice Lab will provide you with the necessary platform to gain hands on skills in Oracle. By completing the lab tasks you will improve your practical skills in Retrieving Data, Restricting and Sorting Data, Using Single-Row Functions to Customize Output, Using Conversion Functions and Conditional Expressions, Reporting Aggregated Data Using the Group Functions, Displaying Data from Multiple Tables Using Joins, Using Subqueries to Solve Queries and Managing Tables using DML Statements. These same tasks will help you understand the objectives and competencies required by the Oracle 1Z0-061 certification exam.

Vendor:   Oracle
Vendor Id:   ORACLE-1Z0-061
Version:   1
Level:   Entry
Learning Time:   360  Minutes


  1. Features of Oracle Database 12c
  2. Exercises:
    • Introduction
    • Oracle Database 12c
    • Summary
  3. Retrieving Data Using SQL Statements
  4. Exercises:
    • Introduction
    • SQL SELECT Statements
    • Basic SELECT Statements
    • Summary
  5. Restricting and Sorting Data
  6. Exercises:
    • Introduction
    • Limiting Rows Retrieved by Queries
    • Sorting Rows Retrieved by Queries
    • Summary
  7. Using Single Row Functions to Customize Output
  8. Exercises:
    • Introduction
    • Functions Available in SQL
    • Using General Functions in SELECT statements
    • Summary
  9. Conversion Functions and Conditional Expressions
  10. Exercises:
    • Introduction
    • Conversion Functions Available in SQL
    • Introduction to TO_CHAR, TO_DATE and TO_NUMBER
    • Apply Conditional Expressions in a SELECT Statement
    • Summary
  11. Reporting Aggregated Data Using Group Function
  12. Exercises:
    • Introduction
    • Identify Available Group Functions
    • Using Group Functions
    • Group Data using GROUP BY Clause
    • Include or Exclude Grouped Rows
    • Summary
  13. Displaying Data from Multiple Tables using JOIN
  14. Exercises:
    • Introduction
    • Using EQUIJOINS and NON EQUIJOINS to Access Data from Multiple Tables
    • Using SELF JOIN
    • Using OUTER JOIN
    • Generate Cartesian Product using CROSS JOIN
    • Summary
  15. Using Subqueries
  16. Exercises:
    • Introduction
    • Define Subqueries
    • Troubleshooting with Subqueries
    • Types of Subqueries
    • Write Single Row and Multiple Row Sub Queries
    • SET Operators
    • Combine Multiple Queries with SET Operators
    • Summary
  17. Managing Tables using DML Statements
  18. Exercises:
    • Introduction
    • Truncate Data
    • Insert a Row into a Table
    • Update Rows in a Table
    • Delete Rows from a Table
    • Control Transactions
    • Summary
  19. Introduction to DDL Language
  20. Exercises:
    • Introduction
    • Categorizing Main Database Objects
    • Table Structure
    • Data Types for Columns
    • Creating a Simple Table
    • Introduction to Constraints
    • Introduction to Schema Objects
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
USD 295 USD 120 59% OFF
  • 360
    + Minutes of practical exercises
  • Gain practical experience with real-world scenarios
  • Access to real hardware & software in real time
  • Experiment & put theory to practice
  • Includes exercises designed to prepare for exams.
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top