Courses

Oracle Database 12c: Installation and Administration

Start your prep for the Oracle Database 12c 1Z0-062 certification exam with Oracle Database 12c: Installation and Administration course. The study guide covers the objectives of 1Z0-062 exam and topics including DBAAS; Oracle Database 12c components and architecture; creation and operation of Oracle Database 12c; storage and space management; network architecture; backup and recovery; and many more. The cert guide is designed for database administrators, support engineers, technical administrators, and data warehouse administrators with working knowledge of SQL and PL/SQL packages, and basic knowledge of Linux operating system.

Here’s what you will get

The Oracle Certified Associate (OCA) credential is the first step toward achieving the Oracle Certified Professional (OCP) certification. OCA certification proves that you have the fundamental knowledge and skills to support an Oracle Database 12c database. The OCA Database 1Z0-062 exam focuses on the topics like Database management and performance measurement; controlling resources and jobs; grid infrastructure and data movement; and many more. This exam has been validated against Oracle Database 12.1.0.1.0.

Lessons


  • null

    13+ Lessons

  • null

    224+ Exercises

  • null

    105+ Quizzes

  • null

    58+ Flashcards

  • null

    58+ Glossary of Terms

    Test Prep


    • null

      10+ Pre-Assessment Questions

    • null

      4+ Full Length Tests

    • null

      40+ Post-Assessment Questions

    Live Lab (Add-on Component)


    • null

      61+ Live Lab

    Videos and How To..
    The Learning Warehouse course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.


    • null

      37+ Videos

    • null

      14:02+ Hours


    Here’s what you will learn
    Lesson 1: Introducing Oracle Database 12c Components and Architecture
    Oracle Database Fundamentals Oracle Database 12c Architecture Summary Exam Essentials
    Lesson 2: Creating and Operating Oracle Database 12c
    Oracle Database 12c Software Installation Using DBCA to Create an Oracle 12c Database Working with Oracle Database Metadata Managing Initialization-Parameter Files Starting Up and Shutting Down an Oracle Instance Monitoring the Database Alert Log Summary Exam Essentials
    Lesson 3: Understanding Storage and Space Management
    Understanding the Physical and Logical Storage Managing Tablespaces Managing Data Files Managing Space Summary Exam Essentials
    Lesson 4: Managing Data Concurrency and Undo
    Managing Data Changes Using DML Managing Data Concurrency Summary Exam Essentials
    Lesson 5: Understanding Oracle Network Architecture
    Introducing Network Configurations An Overview of Oracle Net Features Configuring Oracle Net on the Server Configuring Oracle Net for the Client An Overview of Oracle Shared Server Understanding Database Resident Connection Pooling Communicating Between Databases Summary Exam Essentials
    Lesson 6: Implementing Security and Auditing
    Creating and Managing User Accounts Granting and Revoking Privileges Controlling Resource Usage by Users Auditing Database Activity Summary Exam Essentials
    Lesson 7: Maintaining the Database and Managing Performance
    Proactive Database Maintenance Managing Performance Summary Exam Essentials
    Lesson 8: Using Backup and Recovery
    Understanding and Configuring Recovery Components Performing Backups Understanding Types of Database Failures Performing Recovery Operations Summary Exam Essentials
    Lesson 9: Controlling Resources and Jobs
    Resource Management with the Resource Manager Task Automation with Oracle Scheduler Summary Exam Essentials
    Lesson 10: Upgrading to Oracle Database 12c
    Determining the Database Upgrade Method Preparing for a Database Upgrade Upgrading the Database Summary Exam Essentials
    Lesson 11: Using Grid Infrastructure and Data Movement Tools
    Tools for Moving Data Migrating Data Using Data Pump Loading Data with SQL*Loader Populating External Tables Introducing Grid Infrastructure Summary Exam Essentials
    Lesson 12: Introduction to DBAAS
    Lesson 13: Video Tutorials
    Introduction Database Concepts And Tools DML Atomicity DML Statements Data Concurrency Backup Installation Memory Structure Tables Indexes Constraints And Triggers Implementing Security Storage Structures Internal Memory Structures Background Processes Starting And Stopping Database Critical Storage Files

    Hands on Activities (Live Labs)

    Introducing Oracle Database 12c Components and Architecture
    Creating and Operating Oracle Database 12c
    Understanding Storage and Space Management
    Managing Data Concurrency and Undo
    Understanding Oracle Network Architecture
    Implementing Security and Auditing
    Maintaining the Database and Managing Performance
    Using Backup and Recovery
    Controlling Resources and Jobs
    Upgrading to Oracle Database 12c
    Using Grid Infrastructure and Data Movement Tools
    Introduction to DBAAS
    Video Tutorials

    Exam FAQs

    – What is the exam registration fee?
    £200

    – Where do I take the exam?
    Pearson VUE.

    – What is the format of the exam?
    The exam consists scenario-based multiple choice questions.

    – How many questions are asked in the exam?
    The exam contains 67 questions.

    – What is the duration of the exam?
    120 minutes

    – What is the passing score?
    64%

    – What is the exam’s retake policy?
    In the event that you fail your first attempt at passing the Dreamweaver CC examination, Adobe’s retake policy is:
    – Candidates may not retake a beta exam at any time.
    – Candidates may not retake a passed exam at any time.
    – Candidates may retake an online non-proctored exam at any time.
    – Candidates are only allowed 4 attempts to pass an exam in a 12-month period.
    – Candidates must resubmit a failed Master Assignment within 30 days of receiving the notification of failing.
    – Candidates must wait 14 days before retaking a failed proctored exam. (Registration will be allowed on the 14th day)

    – What is the validity of the certification?
    Oracle certifications have no expiration unless Oracle changes its policy.

    – Where can I find more information about this exam?
    To know more about the 1Z0-062, click here.

    – Which certification covers this exam?
    – OCA: Oracle Database Administrator Certified Associate
    – OCP: Oracle Database Administrator Certified Professional

    – What are the career opportunities after passing this exam?
    – DBA
    – SQL Developer
    – Oracle Programmer
    – Server Administrator
    – Database Administrator

    Enquire Now

    Complete the form below to receive a quote or more information

     

    Why Choose Us?

    Best Price Guaranteed

    We offer best price for our courses. You won't find better value in the market.

    Best Online Courses

    We offer the best online courses for many industries, learn today and get hired tomorrow.

    Financing Available

    Having financial issues? Don't worry we have comprehensive financing options available.

    img-slider-4.png
    13
    Mar, 2019

    Oracle Database 12c: Installation and Administration


    Course Price

    £975.00