– Introduction – Retrieving Data Using the SQL SELECT Statement – Restricting and Sorting Data – Using Single-Row Functions to Customize Output – Using Conversion Functions and Conditional Expressions – Reporting Aggregated Data Using the Group Functions – Displaying Data From Multiple Tables – Using Sub-queries to Solve Queries – Using the SET Operators – Manipulating Data – Using DDL Statements to Create and Manage Tables – Creating Other Schema Objects
Oracle Database 11g: Administration Workshop I
– Exploring the Oracle Database Architecture – Preparing the Database Environment – Creating an Oracle Database – Managing the Oracle Instance – Configuring the Oracle Network Environment – Managing Database Storage Structures – Administering User Security – Managing Schema Objects – Managing Data and Concurrency – Managing Undo Data – Implementing Oracle Database Security – Database Maintenance – Performance Management – Backup and Recovery Concepts – Performing Database Backups – Performing Database Recovery – Moving Data – Enhancing Database Capabilities
Oracle Database 11g: Develop PL/SQL Program Units
– Introduction – Creating Stored Procedures – Creating Stored Functions – Creating Packages – Working With Packages – Using Oracle-Supplied Packages in Application Development – Using Dynamic SQL – Design Considerations for PL/SQL Code – Creating Triggers – Creating Compound, DDL, and Event Database Triggers – Using the PL/SQL Compiler – Managing PL/SQL Code – Managing Dependencie
Data Warehousing Fundamentals
This course will help you understand the basic concepts of administering a data warehouse. You’ll learn to use various Oracle Database features to improve performance and manageability in a data warehouse. – Implement partitioning. – Use parallel operations to reduce response time. – Extract, transform and load data. – Create, use and refresh materialized views to improve data warehouse performance. – Use query rewrite to quickly answer business queries using materialized views.