Custom Search

Online Queries eLearning - Training Resources

Queries Training Provider? - Tell us about your Training!
Queries Training Seminars and Classes
From Online Training Directory
The Internet - Applying the Basics to your Business on-line e-learning cbt (computer based)study at homecourseware ...odule, techniques for searching with tips and making your queries using Boolean language, simple words or stringing words together are outlined and explained. The search engines are explained in detail and how they are used for a search. Module 3. Business Research In this module, there is a detailed explanation on how to do effective business research. Gathering data on other companies?  more...
SQL Server 2000 Complete Course on-line e-learning cbt (computer based) This course is a complete set of SQL Server 2000 Administration, SQL Server 2000 Desing and Implementation, Datawarehousing and XML Enabled Applications using SQL 2000. This course teaches you to administer and troubleshoot information systems that incorporate the SQL Server 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, plan, design, and create SQL 2000 databases,  more...
Office 2000 Intermediate on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...the primary database objects in Access, including tables, queries, forms, reports, and data access pages. Some other skills students will learn include working with HTML and hyperlinks, using the Query Wizard, and customizing reports. Students will also be introduced to advanced components of Microsoft PowerPoint 2000, such as using masters, templates, and animation features, preparing  more...
Office XP (2002) Intermediate on-line e-learning cbt (computer based)study at homecoursewareSelf Directed This course introduces students to some new features of Microsoft Office XP. It covers the major features that apply to all of the applications. This includes Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Access, and Microsoft Outlook. This intermediate course strives to broaden and develop the intermediate skills that students already possess. This intermediate course  more...
Office 2000 Advanced on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...te and use the primary database objects including tables, queries, forms, reports, and data access pages. The course also teaches strategies for protecting data by enacting various security measures and by controlling how data is entered into a database. Mastery of Microsoft PowerPoint 2000 will empower an experienced user to apply advanced visual effects, import and export elements, work  more...
Microsoft Access 2002 Core on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...d how to create and use tables, forms, filters and sorts, queries, and reports. This course will introduce students to the new features in Microsoft Access 2002 that set it apart from Access 2000, including speech recognition and the new Task Pane, as well as the basic elements that compose an Access database, to broaden and develop their basic database design skills. After they learn how to  more...
Microsoft Access 2002 Expert on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...the primary database objects in Access, including tables, queries, forms, reports, and data access pages. In addition, students will be introduced to advanced features that allow Access to be used as a development tool. The course also teaches strategies for protecting data by enacting various security measures and by controlling how data is entered into a database. Finally, various  more...
Microsoft Access 2002 Level 1 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed Students will learn what a database is and how an effective database should be designed and set up. This course will also cover the new features in Access 2002 that set it apart from Access 2000, including speech recognition and the new Task Pane. This course introduces students to the basic elements that compose an Access database. Students will learn what a database is and how an effective  more...
Microsoft Access 2002 Level 2 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...the primary database objects in Access, including tables, queries, forms, reports, and data access pages. Students will also learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. This intermediate course strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete  more...
Microsoft Access 2002 Level 3 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...the primary database objects in Access, including tables, queries, forms, reports, and data access pages. In addition, students will be introduced to advanced features that allow Access to be used as a development tool. The course also teaches strategies for protecting data by enacting various security measures and by controlling how data is entered into a database. Finally, various  more...
Access 2007 Level 1 on-line e-learning cbt (computer based) This entry-level course introduces students to the basic elements that comprise a Microsoft Office Access database. Students will learn what a database is and how an effective database should be designed and set up. They will learn the importance of establishing relationships, as well as how to establish and edit relationships and enforce referential integrity. Access 2007 Level 1 This  more...
Access 2007 Level 2 on-line e-learning cbt (computer based) ...bjects in Microsoft Office Access 2007, including tables, queries, forms, and reports. Access 2007 Level 2 Strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to create and use the primary database objects in Microsoft Office Access 2007, including tables, queries, forms, and reports. The  more...
Access 2000 Level 3 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...the primary database objects in Access, including tables, queries, forms, reports, and data access pages. In addition, students will be introduced to advanced features that allow Access to be used as a development tool. The course also teaches strategies for protecting data by enacting various security measures and by controlling how data is entered into a database. Finally, various  more...
Access 2000 MOUS on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...the primary database objects in Access, including tables, queries, forms, reports, and data access pages. This comprehensive course teaches students both the basic and the more advanced elements that compose an Access database. Students will learn how to create their own databases in Access and use the basic tools of the Access application: tables, forms, filters and sorts, queries, and  more...
Access 2000 Proficient on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...on; creation and use of tables, forms, filters and sorts, queries, and reports; as well as some techniques designed to make data entry in Access databases faster, easier, and less error-prone. This comprehensive course teaches students both the basic and more advanced elements that compose an Access database. Students will learn how to create their own databases in Access; and learn how to  more...
Access 2002 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...of the Access application: tables, forms, filters, sorts, queries, and reports. The next part of the course strives to broaden and develop the basic database skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access. The course also shows how to work with individual fields to ensure that  more...
Access 2002 MOUS on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...the Access application: tables, forms, filters and sorts, queries, and reports. In addition, students will learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. As the course becomes more advanced, students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, as well as  more...
Access 2000 Expert on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...the primary database objects in Access, including tables, queries, forms, reports, and data access pages. This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms,  more...
Access 2000 Level 1 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed As students are introduced to the basic elements that compose an Access database, they will learn what a database is and how an effective database should be designed and set up. The students will also learn how to create their own databases and how to enter and manipulate data. This course introduces students to the basic elements that compose an Access database. Students will learn what a  more...
Access 2000 Level 2 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...the primary database objects in Access, including tables, queries, forms, reports, and data access pages. Some other skills students will learn include working with tables and data, working with HTML and hyperlinks, using the Query Wizard, and customizing reports. Students will also learn how to maintain databases by backup, as well as how to compact and repair them. In addition, students will  more...
Access 2000 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed ...of the Access application: tables, forms, filters, sorts, queries, and reports. As students advance in the course, they will work with tables and data, HTML and hyperlinks, use the Query Wizard, and customize reports. They will also learn how to maintain databases as backups, as well as compacting and repairing them. Students will also use Access as a development tool in the most advanced  more...
Access 97 Level 3 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed In this course, accomplished Access users will be introduced to the most powerful features in Microsoft Access 97. Students will work with advanced forms, use parameter and crosstab queries, and employ complex calculation expressions and selection criteria.  more...
Access 97 on-line e-learning cbt (computer based)study at homecoursewareSelf Directed This course introduces the database functions of Microsoft Access 97, such as working with Access menus and dialog boxes, creating and editing tables, formatting columns and rows, and planning table design. Accomplished users will work on advanced forms, use parameter and crosstab queries, and employ complex calculation expressions and selection criteria.  more...
From Michael Management Corporation
SAP Business Information Warehouse (BI & BW) on-line e-learning cbt (computer based)study at homeself directed ...sing filters, drilldowns, conditions, etc. - Create new queries with the Query Designer Release: BI 7. 0, ECC 6. 0 (newest SAP release) Audience: End users Prerequisite: - Basic SAP skills (SAP101) - A general understanding of SAP terms Exam & Certificate: - approx. 35 questions - Certificate of Completion CPE credits: 6. 0 Includes: - 12 lessons, approx. 6  more...
From 123-CBT Computer Based Training
Designing Efficient Application Access on-line e-learning cbt (computer based) recognize how to efficiently utilize client libraries for database access using automation management objects, server Network Interface and MARS for queries and row management  more...
Designing Queries in SQL 2005 on-line e-learning cbt (computer based) recognize how to design and execute queries in SQL Server 2005, utilizing XQuery and the XML Data Modification Language  more...
Oracle Database 11g Conversion Functions Group Functions and Joins on-line e-learning cbt (computer based) To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...
Oracle Database 11g Subqueries Set Operators and Data Manipulation on-line e-learning cbt (computer based) To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...
Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms on-line e-learning cbt (computer based) To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  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  more...
Analyzing and Optimizing SQL Server 2000 Queries on-line e-learning cbt (computer based) To show how to analyze and optimize queries  more...
Retrieving Data and Running Queries in SQL Server 2005 on-line e-learning cbt (computer based) To perform relational data and XML data management tasks, and work with assemblies and transactions in SQL Server 2005  more...
Manipulating Data with DB2 UDB on-line e-learning cbt (computer based) To execute queries using SQL  more...
Microsoft SMS 2003 Managing Collections Queries and Reports on-line e-learning cbt (computer based) To explain how to manage collections, queries and reports in SMS 2003  more...
Oracle9i SQL Data Retrieval Techniques on-line e-learning cbt (computer based)cd rom ...queries, 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 Identify a Cartesian product. o Retrieve  more...
SQL Server 2000 Querying with Transact SQL Part 2 Working with Queries on-line e-learning cbt (computer based)cd rom ...erview This course will teach students how to work with queries. The course will also introduce views, stored procedures, triggers, and user-defined functions. Learn To Identify advantages of using aliases for table names. Identify the guidelines for using joins. Identify the considerations for using inner joins. Identify considerations for using subqueries. Create a derived table  more...
SQL Server 2000 Querying with Transact SQL Curriculum on-line e-learning cbt (computer based)cd rom The MS SQL Server 2000 Querying with Transact SQL Curriculum includes the following courses: MS SQL Server 2000: Querying with Transact SQL Part 1(Manipulating Data) MS SQL Server 2000: Querying with Transact SQL Part 2(Working with Queries) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...
SQL Server 2000 Design Implement Databases Part 5 Dist Data Locks on-line e-learning cbt (computer based)cd rom ... Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking. Learn To: o Identify guidelines for importing and exporting data. o Match SQL Server 2000 tools used to import and export data with their functions. o Identify the features and functions of the Data Transformation  more...
SQL Server 2000 Design Implement Databases Part 4 Managing Indexes on-line e-learning cbt (computer based)cd rom ...earn how to optimize query performance and how to analyze queries. Learn To Identify the features of clustered indexes. Identify the features of nonclustered indexes. Retrieve information from the sysindexes table. Identify guidelines for creating indexes. Identify the considerations for creating unique indexes. Identify the considerations for creating composite indexes. Identify  more...
IBM DB2 Universal Database V6 1--App Development on-line e-learning cbt (computer based)cd rom ...e data from two or more tables using a join. Combine two queries into a single result table using set operations. Retrieve data in a restricted condition using a subquery. Retrieve data with referenced values using a correlated subquery. Retrieve data using scalar functions. Retrieve summarized data for groups using grouping functions. Create different levels of aggregation data using  more...
IBM DB2 Universal Database V6 1--App Development on-line e-learning cbt (computer based)cd rom ...e data from two or more tables using a join. Combine two queries into a single result table using set operations. Retrieve data in a restricted condition using a subquery. Retrieve data with referenced values using a correlated subquery. Retrieve data using scalar functions. Retrieve summarized data for groups using grouping functions. Create different levels of aggregation data using  more...
Windows 2000 Network Infrastructure Admin --Part 1 DHCP DNS WINS on-line e-learning cbt (computer based)cd rom ...erver in a specified scenario. Test a DNS server for DNS queries by using the Action menu. Troubleshoot a DNS client that is unable to access the DNS host specified in the host name. Troubleshoot a DNS server that is not responding. Troubleshoot a DNS zone. Unit 3: Networking Services: WINS Duration: 2 Hour(s) Sequence the steps in the NetBIOS name resolution process when the  more...
Access 2000 Expert User on-line e-learning cbt (computer based)cd rom ...this course, students will learn how to create and refine queries; create, modify and enhance the forms in the Design view; create, modify and enhance reports; and secure and enhance the performance of an Access 2000 database. L earn To: Create and refine queries. Create, modify and enhance the forms in the Design view. Create, modify and enhance reports. Secure and enhance the  more...
Oracle Reports R6 Enhance Reports on-line e-learning cbt (computer based)cd rom ...n filtering data in a group. Build a report by creating queries. Enhance a report by creating columns. Identify the sections of the Layout Model. Identify the components in the Data Model view. Control the common layout properties. Create a link file. Identify the objects in the Data Model and the Layout Model to enhance matrix reports. Create nested matrix reports. C  more...
Oracle Form Builder R6 Writing and Debugging Code on-line e-learning cbt (computer based)cd rom ...create and control alerts, debug PL/SQL code, and process queries in form modules. In addition, the course will cover transaction processing, Form Builder application customization, and writing flexible code. L earn To: Identify the communication formats used by Form Builder. Write the code to handle errors, suppress system messages, create alerts and control alerts at run time.  more...
Oracle Form Builder Writing and Debugging Code on-line e-learning cbt (computer based)cd rom ...create and control alerts, debug PL/SQL code, and process queries. In addition, transaction processing, Form Builder application customization, and writing flexible code will be covered. L earn To: Identify the descriptions of the communication formats used by Form Builder. Write codes to detect errors, suppress system messages, create alerts, and control alerts at runtime. Run  more...
Frontpage 2000 Expert User on-line e-learning cbt (computer based)cd rom C ourse Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic  more...
Frontpage 2000 Expert User on-line e-learning cbt (computer based)cd rom Course Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic  more...
Visual C 6 0 Designing Implementing Distributed Applications - Part 3 on-line e-learning cbt (computer based)cd rom ...by using joins with the SELECT statement. Create summary queries to display data in customized sorted format. Modify the data contained in a table by using SQL statements. Create a view for restricting access to the specific columns to tables by using Enterprise Manager. Identify the features of the ODBC data access technology. Identify the features of the RDO data access technology.  more...
Oracle SQL Specifics Retrieving and Formatting Data on-line e-learning cbt (computer based)cd rom ...ase and how SET operators can be used to combine multiple queries into a single query. Users will also learn how subqueries and correlated subqueries can help to solve data retrieval problems. Finally, participants will learn how to retrieve data based on a hierarchical relationship between rows. L earn To: Define relational database concepts and object relational database concepts.  more...
Oracle SQL and SQL Plus Advanced SELECT Statements on-line e-learning cbt (computer based)cd rom ...arner 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 subqueries. Write multiple-row and multiple-column subqueries. Write correlated subqueries. Write queries using number DECODE and  more...
Oracle SQL and SQL Plus SQL Plus and Reporting on-line e-learning cbt (computer based)cd rom ...s the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output. L earn To: Identify the fundamental concepts of SQL*Plus and write queries using SQL*Plus runtime variables. Identify the SQL*Plus commands associated with line editing, file manipulation, and script  more...
TCP IP Internetworking on Microsoft Windows NT 4 0 - Part 3 on-line e-learning cbt (computer based)cd rom Course Overview This is the third course in a four part series for IT professionals who intend to set up, configure, use and support TCP/IP on Microsoft Windows NT 4.0. The series aims to enable the professionals to pass Microsoft exam 70-59, Internetworking Microsoft TCP/IP on Microsoft Windows NT 4.0. L earn To: Administer a WINS environment by configuring database replication  more...
SQL Server 7 0 - Implementing a Database - Part 1 on-line e-learning cbt (computer based)cd rom ...SQL statements. Sequence the steps for processing cached queries. Select the mechanisms that save query definitions automatically. Select the mechanisms that save specified query definitions. Unit 3: Constructing Databases Duration: 2 Hour(s) Select the description of how SQL Server stores data. Sequence the steps of the transaction logging process. Perform the steps to create a  more...
SQL Server 7 0 - Implementing a Database - Part 3 on-line e-learning cbt (computer based)cd rom ...orm the steps to create a single result set from multiple queries. Identify the characteristics of the SELECT INTO statement. Perform the steps to create a temporary table. Unit 2: Advanced Query Techniques Duration: 3 - 4 Hour(s) Select the guidelines for using subqueries. Perform the steps to return a single value of data. Perform the steps to return a list of values. Select  more...
SQL and PL SQL Basic SELECT on-line e-learning cbt (computer based)cd rom ...elational database management systems. Write SQL SELECT queries. Customize SQL queries when selecting data from a table. Identify SQL*Plus environment, features, and commands. Restrict rows retrieved by a query. Identify comparison operators that can be used in defining row retrieval restrictions. Identify logical operators that can be used to define row retrieval restrictions.  more...
SQL and PL SQL Data Retrieval Techniques on-line e-learning cbt (computer based)cd rom ...ause of another SQL statement 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.  more...
Oracle SQL for End Users--Part 1 on-line e-learning cbt (computer based)cd rom ... creates basic SQL SELECT statements and customizes these queries to restrict and sort the results. In addition, the learner writes statements that contain a variety of single-row functions. L earn To: Identify database principles and concepts concerning the Oracle server, SQL, and SQL*Plus. Write basic SQL SELECT statements. Add clauses to basic SQL SELECT statements to restrict  more...
Oracle SQL for End Users--Part 2 on-line e-learning cbt (computer based)cd rom ... in the database. This course also covers how to embed subqueries in SQL statements. Finally, the learner creates interactive reports by using substitution variables, and executes a formatted report by using SQL*Plus commands. L earn To: Access data from more than one table by using equijoins and nonequijoins and join a table to itself by using a self join. Group data by using group  more...
Access XP Proficient User on-line e-learning cbt (computer based)cd rom ...ndividuals will learn how to make different types of data queries, work with forms and link data to other databases. Learn To • Create a single-table query in Design view. • Create a multiple-table query in Design view. • Create a simple query by using the Simple Query Wizard. • Identify features of the Form Wizard. • Identify features of the AutoForm  more...
Access XP Expert User on-line e-learning cbt (computer based)cd rom ...n Access, the course covers advanced features of database queries, and enhancing forms and reports. Learn To • Create an update query. • Create a delete query. • Create an append query. • Create a form in Design view. • Modify section properties in a form. • Create a subform with the Form Wizard. • Create a report in Design view. •  more...
Access 2003 Curriculum on-line e-learning cbt (computer based)cd rom ... manipulate tables, and how to create simple and advanced queries. The curriculum teaches how to create forms and reports and how to format controls on both forms and reports, and the student is also introduced to importing and exporting data to and from Access. This curriculum consists of two Skill Builder courses: Microsoft Access 2003 Fundamentals Microsoft Access 2003 Proficient User  more...
Access 2003 Fundamentals on-line e-learning cbt (computer based)cd rom ... manipulate tables, and how to create simple and advanced queries. Learn To To identify options in the New File task pane. To identify functions of database object views. To identify options in the Table Wizard. To identify table field properties. To  more...
SAP R 3 3 0 Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview Now you can learn the functionality and capabilities of the SAP R/3 3.0 System, designed for the open system environment, as well as understand the advantages for business and the user. This course will help you differentiate between each integrated application module of the SAP R/3 3.0 system. Through the use of examples of system functions, you will get the user's perspective  more...
CIW Dynamic Server Pages Part 3 on-line e-learning cbt (computer based)cd rom Course Overview This is the final course in a three part series that students will learn about ActiveX Data Objects, error handling and dubugging ASP applications, project management in application development, and data integrity and security issues. Learn To • Identify the situations in which ADO would be used. • Identify ASP application development, error handling, and  more...
CIW Database Specialist Part 3 Database Interaction JDBC on-line e-learning cbt (computer based)cd rom This is the third course in a four part series that teaches students about SQL, relational algebra, transactions and database security, and an introduction to the JDBC. This course covers SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins,  more...
From Serebra Learning Corporation
Microsoft Access 2000 Basic on-line e-learning cbt (computer based) This highly interactive CBT contains five units that cover basic Access skills. Through step-by-step instruction within a realistic simulation of Microsoft Access 2000, students learn how to create and manage data and tables, create forms and reports, and modify a database structure. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics  more...
Microsoft Access 97 Basic on-line e-learning cbt (computer based) This highly interactive CBT contains five units that cover basic Access skills. Through step-by-step instruction within a realistic simulation of Microsoft Access 97, students learn how to create and manage data and tables, create forms and reports, and modify a database structure. This course is designed to help individuals who want to achieve basic proficiency in MS Access 97. Individuals who  more...
Visual Basic 6 0 Database Access Part I on-line e-learning cbt (computer based) ...th client tools built in Visual Basic, to create powerful queries and statements for a server-side database. Finally, this course describes how you can use data controls to access database information. It explains how you can use the Data Environment Designer to create connections, commands, and data-bound forms. Also described are the Data Form Wizard and the ADO Data Control, which are  more...
Working with Complex Data in ColdFusion MX on-line e-learning cbt (computer based) To describe how to work with queries, arrays, and structures in ColdFusion MX Existing ColdFusion 5 users wishing to gain experience in advanced ColdFusion MX development; web and enterprise application developers who have had an introduction to ColdFusion development and wish to learn advanced development techniques  more...
Getting Started with ColdFusion MX on-line e-learning cbt (computer based) To introduce and demonstrate the fundamental concepts, tools, and features of ColdFusion MX Web professionals and developers that want to create dynamic web sites using ColdFusion  more...
Data Retrieval and Manipulation in Macromedia ColdFusion MX on-line e-learning cbt (computer based) To introduce and demonstrate data retrieval and manipulation in ColdFusion MX Web professionals and developers that want to create dynamic web sites using ColdFusion  more...
Introducing Dreamweaver MX and ASP NET on-line e-learning cbt (computer based) To introduce the student to Dreamweaver MX and ASP.NET and explain how to use them to publish database content, reuse code, and navigate through DataSets Web professionals; home users and end users wishing to use Dreamweaver MX to create database-driven web applications built on ASP.NET technology  more...
Visual Basic 6 0 Database Access Part II on-line e-learning cbt (computer based) This course provides a detailed look at the ActiveX Data Object (ADO)that acts as the bridge between your application and a database. Designed for intermediate to advanced Visual Basic application programmers Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential.  more...
Data Integration Database Environments and XML Handling with C 2005 on-line e-learning cbt (computer based) To identify how to configure database connections and handle XML data in Windows Forms applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005 and C# 2005 to develop Windows-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Windows-Based Client Development (70-526) certification exam  more...
XML Data Access in VB NET on-line e-learning cbt (computer based) To use the .NET Framework to manage XML data All Microsoft VB.NET developers wanting to write enterprise applications with serviced components, Windows Services, or .NET Remoting, or studying for the 70-310 exam Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework  more...
Win2000 Active Directory Design Business Requirements and Naming Strategies on-line e-learning cbt (computer based) ... and its integration with ADS, forward and reverse lookup queries, zone transfers, and the DNS notification process. You will also learn about the ADS naming strategies, determining the scope of Active Directory, planning the naming hierarchy and DNS namespace, and identifying compatible DNS servers. Lastly, this course covers DNS deployment strategies for naming the ADS root domain, and the  more...
Microsoft SMS 2003 Managing Collections Queries and Reports on-line e-learning cbt (computer based) To explain how to manage collections, queries and reports in SMS 2003 Systems administrators, systems engineers, systems analysts, IT consultants, and support professionals with responsibility for planning, implementing, and maintaining Microsoft Systems Management Server 2003  more...
Administering BizTalk Server 2000 on-line e-learning cbt (computer based) To administer and manage BizTalk Server 2000 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...
Security administration in Check Point Logging and SmartView Tracker on-line e-learning cbt (computer based) To identify the components of SmartView Tracker and the data it can access and to be able to use that data to block intruders system administrators, security managers, network engineers, and consultants who manage Check Point NG VPN-1/FireWall-1 gateway deployments  more...
Cisco BSCI 3 0 EIGRP Options Authentication and Issues on-line e-learning cbt (computer based) To enable you to describe and configure EIGRP advanced options, authentication, and recognize common issues when configuring EIGRP in an Enterprise Network Candidates for Cisco CCNP, CCDP, CCIP, and Cisco CCIE Routing and Switching and CCIE Communications and Services certifications; network administrators, technicians, and senior network support staff who are responsible for implementing and  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...
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...
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...
Manipulating Data with DB2 UDB on-line e-learning cbt (computer based) To execute queries using SQL 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...
Advanced Database Design in Access 2002 on-line e-learning cbt (computer based) To provide an overview of advanced database design 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...
Exchanging Data with Excel 2007 on-line e-learning cbt (computer based) ...ctionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage and customize workbooks. This course explores creating links, importing text files, and creating database and web queries. Importing  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...
Microsoft Access 97 Intermediate on-line e-learning cbt (computer based) ...oft Access, individuals learn how to create multiple task queries, develop form as and sub-forms, create complex reports, share access information with other office programs and create advanced queries. Performance-based Pre- and Post-Assessments create a custom course path for each learner covering only the topics not yet mastered. A searchable index and online glossary make the CBT a great  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...
Microsoft Excel 2000 Intermediate on-line e-learning cbt (computer based) This highly interactive CBT contains six units that cover intermediate Excel skills. Through step-by-step instruction within a realistic simulation of Microsoft Excel 2000, students learn how to manage workbooks, automate tasks, use and analyze list data, enhance charts and worksheets, and work with Excel and the Internet. Performance-based Pre- and Post-Assessments create a custom course path for  more...
Microsoft Access 2000 Intermediate on-line e-learning cbt (computer based) This highly interactive CBT contains six units that cover intermediate Access skills. Through step-by-step instruction within a realistic simulation of Microsoft Access 2000, students learn how to create complex queries, forms, and reports, share Access information with other programs, and add objects to a form. Related Exam: MOUS Access 2000 Expert. Designed to teach intermediate Access skills.  more...
ECDL ICDL 4 Module 5 Database - Access 2003 Queries and Reports on-line e-learning cbt (computer based) ...queries and reports. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a database application; end users wanting to become familiar with database concepts; end users wanting to attain competency in using Microsoft Access 2003; end users wanting to attain an  more...
Microsoft Access 2000 Expert User on-line e-learning cbt (computer based) This course provides participants the knowledge to use the advanced features of Microsoft Access 2000. At the completion of this course, students will learn how to create and refine queries; create, modify and enhance the forms in the Design view; create, modify and enhance reports; and secure and enhance the performance of an Access 2000 database.  more...
Webmaster Essentials on-line e-learning cbt (computer based) WebMaster is a title given to an individual responsible for maintaining a web site and responding to queries about it. In this course, the student will learn how to create a web site. The student will choose communications connections and server platforms for the web site development. The student will then use HTML and CGI to develop simple and complex web sites. This course is designed for  more...
Building a Data Warehouse on-line e-learning cbt (computer based) The Building a Data Warehousing WBT is the second course in the Data Warehousing curriculum. It provides students with an overview of the core technologies, concepts, architecture, and various features of data warehouses, models, and data extraction tools. People who have a fairly good knowledge of the concepts of database systems, relational database management systems, and their architecture.  more...
Creating Queries Forms with Access 2002 on-line e-learning cbt (computer based) ...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 guides users in  more...
Using Advanced Data Management Techniques on-line e-learning cbt (computer based) The Using Advanced Data Management Techniques WBT is the third course in the Office XP: Excel 2002 curriculum. This course teaches the users how to create lists in Excel and manage them by filtering, sorting, subtotaling data, and specifying validation criteria. Additionally, it explains the procedures involved in importing data in Excel from external sources, such as Access databases, text files,  more...
MS Access 2003 Fundamentals on-line e-learning cbt (computer based) This course maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships how to manipulate tables and how to create simple and advanced queries.  more...
IBM DB2 UDB Essentials Part 3 - SQL Fundamentals on-line e-learning cbt (computer based) This course introduces the learner to the fundamental elements of the SQL language. Simple query running is covered before moving on to more complex procedures such as retrieving data from multiple tables and creating single reports from multiple queries. Scalar and column functions are covered. Coverage is also given to running subqueries and maintaining data. On completion of the course the  more...
MS Access 2003 Fundamentals on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships, how to manipulate tables, and how to create simple and advanced queries.  more...
SQL Server 7.0 Developing SQL Client/Server Part I on-line e-learning cbt (computer based) ...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 structure and to use OLE DB ActiveX ODBCDirect Microsoft English Query Query Analyzer and to create and evaluate queries. In a corporate setting the primary factors in implementing a  more...
SQL Server 7.0 Developing SQL Client/Server Part II on-line e-learning cbt (computer based) ...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 structure and to use OLE DB ActiveX ODBCDirect Microsoft English Query Query Analyzer and to create and evaluate queries. In a corporate setting the primary factors in implementing a  more...
SQL Server 7.0 Advanced Features Part I on-line e-learning cbt (computer based) ... function of advanced Transact-SQL OSQL and and ODS-based queries methods of managing SQL Server failover support distributed transaction fundamentals Office 2000 integration and Visual Studio integration. The student will learn to create heterogeneous distributed queries and fundamentals of managing the server arrays that require advanced query techniques. The course presents an overview of  more...
SQL Server 7.0 Advanced Features Part II on-line e-learning cbt (computer based) ...yntax and function of advances Transact-SQL and ODS-based queries methods of managing SQL Server failover support distributed transaction fundamentals Office 2000 integration and Visual Studio integration. The student will learn to create heterogeneous distributed queries and fundamentals of managing the server arrays that require advanced query techniques. The course presents an overview of  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 PL/SQL - Adv SQL, SQL *Plus & Data Dictionary on-line e-learning cbt (computer based) In this course you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. Furthermore the course discusses the SQL *Plus format commands and script files. The concept of data dictionary tables and views is also covered in the course. Related Exam: Oracle Exam #1Z0-001:  more...
MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation, how to create and manage indexes, as well as learn how to optimize query performance and how to analyze queries.  more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data, and how to transform data with DTS. Additionally, users will learn how to manage distributed queries and linked servers, create transactions, manage locks, and how to troubleshoot transactions and locking.  more...
Microsoft Access 2002 Proficient User on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This courses covers more advanced features of Access 2002. Individuals will learn how to make different types of data queries, work with forms and link data to other databases.  more...
Microsoft Access 2002 Expert User on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course covers the more complex aspects of working with data using Access 2002. Assuming the learner is already proficient in Access, the course covers advanced features of database queries, and enhancing forms and reports.  more...
Oracle9i SQL: Data Retrieval Techniques on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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.  more...
MS Office 2000: Access for Professionals II on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course teaches the student how create queries, forms and reports. The student will also look at integrating data with other applications and exporting database objects to the Web.  more...
MS Office 2000: Access for Experts I on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course teaches the student how to create a table and update information in the table through queries. The student will also learn to create forms.  more...
Microsoft SQL Server 2000 Querying with Transact-SQL Part 2: Working with Queries on-line e-learning cbt (computer based) This course will teach students how to work with queries. The course will also introduce views stored procedures triggers and user-defined functions.  more...
MS SQL Server 2000: Design and Implementation Part 4: Managing Indexes on-line e-learning cbt (computer based) This is the fourth course in a five part series that will teach students how to work with SQL Server indexes. Students will learn how to plan for index creation how to create and manage indexes as well as learn how to optimize query performance and how to analyze queries.  more...
MS SQL Server 2000: Design and Implementation Part 5: Distributed Data and Locks on-line e-learning cbt (computer based) This is the final course in a five part series that teaches how to manage SQL Server 2000 transactions and locks. This course will cover how to import and export data and how to transform data with DTS. Additionally users will learn how to manage distributed queries and linked servers create transactions manage locks and how to troubleshoot transactions and locking.  more...
Microsoft Access 2002 Proficient User on-line e-learning cbt (computer based) This courses covers more advanced features of Access 2002. Individuals will learn how to make different types of data queries work with forms and link data to other databases.  more...
Microsoft Access 2002 Expert User on-line e-learning cbt (computer based) This course covers the more complex aspects of working with data using Access 2002. Assuming the learner is already proficient in Access the course covers advanced features of database queries and enhancing forms and reports.  more...
Oracle Developer: Writing and Debugging Code on-line e-learning cbt (computer based) This course is the third in a six-part Oracle Developer series that is based on Oracle Developer Release 6. In this course learners will create and control alerts debug PL/SQL code and process queries in form modules. In addition the course will cover transaction processing Form Builder application customization and writing flexible code.  more...
Oracle SQL for End Users Part 1 on-line e-learning cbt (computer based) Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties introduces the Oracle server and indicates how SQL and SQL*Plus are used in the Oracle product  more...
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: Data Retrieval Techniques on-line e-learning cbt (computer based) 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.  more...
Oracle Form Builder: Writing and Debugging Code on-line e-learning cbt (computer based) This course is the third in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will help participants learn to create and control alerts debug PL/SQL code and process queries. In addition transaction processing Form Builder application customization and writing flexible code will be covered.  more...
Oracle Discoverer 3.1: Data Exploration on-line e-learning cbt (computer based) This course introduces participants to the querying and analytical capabilities of Oracle Discoverer 3.1. Participants will learn how to create modify run and refine ad hoc queries. They will also learn how to view chart and analyze multidimensional data. Finally they will learn how to schedule and manage report generation in batch mode.  more...
Oracle 9iAS: Discoverer Plus for End Users on-line e-learning cbt (computer based) This course introduces students to the querying and analytical capabilities of Oracle Discoverer4i Plus. Students learn how to create modify run and refine ad hoc queries using multidimensional data. Students also learn how to create edit and customize graphs to analyze data.  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 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...
Fundamentals of MS Access 2000 on-line e-learning cbt (computer based) This course familiarizes the students with the database fundamentals and teaches them how to perform database maintenance using MS Access. This course focuses on creation and design of databases and tables. The students will also learn the concept of querying tables.  more...
SQL Basic Skills on-line e-learning cbt (computer based) This course will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students willl be able to query and update tables using SQL statements.  more...
Implementing an SQL 7.0 Data Warehouse on-line e-learning cbt (computer based) The Implementing an SQL 7.0 Data Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for  more...
QMF Essentials (Ver 3.1) on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd Teaches the creation of data base queries using three languages: SQL, Prompted Query Mode and Query by Example (QBE).  more...
SQL Queries on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd Describes SQL querying from simple one column, one table queries to advanced joining and merging of data from multiple tables.  more...
Implementing an MS SQL Server 7.0 Data Warehouse on-line e-learning cbt (computer based) This course teaches the student how to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of crating files and filegroups and helps students to select an application programming interface for accessing a data source. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL  more...
From Seletel Informatique
Online Access 2000 MOS Series on-line e-learning cbt (computer based) This series is designed to help users prepare for Microsoft Access 2000 MOS certification. It shows how to create, plan, and modify databases and tables in Access 2000. It also covers sorting and filtering, creating queries, forms and reports, and advanced tasks such as saving Access objects as Web pages, importing data, and adding hyperlinks.  more...
Online Access 2003 Series on-line e-learning cbt (computer based) The Access 2003 series of courses starts off with an overview of both database concepts in general and Access in particular. Learners then find out how to design, build, and use Access tables. Further topics include using queries, find, filter, and sort to unearth answers from data. Learners finally move on to the Access report system and delve into wizards, timesaving tips, and even a bit of  more...
Online Access 2002 Series on-line e-learning cbt (computer based) This series shows how to create, plan, and modify databases and database objects in Access 2002. Courses cover the following topics: understanding relational databases, creating and planning databases, selecting and printing database objects, creating tables, entering records, modifying tables and field properties, using advanced sorts, finding records, applying and removing filters, establishing  more...
Online Access 2007 Series on-line e-learning cbt (computer based) This series covers how to use Access 2007 to create, modify, and access databases. It shows the learner how to use the Ribbon-based Access 2007 interface, as well as how to build tables, forms, and reports. Learners will also be able to use queries and filters to sort through data in Access 2007.  more...
Online Access 2007 Advanced Series on-line e-learning cbt (computer based) Access 2007 offers many more powerful features than a beginning user first touches. This series will explore some of the more powerful abilities of Access, including pivot tables and charts, graphs, forms, security, multitable and crosstab queries, macros, and more. This series is for anyone who wants to move beyond the basic concepts of Microsoft Access.  more...
From Software Training Academy, Inc
The JSP Standard Tag Library instructor led trainingon-line e-learning cbt (computer based) ...nd deletes on relational data using SQL actions. Manage queries and updates in transaction contexts. Parse XML content from a variety of sources. Derive information from parsed XML content using XPath expressions. Implement conditional processing and loops based on XML information. Apply XSLT transformations to XML content. Implement a simple Web service that reads and writes SOAP.  more...
JDBC Programming Rev 5 instructor led trainingon-line e-learning cbt (computer based) ...s. Use prepared statements to produce reusable database queries and optimize execution time. Use callable statements to access database procedures. Use scrollable and updatable results sets for more robust solutions. Use commit, rollback, and savepoint to build transactional systems. Use batch processing for efficient handling of large datasets. Understand the use of RowSets and  more...
Java Server Pages JSP instructor led trainingon-line e-learning cbt (computer based) ...nd deletes on relational data using SQL actions. Manage queries and updates in transaction contexts. Derive information from parsed XML content using XPath expressions. Implement conditional processing and loops based on XML information. Apply XSLT transformations to XML content. Implement a simple Web service that reads and writes SOAP. Duration: 4 days. Prerequisites: No formal  more...
XML Programming Using Java instructor led trainingon-line e-learning cbt (computer based) ...ML persistence using the JAXB. Write simple and complex queries into XML document content using XPath. Use XSLT for XML-to-XML transformations. Use the built-in template rules correctly to process the right source information. Use mode and priority to control template matching. Control exact production of text, HTML and XML elements, and whitespace. Derive source document content  more...
XSLT instructor led trainingon-line e-learning cbt (computer based) ...expect. LEARNING OBJECTIVES Write simple and complex queries into XML document content using XPath. Harness the built-in template rules to process just the right source information, getting maximum leverage from the XSLT processor. Control the exact production of text, HTML and XML elements, and whitespace. Use mode and priority to control template matching. Use looping and  more...
SQL Server 2005 Transact SQL T-SQL instructor led trainingon-line e-learning cbt (computer based) ...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 can now use .NET languages like C# and Visual  more...
SQL Server 2005 Transact SQL T-SQL with Additional Topics instructor led trainingon-line e-learning cbt (computer based) ...ding 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 Transact-SQL programming language including improved support for error handling and hierarchical queries, and  more...
SQL Server 2005 instructor led trainingon-line e-learning cbt (computer based) ...w 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 language including improved support for error handling and hierarchical queries, and  more...
SQL Server 2005 - Additional Topics instructor led trainingon-line e-learning cbt (computer based) ...xpressions, and learn techniques for dealing with complex queries Explore advanced techniques for working with complex data structures Learn how to use source control with SQL Server Management Studio Discover new XML capabilities in SQL Server 2005 Course Duration: 3 days Prerequisites: This course assumes that students have a basic understanding of Windows operating  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 - Advanced SQL instructor led trainingon-line e-learning cbt (computer based) ... 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 directly from the database"), Oracle10g regular  more...
Advanced Java Programming Rev 5 instructor led trainingon-line e-learning cbt (computer based) ...s. Use prepared statements to produce reusable database queries and optimize execution time. Use callable statements to access database procedures. Use scrollable and updatable results sets for more robust solutions. Use commit, rollback, and savepoint to build transactional systems. Use batch processing for efficient handling of large datasets. Use the Java 5.0 Core API and  more...
From Learningdom
BO XI R2 training ...mizing InfoView, Creating Web Intelligence Documents with Queries, Restricting Data Returned by a Query, Report Design in the Java Report Panel, Enhancing the Presentation of Reports, Formatting Reports, Creating Formulas and Variables, Synchronizing Data, Analyzing Data, Sharing Web Intelligence Documents, Working in Interactive View, Alternative Query Techniques, Character and Date String  more...
SQL and PLSQL Training instructor led trainingon-line e-learning cbt (computer based)computer lab ...Queries, Data sorting and restricting, Functions, Data from Multiple Tables, Group By Clause, Create Table, Alter Table, Constraints, More Constraints, Indexes, Views, Set operators, SQL Aggregate Functions PL/ SQL PL/ SQL Basics, Using SQL*Plus for PL/ SQL, Using TOAD for PL/ SQL, All about variable declaration, PL/ SQL Looping, Conditional Logic, : DML within PL/ SQL, Cursors,  more...
From Content Writing Training Program
Content Writing Training Program Does the question a How to Write?a cross your mind? Do you want to know what it takes to be a writer? Do you want to know the careers in writing? Then, you are at the right place! For all the above details and more visit: www. contentwritingtraining. com The Content Writing Training is a simple and comprehensive program which helps you acquire the skills required to be an excellent writer.  more...
From Wavelength
Content Writing for the Web Certificate Online Course on-line e-learning cbt (computer based)study at homegroup study and discussionself directed Wavelength's ONLINE CERTIFICATE COURSE - CONTENT WRITING FOR THE WEB (CWWC Online) =============================================================================== (Course Website: http://www. vibrantwavelength. com/ content_writing_for_web_online. htm) Who Should Join this Course? ============================ Individuals with good writing skills, who wish to: * write content for the  more...
Instructional Design for Senior Professionals on-line e-learning cbt (computer based)study at homegroup study and discussionself directed Wavelength's ONLINE CERTIFICATE COURSE - INSTRUCTIONAL DESIGN for SENIOR PROFESSIONALS (IDSP Online) =============================================================================== (Course Website: http://www. vibrantwavelength. com/ idsp_online. htm) Who Should Join this Course? ============================ * Training Managers, eLearning Project Managers, Delivery Managers, Content  more...
E-Learning for Trainers on-line e-learning cbt (computer based)study at homegroup study and discussionself directedtrain the trainer Wavelength's ONLINE CERTIFICATE COURSE - ELEARNING FOR TRAINERS (ELT Online) =============================================================================== (Course Website: http://www. vibrantwavelength. com/ elt_online. htm) Who Should Join this Course? ============================ * Trainers, Training Professionals, Corporate/ BPO Trainers, Training Content Developers, Teachers,  more...
Instructional Design for Trainers on-line e-learning cbt (computer based)study at homegroup study and discussionself directedtrain the trainer Wavelength's ONLINE CERTIFICATE COURSE IN INSTRUCTIONAL DESIGN FOR TRAINERS (IDT Online) =============================================================================== (Course Website: http://www. vibrantwavelength. com/ idt_online. htm) Who Should Join this Course? ============================ * Trainers, Training Professionals, Corporate/ BPO Trainers, Training Content Developers,  more...
Wavelength - Online Certificate Course In Instructional Design And Content Writing - IDCWC Online on-line e-learning cbt (computer based)study at homegroup study and discussionself directed Wavelength's ONLINE CERTIFICATE COURSE IN INSTRUCTIONAL DESIGN AND CONTENT WRITING (IDCWC Online) =============================================================================== (Course Website: http://www. vibrantwavelength. com/ idcwc_online. htm) Who Should Join this Course? ============================ * Instructional Designers, Training Professionals, Content Writers, Technical  more...
From The Virtual Training Company
Microsoft Access 2003 on-line e-learning cbt (computer based) Microsoft Access 2003 now makes it easier for anyone to use, or create powerful database solutions to help organize, access, and share data, in no time. Virtual Training Company author, Dave Mercer, guides users through the Access 2003 set of powerful tools that are easy enough to learn for beginners, but sophisticated enough for the most complex developers. Mercer first covers the basics of using  more...
Microsoft Access 2000 on-line e-learning cbt (computer based) Microsoft Access 2000 gives you powerful new tools for managing your data. You can share your database with coworkers over an intranet, find and retrieve information quickly, and take advantage of pre-packaged automated solutions to quickly create databases. In Virtual Training Company's tutorial, author Lorie Flenner begins very basic, explaining the key concepts behind Access and relational  more...
From Teach Me IT
Tuning Oracle8 Database Performance on-line e-learning cbt (computer based)study at home ...ts of Oracle, such as database operations and distributed queries, applications and operating system, redo log buffer and shared buffer pools, and I/O. Describe Performance Tuning List the steps of the tuning method Diagnose performance problems in an existing system List the diagnostic tools Tune database operations Tune distributed queries Tune applications Tune operating system  more...
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...
Optimizing and Securing an Oracle8 Data Warehouse on-line e-learning cbt (computer based)study at home Optimizing and Securing an Oracle8 Data Warehouse is the third course of the Oracle8 Data Warehousing curriculum. This course acquaints users to the various methods that can be employed to secure and optimize an Oracle8 data warehouse. The course explains the concepts of tuning the data warehouse, creating backups, recovering and archiving data. The course extensively covers aspects related to  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...
Implementing an SQL 7.0 Data Warehouse on-line e-learning cbt (computer based)study at home ...udents to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for accessing a data source. After completing this course, the student will be able to: Describe the considerations involved in designing a database Create files  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...
Building a Data Warehouse on-line e-learning cbt (computer based)study at home ...y different kinds of temporal data and construct temporal queries Develop temporal transformations from subject areas to the warehouse model Define the dimensional model and its components Define the flow of products through a value chain Convert the dimensional model to the warehouse model Identify types of schema Implement the dimensional schema as a star schema Select the hardware  more...
Creating Queries & Forms with Access 2002 on-line e-learning cbt (computer based)study at home ...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 guides users in  more...
Using Advanced Data Management Techniques on-line e-learning cbt (computer based)study at home The Using Advanced Data Management Techniques WBT is the third course in the Office XP: Excel 2002 curriculum. This course teaches the users how to create lists in Excel and manage them by filtering, sorting, subtotaling data, and specifying validation criteria. Additionally, it explains the procedures involved in importing data in Excel from external sources, such as Access databases, text files,  more...
From Skillspride Online Training
Informix SQL Advanced on-line e-learning cbt (computer based) This course will provide the reader with the knowledge to control database security and integrity, perform advanced database queries, optimise query efficiently and control the database within the UNIX environment  more...
Lotus Notes 4.6 Advanced User on-line e-learning cbt (computer based) This course is an advanced presentation of some of the more technical user features of Lotus Notes. Users who appreciate a challenging experience will enjoy venturing into Notes database design and automation features. Readers will learn to use and create queries, full text indexes, agents and SmartIcons. To import & export data, link & embed objects and write basic formulas, plus understand  more...
Lotus Notes 4.5 Advanced User on-line e-learning cbt (computer based) This course is an advanced presentation of some of the more technical user features of Lotus Notes. Users who appreciate a challenging experience will enjoy venturing into Notes database design and automation features. Readers will learn to use and create queries, full text indexes, agents and SmartIcons. To import & export data, link & embed objects and write basic formulas, plus understand  more...
Lotus Approach Millennium Edition Introduction on-line e-learning cbt (computer based) Lotus Approach Millennium Edition is a relational database forming part of the SmartSuite office applications suite. This course is designed to allow readers to get to grips with the basic features of Approach. Readers will be able to create databases; view data, design data queries and produce reports. The course also provides an introduction to database theory and practice, plus hints and tips  more...
Microsoft Internet Explorer 5.0 Internet Introduction on-line e-learning cbt (computer based) This course is a self-paced introduction to browsing the internet and sending e-mail using MS Internet Explorer and MS Outlook Express. You can work through the step-by-step examples in your own time and at your own speed. Completing the lessons will allow you to browse the world wide web and send e-mail with confidence. As well as browsing and e-mail, topics of study include the background and  more...
CLAIT Level 2 - Database Solutions with Access 2002 on-line e-learning cbt (computer based) This course is designed to help you to obtain the skills and knowledge required for CLAIT Level 2 Unit 3 " and Unit 11 Database Solutions. You will learn to use Access 2002 to create a database and database reports. You will learn to design and format tables, forms, reports, and queries. You will also be able to use calculated fields and functions to group and summarise data in queries and  more...
Microsoft Access 97 Intermediate on-line e-learning cbt (computer based) This intensive course is designed to give existing Access 97 users additional skills and knowledge on using the many features and functions of this software to make them more efficient and effective when processing data with Access. This entirely 'hands on' course will give readers experience in producing database applications and the ability to create a variety of data views, queries and reports.  more...
Microsoft Access XP 2002 Level 2; Intermediate on-line e-learning cbt (computer based) To build on some existing database design and/or user experience that may have been gained from our " Access XP 2002 Level 1; Introduction course. The reader will learn about action queries, formatting text, printing a document, reports, web publishing, database replication and data access pages. Microsoft  more...
Microsoft Access 2002 (XP) Introduction on-line e-learning cbt (computer based) MS Access 2002 (XP) is the latest database from Microsoft designed specifically for a graphical environment. This courses is designed to teach the reader to create and update a simple database using the application Microsoft Access 2002. You will learn to add and edit records, create a table and apply basic field properties and to produce simple queries, forms and reports.  more...
Microsoft Access 2002 (XP) Intermediate on-line e-learning cbt (computer based) This intensive course will help readers to build on their basic understanding of Microsoft Access 2002, in order to produce more comprehensive and robust database applications. Readers will get experience in the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and reports.  more...
Microsoft Access 2002 (XP) Advanced on-line e-learning cbt (computer based) To develop a relational database using Microsoft Access. Readers will learn to design databases incorporating different types of table relationships, use data validation and referential integrity, create queries to update and summarise data, build custom forms and reports for multiple data sources and create output for the internet.  more...
Microsoft Access 2000 Intermediate on-line e-learning cbt (computer based) This intensive course is designed to give existing Access 2000 users additional skills and knowledge on using the many features and functions of this software to make them more efficient and effective when processing data with Access. This entirely 'hands on' course will give readers experience in producing database applications and the ability to create a variety of data views, queries and  more...
Microsoft Access 2000 Intermediate on-line e-learning cbt (computer based) This intensive course is designed to give existing Access 2000 users additional skills and knowledge on using the many features and functions of this software to make them more efficient and effective when processing data with Access. This entirely 'hands on' course will give readers experience in producing database applications and the ability to create a variety of data views, queries and  more...
Microsoft Access 2003 Introduction on-line e-learning cbt (computer based) This course is designed to help you to obtain the skills required to update records in a database and to use Access to create a simple database. You will learn to design tables and queries and to create forms and reports using built-in tools.  more...
Microsoft Access 2003 Advanced on-line e-learning cbt (computer based) This course will help you to customise and manage a database application using Microsoft Access. You will learn to use macros and command bars, link to external data sources and update data using action queries. You will also learn the basics of managing a shared database. You will learn how to use the User Level Security Wizard to secure the application and create a split-end database for use on  more...
Microsoft Access XP 2002 Level 2; Intermediate on-line e-learning cbt (computer based) To build on some existing database design and/or user experience that may have been gained from our " Access XP 2002 Level 1; Introduction course. The reader will learn about action queries, formatting text, printing a document, reports, web publishing, database replication and data access pages. Microsoft  more...
Microsoft Access 2002 (XP) Introduction on-line e-learning cbt (computer based) MS Access 2002 (XP) is the latest database from Microsoft designed specifically for a graphical environment. This courses is designed to teach the reader to create and update a simple database using the application Microsoft Access 2002. You will learn to add and edit records, create a table and apply basic field properties and to produce simple queries, forms and reports.  more...
Microsoft Access 2002 (XP) Intermediate on-line e-learning cbt (computer based) This intensive course will help readers to build on their basic understanding of Microsoft Access 2002, in order to produce more comprehensive and robust database applications. Readers will get experience in the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and reports.  more...
Microsoft Access 2002 (XP) Advanced on-line e-learning cbt (computer based) To develop a relational database using Microsoft Access. Readers will learn to design databases incorporating different types of table relationships, use data validation and referential integrity, create queries to update and summarise data, build custom forms and reports for multiple data sources and create output for the internet.  more...
ECDL 4 Database with Access 2003 on-line e-learning cbt (computer based) This course is designed to help you to obtain the skills and knowledge required for ECDL Module 5 " (Syllabus 4.0). You will learn to use Access to create a relational Database and database queries, forms, and reports. You will learn to design and format tables, forms, reports, and queries. You will also be able to use calculated fields and functions to group and summarise data in queries and  more...
ECDL Database with MS Access 2002 on-line e-learning cbt (computer based) This course is designed to prepare readers for the ECDL/ICDL module 5 examination. The course will allow reader to create, edit and format a simple database consisting of tables, queries, forms and reports using Access 2002. The course follows ECDL/ICDL syllabus version 3.0.  more...
ECDL AM5 Advanced Database with Access 2002 on-line e-learning cbt (computer based) This course is designed to help you to obtain the skills and knowledge required for ECDL AM5 " Advanced. You will learn to use Access 2002 to create a relational database, design queries, forms, and reports, and automate actions using macros. You will learn how to design a relational Database structure and create queries, forms, and reports based on multiple tables. You will also learn to import,  more...
ECDL 4 Database with Access 2000 on-line e-learning cbt (computer based) This course is designed to help you to obtain the skills and knowledge required for ECDL Module 5 " (Syllabus 4.0). You will learn to use Access to create a relational Database and database queries, forms, and reports. You will learn to design and format tables, forms, reports, and queries. You will also be able to use calculated fields and functions to group and summarise data in queries and  more...
A+ Syllabus 10 - Module 9 - Customer Service Techniques on-line e-learning cbt (computer based) At the end of this course you will be able to: describe the principles that are important in a basic approach to customer queries; describe the type of words, inflection, tone and body language that should be used when communicating with a customer.  more...
A+ Module 9 - Customer Service Techniques on-line e-learning cbt (computer based) At the end of this course you will be able to: describe the principles that are important in a basic approach to customer queries; describe the type of words, inflection, tone and body language that should be used when communicating with a customer.  more...
From The Virtual Training Company
Microsoft Excel 2002 on-line e-learning cbt (computer based) Microsoft Excel 2002 offers tools that make it easy to access, connect, and analyze critical data, proving that Excel spreadsheets are no longer just for financial professionals. Virtual Training Company author Julia Kelly will instruct users on how to use this powerful spreadsheet program. Excel 2002 allows users to find and format data more quickly by utilizing context sensitive options as tasks  more...
Macromedia Dreamweaver MX - Web Applications on-line e-learning cbt (computer based) ...ll teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia's Live Object and Server Behaviors with ASP, ASP.NET  more...
tcw11-gfc--11/25/09-22:44:26-(16702)[A]-[A]-[A]