Online Database 10g eLearning - Training Resources
Database 10g Training Provider? - Tell us about your Training!
From Online Training Directory
Oracle 10g OCA
...essional. It?s designed to provide a foundation in Oracle Database 10g. Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. This credential is your first step toward success as an Oracle professional, and demonstrates your firm foundation in the basic administration of Oracle Database 10g. By earning your Oracle Certification from
more...
From 123-CBT Computer Based Training
Oracle Database 10g Installing Oracle Database 10g Release 2
To introduce the concepts of RDBMS and Oracle database administration, and explain how to install Oracle Database 10g software
more...
Oracle Database 10g Installing Oracle Database 10g Release 2
Oracle Database 10g Creating Databases Release 2
To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant
more...
Oracle Database 10g Database Interfaces Release 2
To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces
more...
Oracle Database 10g Database Control and Storage Structures Release 2
To explain the fundamentals of Oracle database control and how to use tablespaces
more...
Oracle Database 10g Users and Security Release 2
To explain how to manage users, implement security, and audit database activity on an Oracle 10g database
more...
Oracle Database 10g Managing Schema Objects and Data Release 2
To demonstrate how to manage schema objects and data in an Oracle 10g database
more...
Oracle Database 10g The SQL Loader and PL SQL Release 2
To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database
more...
Oracle Database 10g Oracle Net Services and Shared Servers Release 2
To provide an overview of Oracle Net Services and Shared Server
more...
Oracle Database 10g Monitoring and Maintenance Release 2
To demonstrate how to control database performance and configure proactive database maintenance
more...
Oracle Database 10g Managing Undo Data and Lock Conflicts Release 2
To discuss how to manage undo data and manage lock conflicts in an Oracle database
more...
Oracle Database 10g Managing Backup and Recovery Release 2
To discuss how to manage backup and recovery in an Oracle 10g database
more...
Introduction to Oracle and SQL in Oracle Database 10g
To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements
more...
SQL Functions in Oracle Database 10g
To describe how to use SQL functions for data retrieval
more...
Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases
more...
Group and Datetime Functions in Oracle Database 10g
To demonstrate how to use group and datetime functions in Oracle 10g
more...
Subqueries and Hierarchical Queries in Oracle Database 10g
To demonstrate how to use subqueries and hierarchical queries in Oracle 10g
more...
Regular Expressions and User Access in Oracle Database 10g
To demonstrate how to use regular expression support and control user access in Oracle 10g
more...
Creating and Managing Tables and Constraints in Oracle Database 10g
To demonstrate how to create and manage tables and constraints in Oracle 10g
more...
Database Objects in Oracle Database 10g
To demonstrate how to create database views, sequences, indexes, and synonyms
more...
Managing Database Objects in Oracle Database 10g
To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g
more...
Manipulating Data in Oracle Database 10g
To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements
more...
Introduction to PL SQL
To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL
more...
Using PL SQL with an Oracle Server
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block
more...
Using Control Structures
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct
more...
Using Composite Data Types
To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records
more...
Explicit Cursors and Exception Errors
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled
more...
Creating Stored Procedures and Functions
To create and execute a stored function and call, and remove and view stored functions in PL/SQL
more...
Oracle Database 10g New Features in Security and Software Maintenance
To use the new security and software upgrade features in Oracle 10g
more...
Oracle Database 10g New Features in VLDB Support
To use Oracle 10g's new VLDB support features
more...
Oracle Database 10g Miscellaneous New Features
To recognize how various new features are used in Oracle 10g
more...
Using Flashback Technology in Oracle 10g
To outline the considerations and procedures for using Flashback features
more...
Performing and Managing Backups in Oracle 10g
To outline the processes and considerations for using RMAN to perform and monitor backups
more...
Advanced Database Recovery and Repair in Oracle 10g
To outline the processes for recovering non-critical files, performing incomplete recoveries, and repairing corrupted components of databases
more...
Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle
To outline the concepts and processes to secure the Oracle listener and to work with remote and distributed transactions
more...
Using Globalization Support in Oracle 10g
To outline the considerations and procedures for globalizing a database
more...
Optimizing Database Performance in Oracle 10g
To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors
more...
Managing Storage and System Resources in Oracle 10g
To outline the processes and considerations for using the Automatic Storage Management and Database Resource Manager features
more...
Using the Scheduler to Automate Tasks in Oracle 10g
To outline the processes and considerations for using the Scheduler tool
more...
Using Advanced Features in Oracle 10g
To outline the processes and considerations for using the advanced features of Oracle Database 10g
more...
Oracle Database 10g New Installation and Configuration Features
To discuss the new installation and configuration features of Oracle 10g
more...
Oracle Database 10g New Data Loading Features
To discuss new data loading features in Oracle 10g
more...
Oracle Database 10g New Automatic Management and Management Infrastructure Feat
To identify the new automatic management and management infrastructure features of Oracle 10g
more...
Oracle Database 10g New Resource Scheduling and Task-Management Features
To identify the new resource, scheduling, and task-management features of Oracle 10g
more...
Oracle Database 10g New Space Management Features
To identify the new space management features of Oracle 10g
more...
Oracle Database 10g New Storage Features
To identify the new storage features of Oracle Database 10g
more...
Oracle Database 10g New Tuning Performance-monitoring and Analysis Features
To use Oracle 10g's new tuning, performance-monitoring, and analysis features
more...
Oracle Database 10g New Backup and Recovery Features
To use Oracle 10g's new backup and recovery features
more...
Oracle Database 10g Using Flashback
To recognize Oracle 10g's Flashback technology and use Flashback features
more...
Oracle Application Server 10g mod_plsql CGI Scripts and Database Providers
To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS
more...
Oracle Database 10g Administration Workshop II Part 3

