Online Database Configuration eLearning

Oracle Database 10g Creating Databases Oracle Database 10g: Creating Databases Oracle To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant  more...

SQL Server 2008 Instance Database Configuration ...Database Configuration Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Implementation and Maintenance (Exam 70-432) SQL Server 2008's core component is its Database Engine, which provides storage, processing, and security for enterprise data through its controlled access and rapid transaction processing. Another feature of SQL Server 2008 is the SQL Server Management  more...

Oracle Database 11g Configure Manage Use Services in RAC ...ces and databases. Using standard interfaces, such as the Database Configuration Assistant, Enterprise Manager, and SRVCTL, services can be configured, administered, enabled, disabled, and measured as a single entity. This course provides an introduction to services and discusses how to configure, modify, and use services in a RAC environment. It explains how to use services with client  more...

Oracle Database 11g Diagnosing Oracle Clusterware Node Management Oracle Database 11g: Diagnosing Oracle Clusterware & Node Management Oracle 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 debugging Oracle Clusterware and RAC components. This course discusses the basics of debugging and the use of diagnostics  more...

Oracle Database 11g R2 Database Creation Instance Management ... tasks to plan a database installation and how to use the Database Configuration Assistant (DBCA) to install the Oracle Database 11g software. It demonstrates how to manage the instance, including setting initialization parameters, accessing the database and Enterprise Manager, viewing information about the instance, startup and shutdown stages, and viewing the alert log to ensure that there  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ... the Redo Log buffer. Finally, participants will identify database configuration and I/O issues, including tablespace usage and guidelines. L earn To: Identify application tuning issues that will impact database performance. Identify the contents and functions of the shared pool. Identify how the Buffer Cache is managed and tuned. Learn how to tune the Redo Log  more...

Oracle8i Performance Tuning Managing Memory Disk I O ... the Redo Log buffer. Finally, participants will identify database configuration and I/O issues, including tablespace usage and guidelines. L earn To: Identify application tuning issues that will impact database performance. Identify the contents and functions of the shared pool. Identify how the Buffer Cache is managed and tuned. Learn how to tune the Redo Log Buffer. Learn  more...

Oracle Database 10g New Features for Administrators Part 1 ...ion options in Oracle Database 10g. Identify different database configuration tools provided by Oracle Database 10g. Identify features of Automatic Workload Repository (AWR) in statistics collection. Identify features of a policy framework. Identify features of the initialization parameters in Oracle Database 10g. Unit 3: Loading and Unloading Data Identify features of  more...

Oracle Database 10g Administration Workshop I Part 1 ...UI). Identify the steps to create a database using the Database Configuration Assistant (DBCA). Match the files that constitute an Oracle database with their descriptions. Identify features of a tablespace structure in Oracle Database 10g. Identify features of memory structures associated with an Oracle instance. Match background processes in Oracle with their functions.  more...