Oracle Certified Associate
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].
