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...
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...
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...
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: Oraclemore...
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...
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 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...
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...
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 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...
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 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...
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 Certifiedmore...
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, Connectionmore...