Oracle Database 11g: Conversion Functions, Group Functions, and Joins
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one ...
Oracle Database 11g: Data Dictionary Views and Large Data Sets
To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table ...
Oracle Database 11g: Database Architecture and ASM
To recognize the structural elements in Oracle Database 11g's architecture, including and Automatic Storage Management (ASM), and recognize the steps for managing storage using disk groups.
Oracle Database 11g: Database Architecture and Installation
Identify the elements of the Oracle Database 11g architecture and recognize the tools and steps required to install the Oracle Database 11g software
Oracle Database 11g: Database Auditing
Monitoring or auditing should be an integral part of your security procedures. Oracle Database 11g includes auditing tools for database, user, and fine-grained auditing. This course explores how to ...
Oracle Database 11g: Database Creation, Instance Management, and Connectivity
Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and ...
Oracle Database 11g: Database Performance and Space Management
To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and ...
Oracle Database 11g: Database Replay and Automatic SQL Tuning
Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database
Oracle Database 11g: Database Security
Oracle Database server is highly secure, but to fully maximize the security features offered, the database must be well protected as well. This course explores how to configure Oracle Database 11g in ...
Oracle Database 11g: Diagnosing Oracle Clusterware and Node Management
Problems that occur with Oracle RAC instances can be difficult to diagnose because they span across two or more nodes in a cluster. Oracle Database 11g provides various methods for diagnosing and ...