This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption.
Learn To:
Identify features of Flashback
more...
Oracle Database 10g Administration Workshop II Part 4

This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Learners will learn how to use various database technologies, such as Resource Manager, the Scheduler, and materialized views.
Learn To:
Identify features of Automatic Storage Management (ASM).
Identify features of Automatic Storage Management (ASM)
more...
Oracle Database 10g Adminsitration Workshop I Part 3

...y practices and principles that are implemented in Oracle Database 10g.
Identify advantages of revoking unnecessary privileges from the user group PUBLIC.
Identify guidelines for restricting dictionary and directory access.
Audience:
The target audience is Data Administrators, Technical Consultants, Support Engineers, and Sales Consultants.
Deployment:
Self-Study
Language
more...
Oracle Database 10g SQL Fundamentals I Part 2

In this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. .
Learn To:
Identify the
more...
Oracle Database 10g PL SQL Fundamentals Curriculum

The Oracle Database 10g: PL/SQL Fundamentals Curriculum includes the following courses:
Oracle Database 10g: PL/SQL Fundamentals (Part 1)
Oracle Database 10g: PL/SQL Fundamentals (Part 2)
Oracle Database 10g: PL/SQL Fundamentals (Part 3)
To review individual course descriptions, please return to the previous page and select the desired title(s).
more...
Oracle Database 10g PL SQL Fundamentals Part 1

In this course, the learner will get familiar with the procedural language to access Oracle database. The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as
more...
Oracle Database 10g SQL Fundamentals I Curriculum

The Oracle Database 10g: SQL Fundamentals I Curriculum includes the following courses:
Oracle Database 10g: SQL Fundamentals I (Part 1)
Oracle Database 10g: SQL Fundamentals I (Part 2)
To review individual course descriptions, please return to the previous page and select the desired title(s).
more...
Oracle Database 10g SQL Fundamentals I Part 1

...ed to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features.
Learn To:
Match the different phases of system development life cycle (SDLC) with their features.
Identify features of an Entity Relationship (ER) model.
Identify features of Relational
more...
Oracle Database 10g Administration Workshop II Part 2

