Oracle Database 10g: Administration Workshop I

Share This

Course Description

Intended Audience for this Course

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

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 this Course

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

This Course prepare students for the following Exams

• 1Z0-042 : Oracle10g Database: Administration I

Recommended Next Steps after taking this Course

• Oracle Database 10g: Administration Workshop II

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

Benefit of taking this course at NetCom Information Technology

• Why choose Oracle Training at NetCom Information Technology?
  As a recognition for training excellence, NetCom Information Technology 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 Information Technology is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Associate Partner, CompTIA Learning Alliance Member, 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 Instructors
  See our world-class instructors.  
• Actual Client Testimonials

  Aug 20 2010 Course was hands-on, with all questions about content, syntax and concepts answered. -William D. Course(s) Taken Oracle DBA Track (11g)

  
  

  Aug 13 2010 Very thorough; The help on setting up an Oracle system on our own PC was invaluable. -William D. Course(s) Taken Oracle DBA Track (11g)

  
  

  Aug 06 2010 So far so good the training is proceeding well and I am happy to be taking it. -Colince T. Course(s) Taken Oracle DBA Track (11g)

  
  

  Jun 07 2010 [The instructor] was the best part of the course. Knowledgeable, personable, and just a very effective educator. -Phil R. Course(s) Taken Oracle DBA Track (11g) Boot Camp

  
  

  Dec 05 2009 Excellent. -Jeff Course(s) Taken Oracle DBA Track (11g) Boot Camp

  
  

  Mar 02 2007 To be frank I was very nervous about the training the first day given my bad experiences with other training schools but I have really enjoyed every bit of it. I have already told lot of my friends about NetCom. Thanks for the wonderful class! Anand Course(s) Taken Oracle DBA Track (10g)

  
  

  M. W. Jun 13 2005 The instructor is very knowledgeable about the subject matter. The labs are very helpful in understanding the subject. Course(s) Taken Oracle DBA Track (9i)

  
  

  Bijo Thomas May 26 2005 Just wanted to inform you that I have passed both of my A+ exams thanks to [the Instructor's] help. Also, I have recently just been hired at a new job working in New York City as a support engineer for a private firm. Just wanted to let you know that you are a great teacher and keep up the good work! I plan to take my Network+ exam in a month or so. Course(s) Taken Oracle DBA Track (9i)

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

  See our list of awards.

• Specialized Bootcamp 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

• 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@netcominfo.com