Custom Search
Home > Training Search > S > Sql Server Data > Online eLearning

Online Sql Server Data eLearning - Training Resources

Sql Server Data Training Provider? - Tell us about your Training!
on-line e-learning cbt (computer based)
online course
 instructor led training
instructor-led class
 study at home
learn at home
 group study and discussion
group study
 self directed
self-directed study
 cd rom
cd-based training
 DVD
DVD video training
 book
printed book
 e-book
e-book digital book
 workshop / seminar
workshop seminar
 train the trainer
train the trainer
 computer lab
computer-based learning
 special pricing!
discount pricing
 on-line tutorial)
online tutorial
Sql Server Data Training Seminars and Classes
From Online Training Directory
SQL Server 2000 Complete Course on-line e-learning cbt (computer based) This course is a complete set of SQL Server 2000 Administration, SQL Server 2000 Desing and Implementation, Datawarehousing and XML Enabled Applications using SQL 2000. This course teaches you to administer and troubleshoot information systems that incorporate the SQL Server 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, plan, design, and create SQL 2000 databases,  more...
From 123-CBT Computer Based Training
Database Deployment and Data Distribution on-line e-learning cbt (computer based) recognize how to design, deploy and utilize database deployment and database distribution solutions  more...
Designing Access to SQL Server Data on-line e-learning cbt (computer based) recognize how to design and utilize data access technologies to manage SQL Server and access SQL Server Data  more...
Designing Efficient Application Access on-line e-learning cbt (computer based) recognize how to efficiently utilize client libraries for database access using automation management objects, server Network Interface and MARS for queries and row management  more...
Designing Queries in SQL 2005 on-line e-learning cbt (computer based) recognize how to design and execute queries in SQL Server 2005, utilizing XQuery and the XML Data Modification Language  more...
Designing a SQL Server 2005 Cursor Strategy on-line e-learning cbt (computer based) recognize how to design and implement an appropriate cursor strategy in SQL Server 2005  more...
Designing a SQL Server 2005 Transaction Strategy on-line e-learning cbt (computer based) recognize the different levels of isolation and granularity to manage concurrency and execute a transaction strategy in SQL Server 2005  more...
SQL Server 2005 Error Handling Techniques on-line e-learning cbt (computer based) recognize how to design code for validating input, for error handling and for user-defined messages in SQL Server 2005  more...
Optimizing Query Performance and Index Strategies on-line e-learning cbt (computer based) recognize how to optimize query performance and indexing strategies in SQL Server 2005  more...
Optimizing Storage in SQL Server 2005 on-line e-learning cbt (computer based) recognize how to optimize database storage and SQL Server performance  more...
Scaling Applications and Resolving Performance Issues on-line e-learning cbt (computer based) recognize how to scale out applications to enterprise level and troubleshoot and identify performance issues that result  more...
Designing a Database Server Data Recovery Solution for SQL Server 2005 on-line e-learning cbt (computer based) To select the appropriate data backup and recovery solution for a SQL Server 2005 database  more...
Optimizing a Database Data Recovery Plan for SQL Server 2005 on-line e-learning cbt (computer based) To identify potential causes of database failure, and select the appropriate fault tolerance and restore strategies for a scenario  more...
Managing Database Data in a SQL Server 2005 Environment on-line e-learning cbt (computer based) To recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database  more...
Managing Data Between Servers and Databases on-line e-learning cbt (computer based) To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005  more...
Programming with SQL Server 2005 on-line e-learning cbt (computer based) recognize how to implement SQL Server 2005 programming features to work with database data  more...
Using XML on-line e-learning cbt (computer based) recognize how to use, implement, retrieve and manipulate XML data in SQL Server 2005 using XQuery language  more...
CLR Integration on-line e-learning cbt (computer based) recognize how to use CLR integration in SQL Server 2005 to create, implement and work with data, and how to execute .NET assemblies to achieve this  more...
Developing Applications that Use SQL Server Business Intelligence Services on-line e-learning cbt (computer based) recognize how to implement Reporting Services to generate reports and Integration Services to manipulate data according to your requirements  more...
Using PL SQL with an Oracle Server on-line e-learning cbt (computer based) To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block  more...
Transferring and Transforming Data in SQL Server 2000 on-line e-learning cbt (computer based) To enable students to extract and transform data in SQL Server 2000  more...
The SQL Server 2000 Logical Data Model on-line e-learning cbt (computer based) To describe SQL Server data entities and their normalization  more...
Using T-SQL in SQL Server 2000 on-line e-learning cbt (computer based) To discuss Transact-SQL and its elements and view and define data using Transact-SQL statements  more...
SQL Server 2000 Transactions and Distributed Data on-line e-learning cbt (computer based) To demonstrate how to utilize transactions and distributed data  more...
Retrieving Data and Running Queries in SQL Server 2005 on-line e-learning cbt (computer based) To perform relational data and XML data management tasks, and work with assemblies and transactions in SQL Server 2005  more...
SQL Server 2005 High Availability and Disaster Recovery on-line e-learning cbt (computer based) To implement database mirroring, log shipping, database snapshots, and data replication in SQL Server 2005  more...
Transferring and Transforming Data in SQL Server 2000 on-line e-learning cbt (computer based) To enable students to extract and transform data in SQL Server 2000  more...
Oracle9i Database Admin Perform Database Backups on-line e-learning cbt (computer based)cd rom Course Overview This course introduces students to backup methods for Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as RMAN, standard  more...
Oracle9i SQL DML and DDL on-line e-learning cbt (computer based)cd rom The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.  more...
Oracle9i SQL Basic SELECT Statements on-line e-learning cbt (computer based)cd rom This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o Identify the components of the relational  more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data on-line e-learning cbt (computer based)cd rom 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 Curriculum on-line e-learning cbt (computer based)cd rom The MS SQL Server 2000 Querying with Transact SQL Curriculum includes the following courses: MS SQL Server 2000: Querying with Transact SQL Part 1(Manipulating Data) MS SQL Server 2000: Querying with Transact SQL Part 2(Working with Queries) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks on-line e-learning cbt (computer based)cd rom This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify  more...
SQL Server 2000 Design Implement Databases Part 3 Managing Objects on-line e-learning cbt (computer based)cd rom ...ive 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 user-defined functions with their characteristics.  more...
SQL Server 2000 Design Implement Databases Part 2 Managing Data on-line e-learning cbt (computer based)cd rom ...ive 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 modeling. Identify the login authentication modes  more...
SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server on-line e-learning cbt (computer based)cd rom ...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 the features and functions of SQL Server 2000 services. Match the basic types of statements used in Transact-SQL with their functions. Match Data  more...
SQL Server 2000 Designing Implementing Databases Curriculum on-line e-learning cbt (computer based)cd rom The MS SQL Server 2000 Designing & Implementing Database Curriculum includes the following courses: MS SQL Server 2000: Design & Implement Databases Part 1(Intro. to SQL Server) MS SQL Server 2000: Design & Implement Databases Part 2 (Managing Data) MS SQL Server 2000: Design & Implement Databases Part 3(Managing Objects) MS SQL Server 2000: Design & Implement Databases Part 4(Managing  more...
SQL Server 2000 Database Admin Part 4 Managing Data on-line e-learning cbt (computer based)cd rom 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 on-line e-learning cbt (computer based)cd rom 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 on-line e-learning cbt (computer based)cd rom 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 Administration Curriculum on-line e-learning cbt (computer based)cd rom The MS SQL Server 2000 Database Administration Curriculum includes the following courses: MS SQL Server 2000: Database Admin. Part 1(Install. SQL Server 2000) MS SQL Server 2000: Database Admin. Part 2(Managing Databases) MS SQL Server 2000: Database Admin. Part 3(Security & Data Recovery) MS SQL Server 2000: Database Admin. Part 4(Managing Data) MS SQL Server 2000: Database Admin. Part  more...
IBM DB2 Universal Database V6 1--Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview 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  more...
IBM DB2 Universal Database V6 1--Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview 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  more...
Oracle PL SQL Database Programming on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored  more...
Oracle8i Performance Tuning Managing Memory Disk I O on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...
Oracle8i Performance Tuning Architecture Strategy on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,  more...
Oracle8i Database Admin Manage Storage Structures on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify  more...
Oracle8i Database Admin Manage an Instance on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...
Oracle Reports R6 Control Reports on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and  more...
Oracle Form Builder R6 Including Reusable Oracle Components on-line e-learning cbt (computer based)cd rom Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to  more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student  more...
Oracle8 Performance Tuning Managing Memory and Disk I O on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery on-line e-learning cbt (computer based)cd rom Course Overview This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to  more...
Oracle8 Backup and Recovery - Strategies and Backups on-line e-learning cbt (computer based)cd rom Course Overview This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course, users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally, users will  more...
Oracle8 Database Administration - Manage Security on-line e-learning cbt (computer based)cd rom Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and  more...
Oracle8 Database Administration - Manage Data on-line e-learning cbt (computer based)cd rom Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...
Oracle8 Database Administration - Manage Storage Structures on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify  more...
Oracle Form Builder Including Reusable Oracle Components on-line e-learning cbt (computer based)cd rom Course Overview This course is the sixth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn how to implement methods to use data sources, and to integrate charts, reports and timers in Forms. In addition, reusing components, objects and code will be taught. Finally, Form Builder's new features will be covered. L  more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5 on-line e-learning cbt (computer based)cd rom Course Overview This is the final course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft  more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 on-line e-learning cbt (computer based)cd rom Course Overview This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data  more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3 on-line e-learning cbt (computer based)cd rom Course Overview This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise  more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2 on-line e-learning cbt (computer based)cd rom Course Overview This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models;  more...
SQL Server 7 0 Designing Implementing Data Warehouses Curriculum on-line e-learning cbt (computer based)cd rom The Designing and Implementing Data Warehouses Using Microsoft SQL Server 7.0 Curriculum consists of the following courses: MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1 MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2 MS SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3 MS SQL Server 7.0: Designing and Implementing Data  more...
SQL Server 7 0 Designing Implementing Data Warehouses - Part 1 on-line e-learning cbt (computer based)cd rom Course Overview This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing;  more...
Visual C 6 0 Designing Implementing Distributed Applications - Part 3 on-line e-learning cbt (computer based)cd rom Course Overview This is the final course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Create a database, maintain data integrity and import data. Write SQL statements to access data from tables and manipulate the  more...
Visual Basic 6 0 Designing Implementing Distributed Applications - Part 3 on-line e-learning cbt (computer based)cd rom ...dd Data Environment command. Establish a connection to a SQL Server database using the Data Link Properties dialog box. Display the structure of a SQL Server database. Create a SQL Stored Procedure. Display the T-SQL Debugger for debugging a SQL Stored Procedure. Identify the use of delimiter commands in SQL Transactions. Unit 2: Accessing Data from the Middle Tier Duration: 3 - 4  more...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 on-line e-learning cbt (computer based)cd rom Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential  more...
Visual InterDev 6 0 Accessing Remote Data on-line e-learning cbt (computer based)cd rom C ourse Overview This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of  more...
Visual InterDev 6 0 Accessing Remote Data on-line e-learning cbt (computer based)cd rom Course Overview This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of Remote  more...
Visual InterDev 6 0 Active Server Pages and Data Access on-line e-learning cbt (computer based)cd rom ...d in the login authentication process for connecting to a SQL Server database. Add the connection information for connecting to a SQL Server database. Add a data connection to a project. Identify the features of a data command. Match the Query Designer panes with their functions. Add a data command to the data environment. Identify the data display and data manipulation controls.  more...
Introduction to Data Warehousing on-line e-learning cbt (computer based)cd rom Course Overview This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing, this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally, you'll learn about the Oracle data warehouse. L earn To: Identify the basic  more...
Oracle SQL Specifics Retrieving and Formatting Data on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will  more...
Oracle SQL Tuning Tuning SQL and the Optimizer on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a two-part series on SQL Statement Tuning. This course will help application developers to design SQL statements that can reuse parsing and influence the optimizer to improve performance. L earn To: Identify the factors that affect network traffic. Identify the factors that affect parsing. Identify the guidelines for the reuse of  more...
SQL Server 7 0 System Administration - Part 5 on-line e-learning cbt (computer based)cd rom Course Overview This is the final course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the methods and attributes of SQL Server 7.0 replication. Identify and apply techniques for planning and setting up SQL Server 7.0 replication. Identify the procedures for  more...
SQL Server 7 0 - Implementing a Database - Part 1 on-line e-learning cbt (computer based)cd rom ...s. Sequence the steps for validating permissions. Match SQL Server databases with their descriptions. Match the database components with their descriptions. Select the characteristics of SQL Server objects. Match commonly used system tables with their functions. Identify methods for retrieving metadata from system tables. Sequence the steps for implementing a SQL Server database.  more...
SQL Server 7 0 - Implementing a Database - Part 2 on-line e-learning cbt (computer based)cd rom Course Overview This is the second course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Implement data integrity. Create and maintain indexes. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database  more...
SQL Server 7 0 System Administration - Part 1 on-line e-learning cbt (computer based)cd rom ...ware applications. Sequence the steps for implementing a SQL Server database. Sequence the steps to administer a SQL Server database. Match each application deployment option with its description. Unit 2: Installing and Configuring SQL Server Duration: 2 - 3 Hour(s) Identify the hardware and software installation requirements for installing SQL Server 7.0. Perform a typical SQL  more...
SQL Server 7 0 System Administration - Part 2 on-line e-learning cbt (computer based)cd rom ...rity, and database structure. Understand the basics of SQL Server databases and how to create databases and other objects. Modify databases; manage data on multiple disks; assess database size requirements and to plan for growth. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for installing, configuring, administering and  more...
SQL Server 7 0 System Administration - Part 3 on-line e-learning cbt (computer based)cd rom Course Overview This is the third course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the concepts, interfaces and fixed roles involved in performing backups. Gain a working knowledge of database, transaction log and filegroup backups and perform these backups as  more...
SQL Server 7 0 System Administration - Part 4 on-line e-learning cbt (computer based)cd rom Course Overview This is the fourth course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Automate SQL Server 7.0 administrative tasks. Identify and use the SQL Server 7.0 tools for transferring and transforming data. Identify and use the tools for monitoring and  more...
SQL Server 7 0 - Implementing a Database - Part 3 on-line e-learning cbt (computer based)cd rom Course Overview This is the third course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Query multiple tables using Transact-SQL statements. Retrieve and modify data using advanced query techniques. C ontent Emphasis Skills-Based A udience This course is designed for IT  more...
SQL Server 7 0 - Implementing a Database - Part 4 on-line e-learning cbt (computer based)cd rom Course Overview This is the fourth course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Generate summary value and summary data as well as generate control break reports using aggregate functions. Define transactions and set transaction isolation levels. Identify the purpose and  more...
SQL Server 7 0 - Implementing a Database - Part 5 on-line e-learning cbt (computer based)cd rom Course Overview This is the final course in a five part series that will provide students with the knowledge to implement a database solution with Microsoft SQL Server 7.0. L earn To: Access data by using the Stored Procedure model. Access data using triggers. Set up a distributed environment to access, modify and manage remote data. C ontent Emphasis Skills-Based A  more...
SQL and PL SQL PL SQL Basics on-line e-learning cbt (computer based)cd rom Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.  more...
SQL and PL SQL Basic SELECT on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic  more...
Oracle Database 10g Administration Workshop II Part 1 on-line e-learning cbt (computer based)cd rom This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Students will also practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Learn To: Match goals of Oracle Database 10g manageability features with the methods of achieving them. Identify features of the Oracle Database  more...
Oracle Database 10g New Features for Administrators Part 2 on-line e-learning cbt (computer based)cd rom Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring. Learn To: Identify features of Automatic Database Diagnostic Monitor  more...
Oracle Database 10g New Features for Administrators Part 4 on-line e-learning cbt (computer based)cd rom Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as flash backup and recovery. Learn To: Identify features of the flash backup and recovery strategy. Identify tasks that you perform when using the flash recovery  more...
Oracle Database 10g New Features for Administrators Part 5 on-line e-learning cbt (computer based)cd rom Oracle Database 10g is designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. Oracle Database 10g supports the Oracle vision of creating a self-aware, self-learning, and completely self-managing database. This course covers new features of Oracle Database 10g such as automatic storage management, upgrade methods, RMAN backup, flash  more...
IBM DB2 Universal Database V6 1--Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview 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  more...
IBM DB2 Universal Database V6 1--Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview 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  more...
Oracle SQL for End Users--Part 1 on-line e-learning cbt (computer based)cd rom Course Overview Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the  more...
Office XP - Planning Collaborative Solutions Curriculum on-line e-learning cbt (computer based)cd rom The Microsoft Office XP - Planning Collaborative Solutions Curriculum presents the learner with a comprehensive introduction to SharePoint Team Services and the principal technologies within Office XP that facilitate sharing of line-of-business data. The curriculum begins with an introduction to SharePoint Team Services and Team Services site architecture. It covers administrative issues and user  more...
Office XP Collaborative Solutions Part 1 on-line e-learning cbt (computer based)cd rom This is the first course in a two part series that presents the learner with a comprehensive introduction to SharePoint Team Services and the principal technologies within Office XP that facilitate sharing of line-of-business data. The course begins with an introduction to SharePoint Team Services and Team Services site architecture. It covers administrative issues and user roles, and then moves  more...
Office XP Collaborative Solutions Part 2 on-line e-learning cbt (computer based)cd rom This is the second course in a two-part series that provides the learner with an introduction to Knowledge Management, and how SharePoint Portal Server facilitates this. Topics include, portal server's difference from team services, principal areas of data sharing within SharePoint Portal Server, data access and search mechanisms. Digital dashboards are covered in considerable detail of setup,  more...
Oracle 9i New Features Database Administration on-line e-learning cbt (computer based)cd rom This course introduces learners to the Oracle9i enhancements in server-side manageability, Oracle Enterprise Manager, and globalization. Learn To Identify memory and space management improvements. Describe segment and index management improvements. Identify improvements in database operations and performance.  more...
Commerce Server 2000 Design Implementation Curriculum on-line e-learning cbt (computer based)cd rom The Commerce Server 2002 provides users with the skills necessary for user profiling, catalog management and advanced online business analytics including installation, administration tools, site packaging, and Commerce Server Manager. This curriculum consists of five Skill Builder courses. Course 74116 MS Commerce Server 2000: Design and Imp. Part 1 - Intro, 74117 MS Commerce Server 2000: Design  more...
Commerce Server 2000 Design Impl Part 1 Intro on-line e-learning cbt (computer based)cd rom This is the first course in a five part series that covers Commerce Server 2000, focusing on business, functional, and integration requirements that need to be considered in preparation for its deployment. The course then covers Business to Consumer Web sites and fundamental elements of Commerce Server 2000, including installation, administration tools, site packaging, and Commerce Server Manager.  more...
Commerce Server 2000 Design Impl Part 2 Users Objects Catalogs on-line e-learning cbt (computer based)cd rom This is the second course in a five part series that covers the importance of user authentication and how to set up identification, authentication, and profiling systems for anonymous and registered users. The course also focuses on catalogs in a Commerce Server Web site, the tools used to create one, and the skills required to build Web pages to browse and search catalogs. Learn To: o  more...
Commerce Server 2000 Design Impl Part 3 Pipelines on-line e-learning cbt (computer based)cd rom This is the third course in a five part series that focuses on pipelines and their use in running ad campaigns. It covers how to define and run a pipeline in Microsoft Commerce Server 2000, and how to create custom components - Scriptor and Compiled - that can be added to a pipeline. The course also covers the code used to implement campaigns built and designed by Commerce Server 2000. Learn To:  more...
Visual Basic NET-Web Based Development Part 3 on-line e-learning cbt (computer based)cd rom Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security  more...
Visual Basic NET-Web Based Development Part 3 on-line e-learning cbt (computer based)cd rom Assuming that the learner is now familiar with the basics of Web forms and controls, this course introduces ADO .NET and guides the learner through database connections and data access. Learn To: o To identify features of ADO.NET. o To ientify the syntax for importing ADO.NET namespaces. o To ientify features of the ADO.NET object model. o To identify features of SQL Server security  more...
CIW Dynamic Server Pages Part 1 on-line e-learning cbt (computer based)cd rom Course Overview This is the first course in a three part series that introduces students to PHP Hypertext Processor and provides the foundational knowledge for the course series. Additionally, this course will cover an introduction to PHP, PHP fundamentals, string manipulation and file input/output, and PHP and databases. Learn To • Identify PHP. • Identify the basic and  more...
CIW Dynamic Server Pages Part 3 on-line e-learning cbt (computer based)cd rom Course Overview This is the final course in a three part series that students will learn about ActiveX Data Objects, error handling and dubugging ASP applications, project management in application development, and data integrity and security issues. Learn To • Identify the situations in which ADO would be used. • Identify ASP application development, error handling, and  more...
Commerce Server 2000 Design Impl Part 4 Ad Campaigns Websites on-line e-learning cbt (computer based)cd rom This is the fourth course in a five part series that teaches how to build ad, discount, and direct mail campaigns. It provides basic coverage of what packaging is, how it works, and when and why the learner will want to package their Commerce Server Web sites. Topics that teach how to manage user accounts and managing orders are also covered. Learn To: o Identify features of Commerce Server  more...
Commerce Server 2000 Design Impl Part 5 Infra Sec Admin on-line e-learning cbt (computer based)cd rom ...o Create a new SQL Server login account. o Create a new SQL Server data source to store user profile information. o Identify guidelines for monitoring performance. o Identify functions of SQL Profiler. o Start the Predictor resource by using Commerce Server Manager. Audience The intended audience for this course includes Professional Web Developers. These developers will have  more...
Microsoft NET Tech Overview Part 1 NET Platform Framework on-line e-learning cbt (computer based)cd rom This course gives an introduction and basic explanation of the Microsoft .NET Platform and its components, including the .NET Enterprise Servers (BizTalk Server, Application Center, Host Integration Center, Mobile Information Center Internet Security and Acceleration Server and SQL Server) as well as development tools and technologies (XML, ASP.NET, Visual Studio.NET, and SOAP). Other areas such  more...
From Serebra Learning Corporation
Visual Basic 6 0 Database Access Part I on-line e-learning cbt (computer based) This course provides an introduction to Visual Basic's capabilities relating to database access and manipulation in an online environment. It explains how databases are organized, how information is retrieved and manipulated in databases, and what technologies are available to ensure cross-platform and uniform access to database information. This course describes the fundamentals of viewing  more...
Transferring and Transforming Data in SQL Server 2000 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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...
Visual Basic 6 0 Advanced Enterprise Client Server Dev Part I on-line e-learning cbt (computer based) This course discusses database security implementations to aid a developer in correctly programming components that access data without compromising security. The different security modes available to Microsoft SQL Server 7.0 and previous versions of SQL Server are explained, as well as their respective advantages. It also explains creating Windows NT accounts and user groups. This course  more...
Data Integration with C 2005 and ASP NET 2 0 on-line e-learning cbt (computer based) To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, C# 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam  more...
Data Integration with Visual Basic 2005 and ASP NET 2 0 on-line e-learning cbt (computer based) To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, Visual Basic 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam  more...
XML Data Access in VB NET on-line e-learning cbt (computer based) To use the .NET Framework to manage XML data All Microsoft VB.NET developers wanting to write enterprise applications with serviced components, Windows Services, or .NET Remoting, or studying for the 70-310 exam Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework  more...
Small Business Server 2000 on-line e-learning cbt (computer based) To provide an overview of Microsoft Small Business Server (SBS) 2000 and its main features, such as its management consoles and monitoring tools, and to show how Microsoft Exchange 2000, ISA Server 2000, and Microsoft SQL Server 2000 integrate with SBS 2000 Network administrators for companies of up to 50 users; IT solutions companies that wish to deploy SBS 2000  more...
Troubleshooting and Disaster Recovery of SharePoint 2003 on-line e-learning cbt (computer based) To describe troubleshooting and the implementation of a disaster recovery strategy for SharePoint Portal Server 2003 Administrators who intend to deploy SharePoint Portal Server 2003 and SharePoint technologies; IT professionals who wish to gain knowledge of SharePoint products and technologies  more...
Project Server 2003 Planning Security Operations on-line e-learning cbt (computer based) To plan and implement the Project Server 2003 security structure and operations Systems administrators, systems engineers, systems analysts, IT consultants, and IT professionals with responsibility for planning and implementing Project Server 2003; learners preparing for MCSE certification exams  more...
Maintaining and Securing Data in SharePoint 2003 on-line e-learning cbt (computer based) To describe how to configure and maintain databases and implement security measures in SharePoint Portal Server 2003 Administrators who intend to deploy SharePoint Portal Server 2003 and SharePoint technologies; IT professionals who wish to gain knowledge of SharePoint products and technologies  more...
Cisco CallManager Fundamentals on-line e-learning cbt (computer based) To explain how to deploy a Cisco CallManager server in a cluster using a supported IP telephony deployment model IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)  more...
Fundamentals of Cisco CallManager on-line e-learning cbt (computer based) To deploy a Cisco CallManager server in a cluster using a supported IP Telephony deployment model. IT professionals responsible for installing, configuring, and maintaining the ongoing administration of a Cisco IP Telephony solution; candidates preparing for the Cisco IP Telephony exam (642-444 CIPT)  more...
Using PL SQL with an Oracle Server on-line e-learning cbt (computer based) 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...
Restoring SQL Server 2000 Databases on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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...
Advanced Database Features in Access 2002 on-line e-learning cbt (computer based) To demonstrate a range of advanced database features in Access 2002 Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level  more...
Microsoft Visual InterDev 6.0: Accessing Remote Data on-line e-learning cbt (computer based) This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to work with database records and identify the methods of managing recordset size; identify the components of Remote Data Services  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1 on-line e-learning cbt (computer based) This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2 on-line e-learning cbt (computer based) This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3 on-line e-learning cbt (computer based) This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4 on-line e-learning cbt (computer based) This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from  more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 5 on-line e-learning cbt (computer based) This is the final course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data  more...
SQL Server 7.0 Database Admin. Part I on-line e-learning cbt (computer based) This course builds upon previous courses by covering database management and provides a foundation for advanced courses on data warehousing client/server application development and SQL to IIS active server pages. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.  more...
MCSD Solutions Architecture IV on-line e-learning cbt (computer based) This course explains how to implement data services with SQL Server and how to create service components user interfaces and user services with Visual Basic 6.0.  more...
SQL Server 7.0 Introduction on-line e-learning cbt (computer based) ...efits of SQL Server 7.0 a major update to Microsoft's SQL Server database product. It describes the major differences between versions 6.5 and 7.0 and examines core components data warehousing application development tools and SQL management tools. This course provides an excellent foundation for advanced courses on upgrade and installation system management database administration data  more...
SQL Server 7.0 Management Part I on-line e-learning cbt (computer based) This course is designed to teach the skills necessary to take full advantage of SQL Server 7.0 features and enhancements used to manage data. SQL Server 7.0 contains two powerful tools for managing data: Transact-SQL at the command-line level and SQL Server Wizard features. This course presents a comprehensive view of the database development process by outlining the processes of creating the  more...
SQL Server 7.0 Data Warehousing SQL Part I on-line e-learning cbt (computer based) This course is designed to help students gain knowledge of the core components of data warehousing application development tools and SQL management tools. The course introduces basic concepts terminology for understanding SQL Server 7.0 relational databases Structured Query Language and new or improved features. It builds on this foundation to cover client/server web applications programming  more...
SQL Server 7.0 Data Warehousing Part II on-line e-learning cbt (computer based) This course is a multi-step process of collecting cleansing and storing data for use in analyses and reporting applicaitions and making information available to a wide audience of end-users. Using the Data Transformation Services Package Designer the student will be able to define steps workflow and transformations necessary to build a data warehouse.  more...
SQL Server 7.0 Developing SQL Client/Server Part I on-line e-learning cbt (computer based) This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server  more...
SQL Server 7.0 Developing SQL Client/Server Part II on-line e-learning cbt (computer based) This course is designed to present a comprehensive view of the client/server application. The course outlines the structure and elements of client/server architecture interfaces available strategies in accessing data from the client side through queries and tools available with SQL Server 7.0 to improve and enhance the query process. The student will learn to create a multi-tiered client/server  more...
SQL Server 7.0 Web Integration on-line e-learning cbt (computer based) This course introduces several new or enhanced technologies procedures and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web  more...
MS SQL Server 2000: Database Administration Part 3: Security and Data Recovery on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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.  more...
MS SQL Server 2000: Database Administration Part 4: Managing Data on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course deals with transferring data, managing replication services, and maintaining high availability.  more...
MS SQL Server 2000: Design and Implementation Part 2: Managing Data on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This is the second course in a five part series that will teach students how to work with SQL Server data.  more...
MS SQL Server 2000: Design and Implementation Part 3: Managing Objects on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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.  more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking.  more...
Microsoft Commerce Server 2000 Design and Implementation Part 5: Infrastructure, Security, & Admin. on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This is the final course in a five part series that covers designing a network infrastructure to support Commerce Server 2000, describing the infrastructure components including Web Farms, staging servers and development servers, and covering network performance improvement by using switches to connect servers. The course focuses on providing network security, including configuring firewalls and  more...
Oracle9i SQL: DML and DDL on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.  more...
Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.  more...
Microsoft SQL Server 2000 Querying with Transact-SQL Part 1: Manipulating Data on-line e-learning cbt (computer based) This course presents students with both theoretical and practical instruction in the subject of manipulating data with Transact-SQL.  more...
MS SQL Server 2000: Database Administration Part 3: Security and Data Recovery on-line e-learning cbt (computer based) 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.  more...
MS SQL Server 2000: Database Administration Part 4: Managing Data on-line e-learning cbt (computer based) This course deals with transferring data managing replication services and maintaining high availability.  more...
MS SQL Server 2000: Design and Implementation Part 2: Managing Data on-line e-learning cbt (computer based) This is the second course in a five part series that will teach students how to work with SQL Server data.  more...
MS SQL Server 2000: Design and Implementation Part 3: Managing Objects on-line e-learning cbt (computer based) 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.  more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks on-line e-learning cbt (computer based) This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data and how to transform data with DTS. Additionally users will learn how to manage distributed queries and linked servers create transactions manage locks and how to troubleshoot transactions and locking.  more...
Oracle SQL for End Users Part 1 on-line e-learning cbt (computer based) Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties introduces the Oracle server and indicates how SQL and SQL*Plus are used in the Oracle product  more...
Planning an SQL 7.0 Data Warehouse on-line e-learning cbt (computer based) The Planning an SQL 7.0 Data Warehouse course is the first course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides students with the preliminary knowledge for planning and implementing data warehouses using SQL Server  more...
Implementing an SQL 7.0 Data Warehouse on-line e-learning cbt (computer based) The Implementing an SQL 7.0 Data Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for  more...
Using SQL 7.0 OLAP Services on-line e-learning cbt (computer based) The Using SQL 7.0 OLAP Services course is the third course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) Services . It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP  more...
Optimizing a SQL 7.0 Data Warehouse on-line e-learning cbt (computer based) The Optimizing an SQL 7.0 Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the  more...
MS SQL Server 6.5: Design & Management on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: SQL Server implementor roles and responsibilities; data modeling and data definition concepts; database object creation, such as tables; and basic data retrieval, manipulation, and modification. This course, together with MS SQL Server 6.5 DB Design Il, prepares students for  more...
MS SQL Server 6.5: Advanced Retrieval Structures on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd In this course, students will learn to implement a database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server  more...
Managing MS SQL Server 7.0 on-line e-learning cbt (computer based) This course provides the student with ways to configure SQL Server and managing data in SQL Server. It also presents ways to manage various administrative tasks. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0.  more...
Managing MS SQL Server 7.0 Security on-line e-learning cbt (computer based) This course enables the student to plan a backup and restoration strategy for preventing data loss. It also provides the student with an introduction to SQL security concepts and the security accounts used by SQL Server. In addition, the course prepares the student to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-028).  more...
MS SQL Server 7.0 Basics on-line e-learning cbt (computer based) This course teaches the student the concept of database and tables in SQL Server 7.0. It also covers the tools used to maintain data integrity. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 7-029.  more...
Basic SQL Programming on-line e-learning cbt (computer based) This course introduces the student to the basics of T-SQL. It also covers the skills required to retrieve and modify data using T-SQL. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.  more...
Advanced SQL Programming on-line e-learning cbt (computer based) This course teaches the student how to create stored procedures, manage distributed data and transactions. The student will also learn the importance of locks and how to troubleshoot a deadlock. Finally the student will learn how to optimize the query execution plan developed by SQL Server. The Implementing SQL Server curriculum prepares the student for the Microsoft Exam 70-029.  more...
Planning an MS SQL Server 7.0 Data Warehouse on-line e-learning cbt (computer based) This course provides the student with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides the student with the preliminary knowledge for planning and implementing data warehouses using SQL Server 7.0 In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).  more...
Implementing an MS SQL Server 7.0 Data Warehouse on-line e-learning cbt (computer based) This course teaches the student how to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of crating files and filegroups and helps students to select an application programming interface for accessing a data source. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL  more...
Using MS SQL Server 7.0 OLAP Services on-line e-learning cbt (computer based) This course provides the student with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) services. It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP services. The students will be able to design and optimize an OLAP database. In addition, the course prepares students to take the  more...
Optimizing a MS SQL Server 7.0 Data Warehouse on-line e-learning cbt (computer based) This course helps the student to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).  more...
From Software Training Academy, Inc
Java Server Pages JSP instructor led trainingon-line e-learning cbt (computer based) This four-day course develops skills in JavaServer Pages, or JSP, which is the standard means of authoring dynamic content for Web applications under the Java Enterprise platform. It treats JSP 2.0, including older features such as scriptlets but focusing on newer features and techniques, including JSP expressions and the JSTL. At the end of the course, students will be well prepared to author  more...
SQL Server 2005 Reporting Services SSRS instructor led trainingon-line e-learning cbt (computer based) In this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in  more...
SQL Server 2005 Transact SQL T-SQL instructor led trainingon-line e-learning cbt (computer based) In this course, you ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers  more...
SQL Server 2005 Transact SQL T-SQL with Additional Topics instructor led trainingon-line e-learning cbt (computer based) In this course, you'll start by learning about the basic features that are available in SQL Server, including how to design and create a database and how to build queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You'll learn about the new enhancements to the  more...
SQL Server 2005 instructor led trainingon-line e-learning cbt (computer based) In this course, you ll learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming  more...
SQL Server 2005 Integration Services SSIS instructor led trainingon-line e-learning cbt (computer based) This course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development  more...
SQL Server 2005 - Additional Topics instructor led trainingon-line e-learning cbt (computer based) Developing a database, getting the database to work with your applications, and getting it to production is just the beginning, but can often be where the story ends. This course examines other SQL Server 2005 essential application, support, and maintenance topics features you can use for high-availability, stability, reliability, and scalability of databases, plus enhancements for processing  more...
SQL Server 2005 Analysis Services SSAS instructor led trainingon-line e-learning cbt (computer based) In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to  more...
Oracle 10g Administration instructor led trainingon-line e-learning cbt (computer based) Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data  more...
ADO NET for Windows Applications Using C instructor led trainingon-line e-learning cbt (computer based) This three-day intensive course teaches the essential elements of ADO. NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO. NET in a realistic setting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005.  more...
ADO NET for Web Applications Using C instructor led trainingon-line e-learning cbt (computer based) This three-day intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications for the Web. The course includes a major case study demonstrating the use of ADO.NET and ASP.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and  more...
ADO NET Using C instructor led trainingon-line e-learning cbt (computer based) This intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005. The course  more...
ADO NET Using VB NET instructor led trainingon-line e-learning cbt (computer based) This three-day intensive course teaches the essential elements of ADO.NET such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005. The  more...
From Binary Research International, Inc.
Implementing and Maintaining Microsoft SQL Server 2005 The training course consists of online, live instructor-led sessions and additional self-paced e-learning content, scenario-based labs, and assessments to provide Participants with the knowledge and skills to manage and maintain Microsoft SQL Server 2005. Topics include: SQL Server 2005 Architecture Preparing to Install SQL Server 2005 Installing SQL Server 2005 Installing and Configuring  more...
From Teach Me IT
Advanced PL/SQL Programming on-line e-learning cbt (computer based)study at home The Advanced PL/SQL Programming WBT is the third course in this curriculum. This course will enable users to create functions, packages, database objects, collections, and triggers. Additionally, it will enable users to create transactions, apply locks, and use dynamic SQL. After completing this course, the student will be able to: Create PL/SQL packages Manage PL/SQL packages Identify various  more...
Getting Started with SQL Server 2000 on-line e-learning cbt (computer based)study at home The Getting Started with SQL Server 2000 course is the first course in the SQL Server 2000 Database Implementation curriculum. This course introduces the features and components of SQL Server 2000. It describes the architecture of SQL Server 2000 and the various programming tools that are used to work with Transact SQL statements. It also teaches the various methods to create and manage databases  more...
Retrieving Data in SQL Server 2000 on-line e-learning cbt (computer based)study at home The Retrieving Data in SQL Server 2000 is the second course in the SQL Server 2000 curriculum. SQL Server 2000 curriculum prepares the students for the Microsoft Certification exam Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition (70-229). This course teaches how to insert data in a SQL Server table and use views to retrieve data. It also introduces users to  more...
Implementing SQL Server 7.0 on-line e-learning cbt (computer based)study at home The Implementing SQL Server 7.0 course is the first course in the Administering Microsoft SQL Server 7.0 curriculum consisting of four courses. This curriculum prepares students to take the Microsoft certification Administering Microsoft SQL Server 7.0 (70-028) exam. It provides students with an introduction to the core technologies, architecture, and various features of Microsoft SQL Server 7.0.  more...
Managing SQL Server 7.0 on-line e-learning cbt (computer based)study at home The Managing SQL Server 7.0 WBT is the second course in the Administering Microsoft SQL Server 7.0 curriculum. This curriculum prepares students to take the Microsoft certification Administering Microsoft SQL Server 7.0 (70-028) exam. It provides the students with ways to configure SQL Server and managing data in SQL Server. It also presents ways to manage various administrative tasks. After  more...
Managing SQL Server Security on-line e-learning cbt (computer based)study at home The Managing SQL Server Security course is the third course in the Administering Microsoft SQL Server 7.0 curriculum consisting of four courses. This curriculum prepares students to take the Microsoft certification Administering Microsoft SQL Server 7.0 (70-028) exam. It enables the students to plan a backup and restoration strategy for preventing data loss. It also provides students with an  more...
Planning an SQL 7.0 Data Warehouse on-line e-learning cbt (computer based)study at home The Planning an SQL 7.0 Data Warehouse course is the first course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data  more...
Implementing an SQL 7.0 Data Warehouse on-line e-learning cbt (computer based)study at home The Implementing an SQL 7.0 Data Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also  more...
Using SQL 7.0 OLAP Services on-line e-learning cbt (computer based)study at home The Using SQL 7.0 OLAP Services course is the third course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It provides students with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP)  more...
Optimizing an SQL 7.0 Data Warehouse on-line e-learning cbt (computer based)study at home The Optimizing an SQL 7.0 Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query  more...
SQL Server 7.0 - Basics on-line e-learning cbt (computer based)study at home SQL Server 7.0 - Basics presents the concept of database and tables in SQL Server 7.0. It also covers the tools used to maintain data integrity. This course is the first course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL  more...
SQL Server 7.0 - Basic Programming on-line e-learning cbt (computer based)study at home SQL Server 7.0 - Basic Programming course is the second course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL Server7.0 (70-029). This course introduces students to the basics of T-SQL. It also covers the skills required to  more...
Advanced SQL Programming on-line e-learning cbt (computer based)study at home This course is the third course of the three courses in the Implementing SQL Server curriculum. The Implementing SQL Server curriculum prepares the students for the Microsoft Certification exam Implementing and Designing Databases with Microsoft SQL Server7.0 (70-029). The title of this course is Advanced SQL Programming. This course teaches students how to create stored procedures, manage  more...
From Skillspride Online Training
Microsoft Windows NT 4 Networking Technologies on-line e-learning cbt (computer based) At the end of the Course readers will be able to understand the role of an NT Workstation and NT Server Administrator; formulate policies to restrict access to secure information and systems; formulate policies to properly manage backup of data; understand User Rights and their implications for security; understand Access Control Lists and how they can be used to restrict access to secure data and  more...
Microsoft Visual Basic 5.0 Client Server Development on-line e-learning cbt (computer based) This course teaches the skills required to develop client server applications using MS Visual Basic 5.0 Enterprise Edition. Readers will understand ODBC and OLE DB and the different methods available in VB 5.0 for accessing data. They will learn how to use DAO, RDO and ADO plus how to use objects in Visual Basic. Readers will create ActiveX Components and deploy them on a Network using DCOM.  more...
Microsoft SQL Server 2000; Introduction to Databases and Programming on-line e-learning cbt (computer based) This course introduces readers to the major topics of databases and programming using Microsoft SQL Server 2000. The reader will learn about system databases, tables, data definition, creating tables, retrieving data, modifying data, indices, data integrity, views, triggers, stored procedures, programmability, distributed data and distributed transactions. Throughout the course there are practical  more...
Microsoft SQL Server 2000 Administration on-line e-learning cbt (computer based) This intensive course will introduce readers to administration of Microsoft SQL Server 2000 databases. The general objective of the course is to install SQL Server, create databases, import data, set up security, automate jobs and alerts, set up replication and create a robust backup regime.  more...
Microsoft SQL Server 7.0 New Features on-line e-learning cbt (computer based) This intensive course introduces the new features of Microsoft SQL Server 7.0. It covers the issues involved in installing SQL Server 7.0 and upgrading from previous releases; focuses on the improved user interface and data management tools; discusses changes to the security model and application development platform; and summarizes the new design elements and architecture of SQL Server 7.0.  more...
From The Virtual Training Company
Macromedia Dreamweaver MX - Web Applications on-line e-learning cbt (computer based) This is the second course in a series of tutorials from the Virtual Training Company for Dreamweaver MX. It covers all that techniques required to construct a data driven web site. Author Mark Fletcher (a Certified Macromedia Professional and member of Team Macromedia) will teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a  more...
on-line e-learning cbt (computer based)
online course
 instructor led training
instructor-led class
 study at home
learn at home
 group study and discussion
group study
 self directed
self-directed study
 cd rom
cd-based training
 DVD
DVD video training
 book
printed book
 e-book
e-book digital book
 workshop / seminar
workshop seminar
 train the trainer
train the trainer
 computer lab
computer-based learning
 special pricing!
discount pricing
 on-line tutorial)
online tutorial
Home > Training Search > S > Sql Server Data > Online eLearning
Advertise With Us
Sell Sql Server Data training?
tcw11-gfc--11/29/09-20:13:12-(16542)[A]-[B]-[A]