This course will teach learners to use RMAN and explain the various RMAN commands. Diagnostic sources, non-critical recovery, and incomplete recovery concepts are also covered in this course. Learners will also learn how to perform incomplete recovery.
Learn To:
Match various RMAN commands with their features.
Distinguish between the methods for issuing RMAN commands.
Identify
more...
Oracle Database 10g Administration Workshop I Part 4

Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques.
Learn To:
Identify benefits of undo data.
Identify features of undo segments.
Identify undo management tasks that a DBA should perform to
more...
Oracle Database Administration Workshop I Part 2

...Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed at
more...
Oracle Database 10g Administration Workshop II Curriculum

...Database 10g: Administration Workshop II Curriculum includes the following courses:
Oracle Database 10g: Administration Workshop II(Part 1)
Oracle Database 10g: Administration Workshop II (Part 2)
Oracle Database 10g: Administration Workshop II (Part 3)
Oracle Database 10g: Administration Workshop II (Part 4)
To review individual course descriptions, please return to the previous page
more...
Oracle Database 10g Administration Workshop II Part 1

...ack technology.
Learn To:
Match goals of Oracle Database 10g manageability features with the methods of achieving them.
Identify features of the Oracle Database 10g manageability strategy.
Identify globalization support features provided by Oracle Database 10g.
Identify features of different encoding schemes supported by Oracle Database 10g.
Distinguish between features of the
more...
Oracle Database 10g New Features for Administrators Part 1

...Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers the new features of Oracle Database 10g that are applicable to database administration. The features include Manageability concepts, Grid computing, enhanced installation features, configuration and performance
more...
Oracle Database 10g New Features for Administrators Curriculum

...Database 10g: New Features for Administrators Curriculum includes the following courses:
Oracle Database 10g: New Features for Administrators (Part 1)
Oracle Database 10g: New Features for Administrators (Part 2)
Oracle Database 10g: New Features for Administrators (Part 3)
Oracle Database 10g: New Features for Administrators (Part 4)
Oracle Database 10g: New Features for Administrators
more...
Oracle Database 10g New Features for Administrators Part 2

...Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring.
Learn To:
Identify features of Automatic Database Diagnostic Monitor (ADDM).
more...
Oracle Database 10g New Features for Administrators Part 3

...Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Resource Manager, job Scheduler, tablespace monitoring, shrinking segments, and partitioning enhancements.
Learn To:
Identify features of Resource Manager in Oracle Database 10g.
Identify
more...
Oracle Database 10g New Features for Administrators Part 4

...Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as flash backup and recovery.
Learn To:
Identify features of the flash backup and recovery strategy.
Identify tasks that you perform when using the flash recovery area
more...
Oracle Database 10g New Features for Administrators Part 5

...Database 10g is designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. Oracle Database 10g supports the Oracle vision of creating a self-aware, self-learning, and completely self-managing database. This course covers new features of Oracle Database 10g such as automatic storage management, upgrade methods, RMAN backup, flash
more...
Oracle Database 10g Administration Workshop I Curriculum

...Database 10g: Administration Workshop I Curriculum includes the following courses:
Oracle Database 10g: Administration Workshop I (Part 1)
Oracle Database 10g: Administration Workshop I (Part 2)
Oracle Database 10g: Administration Workshop I (Part 3)
Oracle Database 10g: Administration Workshop I (Part 4)
To review individual course descriptions, please return to the previous page and
more...
Oracle Database 10g Administration Workshop I Part 1

...ning Time:
4 hours
Objectives:
Unit 1: Oracle Database 10g Workshop
Identify features of a Relational Database Management System (RDBMS).
Match the different types of integrity constraints with their features.
Identify tasks of an Oracle DBA.
Identify features of Optimal Flexible Architecture (OFA).
Identify prerequisites for installing the Oracle Database 10g software.
more...
Oracle Database 10g PL SQL Fundamentals Part 2

This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers.
Learn To:
Identify features of PL/SQL blocks within a subprogram.
Match types of PL/SQL named blocks
more...
Oracle Database 10g PL SQL Fundamentals Part 3

In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options.
Learn To:
Match the stages in the execution of SQL statements with
more...
Oracle Application Server 10g Administration Part 3

