Oracle Database Administration

In this course, students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL.

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Topics in this course include: Oracle database architecture, Oracle Net services, database storage structures, backup and recovery, data and concurrency, undo data, performance and database diagnostic. The lesson topics are reinforced with structured hands-on practices.

In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.

In this course, students learn the basic concepts of a data warehouse and study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn to improve performance or manageability in a data warehouse using various Oracle Database features. Students also learn the basics about Oracle's Database partitioning architecture and identify the benefits of partitioning. Students review the benefits of parallel operations to reduce response time for data-intensive operations. Students learn about the extract, transform, and load of data phase (ETL) into an Oracle database warehouse. Students learn the basics about the benefits of using Oracle's materialized views to improve the data warehouse performance. Students also learn at a high level how query rewrite can improve a query's performance.

In this course, students learn about Oracle's Database partitioning architecture and identify the benefits of partitioning. Students also use parallel operations to reduce response time for data-intensive operations. Participants extract, transform, and load data into an Oracle database warehouse. Students also use materialized views to improve the data warehouse performance. Students also learn how query rewrite can improve a query's performance. Students use the SQL Access Advisor to optimize the entire workload. Finally, students learn how to tune materialized views for fast refresh and query rewrite and how to use the compression and resumable sessions features.

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 introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.

This course is designed to introduce the students to Oracle Application Express 3.0. The course covers various Application Express components and wizards to build applications and database objects that are easy to deploy. The students learn how to build forms and reports and incorporate different types of items and shared components. Creating and utilizing various navigation components as well as session management and debugging are discussed. In addition, students incorporate access control, and session protection to enforce application security. Once the application is complete, students learn how to define their packaged application and export the application. Students will also use all the Utilities and Report capabilities that Oracle Application Express provides to build a robust application. The audience for this course includes: Forms Developer, Reports Developer, Application Developers, PL/SQL Developer.

This course will teach students how to get the most out of Oracle 11g Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database 11g automatic tuning features, as well as practicing the manual tuning methods using the Statspack tool. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of 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.

Learn to exploit the new features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Through a series of demonstrations and hands-on practice, you'll learn how to configure and administer a database for use with Real Application Clusters. You'll also learn how to minimize downtime following an outage and how to prevent data loss with Oracle Data Guard. You'll explore Data Guard architecture and learn how to set up physical and logical standby databases. Additional topics include Data Guard's impact on performance, troubleshooting Data Guard, and using Enterprise Manager Grid Control for the creation and management of a Data Guard configuration. The course includes a hands-on workshop that allows students to reinforce the skills they have learned.

Expand your knowledge of the advanced features of Oracle 10g Release 2 for Oracle Real Application Clusters (RAC) by learning how to configure and administer Oracle Enterprise Manager 10g Grid Control. With a broad set of administration, configuration management, provisioning, end-to-end monitoring, and security capabilities, Oracle Grid Control (OGC) reduces the cost and complexity of managing grid computing environments. You'll learn how to implement OGC's robust service level management functionality to improve service levels via rich transaction and end-user performance monitoring and diagnostic capabilities that are designed especially for multi-tier Internet applications. The course also covers advanced features of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC), advanced Data Guard Services, Data Guard broker, advanced backup and recovery procedures using RMAN, and advanced topics in Oracle database tuning.