Oracle Certified Database Administrator
IIUSA-349: Data Modeling and Relational Database Design
Course length: 24 hrs
Prerequisites: Ordinary expertise with using a Web browser.
Tuition: $1538
The Data Modeling and Relational Database Design course covers the use of Entity Relationship (ER) Modeling in detail through many real life examples, practical business problems and solutions. After several iterations the ER model captures the data requirements and business rules and forms a sound basis for the initial design of a relational database. The second part of the course is about the design process and presents the considerations for creating a normalized, stable, maintainable and well-defined relational database, such as Oracle 9i.
Special notes: This is a preparatory course for the Oracle Certified Associate and Oracle Certified Professional Database Administrator credentials.
IIUSA-361: Oracle 9i: Introduction to Oracle9i: SQL
Course length: 40 hrs
Prerequisites: IIUSA-349 Data Modeling and Relational Database Design or prior experience with relational databases. Suggested: Ability to use a graphical user interface (GUI).
Tuition: $2305
This course offers students an extensive introduction to data server technology. The class covers the concepts of both relational and object relational databases and the powerful SQL programming language. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. Students learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. They also learn to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output. Demonstrations and hands-on practice reinforce the fundamental concepts.
Course Topics
- Control data and user access
- Control transactions
- Create and maintain database objects
- Perform multitable INSERT commands and use external tables
- Retrieve, insert, update, and delete data
- Use GROUPING SETS and the WITH clause
- Use iSQL*Plus to format reports
- Use the new single-row DATETIME and NVL2 functions introduced in Oracle9i
- Write SQL scripts that use SQL to generate SQL
- Solve problems by using multicolumn subqueries, subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
- Describe relational and object relational database concepts
- Use advanced techniques to retrieve data by using ROLLUP, CUBE, set operators, correlated subqueries, and hierarchical queries
- Use basic iSQL*Plus commands
Special notes: This course prepares students for Oracle exam 1Z0-007 [SQL].
IIUSA-362: Oracle9i: DBA Fundamentals I
Course length: 40 hrs
Prerequisites: IIUSA-361 Oracle 9i: Introduction to Oracle9i: SQL
Tuition: $2305
This course is designed to give the Oracle database administrator (DBA) a firm foundation in basic database administrative tasks. Students will gain a conceptual understanding of the Oracle9i database architecture and how the architectural structures work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner in order to have a well-designed and operational database. The instructor-led lesson topics are reinforced with structured hands-on practices.
Topics:
- Manage Oracle database files
- Manage tablespaces, segments, extents, and blocks
- Use Globalization Support features
- Start up and shut down an Oracle instance and database
- Manage users, privileges, and resources
- Create an operational database
Special notes: This course prepares students for Oracle exam 1Z0-031 [DBA Fundamentals].
IIUSA-363: Oracle9i: DBA Fundamentals II
Course length: 40 hrs
Prerequisites: IIUSA-362 Oracle9i: DBA Fundamentals I
Tuition: $2305
This course gives the Oracle database administrator (DBA) a firm foundation in fundamental database administrative tasks. Students learn about loading and transporting for databases, and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. In hands-on exercises, students configure network parameters so that database clients and tools can communicate with the Oracle database server. This course also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations.
Topics:
- Loading Data in the Database
- SQL*Loader
- Conventional and Direct Loads
- Uses of SQL*Loader
- Direct Inserts
- Guidelines for Using SQL*Loader and Direct Inserts
- Transporting Data Between Databases
- Networking Overview
- Backup and Recovery Overview
- Basic Oracle Net Architecture
- Noarchivelog Mode Configuration and Archivelog Mode Configuration
- Bounded Recovery Time
- Automatic and Manual Archiving of Log Files
- Multiple Archival Destinations and Processes
- Remote archival of redo logs
Special notes: This course prepares students for exam 1Z0-032 [Oracle9i Database Fundamentals II].
IIUSA-364: Oracle9i: Database Performance Tuning
Course length: 40 hrs
Prerequisites: IIUSA-363 Oracle9i DBA Fundamentals II
Tuition: $2305
This course will introduce participants to the importance of good initial database design, and the method used to tune a production Oracle9i database. The focus is on Database and Instance tuning rather than specific operating system performance issues. Participants will gain practical experience tuning an Oracle database. Using the available Oracle tools, participants also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database. The class includes a one-day interactive workshop that provides participants with real-world experience including problem diagnosis and performance enhancement.
Topics:
- Job Roles in tuning
- Tuning phases
- Application design and programming
- Database configuration
- Adding an application to an existing database
- Troubleshoot and Tune
- Tuning goals and Service Level Agreements
- Common performance problems
- Tuning Methodology
- Database Production tuning
- Trade-offs when tuning
- Using a baseline
Special notes: This course prepares students for exam 1Z0-003 [Performance & Tuning].