Oracle Application Server 10g is an integrated, standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers managing, configuring OC4J applications, maintaining OC4J Application pages, OracleAS Portal, managing portal users and groups, exporting and importing portal objects, and Oracle portal advanced
more...
Oracle Application Server 10g Administration II Part 1

This course describes the advanced administration concepts. In addition, you are introduced to common deployment topologies of Oracle Application Server 10g to enable choosing the appropriate topology according to your business needs. To provide a stable and highly available environment that performs well, you learn the concepts for high availability (HA) and scalability. You also learn to
more...
Oracle Application Server 10g Administration II Part 2

This course introduces learners to Web Cache clusters and OracleAS Clusters. The participants learn to configure these clusters and manage them in OracleAS 10g. The participants also learn to configure J2EE clustering, OC4J, and manage OracleAS in a CFC environment.
Learn To:
Identify features of Oracle Application Server (OracleAS) 10g Web Cache clusters.
Identify benefits of running
more...
Oracle Application Server 10g Administration II Part 3

This course introduces the various Business Intelligence components such as Discoverer, Reports, Forms, and XML applications. The users learn about configuring and managing OracleAS Discoverer, OracleAS Reports Services, OracleAS Forms, and XML applications. They also learn how to deploy and manage OracleAS Web Services.
Learn To:
Match the components of Oracle Application Server
more...
Oracle Application Server 10g Administration II Part 4

