Custom Search
Home > Training Search > U > Use Sql > Online eLearning

Online Use Sql eLearning - Training Resources

Use Sql 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
Use Sql Training Seminars and Classes
From Online Training Directory
Java 2 -- Advanced Enterprise Java on-line e-learning cbt (computer based) This course contains 3 units: Java Database Connectivity (JDBC), Java Native Interface, and The Debugger. Each unit covers detail the elements of Java necessary to implement these features and functions as you program in the Advanced Enterprise Java language. The first unit explains the concept of Java Database Connectivity (JDBC). It covers the features and functions of JDBC and the differences  more...
SQL Server 2000 - XML-Enabled Applications Using SQL 2000 on-line e-learning cbt (computer based) This course is designed to teach students the basics of SQL and XML in building and combining applications where database functions are required This course will give students a good understanding of how to use SQL 2000 in building and integrating applications that use or require a database and are enabled with XML. Course includes a primer for SQL and XML calls for SQL. Course also covers using  more...
Database Management on-line e-learning cbt (computer based) This course features coverage of the important aspects of the relational PC-based database model including coverage of SQL. A highly useful methodology for designing databases is presented and illustrated through a variety of examples. This course is designed for anyone interested in gaining familiarity with database management. Someone taking this course should have some experience using a  more...
Crystal Reports XI on-line e-learning cbt (computer based) Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Crystal Reports XI Receive a fundamental understanding of the concepts of Crystal Reports XI by learning to build reports, use formulas, build groups, work with records, and create charts. Follow Jason Manibog as he teaches you  more...
From 123-CBT Computer Based Training
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 Support Services on-line e-learning cbt (computer based) recognize how to develop and deploy SQL Service Support solutions with Notification Services and Service Broker  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...
Oracle Database 11g Getting Started with SQL and PL SQL New Features on-line e-learning cbt (computer based) To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies  more...
Introduction to Oracle and SQL in Oracle9i on-line e-learning cbt (computer based) To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements  more...
SQL Functions in Oracle9i on-line e-learning cbt (computer based) To describe how to use SQL functions for data retrieval  more...
Oracle Database 10g Database Interfaces Release 2 on-line e-learning cbt (computer based) To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces  more...
Oracle Database 10g The SQL Loader and PL SQL Release 2 on-line e-learning cbt (computer based) To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database  more...
Oracle Database 11g Change Management Overview and SQL Plan Management on-line e-learning cbt (computer based) outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.  more...
Oracle Database 11g Partitioning and Storage-Related Enhancements on-line e-learning cbt (computer based) identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.  more...
Oracle Database 11g Managing the Schema Data and Concurrency on-line e-learning cbt (computer based) Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency  more...
Introduction to Oracle and SQL in Oracle Database 10g on-line e-learning cbt (computer based) To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements  more...
SQL Functions in Oracle Database 10g on-line e-learning cbt (computer based) To describe how to use SQL functions for data retrieval  more...
Explicit Cursors and Exception Errors on-line e-learning cbt (computer based) 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  more...
Dynamic SQL and Metadata on-line e-learning cbt (computer based) To write dynamic SQL and use the DBMS_METADATA package  more...
SQL Server 2005 Messaging and Querying Tools on-line e-learning cbt (computer based) To implement Service Broker components and use full-text search in SQL Server 2005  more...
Oracle SQL PL SQL Using Procedure Builder Curriculum on-line e-learning cbt (computer based)cd rom The courses in this curriculum cover the concepts of relational databases and the SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum  more...
Oracle9i Peformance Tuning Managing Memory and Disk I O on-line e-learning cbt (computer based)cd rom This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the  more...
Oracle9i Database Admin Set Up Oracle Net Services on-line e-learning cbt (computer based)cd rom Course Overview This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server. Learn To •  more...
Oracle9i Database Admin 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 Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To • Define and maintain the five components of the security domain of a user in a given  more...
Oracle9i Database Admin Manage Data Storage on-line e-learning cbt (computer based)cd rom ...ts, identify the concepts associated with SQL*Loader, and use SQL*Loader to load data into tables. • Identify the uses of the export and import utilities, the export modes, and the export paths. • Reorganize data using export and import, identify the features and process of transportable tablespaces and the restrictions while using them. Audience The intended audience for  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 Data Retrieval Techniques on-line e-learning cbt (computer based)cd rom This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. Learn To: o Identify the four Oracle join types used to display data from more than one table. o  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...
BizTalk Server 2000 Part 5 Secruity Optimization on-line e-learning cbt (computer based)cd rom Course Overview This is the last course in a five part series that deals with the securing of the BizTalk Server 2000 environment and the configuring of servers and groups of servers and optimization of server group performance. This course covers the use of tools and utilities to monitor the status of the BizTalk Server 2000 environment. Learn To • Identify Microsoft Windows 2000 and  more...
BizTalk Server 2000 Part 4 Components Solutions Troubleshooting on-line e-learning cbt (computer based)cd rom Course Overview This is the fourth course in a five part series that presents the knowledge and skills necessary to create application integration components (AICs) for use with BizTalk Messaging Services. It also covers the deployment and management of an automated business process between trading partners using BizTalk Server 2000. In this respect, it presents a type of practical application  more...
BizTalk Server 2000 Part 3 Monitoring Orchestration 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 tracking of interchanges and business documents using BizTalk Document Tracking. It also covers the orchestration of the business process using BizTalk Orchestration Designer. The learner will review the core procedures necessary for using both these tools and has an opportunity to practice their use in the three  more...
BizTalk Server 2000 Part 1 Intro to BizTalk Server 2000 on-line e-learning cbt (computer based)cd rom Course Overview This is the first course in a five part series that introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. BizTalk is contextualized in terms of a solution to these various challenges. This course covers the BizTalk administration model and its tools and services. It also covers the installation requirements  more...
BizTalk Server 2000 Curriculum on-line e-learning cbt (computer based)cd rom Course Overview This curriculum introduces the learner to the context of BizTalk operations, identifying the main challenges of EAI and B2B communications. This curriculum covers creating maps using BizTalk Mapper, creating objects in and managing BizTalk Messaging Manager, and the submission of documents to BizTalk Server. Additionally, it covers the tracking of interchanges and business  more...
SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries on-line e-learning cbt (computer based)cd rom ...erate in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include: system administrators, database administrators, application developers, system analysts, and software engineers. Students are  more...
SQL Server 2000 Querying with Transact SQL Part 1 Manipulating Data on-line e-learning cbt (computer based)cd rom ...erate in medium to very large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. The general categories include: system administrators, database administrators, application developers, system analysts, and software engineers. Students are  more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks on-line e-learning cbt (computer based)cd rom ...29 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Learners are expected to have experience with using the Microsoft Windows 2000 operating system. Learners are also expected to have an understanding of basic relational database concepts and have knowledge of basic Transact-SQL syntax. In addition,  more...
SQL Server 2000 Design Implement Databases Part 4 Managing Indexes on-line e-learning cbt (computer based)cd rom ...29 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system, understand database concepts and Transact-SQL syntax. Students should also be familiar with the role of the database administrator. In addition,  more...
SQL Server 2000 Design Implement Databases Part 3 Managing Objects on-line e-learning cbt (computer based)cd rom ...29 operate in medium to large computing environments that use SQL Server 2000, Windows 2000 Active Directory, and Internet Information Server (IIS). Students are expected to have experience with using the Microsoft Windows 2000 operating system, understand database concepts and Transact-SQL syntax. Students should be familiar with the role of the database administrator. In addition, students  more...
SQL Server 2000 Design Implement Databases Part 2 Managing Data 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 work with SQL Server data. Learn To Identify the SQL Server 2000 system-supplied data types. Add a user defined data type. Match the parts of a data row with their features. Identify characteristics of entity modeling. Identify features of attributes. Identify requirements for logical  more...
SQL Server 2000 Design Implement Databases Part 1 Intro to SQL Server on-line e-learning cbt (computer based)cd rom Course Overview This is the first course in a five part series that presents students with both theoretical and practical instruction in the areas of an overview to SQL Server, the Transact-SQL language, and SQL Server Databases. Learn To Identify the features and functions of SQL Server 2000. Match the components of the client-server communication process with their features. Identify  more...
SQL Server 2000 Database Admin Part 4 Managing Data on-line e-learning cbt (computer based)cd rom ...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and  more...
SQL Server 2000 Database Admin Part 3 Security Data Recovery on-line e-learning cbt (computer based)cd rom ...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and  more...
SQL Server 2000 Database Admin Part 2 Manag Databases on-line e-learning cbt (computer based)cd rom ...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and  more...
SQL Server 2000 Database Admin Part 1 Install SQL Server 2000 on-line e-learning cbt (computer based)cd rom ...erate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and  more...
IBM DB2 Universal Database V6 1--App Development on-line e-learning cbt (computer based)cd rom ...amming, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application  more...
IBM DB2 Universal Database V6 1--App Development on-line e-learning cbt (computer based)cd rom ...amming, and dynamic SQL programming. L earn To: Use SQL functions in DB2 Applications. Use different application objects in DB2, such as schema, user-defined types, user-defined functions, and stored procedures. Use SQL within an application. Use dynamic SQL within an application. C ontent Emphasis Skills-Based A udience This course is intended for application  more...
IBM DB2 Universal Database V6 1--Administration on-line e-learning cbt (computer based)cd rom Course Overview 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. L earn To: Implement  more...
IBM DB2 Universal Database V6 1--Administration on-line e-learning cbt (computer based)cd rom Course Overview 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. L earn To: Implement  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...
Oracle PL SQL Procedures Functions Packages on-line e-learning cbt (computer based)cd rom 61114 Course Overview This course is the second in a series of three titles. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally, this course introduces the basics of creating and using packages. L earn To: Identify the types and components of a subprogram. Create a subprogram. Create  more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive 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.  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 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 Oracle8i. 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...
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 Database 10g Administration Workshop II Part 3 on-line e-learning cbt (computer based)cd rom This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption. Learn To: Identify features of Flashback  more...
Oracle Reports R6 Report Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Reports Release 6. This course introduces the learner to, the key features of Report Builder, steps involved in building a standard tabular report and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate  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...
Oracle Form Builder R6 Controlling the User Interface Programmatically on-line e-learning cbt (computer based)cd rom Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:  more...
Oracle Form Builder R6 Enhancing the User Interface on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes how to create input and non-input items, how to create lists of values (LOVs) and editors to support text items, and how to create forms using multiple windows and a variety of canvas styles. Additionally, this course covers ways to add functionality to  more...
Oracle Form Builder R6 Forms Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course introduces the learner to the key features, components, and capabilities of Oracle Developer. In addition, this course helps learners to run, create, and customize a form module. L earn To: Identify the key features, components and capabilities of  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 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...
Oracle8 Database Administration - Create Databases on-line e-learning cbt (computer based)cd rom Course Overview This course is the second 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 storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To:  more...
Oracle8 Database Administration - 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 Oracle8. 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 Report Builder Controlling Reports on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants learn how to develop report templates, code PL/SQL triggers in a report, and use Report Builder's built-in package. Finally, building reports for different environments will be covered. L earn To: Identify the regions of  more...
Oracle Report Builder Enhancing Reports on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the ways to enhance a report using the Data and Layout Model. In addition, this course will help participants learn how to modify layout objects and enhance matrix reports. L earn To: Enhance a report using the  more...
Oracle Report Builder Report Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features of Report Builder, building a standard tabular report, and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate report  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...
Oracle Form Builder Handling Multiple Object Relationships on-line e-learning cbt (computer based)cd rom Course Overview This course is the fifth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants to learn about Key triggers, write applications that respond to mouse events, manage windows and canvases, and use Object Navigator. In addition, users will work with multiple form applications, record groups, and list items. L  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...
Visual C 6 0 Designing Implementing Desktop Applications - Part 1 on-line e-learning cbt (computer based)cd rom Course Overview This is the first 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: Identify the features, tools, Wizards and resource editors of Visual C++ 6.0. Install and configure SQL Server and Microsoft  more...
Visual Basic 6 0 Designing Implementing Distributed 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 programmers with the basic skills to build three-tier client/server solutions. L earn To: Identify features of SQL Server and select the data integrity to implement in a given situation. Use the ActiveX Data Object (ADO) types for establishing a connection, executing a command, navigating recordsets,  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...
Oracle Database 10g SQL Fundamentals I Part 2 on-line e-learning cbt (computer based)cd rom In this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. . Learn To: Identify the  more...
Oracle Database 10g PL SQL Fundamentals Part 1 on-line e-learning cbt (computer based)cd rom In this course, the learner will get familiar with the procedural language to access Oracle database. The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as  more...
Oracle Database 10g SQL Fundamentals I Part 1 on-line e-learning cbt (computer based)cd rom In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features. Learn To: Match the different phases of system development life cycle (SDLC) with their features. Identify features of an Entity Relationship (ER)  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 Specifics Creating and Managing Database Objects on-line e-learning cbt (computer based)cd rom ...ontrol transactions. Control DBA and user access. Use SQL*Plus commands. C ontent Emphasis Skills-Based A udience Application Developers, System Analysts, Database Administrators, Technical Support Personnel. Prior knowledge of SQL and first course in this series, Oracle SQL Specifics: Retrieving and Formatting Data (Course 60116). T otal Learning Time 6 - 8  more...
Oracle SQL and SQL Plus Advanced SELECT Statements on-line e-learning cbt (computer based)cd rom Course Overview This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. L earn To: Write single-row  more...
Oracle SQL Tuning Diagnostics and Tuning Schema on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash  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 Course Overview This is the first 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: Identify the components of SQL Server 7.0. Identify the characteristics of Transact-SQL and its processing. Perform the skills to construct and manage databases. C ontent Emphasis  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 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 install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Work with Microsoft SQL Server is and Work with Microsoft SQL Server 7.0, its architecture, security, and database structure. Understand the basics of SQL Server databases and how to  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...
SQL and PL SQL Data Retrieval Techniques on-line e-learning cbt (computer based)cd rom ... to enhance the power of SQL queries. In addition, how to use SQL*Plus commands to build on basic SQL statements and create customized queries that retrieve the information and display it in a format specified by the user will be covered. L earn To: Retrieve rows from multiple tables by using an equijoin, a non-equijoin, an outer join, and a self join. Write SQL statements that  more...
SQL and PL SQL DML and DDL on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify  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...
Oracle SQL for End Users--Part 2 on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course, the learner displays data from multiple tables by using equijoins, non-equijoins, and self joins. In addition, this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database.  more...
Crystal Reports 8 5 Introductory Report Design Part 2 on-line e-learning cbt (computer based)cd rom Course Overview This is the second course in a two part series that builds on the information taught in the first course, Crystal Reports 8.5: Introductory Report Design Part 1 (13889). Learners will be working with formulas, linking reports, working with Cross-tabs, formatting sections, creating charts, and creating geographical maps. After completing this course, learners will be able to use  more...
Oracle 9i New Features Backup Recovery Performance Tuning on-line e-learning cbt (computer based)cd rom This course introduces students to high availability and fault recovery, data protection and disaster recovery, LogMiner enhancements, online operations, and Recovery Manager enhancements. Students also learn about schema improvements, system improvements, and scalable session state management. Learn To Identify the new features designed to reduce unplanned  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...
Database Technologies Introduction to SQL on-line e-learning cbt (computer based)cd rom The second in a two-part series, this course will teach students the fundamental skills and knowledge needed to acquire a foundation-level understanding of SQL. Building on the basic relational database skills and knowledge acquired in the first course, this course teaches students the essential SQL statements, and associated variations, needed to perform fundamental data access and manipulation  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...
Windows 2000 Implementing Security Part 2 on-line e-learning cbt (computer based)cd rom This course, teaches about security for Windows 2000-based computers. Security templates and security baselines are covered. The learner is guided through additional security configurations including security settings for file and print resources. Web server security and Internet security are also covered. Learn To: • To identify guidelines for planning  more...
Windows 2000 Implementing Security Part 2 on-line e-learning cbt (computer based)cd rom This course, teaches about security for Windows 2000-based computers. Security templates and security baselines are covered. The learner is guided through additional security configurations including security settings for file and print resources. Web server security and Internet security are also covered. Learn To: • To identify guidelines for planning  more...
Commerce Server 2000 Design Impl Part 5 Infra Sec Admin on-line e-learning cbt (computer based)cd rom 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...
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...
Oracle Database 10g PL SQL Fundamentals Part 3 on-line e-learning cbt (computer based)cd rom In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options. Learn To: Match the stages in the execution of SQL statements with  more...
From Serebra Learning Corporation
Relational Database Design and Administration on-line e-learning cbt (computer based) This course covers the design methodologies and techniques utilized when building an application based on a Relational Database Management System (RDBMS), using Structured Query Language (SQL). The course is based on RDBMS technology and will identify and explain the details and implementation. Designed for individuals in the design and administration of relational databases.  more...
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...
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...
Building ADO NET DataSets on-line e-learning cbt (computer based) To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths  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...
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...
Planning for Deployment of Microsoft Biztalk 2000 on-line e-learning cbt (computer based) To describe the planning and design of a BizTalk Server 2000 deployment IT professionals and administrators seeking to gain competency in the use of Microsoft BizTalk Server 2000; candidates for Microsoft Exam 70-230: Designing and Implementing Solutions with Microsoft BizTalk Server 2000, Enterprise Edition  more...
OS 390 COBOL on-line e-learning cbt (computer based) This course provides information regarding the use and future directions of COBOL under OS/390. It begins by covering the fundamentals of accessing three important databases and transaction systems from the point of view of the COBOL programmer. These are the CICS online transaction processing system, the DB2 relational database, and the IMS/DB hierarchical database management system. The course  more...
Web Technologies on-line e-learning cbt (computer based) This WestNet e-Learning module explores the Web technologies, such as JavaScript and databases, used to enhance basic Web page functionality.  more...
Monitoring and Managing IP Telephony Using Internal Server Tools on-line e-learning cbt (computer based) To demonstrate how to manage and monitor an IP telephony solution using internal server tools 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...
Monitoring IP Telephony on-line e-learning cbt (computer based) To recognize the tools of the IP telephony environment and how to maintain it, and monitor and troubleshoot the Cisco CallManager system 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...
Relational Database Concepts Structured Query Language on-line e-learning cbt (computer based) This course introduces the Structured Query Language (SQL), which is the most widely used language for the development and manipulation of relational databases. The course focuses on Relational Database Management Systems (RDBMS) query language technology and will identify and explain the details of the Structured Query Language (SQL). This course is designed to help individuals who want to  more...
Transporting and Loading Data in Oracle9i on-line e-learning cbt (computer based) To describe how to transport and load data in an Oracle9i database Oracle database administrators and database operators  more...
Introduction to Oracle and SQL in Oracle 9i on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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...
Development Platform in Oracle9i on-line e-learning cbt (computer based) To explain the Oracle9i database enhancements that support the Oracle9i database development platform Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database  more...
Tuning Systems and Applications in Oracle9i on-line e-learning cbt (computer based) To describe how to tune systems and applications in Oracle9i Anyone wishing to learn about Oracle9i database performance tuning  more...
Oracle Database 10g The SQL Loader and PL SQL Release 2 on-line e-learning cbt (computer based) To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database Anyone wanting to learn about Oracle Database 10g database administration  more...
Optimizing Database Performance in Oracle 10g on-line e-learning cbt (computer based) To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors Oracle database administrators and database operators  more...
Using the Scheduler to Automate Tasks in Oracle 10g on-line e-learning cbt (computer based) To outline the processes and considerations for using the Scheduler tool Oracle database administrators and database operators  more...
PL SQL Packages on-line e-learning cbt (computer based) To create and work with Oracle 10g packages Database administrators, application developers, and database operators  more...
Oracle-Supplied Packages and DBMS_SCHEDULER on-line e-learning cbt (computer based) To use Oracle-supplied packages Database administrators, application developers, and database operators  more...
PL SQL Triggers on-line e-learning cbt (computer based) To create and manage triggers Database administrators, application developers, and database operators  more...
Dynamic SQL and Metadata on-line e-learning cbt (computer based) To write dynamic SQL and use the DBMS_METADATA package Database administrators, application developers, and database operators  more...
Oracle Database 10g New Resource Scheduling and Task-Management Features on-line e-learning cbt (computer based) To identify the new resource, scheduling, and task-management features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g  more...
Oracle Database 10g New Tuning Performance-monitoring and Analysis Features on-line e-learning cbt (computer based) To use Oracle 10g's new tuning, performance-monitoring, and analysis features Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g  more...
Introduction to PL SQL on-line e-learning cbt (computer based) 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 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...
Using Composite Data Types on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) 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 on-line e-learning cbt (computer based) To demonstrate how to use regular expression support and control user access in Oracle 10g Database administrators, application developers, and database operators  more...
Accessing Data and Manipulating DB2 UDB Database Objects on-line e-learning cbt (computer based) To access data and manipulate database objects Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification  more...
Managing SQL Server 2000 Databases on-line e-learning cbt (computer based) 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...
Backing Up SQL Server 2000 Databases on-line e-learning cbt (computer based) 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 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...
Monitoring a DB2UDB on-line e-learning cbt (computer based) To explain how to monitor a DB2 UDB Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator  more...
Office XP for the Advanced User on-line e-learning cbt (computer based) To provide an overview of the new features and feature enhancements in the following Microsoft Office XP applications - Access, Publisher, FrontPage, and SharePoint Team Services Advanced end-user  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 Office 2000 - Intermediate Access on-line e-learning cbt (computer based) To provide an introduction to the core concepts of Microsoft Access 2000 and the skill areas of creating and enhancing a report, working with queries, and integrating data End-users seeking to become familiar with Microsoft Access 2000; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2000 at Core level  more...
Advanced Querying in Access 2003 on-line e-learning cbt (computer based) To use advanced queries such as joins, parameter, action, and SQL queries Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003  more...
Getting Started with Access 2003 on-line e-learning cbt (computer based) The Getting Started with Access 2003 course is the first course in the Microsoft Access 2003 curriculum. The course familiarizes users with basic database concepts and the features in Access. It describes the concepts and processes involved in creation and design of databases and tables in Access 2003. In addition, this course guides users to efficiently relate, manage, and customize database  more...
DB2 Application Programming I Rel 4 x on-line e-learning cbt (computer based) This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2. Application developers.  more...
DB2 Application Programming II Rel 4 x on-line e-learning cbt (computer based) This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2. Application developers  more...
Creating Queries Forms with Access 2002 on-line e-learning cbt (computer based) The Creating Queries and Forms with Access 2002 WBT is the second course of the Office XP: Access 2002 curriculum, which familiarizes users with the advanced features of Access 2002 that they can use while retrieving and presenting data stored in an Access database. These features include formulating simple and advanced SQL queries, and creating and designing forms. Additionally, this course  more...
IBM DB2 UDB Essentials Part 4 - Advanced SQL on-line e-learning cbt (computer based) This course teaches the learner how to make use of advanced SQL techniques to access DB2 databases in different environments. Indepth coverage is given to creating SQL objects Case CAST and Summary Tables Joins Subqueries Scalar Functions Recursive SQL UDTs/UDFs and general performance guidelines. It is appropriate for learners working in all DB2 environments that is OS/390 VM/VSE AS/400 UNIX  more...
Oracle8i DBA--SQL*Loader, Oracle Export and Import, and NLS on-line e-learning cbt (computer based) ...ansfer tools of Oracles. The course will teach you how to use SQL*Loader to load data into an Oracle database. The course will also teach you how to use the Oracle Export and Import Utilities. Next the course will detail explain the NLS feature of Oracle8i. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative  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 Management Part II on-line e-learning cbt (computer based) This course provides the skills to 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  more...
SQL Server 7.0 Management Part III on-line e-learning cbt (computer based) This course explains how to design a logical model of a database and identifies the components to use in order to organize and access a SQL Server database. It describes the advanced programmatic features of the SQL language which can be used to extend the functionality of SQL stored procedures.Additionally this course examines the functions of a SQL cursor including how to navigate a result set  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 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...
Oracle 8i PL/SQL - Intro to RDBMS and SQL *Plus on-line e-learning cbt (computer based) The course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses such as WHERE ORDER BY and DISTINCT. You  more...
Oracle 8i DBA - Introducing Procedure Builder on-line e-learning cbt (computer based) This course aims to introduce you to the various components of Procedure Builder. It explains the features of the Procedure Builder components such as the Object Navigator the PL/SQL Interpreter the Program Unit Editor the Stored Program Unit Editor and the Database Trigger Editor. It describes how you can use the components of Procedure Builder to create debug and execute program units. Related  more...
Oracle 8i DBA - Data Dictionary and Database Files on-line e-learning cbt (computer based) The course is aimed at familiarizing the student with the Data Dictionary views and database files. The course enables the learner to manage log and control files. The uses and contents of control files will be discussed as well as obtaining information from control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of Data  more...
Oracle9i SQL: Basic SELECT Statements on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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.  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...
Oracle8i Performance Tuning: Optimizing Sorts and Minimizing Contention on-line e-learning cbt (computer based) This course is the third in a three-part Oracle8i Performance Tuning series. This interactive 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 will use  more...
Oracle SQL for End Users Part 2 on-line e-learning cbt (computer based) This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers  more...
Oracle SQL: Basic SELECT Statements on-line e-learning cbt (computer based) 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 SQL statements;  more...
Oracle SQL: Data Retrieval Techniques on-line e-learning cbt (computer based) This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition how to  more...
Oracle9i SQL: Basic SELECT Statements on-line e-learning cbt (computer based) 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.  more...
Oracle9i SQL: DML and DDL on-line e-learning cbt (computer based) 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 PL/SQL: Procedures Functions and Packages on-line e-learning cbt (computer based) This course introduces users to the basics of PL/SQL subprograms. Users will learn how to build and invoke procedures and functions. This course also covers debugging PL/SQL subprograms using Procedure Builder. Additionally users will learn how to trap and handle errors in a PL/SQL block. This course also covers the basics of packages and how to create and use them.  more...
Oracle Report Builder: Controlling Reports on-line e-learning cbt (computer based) This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants learn how to develop report templates code PL/SQL triggers in a report and use Report Builder's built-in package. Finally building reports for different environments will be covered.  more...
Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention on-line e-learning cbt (computer based) 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 will use Oracle tools  more...
Oracle SQL Specifics: Retrieving and Formatting Data on-line e-learning cbt (computer based) 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 learn how SQL  more...
Oracle SQL Specifics: Creating and Managing Database Objects on-line e-learning cbt (computer based) This course is the second 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. Users will learn how to create and manage tables build integrity constraints and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views sequences indexes  more...
Oracle SQL and SQL*Plus: Advanced SELECT Statements on-line e-learning cbt (computer based) This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries.  more...
Oracle SQL and SQL*Plus: SQL*Plus and Reporting on-line e-learning cbt (computer based) This course is the second 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. Users will learn how to create and manage tables build integrity constraints and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views sequences indexes  more...
Oracle SQL Tuning: Diagnostics and Tuning the Schema on-line e-learning cbt (computer based) This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths such as partitioned views B-tree indexes bitmapped indexes index clusters and hash clusters. Participants will  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...
DB2 Application Programming (COBOL) (Rel 2.3) on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.  more...
DB2 Application Programming (PL/1) (Rel 2.3) on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.  more...
DB2 Application Programming (ver 3.1) on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.  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...
From Software Training Academy, Inc
The JSP Standard Tag Library instructor led trainingon-line e-learning cbt (computer based) This two-day module introduces the JSTL, or JSP Standard Tag Library, actually a set of four custom tag libraries that establish a portable standard for common processing tasks in JSP. JSTL is a major part of the new scriptless authoring style encouraged (and enabled) by the JSP 2.0 specification. This module covers all four JSTL libraries in depth: The core actions, which support JSP  more...
JDBC Programming Rev 5 instructor led trainingon-line e-learning cbt (computer based) ...PostgreSQL 8.0 Oracle, version 9i or 10g Lab exercises use SQL99 constructs whenever possible in order to be relevant to databases from all vendors. The course software also includes an optional overlay of workspace and project files to support use of the Eclipse IDE in the classroom. This revision of the course targets the 5.0 version of the Java language and Core API, though the impact  more...
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...
Java Persistence with Hibernate revised instructor led trainingon-line e-learning cbt (computer based) This course develops skills in using the Object/Relational Mapping tool Hibernate. The course uses the latest release version of Hibernate, 3.2, which is directly related to the new EJB 3.0 version defined in Java EE 5.0. By the end of the course, students will be prepared to set-up and use Hibernate as the persistence mechanism in Java applications. LEARNING OBJECTIVES Configure Hibernate  more...
Java Development for Secure Systems Rev 6 0 instructor led trainingon-line e-learning cbt (computer based) This course exposes students to the broad range of challenges and techniques that is "Java security." Secure coding practice for Java incorporates techniques for Java SE and Java EE, and increasingly EE applications are using SE techniques such as policy files and JAAS authentication. This course spends some time on each platform, so that students will be exposed to SE basics such as access  more...
SQL Server 2005 Reporting Services SSRS instructor led trainingon-line e-learning cbt (computer based) ...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 the course will employ shared data  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...
Oracle 10g PL SQL Programming instructor led trainingon-line e-learning cbt (computer based) This class will teach you how to write efficient and scalable PL/SQL programs to create database-intensive PL/SQL applications. Learning how to create efficient, scalable PL/SQL programs is an important objective of this course. To meet that objective, the course includes instruction on such things as the proper use of bind variables, bulk processing, pipelining, benchmarking different  more...
Oracle 10g - Advanced SQL instructor led trainingon-line e-learning cbt (computer based) This course will give experienced Oracle technologists the advanced SQL skills necessary to design and code complex queries against Oracle databases. You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability  more...
Oracle 10g - Introduction to SQL instructor led trainingon-line e-learning cbt (computer based) This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases. Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts. LEARNING OBJECTIVES  more...
Oracle Applications Using ADO NET and C instructor led trainingon-line e-learning cbt (computer based) Oracle is a robust and powerful data storage engine that provides services on all levels of an application infrastructure combining programmer-definable objects and tools, data manipulation tools that are capable of retrieving data from a host of data sources and storing those data in a database, and the capability to automate tasks and run them under developer control. This comprehensive course  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 ProTrain Online
MCTS .NET Framework on-line e-learning cbt (computer based)study at homeself directed Microsoft Certified Technology Specialist (MCTS): .NET Framework certifications enable professionals to target specific technologies and to distinguish themselves by demonstrating in-depth knowledge and expertise in the various Microsoft specialized technologies. A MCTS Certification in Microsoft teaches technicians how to implement and maintain databases using specific instructions and  more...
From The Virtual Training Company
Oracle Performance Tuning 1Z0-033 on-line e-learning cbt (computer based) VTC author, Gavin Powell, covers material in the 1Z0-033 Oracle 9i tuning certification examination, including the basics of performance tuning and tuning tools. Memory tuning covers the shared pool, the database buffer cache and other buffers. From an I/O perspective, topics covered are physical file structures of the database, tablespaces, datafiles and at the block level. Also covered are  more...
Java 2 JSP and Servlets on-line e-learning cbt (computer based) JavaServer Pages and Java Servlets are programs executed by a Web server to produce Web pages which are sent to a client Web browser in response to a request from the browser. This course by Arthur Griffith not only demonstrates how to write them, it also shows how to deploy them to a server and make them run in response to a request. Both Servlets and JavaServer pages can read from files,  more...
Macromedia ColdFusion on-line e-learning cbt (computer based) Macromedia's ColdFusion is a rapid application development platform. Through the use of a tag-based scripting language, it enables you to build and to deploy powerful web-based applications. Even if you do not have any type of programming experience, learning ColdFusion is a breeze with the help of Mike Muller. He guides you through this Virtual Training Company tutorial by taking you through the  more...
From Teach Me IT
Oracle SQL and PL/SQL: Basic Concepts on-line e-learning cbt (computer based)study at home The Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course explains the basic concepts regarding a DBMS, RDBMS, and ORDBMS, and give an Oracle implementation of these. It also provides users with the basic functionality of PL/SQL for creating, viewing,  more...
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...
Implementing an Oracle8 Data Warehouse on-line e-learning cbt (computer based)study at home ...ository with Oracle8 Partition VLDB tables with Oracle8 Use SQL*Loader Implement Oracle products available for moving data into the warehouse Index a data warehouse Manage indexes in a data warehouse Describe OLAP databases Describe the storage mode supported by OLAP services Describe the data warehouse tools used for querying data Describe the Oracle Express Suite of tools used for  more...
SQL Basic Skills on-line e-learning cbt (computer based)study at home The SQL Basic Skills WBT is the first course in the SQL Programming curriculum that consists of two courses. This course acquaints students with SQL and discusses the techniques used for normalizing a database. It also describes various commands and clauses used to query and manipulate a database. After completing this course, the student will be able to: Define a relational database List the  more...
Getting Started with SQL Server 2000 on-line e-learning cbt (computer based)study at home ...escribe the SQL Server 2000 database engine architecture Use SQL Query Analyzer and command-prompt utilities to interact with SQL databases Describe the syntax elements used in T-SQL statements and the methods of executing T-SQL statements Create a logical data model Plan, create, and manage a SQL Server database Define data types Create and manage a table Define the different types of  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...
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...
VB 6.0 Database Basics on-line e-learning cbt (computer based)study at home VB 6.0 Database Basics course is the first course of the three courses in the VB Databases curriculum. This curriculum prepares the students for the Microsoft Certified Professional Designing and Implementing Desktop Applications with Microsoft Visual Basic6.0 (70-176) exam. This course teaches students database basics and database creation through a VB application. Also, this course teaches the  more...
Getting Started with Access 2003 on-line e-learning cbt (computer based)study at home The Getting Started with Access 2003 course is the first course in the Microsoft Access 2003 curriculum. The course familiarizes users with basic database concepts and the features in Access. It describes the concepts and processes involved in creation and design of databases and tables in Access 2003. In addition, this course guides users to efficiently relate, manage, and customize database  more...
Creating Queries & Forms with Access 2002 on-line e-learning cbt (computer based)study at home The Creating Queries and Forms with Access 2002 WBT is the second course of the Office XP: Access 2002 curriculum, which familiarizes users with the advanced features of Access 2002 that they can use while retrieving and presenting data stored in an Access database. These features include formulating simple and advanced SQL queries, and creating and designing forms. Additionally, this course  more...
From CBT Planet
MCDBA 2003 Certification Training Course on-line e-learning cbt (computer based) Our MCDBA training courses put the power of your career into your own hands. The MCSA Training Course is easy to use and makes the learning experience enjoyable.With the most up-to-date information on the SQL server configurations, our MCDBA training will provide you with knowledge to arm you for any current situation in the ever-changing world of...  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 7.0 Programming Part 1 on-line e-learning cbt (computer based) This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software. To encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions. To help developers plan their applications systematically, efficiently and economically and to promote good design and development  more...
Microsoft SQL Server 7.0 Programming Part 2 on-line e-learning cbt (computer based) This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software. To encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions. To help developers plan their applications systematically, efficiently and economically and to promote good design and development  more...
Microsoft SQL Server 6.5 Programming on-line e-learning cbt (computer based) This intensive course is designed to introduce new MS SQL developers to some of the more advanced features and facilities of this software; to encourage confidence, control and creative use of MS SQL by taking a structured look at some of the more advanced functions to help developers plan their applications systematically, efficiently and economically; to promote good design and development  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 > U > Use Sql > Online eLearning
Advertise With Us
Do you teach Use Sql ?
tcw11-gfc--11/27/09-10:24:59-(19822)[B]-[A]-[B]