Online Database Administrator eLearning - Training Resources
Database Administrator Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle SQL PL SQL Using Procedure Builder Curriculum

...al (OCP) Program certification tracks: Oracle8i Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2. Learn To See individual course descriptions for specific course objectives and scope. Audience Application developers, database administrators, designer/ developers, and technical support professionals. Prior
more...
Oracle SQL PL SQL Using Procedure Builder Curriculum
Oracle9i Database Admin Perform Database Backups

... Audience The intended audience for this course include Database administrators, IT managers, and technical professionals. There are no prerequisites for this course. Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 64321 Objectives Unit 1: Oracle
more...
Oracle9i Database Admin Manage an Instance

...components. The participants learn the various tasks of a database administrator that are performed by using OEM and the steps to start and shut down an instance. This course also explains the various dynamic performance views and initialization parameters and the globalization support that is provided. Learn To Identify the memory structures of the SGA and the information stored in
more...
Oracle9i Certified Database Administrator Track Curriculum

...Database Administrator Track Curriculum includes the following curriculums: Introduction to Oracle9i: SQL Curriculum (ID#8054) Oracle9i Database: Fundamentals I Curriculum (ID#8058) Oracle9i Database: Fundamentals II Curriculum (ID#8064) Oracle9i Database: Performance Tuning Curriculum (ID#8068) To review individual curriculum descriptions, please select the corresponding product ID
more...
SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries

Course Overview This course will teach students how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived
more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data

Course Overview This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL. Learn To Identify the basic types of statements used in Transact-Structured Query Language (SQL). Identify the functions of Data Definition Language (DDL) statements. Identify the functions of Data Control Language (DCL) statements.
more...
SQL Server 2000 Design Implement Databases Part 4 Managing Indexes

Course Overview This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries. Learn To Identify the features of clustered indexes. Identify the features of nonclustered
more...
SQL Server 2000 Design Implement Databases Part 3 Managing Objects

Course Overview This is the third course in a five part series that will teach students how to work with SQL Server data objects. Students will learn how to create and manage view, stored procedures, user-defined functions, and triggers. Learn To Identify the features of views. Identify the considerations for creating views. Create a view by using Transact-SQL. Match the different
more...
SQL Server 2000 Design Implement Databases Part 2 Managing Data

Course Overview This is the second course in a five part series that will teach students how to work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical
more...
SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server

Course Overview This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify
more...
IBM DB2 Universal Database V6 1--Administration

...database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement a new DB2 database or application.
more...
IBM DB2 Universal Database V6 1--Administration

...database administrators with the specific skills and knowledge needed to be successful with DB2 Universal Database (UDB) V6.1 database administration in a UNIX, Windows, or OS/2 environment. This course will teach students the critical skills needed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement a new DB2 database or application.
more...
IBM DB2 Universal Database V6 1 Admin Curriculum

...lls-Based A udience These courses are intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and
more...
IBM DB2 Universal Database V6 1 Admin Curriculum

...lls-Based A udience These courses are intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and
more...
UNIX--Part 1 User Fundamentals

... System Analyst, System Administrator, Software Engineer, Database Administrator, Help Desk/Support. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Introduction to UNIX Duration: 1 - 2 Hour(s) Identify the milestones in the development of UNIX. Identify the standards relating to UNIX. Identify the differences between working with windows and with shells.
more...
Oracle8i Network Administration Net8 Additional Config Troubleshooting

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315), and the first part in this series, Oracle8i Network Administration: Net8 Architecture and Basic Configuration (63326). This
more...
Oracle8i Network Administration Net8 Architecture Strategy

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 5, 1Z0-026. T
more...
Oracle8i Backup and Recovery Troubleshooting Recovery

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Backup and Recovery: Strategies and Backups (63321). This course will help candidates
more...
Oracle8i Backup and Recovery Strategies Backups

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course. This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA)
more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Performance Tuning: Strategies and Techniques (63331) and Oracle8i Performance Tuning:
more...
Oracle8i Performance Tuning Managing Memory Disk I O

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Performance Tuning: Strategies and Techniques (63331). This course will help candidates
more...
Oracle8i Performance Tuning Architecture Strategy

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and experience using Oracle Enterprise Manager (OEM). This course will help candidates prepare for
more...
Oracle8i Database Admin Manage an Instance

.... C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This
more...
Oracle8 Backup and Recovery - Strategies and Backups

... with and without RMAN.
L earn To:
Identify the database administrator goals and the criteria for defining a backup and recovery strategy.
Describe the structures and processes in the Oracle architecture.
Identify the implications of operating a database in a given archive mode and identify the steps to change the archive mode.
Set the init.ora parameters and configure the
more...
Oracle8 Certified Database Administrator Curriculum

