Oracle Database 10g: Administration Workshop I

Oracle Database 10g: Administration Workshop I Course Description

Intended Audience for the Oracle Database 10g: Administration Workshop I Course

• Database Administrators
• Sales Consultants
• Support Engineer
• Technical Consultant

Oracle Database 10g: Administration Workshop I Course Objectives

• Install and configure the Oracle Database 10g
• Create and administer user accounts in the Oracle Database 10g
• Backup and Recovery of the Oracle Database 10g
• Monitor, troubleshoot, and maintain the Oracle Database 10g
• Configure Oracle Net services for the Oracle Database 10g

Required Prerequisites for the Oracle Database 10g: Administration Workshop I course

• Oracle Database 10g: Introduction to SQL - Accelerated Version

The Oracle Database 10g: Administration Workshop I Course prepare students for the following Exams

• 1Z0-042 : Oracle10g Database: Administration I

Recommended Next Steps after taking the Oracle Database 10g: Administration Workshop I Course

• Oracle Database 10g: Administration Workshop II

Oracle Database 10g: Administration Workshop I Course Outline

1. Introduction
   1. Explain the course objectives
   2. Identify the Oracle product line
   3. Describe the basic concepts of a relational database
   4. Know core database administrator tasks
2. Installing Oracle Database 10g Software
   1. Identify system requirements
   2. Use optimal flexible architecture
   3. Install software with the Oracle Universal Installer
3. Create an Oracle Database
   1. Describe Oracle Database Architecture
   2. Understand the instance architecture
   3. Use the management framework
   4. Use the Database Creation Assistant
4. Database interfaces
   1. Use structured query language (SQL)
   2. Use Procedural Language/Structured Query Language (PL/SQL)
   3. Use Java
   4. Use the Oracle C++ Call Interface (OCCI)
5. Controlling the database
   1. Start and stop the agent
   2. Start and stop the enterprise manager database console
   3. Start and stop the listener
   4. Startup and shutdown the database
6. Storage Structures
   1. Define the purpose of tablespaces and data files
   2. Create tablespaces
   3. Manage tablespaces
   4. Obtain tablespace information
   5. Create and manage tablespaces using Oracle Managed Files (OMF)
7. Administering users
   1. Create and manage database user accounts
   2. Create and manage roles
   3. Grant and revoke privileges
   4. Control resource usage by users
8. Managing Schema Objects
   1. Create and modify tables
   2. Define constraints
   3. View the attributes of a table
   4. View the contents of a table
   5. Create indexes and views
9. Managing Data
   1. Manipulating data through SQL
   2. Using Import
   3. Using Export
   4. Using SQL Loader
10. PL/SQL
    1. Identify PL/SQL objects
    2. Understand triggers and triggering events
    3. Identify configuration options that affect PL/SQL performance
11. Oracle Database Security
    1. Apply the principal of least privilege
    2. Manage default user accounts
    3. Implement standard password security features
    4. Audit database activity
12. Oracle Net Services
    1. Understand Oracle Net concepts
    2. Use Oracle Net Manager to create and configure listeners
    3. Use the listener control utility to control the Oracle Net Listener
    4. Use the Oracle Net Manager to configure client and middle-tier connection
    5. Use TNSPING to test Oracle Net connectivity
13. Oracle Shared Server
    1. Understand when to use Oracle Shared Servers
    2. Configure Oracle Shared Servers
    3. Monitoring Shared Servers
14. Performance Monitoring
    1. Troubleshoot invalid and unusable objects
    2. Gather optimizer statistics
    3. View performance metrics
    4. React to performance issues
15. Proactive Maintenance: Objectives
    1. Set warning and critical alert thresholds
    2. Collect and use baseline metrics
    3. Use tuning and diagnostic advisors
    4. Use the Automatic Database Diagnostic Monitor (ADDM)
    5. Manage the Automatic Workload Repository
