Oracle Database Administration Workshop Level 1
Duration: 4 Days

John Watson

 4.9/5 (13)
$3,200.00

Oracle Certified Master
John Watson
John wrote the EXAM Guide!

This course provides you with the skills necessary to create and administer an Oracle database.

In this class you will concentrate on the skills and best practices required for day-to-day database administration tasks such as security, creating and managing users, space management, administering undo and redo, running utilities, configuring Oracle networking, and simple backup and recovery techniques.  An in-depth discussion of Oracle instance and database architecture is also provided. The final three topics are optional for this course, as they are covered in real detail elsewhere in the curriculum. However, if time permits and students are interested, they may be covered to a certain extent.

The course is run on the current release of database, but the instructors (OCM John Watson unless otherwise noted) will “back-port” the course to earlier releases where behavior has significantly changed and it is relevant to the students.

Recent Review

“…the instructor knew the material. He didn’t just read screens. He talked about the different points on the screen, show examples of when to use which options, and walked through the examples. He is very comfortable with the subject.”

Please click on the “Reviews” tab above to see more online reviews!

  • Call 1-401-783-6172 for Group or Alumni Discounts.
    If you are a student of an accredited academic institution call us for a 25% discount.

    • Price Qty
    01/11/21 - 01/14/21show details + $3,200.00 (USD)  

    Software installation and database creation
    • Prepare the machine for installation
    • Install the Oracle Home
    • Create a database with the DBCA
    • Generate database creation scripts
    Database and instance architecture
    • Instance memory structures and background processes
    • Database physical structures: datafiles, controlfile, online logfiles
    • Session architecture: user processes 
    • The Data Dictionary
    Instance management
    • Instance parameters
    • SPFILEs and PFILEs
    • Instance startup and shutdown
    • Database mount, open, and close
    • The administration roles and privileged users
    • Operating system and password file privileged user authentication
    • Data dictionary views and dynamic performance views
    • The alert log and trace files
    Oracle Net
    • Understand the client-server processing model
    • Administer database listeners
    • Configure Oracle Net clients
    • Use database links
    Physical storage structures
    • Understand logical and physical structures
    • Create tablespaces and datafiles
    • Alter and drop tablespaces
    • Resize and relocate datafiles
    Space management
    • Understand extent management
    • Using compression
    • Monitoring space usage
    • Reclaiming space within a tablespace
    • Enable resumable space allocation operations
    Managing Users and Security
    • Manage user accounts
    • Grant and revoke privileges
    • Create and grant roles
    • Use password profiles
    Undo management
    • Executing SELECT and DML statements
    • COMMIT and ROLLBACK processing
    • Understand the purpose of undo data
    • Administer undo data
    • Configure undo retention
    Locking and concurrency
    • Multiuser issues
    • Types of lock
    • Automatic and manual locking
    • Detect and solve lock contention
    Audit
    • Understand the need for audit
    • Privileged user audit
    • Standard audit
    • Fine grained audit
    • Configure unified audit
    • Auditing with triggers
    Monitoring and tuning
    • Manage the Automatic Workload Repository
    • Use the Automatic Database Diagnostic Monitor
    • Use the Advisors
    • Configure the alert system
    • Control the autotasks
    Memory management
    • Understand how memory is used in an Oracle instance
    • Manage SGA and PGA structures individually
    • Enable Automatic Shared Memory Management
    • Enable Automatic Memory Management
    • Use the memory advisors
    The Resource Manager
    • Understand resource management
    • Configure and monitor the Resource Manager
    • Investigate the supplied Resource Manager plans
    • Quiesce the database
    • Use instance caging
    The Job Scheduler
    • Run local jobs through the Scheduler
    • Launch jobs on remote systems
    • Use job chains to run a series of tasks
    • Assign priorities to jobs
    • Use windows to enable Resource Manager plans
    Bulk data loading and extraction
    • Use SQL*Loader
    • Create directory objects
    • Create external tables
    • Use Data Pump export and import
    SQL performance
    •  Understand cost based optimization
    • Manage optimizer statistics
    • Display execution plans
    • Use the SQL Tuning Advisor
    • Use the SQL Access Advisor
    Backup and recovery
    • Understand instance recovery
    • Define a Fast Recovery Area
    • Configure the database for recoverability
    • Use the RMAN recovery manager for backup, restore, and recovery
    Understanding and Managing Multitenant Architecture (CDB)
    • The motivation for use of the multitenant option
    • Multitenant architecture
    • Space management and multitenant
    • Security in a multitenant database
    • Migration to multitenant
    John Watson
    https://skillbuilders.com/our_team/john-watson/
     5/5

    That the instructor knew the material. He didn\'t just read screens. He talked about the different points on the screen, show examples of when to use which options, and walked through the examples. He is very comfortable with the subject.

    I received the pre class information 3am the date the class started. For me that was 7am. I had know time to read through the emails and be prepared for class. For a class starting on Monday it would be good to have the information on Friday morning.

    No. John was good about extending the time for the exercises if we were not done when the scheduled time elapsed.
    Barbara Evans
    July 27, 2020
     5/5

    John , our instructor explains the minute details of oracle settings and what happens internally in Oracle when you change settings .
    You can\'t go wrong learning from an Oracle Certified Master

    I would suggest to may be increase the class length to include some additional topics

    Shilpi Balan
    April 2, 2020
     4.9/5

    John is fantastic at what he does and he makes it fun. Overall the course is very good.It contains the information needed to learn how to administer databases in ORACLE and learn the basics of an Oracle database architecture.

    The course contains a lot of information that I believe would be best taught in a lab setting with actual realistic examples. The workshops were OK, but there was nothing realistic about them, or they were too simple to drive in the lesson home.

    Spread it out to 5 days, give more realistic workshops, and give a bit more time to work on the workshops with a quick review of what the results should be of the workshops. Overall, everything was fine, and John is an awesome instructor.
    gonzalez.gilberto@epa.gov
    April 2, 2020
     5/5
    koko bear
    July 19, 2016
     5/5

    The course book is very well organized, and provides great information about Oracle.
    Dave is a great instructor and mentor, very knowledgeable and also patient with my questions.

    The online course delivery is great!
    Peiwen Zhu
    November 17, 2014
     4.9/5

    Use of Paint as a white board was good, as was use of Powerpoint to show the Oracle process for commit.
    Also, it was good that the second instructor (Dave A) could update the chat, re-enforcing the points made by John.
    Mike Kipling
    October 21, 2013
     4.9/5

    the instructors were patienct...it was good
    McKinley (Mac) Floyd
    June 10, 2013
     5/5

    Covered may areas
    Bogdan Droba
    June 10, 2013
     5/5

    The instructor. Very knowledgeable.

    Little more time for to complete the lessons. Some of the topics like backups were briefly discussed due to the size of the topic. Maybe allow more time for this area and shorten other areas like tables?
    Greg Castle
    June 10, 2013
     4.7/5

    It did touch on DBA topics that I needed.
    Tara Diaz
    June 10, 2013
     5/5
    Dave Anderson
    June 10, 2013
     5/5

    [Instructor: John Watson] This course was definitely not light on content (like several courses - not skillbuilders, of course - that I have attended). It is nice to get that much value out of a week-long training.

    [Instructor: John Watson] The delivery of this course was probably the best out of several online courses I have attended. Everything worked well.
    kbrewer@montana.edu
    January 21, 2013
     4.7/5

    [Instructor: John Watson] Good review of the basics. I got my initial [Oracle Database Administration] training over four years ago as a neophyte, so I was looking primarily for "tips and tricks" to help me with my better understanding. Happily

    The exercises were great, but there simply wasn't enough time to cover all the material and do the exercises. I was using my break time to work on them. We are also working DBAs, and the last two hours of the classes are hard to pay attention to whe

    The online format works well with a small group. But I would invest in a shared whiteboard app to make drawings easier and interactive. Even something simple like awwapp.com or flockdraw.com would be better than Paint.
    Scott Lloyd
    January 21, 2013
    $3,200.00

    You May Like

    Copyright © Skillbuilders.com

    Free Online Registration Required

    The tutorial session you want to view requires your registering with us.

    It’s fast and easy, and totally FREE.

    And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

     

    ×