7
Cart Total:$182.93

Oracle Database 11g Certified Associate (OCA) Fundamentals 1Z0-051 and Admin 1z0-052

The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 11g.

$29.99

SKU: IT-1z0-052 Categories: ,
Description

This course is in preparation for the Oracle Database 11g Administrator (OCA 11g) certification exam. The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 11g.

Oracle 11g training course will teach students how to install and maintain an Oracle database, how to create an operational database, and how to properly manage the various structures in an effective and efficient manner, including performance monitoring, database security, user management, and backup/recovery techniques.

Students will also learn skills required for working with SQL, including how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. After completing Oracle OCA 11g course, students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.

Oracle databases are one of the most popular database platforms in the world. Increase your skills and marketability today by achieving Oracle certification!

Course Outline

Oracle 12c OCP 1Z0-062: Installation and Administration Course Outline

Download Course Outline

Instructor And Course Introduction

Database Concepts And Tools – Part 1

Database Concepts And Tools – Part 2

Memory Structure – Part 1

Memory Structure – Part 2

Tables – Part 1

Tables – Part 2

Indexes – Part 1

Indexes – Part 2

Constraints And Triggers – Part 1

Constraints And Triggers – Part 2

Users

Profiles

Privileges

Roles

Storage Structures – Part 1

Storage Structures – Part 2

Internal Memory Structures – Part 1

Internal Memory Structures – Part 2

Background Processes – Part 1

Background Processes – Part 2

Starting And Stopping DataBase – Part 1

Starting And Stopping DataBase – Part 2

Critical Storage Files – Part 1

Critical Storage Files – Part 2

DML Atomicity – Part 1

DML Atomicity – Part 2

DML Insert

DML Update – Part 1

DML Update – Part 2

DML Delete And Review Of DML Statements – Part 1

DML Delete And Review Of DML Statements – Part 2

Data Concurrency – Part 1

Data Concurrency – Part 2

Back Up – Part 1

Back Up – Part 2

Back Up – Part 3

RMAN Catalog

RMAN BackUps – Part 1

RMAN BackUps – Part 2

Disaster Preparedness

Recovery

Flashback Recovery

Installation – Part 1

Installation – Part 2

Course Review – Part 1

Course Review – Part 2

Course Review – Part 3

Course Review – Part 4

Course Review – Part 5

Course Outro

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 Data

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

Oracle Database 11g Certified Associate (OCA) Fundamentals 1Z0-051 and Admin 1z0-052 Course Outline

Download Course Outline

Intro to Oracle

Database Administration

Installing Oracle – Part 1

Installing Oracle – Part 2

Post Setup Overview – Part 1

Post Setup Overview – Part 2

SQLplus – Part 1

SQLplus – Part 2

SQLplus Demo – Part 1

SQLplus Demo – Part 2

SQLplus Demo – Part 3

Startup and Shutdown – Part 1

Startup and Shutdown – Part 2

Oracle Architecture

Schema Objects

Data Access

Architecture

Database Schema

Create Table & Tablespace – Part 1

Create Table & Tablespace – Part 2

Create View

Create Index

Create Sequence

Recovery Manager

What is RMAN

RMAN Demo

Restore – Part 1

Restore – Part 2

SQL – Part 1

SQL – Part 2

Parts of SQL Statement

Select Statement

Build ERD – Part 1

Build ERD – Part 2

Build ERD – Part 3

Functions

More Functions

Group Functions

Custom Functions

SET Operations

Subqueries

Regular Expressions

SQL Loader

Your Training Instructor

Rafiq Wayani
Project Management Instructor

Related Products

$29.99

Course features:

7 Hrs 24 Min

43 Videos

1 Year Access

Available on Web