Oracle Application Development

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.

Learn how to implement relational database solutions using Oracle 10g, 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.

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.

Learn how to develop scalable, high performance applications for the Internet using Oracle Forms Developer. You'll learn how to design and deploy sophisticated database forms that let you use the power of Oracle to drive your business logic. This course shows you how to build, test, debug, and deploy interactive Internet applications using an intuitive graphical user interface (GUI) to design and customize your forms. You'll have the opportunity to practice what you learn by building an order entry application complete with business logic from the ground up.

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 Oracle 10g 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.