16. Undo Management
    1. Monitor and administer undo
    2. Configure undo retention
    3. Guarantee undo retention
    4. Use the undo advisor
17. Monitoring and Resolving Lock Conflicts
    1. Detect and resolve lock conflicts
    2. Manage deadlocks
18. Backup and Recovery Concepts
    1. Describe the basics of database backup, restore and recovery
    2. List the types of failure that may occur in an Oracle Database
    3. Describe ways to tune instance recovery
    4. Identify the importance of checkpoints, redo log files, and archived log file
    5. Configure ARCHIVELOG mode
19. Database backups
    1. Create consistent database backups
    2. Back your database up without shutting it down
    3. Create incremental backups
    4. Automate database backups
    5. Monitor the flash recovery area
20. Database Recovery
    1. Recover from loss of a control file
    2. Recover from loss of a redo log file
    3. Recover from loss of a data file

Benefits of taking the Oracle Database 10g: Administration Workshop I course at NetCom

• Why choose Oracle Training at NetCom Learning?
  As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.

  In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!

• NetCom provides Authorized Training
  NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.

  See our comprehensive list of partner authorizations.

• Award winning, world-class Instructors

  Finnbarr M. - Masters Degree in Computer Science from Boston University along with several certifications. - Over 25 years of experience in the IT field and expert in Unix, GNU/Linux, and Oracle ecosystems. - More than 10 years working as a Software Engineer in multinational companies such as Hewlett-Packard. Bio: Finnbarr has both breadth and in-depth knowledge of Unix, GNU/Linux, and Oracle with 25+ years of experience in operating system internals development, system administration, application development and project management on a wide variety of hardware and software platforms. As a Software Engineer, he developed and managed numerous projects in multinational companies such as Hewlett-Packard. Finnbarr is a member of the Institute of Electrical and Electronic Engineers as well as a Moderator at unix.com. He is also a top Instructor and Subject Matter Expert at NetCom Learning and is well recognized by the students for his knowledge and his great teaching technique.

  See more...  
• Actual Client Testimonials

  May 15 2012 Training environment and material are good. Materials are clear and short to the point. Instructor is very knowledgeable and full of experience. I've learned so much through the lecture as well as from his real life experiences. -Aye M. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  May 15 2012 Great training! Great instructor! -Fasika M. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  May 15 2012 This was a much needed and intensive training. -Paul V. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  May 15 2012 Great experience! Geoff is awesome :-) -Nadie H. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Aug 29 2011 My instructor is very knowledgeable. He was capable of answering all questions and explaining all material in detail. I am glad I chose NetCm for my training. All of the NetCm staff were courteous helpful, and polite. -Adrienne B. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Jul 02 2011 I am very pleased about my experience with NetCom Learning. It was a great course! The best experience I could have expected. Great instructor! Great everything! I am very happy. Thank You! -Lorena M. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Jul 02 2011 Very clean facilities, super friendly staff, knowledgeable instructor. -Alma C. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Jul 02 2011 Geoff was a great instructor during the Oracle course. He ensured I understood the material and brought a sense of fun to the class. I really really have to study for the certification course due to my limited database management skills. This training and certification will hopefully allow me to start a new career. -Denise L. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  
• Awards won by NetCom
  NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!

  See our list of awards.

• Specialized Boot Camp Training

  

  This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.

  For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.

Enrollment Options for the Oracle Database 10g: Administration Workshop I course

• Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with an Educational Consultant.

Training Delivery Methods

• Classroom Training
  NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.

• Live Online Training (LOT)
  NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience.
  Learn more about LOT

• Boot Camp Training
  NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps

• Private Onsite Training
  With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training.
  Learn more about Private Onsite Training

• Private 1-on-1 Training
  NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique.
  Learn more about Private 1-on-1 Training

Call us Toll-free at 1-888-563-8266 FREE Training Inquiry form Website Live Chat Contact us via Email: info@netcomlearning.com