Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

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
South Africa 1684

You are here

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


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

Interactive and entertaining talk-show style format presented by industry leading experts.

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.

  • 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

?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 59
  • 19:21:52
    Hours of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months Access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top