Skip to content

Oracle Database 12c: SQL Fundamentals 1Z0-061

Gain an understanding of multitenant architecture and Cloud provisioning.


StudyOnline247

Summary

Price
Save 50%
£99 inc VAT (was £199)
Or £33.00/mo. for 3 months...
Offer ends 31 December 2021
Study method
Online, self-paced
Duration
1 month
Certification
Oracle Database 12c Administrator Certified Associate
Professional certification What's this?
Additional info
  • Exam(s) / assessment(s) not included in price, and must be purchased separately

3 students purchased this course

Add to basket or enquire

Overview

This course will teach students about multitenant architecture and Cloud provisioning using an Oracle Database. Students will also learn about the retrieval of data, data manipulation language, the combination of queries and SQL functions.

Certification

Oracle Database 12c Administrator Certified Associate

Awarded by Oracle

Description

What you will learn:

The structure of SQL
Creating objects in the database
Object privileges
Multi row functions
Conversion functions

Why study online?

Technological improvements and advances in educational design mean that studying online is no longer just a low cost alternative to traditional training methods. In many respects our online courses offer training which is superior to the majority of available “classroom” options.

Not only is the effectiveness of the training process enhanced, but also the convenience and overall cost efficiency of studying online makes it a compelling option for training. You can learn at your own pace and can repeat each section as many times as required unlike in a classroom environment.

Studying at your own pace, rewinding and going over the material as often as you need improves your long-term memory retention and makes studying more rewarding.

Curriculum for the Oracle 12c OCP 1Z0-061: SQL Fundamentals course:

Module 1: Introduction To Oracle 12c SQL

Introduction To Course
Intro To Oracle 12c SQL Fundamentals
Structure Of SQL
Basic Select Statements
Basic Select Statements Demo

Module 2: Retrieving Data

Modifying Reported Output
The Where Clause
The Order By Clause
Left And Right Outer Joins
The Where Clause Demo
Multi Table Selection Demo

Module 3: SQL Functions

Single Row Functions
Aggregate Functions
Single Row Functions Demo
Multi Row Functions Demo
Group By
Grouping Demo
Conversion Functions
Conversion Functions Demo
Date time Functions
Date time Functions Demo

Module 4: Subqueries

Single Row Subqueries
Single Row Subqueries Demo
Multi Row Subqueries
Multi Row Subqueries Demo
Other Subquery Types
Other Subquery Types Demo

Module 5: Data Manipulation Language

Adding Data
Changing Data
Deleting Data
DML Demo

Module 6: Data Control Language

Security
Object Privileges
DCL Demo

Module 7: Data Definition Language

Creating Objects In The Database
Creating Objects In The Database Demo
Sequences
Sequenced Demo
Indexes
Views

Module 8: Combining Queries

Combining Queries

Module 9: Oracle 12C SQL Fundamentals

Oracle 12c SQL Fundamentals Review - Part 1
Oracle 12c SQL Fundamentals Review - Part 2
Oracle 12c SQL Fundamentals Review - Part 3
Conclusion

Please note that the official exam is not included, however for those who complete the course, they will receive a completion certificate upon request.

Who is this course for?

Anyone that wishes to familiarise themselves with Oracle SQL fundamentals.

Requirements

There are no formal prerequisites to undertaking this course.

Career path

Database Administrator
Oracle Database Engineer
Database Specialist
Database Analyst

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.