|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Seminars
| New Training Providers
| Site Map
| Promote Training Seminars
|
Training Keywords
| Training Seminars
| Training Providers
| Regions
|
| Advertise Training Seminars
| Login
|
||||||||||
Database Administrators Training Seminars and Classes
From Serebra Learning Corporation
Security in a Microsoft SQL Server 2000 Environment
 To explain how to plan and implement security on a SQL 2000 database Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...Transferring and Transforming Data in SQL Server 2000
To enable students to extract and transform data in SQL Server 2000 Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...Fundamentals of Microsoft Visual InterDev 6 0
This course gives an overview of the fundamental concepts of Visual InterDev 6.0. It teaches how to create simple web projects using the Web Project Wizard, as well as how to create site diagrams, manage links between pages, apply links, style sheets, and themes to a project. In addition, it prepares students to take the Microsoft certification exam: Designing and Implementing Web Solutions with more...Scripting with MS Visual InterDev 6 0
This course provides students an insight into the scripting skills necessary to utilize Visual InterDev 6.0 to create dynamic and enhanced Web application. In addition, it prepares students to take the Microsoft certification exam: Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. This course is intended for Web Developers, Web Masters, Web Server Administrators, System more...Developing Applications using MS Visual InterDev 6 0
This course provides students with skills to develop web applications using databases with Visual InterDev 6.0. The students will also be taught the process of deploying web applications on web servers. In addition, this course prepares students to take the Microsoft certification exam: Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. This course is intended for Web more...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...DB2 Design Administration I ver 4 x
Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. Database administrators, analysts and systems designers. more...DB2 Design Administration II ver 4 x
Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. Database administrators, analysts and systems designers. more...OS 390 Introduction to CICS Transaction Server
The OS/390 CICS course provides general information about Customer Information Control System (CICS) and methods for employing it to perform basic Online Transaction Processing (OLTP) tasks in a mainframe environment. The course reviews the overall structure and purpose of CICS and introduces basic command levels for CICS in the following areas: management of data and databases, data communication more...Data Warehousing
This course will provide an overview of Data Warehousing, an emerging technique for storage and retrieval of data from distributed heterogeneous sources. Students will be given an overview of Data Warehousing, study the various components of Data Warehousing Systems, and learn how to build, use and maintain a Data Warehousing System. Information systems managers, database administrators and other more...Data Modeling
To be able to use a database to store data, you have to design it. The first step in designing a database is data modeling. Data modeling enables a database designer to create a model that represents the way in which information is likely to be organized in the database. This data model is then reviewed by the people who are expected to use the final database. Subsequent steps in database more...CCNT Basic Data Communications v6 0 Part 1
This course gives students an introduction to data networks, signals and to data transmission. The Data Networks and Signals section teaches about data terminal equipment (DTE), data communication equipment (DCE), the OSI model, and analog and digital signals. The Data Transmission section teaches about half-duplex and full-duplex circuits, and switched and non-switched data circuits. This section more...CCNT Basic Data Communications v6 0 Part 2
This course teaches students about networks and transmission principles. The networks section teaches about local area networks (LANs), wide-area networks (WANs), hierarchical WANs, and LAN components. This section also teaches about system network architecture (SNA), and TCP/IP. The Transmission Principles section teaches about data protocols, DTE to DCE interface standards, and transmission more...Backup and Recovery Overview and Configuration in Oracle9i
To describe backup and recovery operations, the backup components, and how to configure these components in an Oracle9i database Oracle database administrators and database operators more...CCNT Basic Data Communications v6 0 Part 3
This course teaches students about data communications equipment and media. The LANs and Communications equipment section teaches about the Institute for Electrical and Electronic Engineering (IEEE), analog and digital communication, modulation, multiplexers, and the Synchronous Optical Networks (SONET) protocol. The Transmission Media section teaches about transmission media cables and wireless more...User-Managed and RMAN Backup and Recovery in Oracle9i
To describe how to perform user-managed and Recovery Manager backup and recovery in an Oracle9i database Oracle database administrators and database operators more...Recovery Manager Maintenance in Oracle9i
To describe how to maintain the Recovery Manager (RMAN) and how to create and maintain the recovery catalog in an Oracle9i database Oracle database administrators and database operators more...Transporting and Loading Data in Oracle9i
To describe how to transport and load data in an Oracle9i database Oracle database administrators and database operators more...Networking Overview for Oracle9i Administrators
To provide an overview of the networking solutions and the components of the network architecture in an Oracle9i database Oracle database administrators and database operators more...Oracle Network Configuration in Oracle9i
To explain how to configure client/server Oracle Net Services and a Shared Server for an Oracle9i database Oracle database administrators and database operators more...Introduction to Oracle and SQL in Oracle 9i
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements Junior database administrators, application developers, and database operators more...SQL Functions in Oracle 9i
To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators more...Subqueries Reporting and User-Access Control in Oracle 9i
To describe the use of subqueries, reporting, and user-access control in an Oracle9i database Junior database administrators, application developers, and database operators more...Defining and Manipulating Data in Oracle 9i
To describe how to define database objects and manipulate the data stored within them in an Oracle9i database Junior database administrators, application developers, and database operators more...Introducing Oracle9i Database
To introduce the components and architecture of Oracle9i, the application of Oracle9i, and migrating and upgrading to Oracle9i Oracle database administrators; developers interested in the technical aspects of Oracle9i database more...Manageability Enhancements in Oracle9i
To describe the manageability enhancements of an Oracle9i database Oracle database administrators; developers interested in the technical aspects of Oracle9i database 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...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...Installing Configuring and Upgrading SQL Server 2000
To describe how to install, configure, and upgrade SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...Overview of SQL Server 2000
To provide a high-level overview of SQL Server Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...Managing SQL Server 2000 Databases
To guide students in configuring, performing, and automating routine administrative tasks Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...SQL Server 2000 Databases
To describe how to create and modify SQL Server 2000 databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...Backing Up SQL Server 2000 Databases
To explain how to back up SQL Server databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...Restoring SQL Server 2000 Databases
To describe the process involved in restoring SQL Server databases Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...SQL Server 2000 Replication
To describe how to implement the SQL 2000 replication models Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...Monitoring SQL Server 2000 Performance
To explain how to monitor SQL Server for optimal performance Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition more...IBM DB2 UDB Essentials Part 2 - System and Database Administration
Following on from the first course in this curriculum this course focuses on the roles and principal tasks of the System Administrator and Database Administrators in IBM DB2. Administrative utilities and security are covered. The course also provides comprehensive introduction to the areas of database modelling database design and distributed data processing all core concepts within IBM DB2 UDB. more...SQL Server 7.0 Management Part II
...database administrators managers and users so that they may take full advantage of SQL Server 7.0 features. It explains how to use the fundamental elements of Transact-SQL how to use the SELECT statement and how to monitor database performance. It also examines stored procedures and joins. Related Exam: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and more...IBM DB2 Universal Database V6.1 Fundamentals
This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX Windows or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1 creating and accessing database objects basic Structured Query Language (SQL) and managing more...IBM DB2 Universal Database V6.1 Administration
This course will provide 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. more...DB2 Design & Administration (Rel 2.3)
  Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. more...DB2 Design & Administration (ver 3.1)
Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. more...DB2 Design & Administration (ver 4.x)
This course provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance. more...
From 123-CBT Computer Based Training
Oracle SQL PL SQL Using Procedure Builder Curriculum
 ...jectives and scope. Audience Application developers, database administrators, designer/ developers, and technical support professionals. Prior to taking this curriculum, 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 curriculum more...HTML 4 Part 2 Advanced Topics