...tice in key topic areas. The Complete Oracle8 Certified Database Administrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle8 Database Administration - Manage an Instance (ID#421) Oracle8 Database Administration - Create
more...
Oracle8 Database Administration - Manage an Instance

....
C ontent Emphasis
Skills-Based
A udience
Database Administrators, system administrators, network administrators and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112 and 60113.
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Oracle
more...
SQL and PL SQL Basic SELECT

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. This course will help
more...
SQL and PL SQL Data Retrieval Techniques

... Skills-Based A udience Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. In addition,
more...
SQL and PL SQL DML and DDL

... Skills-Based A udience Application Developers, Database Administrators, Designer/Developers, System Analysts, and Technical Support Professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. In
more...
UNIX User Curriculum

Course Overview This curriculum describes how to get started with UNIX, introducing the Common Desktop Environment (CDE) and the terminal window. It introduces files, directories, printing and operations frequently performed on these. It teaches how to manipulate input and output, as well as how to compress and uncompress files. It also introduces the UNIX shell environment, shell functionality,
more...
SCO SVR 5 --Part 1 Basic Administration

... System Analyst, System Administrator, Software Engineer, Database Administrator. Recommended prerequisite background: The Unix shell environment. Understand the multi-tasking, multi-user nature of the Unix environment. Identify the hardware/software and file structure used in Unix systems. Understand basic networking. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:
more...
SCO SVR 5 --Part 2 Network Administration

... System Analyst, System Administrator, Software Engineer, Database Administrator. Prerequisites to this course would be to understand the UNIX shell environment, the multi-tasking, multi-user nature of the UNIX environment. Identify the hardware/software and file structure used in UNIX systems, and understand basic networking. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit
more...
Solaris--Part 1 Basic Administration

... System Administrator, System Analyst, Web Administrator, Database Administrator, Mail Administrator, Network Engineers. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Installation and Startup Duration: 2 - 3 Hour(s) Identify the functions of the Unix system administrator. Identify the features of the Solaris operating environment. Identify the methods for
more...
Solaris--Part 2 Network Administration

... System Administrator, System Analyst, Web Administrator, Database Administrator, Mail Administrator, Network Engineers. Specifying, installing and administering UNIX systems in small to large enterprises. Administering applications running on UNIX systems (both hardware and software). Managing users and security. Providing advanced help desk and information services. T otal Learning Time
more...
IBM AIX--Part 2 Network Administration

... System Analyst, System Administrator, Software Engineer, Database Administrator, Help Desk/Support, End User. L earn To: Identify the features of the print queue process on AIX. Identify the command-line interface (CLI) commands that are available to manage printing on AIX. Identify the functions of tty terminals on AIX. Identify network configuration options. Identify the
more...
HP-UX--Part 1 Basic Administration

... System Analyst, System Administrator, Software Engineer, Database Administrator, Help Desk/Support. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Installation and Startup Duration: 2 - 3 Hour(s) Identify the features of HP-UX versions 10 and 11. Identify the function of the HP-UX system administrator. Identify the hardware requirements for installing HP-UX.
more...
HP-UX--Part 2 Network Administration

... System Analyst, System Administrator, Software Engineer, Database Administrator, Help Desk/Support, End User. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Printers and Terminals Duration: 2 - 3 Hour(s) Identify the capabilities of printers in HP-UX. Add a local printer by using System Administration Manager (SAM). Identify the procedure to manage print queue
more...
Office XP-New Features Curriculum

Course Overview This curriculum provides a general overview of new productivity and information handling tools. It concentrates on new features within Microsoft Word, Excel and PowerPoint, and Microsoft Office XP software. Additionally, there is an emphasis on database, e-mail, and Internet software. This curriculum consists of two Skill Builder courses: Course 74010 Microsoft Office XP - New
more...
Office XP New Features Part 1 Overview Word Excel PowerPoint

...ce Manager, Web Designer-Developer, System Administrator, Database Administrator. This course presents the learner with the first of two sets of new features available in the new Microsoft Office XP software. Content Emphasis Skills-Based Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American
more...
Visual Basic NET-Windows Development Curriculum

... Edition. Typical job roles include System Administrator, Database Administrator, Application Developer, System Analyst, or Software Engineer. This course requires experience in programming and developing of Visual Basic applications. It is presumed that the student has completed the Microsoft MSDN Training Course 2559A, Introduction to Visual Basic .NET Programming or Equivalent. Deployment
more...
Visual Basic NET-Windows Development Part 1

... Edition. Typical job roles include System Administrator, Database Administrator, Application Developer, System Analyst, or Software Engineer. This course requires experience in programming and developing of Visual Basic applications. It is presumed that the student has completed the Microsoft MSDN Training Course 2559A, Introduction to Visual Basic .NET Programming or Equivalent. Deployment
more...
Visual Basic NET-Windows Development Part 2

... Edition. Typical job roles include System Administrator, Database Administrator, Application Developer, System Analyst, or Software Engineer. This course requires experience in programming and developing of Visual Basic applications. It is presumed that the student has completed the Microsoft MSDN Training Course 2559A, Introduction to Visual Basic .NET Programming or Equivalent. Deployment
more...
Visual Basic NET-Windows Development Part 5

... Edition. Typical job roles include System Administrator, Database Administrator, Application Developer, System Analyst, or Software Engineer. This course requires experience in programming and developing of Visual Basic applications. It is presumed that the student has completed the Microsoft MSDN(r) Training Course 2559A, Introduction to Visual Basic .NET Programming or Equivalent.
more...
From Serebra Learning Corporation
Visual Basic 6 0 Database Access Part II
This course provides a detailed look at the ActiveX Data Object (ADO)that acts as the bridge between your application and a database. Designed for intermediate to advanced Visual Basic application programmers Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential.
more...
Utilizing DB2 UDB Utilities
To explain the use of DB2 UDB data movement and data maintenance utilities Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Managing Disaster Recovery in a DB2 UDB Database
To explain how to use the DB2 UDB disaster recovery utilities Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Managing Database Access in a DB2 UDB
To describe database access management in DB2 UDB Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Managing a DB2 UDB Server
To explain how to manage a DB2 UDB server Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Administering Data Placement in a DB2 UDB
To describe the administration and placement of data in a DB2 UDB database Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Monitoring a DB2UDB
To explain how to monitor a DB2 UDB Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
more...
Oracle9i Database Administration: Manage an Instance


The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by using
more...
Oracle9i Database Administration: Manage an Instance
The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by
more...
IBM/AIX Part 2: Network Administration
This course covers all the UNIX implementation tracks aimed at a system administrator and the following job roles Application Developer Technical Manager System Analyst System Administrator Software Engineer Database Administrator Help Desk/Support End User.
more...
From TechSkills
Microsoft







...ertified Technical Specialist (MCTS), Microsoft Certified Database Administrator (MCITP-DBA), Microsoft Certified Professional (MCP), and Microsoft Office certifications.
Students may complete certification preparation individually, or enroll in our IT Series program, which allows you to earn as many certifications as you can for up to twelve months, for one low price.
TechSkills makes it
more...
Microsoft Certification







...ertified Technical Specialist (MCTS), Microsoft Certified Database Administrator (MCITP-DBA), Microsoft Certified Professional (MCP), and Microsoft Office certifications.
Students may complete certification preparation individually, or enroll in our IT Series program, which allows you to earn as many certifications as you can for up to twelve months, for one low price.
TechSkills makes it
more...
From The Virtual Training Company
Microsoft SQL Server 2005 Administration
SQL Server 2005 is Microsoft's latest release of their enterprise database solution product. SQL Server 2005 is the result of five years of research, development and collection of suggestions and wish lists from database administrators and developers. Microsoft continues to drive the enterprise database market with the added features and capabilities of this new product. Microsoft Certified
more...
From Teach Me IT
Tuning Oracle8 Database Performance

...urriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-014. The course acquaints the users with the basic concept of performance tuning, and also discusses the various diagnostic tools used to diagnose problems in Oracle. It will also enable users to tune the various components of Oracle, such as database operations and distributed queries,
more...
Optimizing Oracle8 Performance

...urriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-014. The course first acquaints the users with the concept of tuning of sorts, checkpoints, resource contention, and then goes on to discuss the various OEM tools to tune background processes, networks and blocks. Additionally, it discusses the various features and uses of the Oracle in-built
more...
Oracle SQL and PL/SQL: Basic Concepts

...urriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course explains the basic concepts regarding a DBMS, RDBMS, and ORDBMS, and give an Oracle implementation of these. It also provides users with the basic functionality of PL/SQL for creating, viewing, maintaining, and altering data in Oracle. After completing this course, the student will
more...
Basic PL/SQL Programming

...urriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course enables users to create views, sequences, synonyms, records, tables, functions, and procedures. Additionally, it enables users to create different kinds of PL/SQL blocks. After completing this course, the student will be able to:
Create views
Identify the different data
more...
Managing Users and Objects

...Database Administrators to create users and manage the different activities associated with them. Additionally, this course acquaints the user with managing various database resources. This course also helps you deal with various user privileges and granting them to users. You will be familiarized with loading data and maintaining its integrity. This course provides information about the
more...
Oracle8 Backup and Recovery - II

...urriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-015. This course is designed to acquaint users with the concepts of backup and recovery operations of an Oracle database. It cites, in detail, the various means and modes of recovering an Oracle database to enable you to implement an effective backup and recovery scheme for your organization. After
more...
Managing Oracle8 Networks

... Networks WBT prepares students for the Oracle8 Certified Database Administrator Track Exam #1Z0-016. This course acquaints network administrators with the basic architecture of Oracle8 networks. It introduces Net8 and teaches users to plan and configure an Oracle8 network. The course also enables users to configure advanced Oracle8 network services, such as Oracle Names Server, Connection
more...