This course covers how to monitor the OracleAS components and processes. It also covers tuning the various components of the OracleAS, as well as backup and recovery of OracleAS. Finally, it provides guidance on reconfiguring the OracleAS middle-tier components.
Learn To:
Identify features of Oracle Diagnostic Logging (ODL).
Identify options for configuring component logging.
more...
From iWare Logic
Certification in Oracle Applications Technologies
...racle Forms- Build Internet Applications
IZ0-040 Oracle Database 10g- New Features for Administrators
IZ0-042 Oracle Database 10g - Administration - I
IZ0-043 Oracle Database 10g - Administration - II
Iz0-048 Oracle Database 10g- R2- RAC for Administrators
IZ0-047 Oracle Database 10g a SQL Expert
IZ0-046 Oracle Database 10g- Managing Oracle on Linux
IZ0-200 11i EBusiness
more...
From Serebra Learning Corporation
Oracle Application Server 10g mod_plsql CGI Scripts and Database Providers
To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g
more...
Oracle Database 10g The SQL Loader and PL SQL Release 2
To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database Anyone wanting to learn about Oracle Database 10g database administration
more...
Oracle Database 10g Oracle Net Services and Shared Servers Release 2
To provide an overview of Oracle Net Services and Shared Server Anyone wanting to learn about Oracle Database 10g database administration
more...
Oracle Database 10g Monitoring and Maintenance Release 2
To demonstrate how to control database performance and configure proactive database maintenance Anyone wanting to learn about Oracle Database 10g database administration
more...
Oracle Database 10g Managing Undo Data and Lock Conflicts Release 2
To discuss how to manage undo data and manage lock conflicts in an Oracle database Anyone wanting to learn about Oracle Database 10g database administration
more...
Oracle Database 10g Managing Backup and Recovery Release 2
To discuss how to manage backup and recovery in an Oracle 10g database Anyone wanting to learn about Oracle Database 10g database administration
more...
Using Flashback Technology in Oracle 10g
To outline the considerations and procedures for using Flashback features Oracle database administrators and database operators
more...
Performing and Managing Backups in Oracle 10g
To outline the processes and considerations for using RMAN to perform and monitor backups Oracle database administrators and database operators
more...
Advanced Database Recovery and Repair in Oracle 10g
To outline the processes for recovering non-critical files, performing incomplete recoveries, and repairing corrupted components of databases Oracle database administrators and database operators
more...
Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g
To outline the concepts and processes to secure the Oracle listener and to work with remote and distributed transactions Oracle database administrators and database operators
more...
Using Globalization Support in Oracle 10g
To outline the considerations and procedures for globalizing a database Oracle database administrators and database operators
more...
Optimizing Database Performance in Oracle 10g
To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors Oracle database administrators and database operators
more...
Managing Storage and System Resources in Oracle 10g
To outline the processes and considerations for using the Automatic Storage Management and Database Resource Manager features Oracle database administrators and database operators
more...
Using the Scheduler to Automate Tasks in Oracle 10g
To outline the processes and considerations for using the Scheduler tool Oracle database administrators and database operators
more...
Using Advanced Features in Oracle 10g
To outline the processes and considerations for using the advanced features of Oracle Database 10g Oracle database administrators and database operators
more...
PL SQL Packages
To create and work with Oracle 10g packages Database administrators, application developers, and database operators
more...
Oracle-Supplied Packages and DBMS_SCHEDULER
To use Oracle-supplied packages Database administrators, application developers, and database operators
more...
Managing Dependencies
To manage dependencies and recompile PL/SQL units Database administrators, application developers, and database operators
more...
Manipulating Large Objects in PL SQL
To use LOBs and the DBMS_LOB package Database administrators, application developers, and database operators
more...
PL SQL Triggers
To create and manage triggers Database administrators, application developers, and database operators
more...
Dynamic SQL and Metadata
To write dynamic SQL and use the DBMS_METADATA package Database administrators, application developers, and database operators
more...
Oracle Database 10g New Installation and Configuration Features
To discuss the new installation and configuration features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Data Loading Features
To discuss new data loading features in Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Automatic Management Features
To identify the new automatic management and management infrastructure features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Resource Scheduling and Task-Management Features
To identify the new resource, scheduling, and task-management features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Space Management Features
To identify the new space management features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Storage Features
To identify the new storage features of Oracle Database 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Tuning Performance-monitoring and Analysis Features
To use Oracle 10g's new tuning, performance-monitoring, and analysis features Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Backup and Recovery Features
To use Oracle 10g's new backup and recovery features Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g Using Flashback
To recognize Oracle 10g's Flashback technology and use Flashback features Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Features in Security and Software Maintenance
To use the new security and software upgrade features in Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g New Features in VLDB Support
To use Oracle 10g's new VLDB support features Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g Miscellaneous New Features
To recognize how various new features are used in Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g
more...
Oracle Database 10g Performance Tuning Tools and Techniques
This course provides an overview of the tuning methodology and performance monitoring. The course also covers common tuning problems and the goals and objectives of performance tuning. Finally, the course covers the tuning life cycle and the tuning methodology followed in the different phases of the tuning life cycle. This course is designed for DBAs, database architects, support engineers, and
more...
Oracle Database 10g Performance Tuning Tuning Data
This course provides an overview of performance pages and dynamic views. Additionally, the course covers key concepts related to metrics, alerts, baselines, and Statspack. This course is designed for DBAs, database architects, support engineers, and technical consultants.
more...
Oracle Database 10g Performance Tuning Tuning Infrastructure
This course discusses the key concepts related to using the Automatic Workload Repository (AWR), the Automatic Database Diagnostic Monitor (ADDM), and Active Session History (ASH) reports. This course is designed for DBAs, database architects, support engineers, and technical consultants.
more...
Oracle Database 10g Performance Tuning Instance Tuning
This course covers the concepts related to tuning the shared pool and the buffer cache. This course also covers the concepts related to the System Global Area (SGA), Automatic Shared Memory Management (ASMM), the Program Global Area (PGA), and the PGA Target Advice. This course is designed for DBAs, database architects, support engineers, and technical consultants.
more...
Oracle Database 10g Performance Tuning Memory Management
This course covers key concepts related to I/O, Redundant Array of Inexpensive Disks (RAID), and Automatic Storage Management (ASM). The course also covers key concepts related to checkpoint and redo. Lastly, the course covers key concepts related to performing space management. This course is designed for DBAs, database architects, support engineers, and technical consultants.
more...
Oracle Database 10g Performance Tuning Performance Management
This course covers the key concepts related to tablespace management and reactive tuning. The course also summarizes key concepts related to performance tuning. This course is designed for DBAs, database architects, support engineers, and technical consultants.
more...
Introduction to PL SQL
To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL Database administrators, application developers, and database operators
more...
Using PL SQL with an Oracle Server
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block Database administrators, application developers, and database operators
more...
Using Control Structures
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct Database administrators, application developers, and database operators
more...
Using Composite Data Types
To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records Database administrators, application developers, and database operators
more...
Explicit Cursors and Exception Errors
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Database administrators, application developers, and database operators
more...
Creating Stored Procedures and Functions
To create and execute a stored function and call, and remove and view stored functions in PL/SQL Database administrators, application developers, and database operators
more...
Introduction to Oracle and SQL in Oracle Database 10g
To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements Database administrators, application developers, and database operators
more...
SQL Functions in Oracle Database 10g
To describe how to use SQL functions for data retrieval Database administrators, application developers, and database operators
more...
Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases Database administrators, application developers, and database operators
more...
Group and Datetime Functions in Oracle Database 10g
To demonstrate how to use group and datetime functions in Oracle 10g Database administrators, application developers, and database operators
more...
Subqueries and Hierarchical Queries in Oracle Database 10g
To demonstrate how to use subqueries and hierarchical queries in Oracle 10g Database administrators, application developers, and database operators
more...
Regular Expressions and User Access in Oracle Database 10g
To demonstrate how to use regular expression support and control user access in Oracle 10g Database administrators, application developers, and database operators
more...
Oracle Database 10g - New Features for Administrators Part 1
...Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers the new features of Oracle Database 10g that are applicable to database administration. The features include Manageability concepts Grid computing enhanced installation features configuration and performance enhancements
more...
Oracle Database 10g - New Features for Administrators Part 2
(Currently no course description)
more...
Oracle Database 10g - New Features for Administrators Part 3
(Currently no course description)
more...
Oracle Database 10g - New Features for Administrators Part 4
(Currently no course description)
more...
Oracle Database 10g - New Features for Administrators Part 5
(Currently no course description)
more...
Oracle Database 10g - Administration Workshop I Part 1
Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught 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.
more...
Oracle Database 10g - SQL Fundamentals I Part 1
In this course learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally the learners will be introduced to the powerful SQL programming language and its features.
more...
From Dbametrix Solutions
Oracle Database 10g 2 days DBA

