Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

courses popup callback

E-COURSE:

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

Instructor-led video course with presentations, workbooks, games, flashcards and quizzes.
Overview

This fantastic Oracle 12c OCP 1Z0-062 course teaches you about the Oracle database concepts and tools, internal memory structures and critical storage files. In addition, you will explore constraints and triggers, background processes and internal memory structures. Learners will come away with a set of highly valuable skills and will be able to gain employment as a Database Administrator, Database Analyst, or Oracle Database Engineer. This course will provide the learner with everything that is needed to pass the Oracle 12c OCP 1Z0-062: Installation and Administration exam.

Objectives
  • Understanding data definition language and its manipulation
  • Understanding database concepts and tools, memory structure, tables, and indexes
  • How to undertake installation, backup, and recovery
Target Audience
  • The course is for students who want to prepare for the Oracle 12c certification exam.
  • Everyone, Science & Technology Professionals

Module 1: Database Concepts And Tools

1.1 Instructor And Course Introduction

1.2 Database Concepts And Tools­ Part 1

1.3 Database Concepts And Tools­ Part 2

Module 2: Memory Structure

2.1 Memory Structure­ Part 1

2.2 Memory Structure ­Part 2

Module 3: Tables

3.1 Tables ­Part 1

3.2 Tables ­Part 2

Module 4: Indexes

4.1 Indexes ­Part 1

4.2 Indexes­ Part 2

Module 5: Constraints And Triggers

5.1 Constraints And Triggers ­Part 1

5.2 Constraints And Triggers ­Part 2

Module 6: Users

6.1 Users

6.2 Profiles

6.3 Privileges

6.4 Roles

Module 7: Internal Structures

7.1 Storage Structures­ Part 1

7.2 Storage Structures ­Part 2

7.3 Internal Memory Structures ­Part 1

7.4 Internal Memory Structures ­Part 2

7.5 Background Processes ­Part 1

7.6 Background Processes ­Part 2

Module 8: Starting Up and Shutting Down Database

8.1 Starting And Stopping Data Base ­Part 1

8.2 Starting And Stopping Data Base­ Part 2

Module 9: Critical Storage Files

9.1 Critical Storage Files­ Part 1

9.2 Critical Storage Files­ Part 2

Module 10: Data Manipulation Language

10.1 DML Atomicity­ Part 1

10.2 DML Atomicity­ Part 2

10.3 DML Insert

10.4 DML Update ­Part 1

10.5 DML Update ­Part 2

10.6 DML Delete And Review Of DML Statements ­Part 1

10.7 DML Delete And Review Of DML Statements ­Part 2

Module 11: Data Concurrency

11.1 Data Concurrency ­Part 1

11.2 Data Concurrency­ Part 2

Module 12: BackUp And Recovery

12.1 BackUp­ Part 1

12.2 BackUp ­Part 2

12.3 BackUp ­Part 3

12.4 RMAN Catalog

12.5 RMAN BackUps ­Part 1

12.6 RMAN BackUps­ Part 2

12.7 Disaster Preparedness

12.8 Recovery

12.9 Flashback Recovery

Module 13: Installation

13.1 Installation ­Part 1

13.2 Installation­ Part 2

Module 14: Course Review

14.1 Course Review­ Part 1

14.2 Course Review­ Part 2

14.3 Course Review­ Part 3

14.4 Course Review­ Part 4

14.5 Course REview ­Part 5

14.6 Course Outro

E-COURSE Expert-led video course with presentations, workbooks, quizzes, games and flashcards.
  • 19:21:52+ Hours Of learning
  • Includes video, presentations, workbooks, quizzes, flashcards & games
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top