Practice Lab 1Z0-061: Oracle Database 12c: SQL Fundamentals

$169.00
$204.49 incl. vat

duration: 11 hours |

access duration: 180 days

Through this LiveLab, focussed on 1Z0-061: Oracle Database 12c: SQL Fundamentals, you will receive hands-on experience regarding the Oracle database management system with SQL, you will improve your practical knowledge and skills on the various exam subjects.
You will perform practical exercises regarding Entity Relationship Model, SQL Developer, HR Schema, AUTOTRACE, Distinct, MOD function, Sysdate, Trunc functions, Case Expression and far more.

Result

You have extensive experience with regards tothe Oracle database management system with SQL.

Prerequisites

You have successfully finished a training course for the certification exam this lab helps you to prepare for. A training course for this lab is available through us.

Target audience

Database Administrators

Practice Lab 1Z0-061: Oracle Database 12c: SQL Fundamentals

11 hours

Retrieving Data Using SQL Statements

  • Introduction
  • SQL SELECT Statements
  • Basic SELECT Statements
  • Summary

Conversion Functions and Conditional Expressions

  • Introduction
  • Conversion Functions Available in SQL
  • Introduction to TO_CHAR, TO_DATE and TO_NUMBER
  • Apply Conditional Expressions in a SELECT Statement
  • Summary

Using Subqueries

  • 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

Introduction to DDL Language

  • Introduction
  • Categorizing Main Database Objects
  • Table Structure
  • Data Types for Columns
  • Creating a Simple Table
  • Introduction to Constraints
  • Introduction to Schema Objects
  • Summary

Features of Oracle Database 12c

  • Introduction
  • Oracle Database 12c
  • Summary

Managing Tables using DML Statements

  • Introduction
  • Truncate Data
  • Insert a Row into a Table
  • Update Rows in a Table
  • Delete Rows from a Table
  • Control Transactions
  • Summary

Displaying Data from Multiple Tables using JOIN

  • 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

Using Single Row Functions to Customize Output

  • Introduction
  • Functions Available in SQL
  • Using General Functions in SELECT statements
  • Summary

Reporting Aggregated Data Using Group Function

  • Introduction
  • Identify Available Group Functions
  • Using Group Functions
  • Group Data using GROUP BY Clause
  • Include or Exclude Grouped Rows
  • Summary

Restricting and Sorting Data

  • Introduction
  • Limiting Rows Retrieved by Queries
  • Sorting Rows Retrieved by Queries
  • Summary

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam. 

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediatelyThe lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience. 

Why OnlineITCourses.com?

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Orderproces

Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

frequently asked quesions

What is included?

Duration 11 hours
Language
Certificate of participation No
Online access 180 days
Monitor Progress Yes
Examination possibleYes
Mobile ready Yes

Also included in world's #1 eLearning portal

Sharing knowledge Unlimited access to our IT professionals community
Study advice Our consultants are here for you to advice about your study career and options
Study materials Certified teachers with in depth knowledge about the subject.
Platform Access to our platform.
Service World's best service

Life Long Learning

Follow multiple courses? Read more about our Life Long Learning concept

read more

Contact us

Need training advise? Contact us!


contact