...audience for this course includes, System Administrators, Database Administrators, Help Desk/Support, Application Developers, System Analysts and Software Engineers. Learners are expected to have an understanding of basic Internet and Website concepts. In addition, students should have taken the first part of this series (86041). Content Emphasis Skills-Based Deployment Options more...HTML 4 Part 2 Advanced Topics
...audience for this course includes, System Administrators, Database Administrators, Help Desk/Support, Application Developers, System Analysts and Software Engineers. Learners are expected to have an understanding of basic Internet and Website concepts. In addition, students should have taken the first part of this series (86041). Content Emphasis Skills-Based Deployment Options more...HTML 4 Part 1 HTML Fundamentals
...audience for this course includes, System Administrators, Database Administrators, Help Desk/Support, Application Developers, System Analysts and Software Engineers. Learners are expected to have an understanding of basic Internet and Website concepts. Content Emphasis Skills-Based Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American more...HTML 4 Part 1 HTML Fundamentals
...audience for this course includes, System Administrators, Database Administrators, Help Desk/Support, Application Developers, System Analysts and Software Engineers. Learners are expected to have an understanding of basic Internet and Website concepts. Content Emphasis Skills-Based Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American more...Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention
... Audience The intended audience for this course includes database administrators and application developers, regardless of role or experience level. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian Portuguese, Spanish Total Learning Time 6 to 8 hours 64333 Objectives more...Oracle9i Peformance Tuning Managing Memory and Disk I O
... Audience The intended audience for this course includes Database Administrators, Technical Support Professionals, and System Administrators. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Portuguese, Spanish Total Learning Time 6 to 8 hours 64332 Objectives Unit 1: SQL more...Oracle9i Performance Tuning Architecture Strategy
.... Audience This intended audience for this course are Database Administrators. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian Portuguese, Spanish Total Learning Time 6 to 8 hours 64331 Objectives Unit 1: Tuning the Oracle9i Server: Overview 1 - 2 hours o Match more...Oracle9i Database Admin Set Up Oracle Net Services
... Audience The intended audience for this course are Database administrators. Required prerequisites are Oracle SQL, Oracle PL/SQL. Suggested prerequisites include Oracle9i Database Administration: Manage an Instance (64311), and Oracle9i Database Administration: Create a Database (64312). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE more...Oracle9i Database Admin Recover Databases
... Audience The intended audience for this course include Database Administrators, IT managers, and technical professionals. There are no required prerequisites. Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 64322 Objectives Unit 1: Oracle Recovery 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...Oracle9i Database Admin Manage Security
... Audience The intended audience for this course include Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Additionally, learners should have taken the first four parts of this series (64311-64314). Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: more...Oracle9i Database Admin Manage Data Storage
... Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first three parts of this series 64311-64313. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML more...Oracle9i Database Admin Manage Storage Structures
... Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first two parts of this series 64311 and 64312. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: more...Oracle9i Database Admin Create a Database
Course Overview The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to more...Oracle9i Database Admin Manage an Instance
... Audience The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, more...Oracle9i SQL DML and DDL
...y. Audience The intended audience for this course are Database Administrators. Required prerequisite knowledge includes Oracle9i SQL: Basic SELECT Statements 61130 and Oracle9i SQL: Data Retrieval Techniques 61131. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian more...Oracle9i SQL Data Retrieval Techniques
...substitution variable. Audience The audience includes database administrators, designers, developers, technical support professionals, and application developers. This course will help students prepare for the Oracle9i DBA certification, and is mapped to Exam 1Z0-007. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits more...Oracle9i SQL Basic SELECT Statements
... Audience The target audience for this course includes database administrators and application developers. This course will help students prepare for the Oracle9i DBA certification, and is mapped to Exam 1Z0-007. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Brazilian Portuguese, more...BizTalk Server 2000 Part 5 Secruity Optimization
...e The audience for this course includes Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers who operate in medium to very large computing environments that use Microsoft BizTalk Server 2000. Learners should have a minimum of one year's experience designing and developing distributed applications by using Microsoft technologies. Prerequisites more...BizTalk Server 2000 Part 4 Components Solutions Troubleshooting
...e The audience for this course includes Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers who operate in medium to very large computing environments that use Microsoft BizTalk Server 2000. Learners should have a minimum of one year's experience designing and developing distributed applications by using Microsoft technologies. Prerequisites more...BizTalk Server 2000 Part 3 Monitoring Orchestration
...ence for this course would include System Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers. Prerequisite knowledge would include expertise with XML, and experience with XSLT recommended. Working knowledge of COM+, including development tools such as Microsoft Visual Basic and Microsoft Visual C++, and a working knowledge of Microsoft more...BizTalk Server 2000 Part 2 Documents Mapping Managing Submitting
... audience for this course includes System Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers. Prerequisites include experience with XML and it is recommended that learners have experience with XSLT. Learners should also have a working knowledge of COM+, including development tools such as Microsoft Visual Basic and Microsoft Visual C++, and a more...BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000
... audience for this course includes System Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers who operate in medium to very large computing environments that use Microsoft BizTalk Server 2000. Learners should have a minimum of one year's experience designing and developing distributed applications by using Microsoft technologies. Prerequisites more...BizTalk Server 2000 Curriculum
...ience for this curriculum includes System Administrators, Database Administrators, Application Developers, System Analysts, and Network Designers who operate in medium to very large computing environments that use Microsoft BizTalk Server 2000. Learners should have a minimum of one year's experience designing and developing distributed applications by using Microsoft technologies. Prerequisites more...IBM DB2 Univ Database V7 1 Transition Part 2 Business Intelligence
Course Overview This is the second course in a two part series that students will be introduced to the concept of business intelligence. This course also covers administrative enhancements, and it discusses DB2 family enhancements. Learn To Identify the components of the data warehousing process. Identify the enhancements in Business Intelligence (BI) products available for DB2 version more...IBM DB2 Univ Database V7 1 Transition Part 2 Business Intelligence
Course Overview This is the second course in a two part series that students will be introduced to the concept of business intelligence. This course also covers administrative enhancements, and it discusses DB2 family enhancements. Learn To Identify the components of the data warehousing process. Identify the enhancements in Business Intelligence (BI) products available for DB2 version more...IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies
Course Overview This is the first course in a two part series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify more...IBM DB2 Univ Database V7 1 Transition Part 1 Core Competencies
Course Overview This is the first course in a two part series that students will learn about OLAP functionality, SQL and AD Enhancements. Additionally, this course covers Federated Databases and Extenders and what has been added in these areas. Learn To Identify the enhancements that emerged with each version of DB2. Identify the six main product editions of the DB2 family. Identify 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 Database Admin Part 5 Maint SQL Server 2000
Course Overview This is the last course in a five part series that deals with managing, monitoring, and troubleshooting SQL Server 2000. Learn To Identify guidelines for configuring SQL Server Agent. Identify guidelines for using SQLAgentMail and SQL Mail. Configure a Microsoft Outlook Exchange profile for your administrative account. Identify the goals of SQL Server 2000 monitoring. more...SQL Server 2000 Database Admin Part 4 Managing Data
Course Overview This course deals with transferring data, managing replication services, and maintaining high availability. Learn To Identify guidelines for importing and exporting data. Match SQL Server 2000 tools used to import and export data with their functions. Identify the features and functions of the Data Transformation Services (DTS) process. Identify the features of more...SQL Server 2000 Database Admin Part 3 Security Data Recovery
Course Overview This is the third course in a five part series that deals with the backup and restore strategies for SQL Server 2000 and with managing security and permissions with SQL Server 2000. Learn To Identify how login accounts are processed. Identify the characteristics of the two authentication modes. Sequence the steps to implement an authentication mode. Identify the more...SQL Server 2000 Database Admin Part 2 Manag Databases
Course Overview This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects. Learn To Identify the database option categories. Identify features of the tools used to view database properties. View database more...SQL Server 2000 Database Admin Part 1 Install SQL Server 2000
This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000. Learn To Identify the features and functions of SQL Server. Identify the components involved in the client-server communication process. Identify the steps in the client-server communication process. Identify the minimum 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--Fundamentals
...database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: more...IBM DB2 Universal Database V6 1--Fundamentals
...database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases. L earn To: 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...Oracle PL SQL Database Programming
... Skills-Based A udience Application Developers, Database Administrators, and Technical Support Professionals. Prior to taking this course, students should have knowledge equivalent to the computer based training (CBT) courses entitled: Oracle SQL and SQL *Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL *Plus: DML and DDL (course 61112), Oracle PL/SQL: Basics (course more... | ||||||||||
