0
  • No products in the cart.
Cart Total:$0.00

Oracle 12c OCP 1Z0-061: SQL Fundamentals

With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning.

$39.99

SKU: IT-1Z0-061 Categories: , ,
Description

Note: Although this course is based on an older version, it remains to be a beneficial resource for educating and training.

About our online course:

With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace.

Who is this Oracle 12c OCP 1Z0-061: SQL Fundamentals training course for?

Perfect for IT professionals and Oracle administrators seeking to advance their skill level, this Oracle Database 12c Administration program is especially tailored for those aiming to enhance their database language proficiency. After completing the course, attendees will have acquired an unparalleled understanding of the latest version of Oracle that can be applied in both rising IT careers as well as established ones looking to validate their expertise.

Course Outline

Oracle 12c OCP 1Z0-061: SQL Fundamentals Course Outline

Download Course Outline

Introduction

Intro To Oracle 12c-SQL Fundamentals

Structure Of SQL

Basic Select Statements

Basic Select Statements Demo

Modifying Reported Output

The Where Clause

The Order By Clause

Left And Right Outer Joins

The Where Clause Demo

Multi-Table Selection Demo

Single Row Functions

Aggregate Functions

Single Row Functions Demo

Muiltrow Functions Demo

Group By

Grouping Demo

Conversion Functions

Conversion Functions Demo

Datetime Functions

Datetime Functions Demo

Single-Row Subqueries

Single-Row Subqueries Demo

Multi-Row Subqueries

Multi-Row Subqueries Demo

Other Subquery Types

Other Subquery Types Demo

Adding Data

Changing Data

Deleting Data

DML Demo

Security

Object Privileges

DCL Demo

Creating Objects In The Database

Creating Objects In The Database Demo

Sequences

Sequenced Demo

Indexes

Views

Combining Queries

Oracle 12c SQL Fundamentals Review – Part 1

Oracle 12c SQL Fundamentals Review – Part 2

Oracle 12c SQL Fundamentals Review – Part 3

Conclusion

Related Products

$39.99

Course features:

16 Hrs 21 Min

45 Videos

1 Year Access

Available on Web