Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

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
Johannesburg
South Africa 1684

You are here

courses popup callback

LIVE LAB:

Oracle 12c OCP 1Z0-061: SQL Fundamentals

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

Overview

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

Exercises

  1. Features of Oracle Database 12c
  2. Total Learning Time is 60  Minutes and module version is 7

    Exercises:
    • Introduction
    • Oracle Database 12c
    • Summary
  3. Retrieving Data Using SQL Statements
  4. Total Learning Time is 60  Minutes and module version is 12

    Exercises:
    • Introduction
    • SQL SELECT Statements
    • Basic SELECT Statements
    • Summary
  5. Restricting and Sorting Data
  6. Total Learning Time is 60  Minutes and module version is 8

    Exercises:
    • Introduction
    • Limiting Rows Retrieved by Queries
    • Sorting Rows Retrieved by Queries
    • Summary
  7. Using Single Row Functions to Customize Output
  8. Total Learning Time is 60  Minutes and module version is 16

    Exercises:
    • Introduction
    • Functions Available in SQL
    • Using General Functions in SELECT statements
    • Summary
  9. Conversion Functions and Conditional Expressions
  10. Total Learning Time is 60  Minutes and module version is 7

    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. Total Learning Time is 60  Minutes and module version is 7

    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. Total Learning Time is 60  Minutes and module version is 8

    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. Total Learning Time is 60  Minutes and module version is 6

    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. Total Learning Time is 60  Minutes and module version is 6

    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. Total Learning Time is 60  Minutes and module version is 3

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