Oracle Database Administration

Learn how to implement relational database solutions using Oracle. The latest version of Oracle's powerful and popular database management system. This course introduces Oracle Database 10g technology along with relational database concepts and the powerful SQL programming language. The course covers essential SQL skills including querying the database, using metadata and creating database objects.

Gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You'll learn how to create an operational database and properly manage the various structures in an effective and efficient manner with emphases on performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.

Expand your Oracle database administration skills. You'll learn how to configure an Oracle database for multilingual applications and practice various methods of recovering the database using RMAN, SQL, and Flashback technology. You'll also learn about tools for monitoring database performance and steps to take to improve database performance. Additional topics include the use of the Resource Manager, the Scheduler, and Automatic Storage Management (ASM). All lesson topics include structured, hands-on practices accompanied by a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam.

This course introduces PL/SQL and helps you understand the benefits of this powerful programming language. You'll learn how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. You'll also learn how to create anonymous PL/SQL blocks, stored procedures, functions, and how to use other, standard programming techniques. Additional topics include the use of stored procedures, functions, packages and database triggers, and you'll learn how to manage PL/SQL program units dependencies, how to manipulate large objects, and how to use some of the Oracle-supplied packages. Demonstrations and hands-on practice reinforce the fundamental concepts.

If you need to learn more about the design of relational database systems, this course is for you. You'll explore how the relational database approach is used in both open and closed systems and on both mainframe and client/server platforms, and learn about the design of systems of all sizes including standalone, workgroup, departmental, and enterprise-wide applications. You'll also learn how to incorporate data from legacy systems as well as how to develop entirely new systems. You'll have the opportunity to design a rational database model in class and refine it for a real-world system or case study. Topics include an overview of database systems, defining business entities, entity relationship modeling (ERM) for top-down analysis, defining relational database tables and attributes, conversion of logical design to physical design, normalization of tables, and using structured query language (SQL) to process data and generate reports.

This course is designed to give the student a firm foundation in the art of SQL tuning. The participant learns the necessary knowledge and skills to effectively tune SQL against the Oracle9i Server. Students gain a thorough conceptual understanding of the Rule-Based and Cost-Based Optimizer. The course uses a series of challenge-level workshops, allowing students to "play, discover, and learn" at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax.

Learn how to get the optimal performance from your Oracle 10g Database by applying performance tuning methods that maximize the utility of the database. You'll learn how to use Oracle's automatic tuning features as well as apply manual tuning methods using the Statspack tool. Next, you'll learn how to apply those tuning features and methods to the various tunable components of an Oracle database. This course gives you plenty of opportunities for hands-on practice through a series of practical workshops.

If you are a database administrator or developer who needs to design, maintain, and use a data warehouse, this course is for you! You'll learn about the data warehousing features of Oracle 10g and how to design and build a data warehouse. The course covers various data warehouse schemas, the ETL process (extraction, transformation, and loading), data partitioning, parallelism concepts and parallel operations, materialized views, Query Rewrite, SQL Access Advisor, and database warehousing system management including security and backup/recovery strategies.