Oracle Database 12c: SQL Fundamentals 1Z0-061

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.

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.

Anyone that wishes to familiarise themselves with Oracle SQL fundamentals.

There are no formal prerequisites to undertaking this course.

Database Administrator
Oracle Database Engineer
Database Specialist
Database Analyst

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