2 days DBA courses are made for fast track and crash courses of Oracle DBA. It is fully designed by Oracle.
DBAMETRIX is providing Online Training, Online Training videos and Online IT Training of Oracle DBA courses. We are offering following all Oracle DBA courses as e-learning using web based online training. Expert Instructor provides you maximum benefit for your valuable investment for
more...
From Software Training Academy, Inc
JDBC Programming Rev 5

This one-day course covers the fundamentals of database programming in Java using JDBC (Java Database connectivity) in an incremental fashion, to get the programmer up to speed quickly and then to layer a deeper understanding of JDBC upon that foundation. This course has been designed to work with any of these relational database management systems:
Apache Derby, version 10.1
MySQL, version
more...
Oracle 10g Administration

Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data
more...
Oracle 10g PL SQL Programming

This class will teach you how to write efficient and scalable PL/SQL programs to create database-intensive PL/SQL applications.
Learning how to create efficient, scalable PL/SQL programs is an important objective of this course. To meet that objective, the course includes instruction on such things as the proper use of bind variables, bulk processing, pipelining, benchmarking different
more...
Oracle 10g - Advanced SQL

This course will give experienced Oracle technologists the advanced SQL skills necessary to design and code complex queries against Oracle databases.
You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability
more...
Oracle 10g - Introduction to SQL

This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases.
Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts.
LEARNING OBJECTIVES
more...
Oracle Applications Using ADO NET and C

Oracle is a robust and powerful data storage engine that provides services on all levels of an application infrastructure combining programmer-definable objects and tools, data manipulation tools that are capable of retrieving data from a host of data sources and storing those data in a database, and the capability to automate tasks and run them under developer control.
This comprehensive course
more...
