Online Database Administrator eLearning

Oracle 11g DBA OCA Library Oracle 11g DBA OCA Library Oracle Oracle Database 11g Administrator Certified Associate Oracle Database Administrator 11g Certfied Associate Library  more...

Oracle Database 11g R2 Database Architecture Recovery Operations ...base and its major components function. Also as an Oracle Database administrator, you need to be able to recover when problems occur in the database. This is accomplished using backups, which are used to protect against problems such as media failure, user errors, and application errors. This course reviews the major architectural components of the Oracle Database 11g architecture, such as  more...

Oracle Database 11g R2 Performing Restore Recovery Tasks ...R2: Performing Restore & Recovery Tasks Oracle As a database administrator it is very important to understand how to restore and recover your database in the event of a loss of a file due to media, hardware, or user error. The restoration process involves moving a backup into place to be used by the database when a file is damaged. The recovery process involves applying redo to bring the  more...

Oracle Database 11g R2 Database Architecture Installation ...uctures. In addition, this course describes the role of a database administrator (DBA) and the tasks and tools required for this role. This course also covers how to plan for the Oracle Grid Infrastructure and Oracle Database 11g software installations, as well as how to do the installation using the Oracle Universal Installer. This course is one of a series in the SkillSoft learning path that  more...

Oracle Database 11g R2 Database Creation Instance Management ...g: Administration Workshop I Release 2 As an Oracle Database administrator, it is important to plan the database to ensure that the database software is installed properly. Planning involves the logical storage structure, the overall design, and a backup strategy. It is also important to manage the database instance after the installation to ensure that it runs properly, and is started  more...

Oracle Database 11g R2 Backup Recovery ...backups are expected job duties of an Oracle Database 11g Database Administrator (DBA) to ensure that the database is available for users when they require it. They also need to ensure if a failure does occur that the loss of data is minimized as much as possible and they can recover the database in an efficient manner. As an Oracle DBA, it is important to understand the various internal  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:  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...

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...

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 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 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 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 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 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 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...

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...

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...

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...

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 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 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 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 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...

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...

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...

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 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...

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...

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...

Oracle8 Backup and Recovery - Strategies and Backups ...th 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  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...

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...

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...