Online Data Access eLearning
Data Access Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Access 2002 Advanced

...as Synchronizing Multiple Replicas Resolving Conflicts Data Access Pages Selecting Source Data For A Page Applying A Theme Viewing A Data Access Page Editing A Data Access Page Viewing A Page In Internet Explorer Lesson 4: Introduction To Macros Introduction Lesson Objectives Introduction To Macros Macro Properties Macro Basics Running A Macro Customizing Macros Verifying
more...
Access 2002 Advanced
Access 2002 Intermediate

...operties Printing A Form Lesson 4: Charts, Queries & Data Access Pages Introduction Lesson Objectives The Chart Wizard Selecting A Source Specifying Fields Selecting A Chart Type Laying Out Chart Data Finishing A Chart Modifying A Chart Creating A Select Query Adding Fields To A Select Query Running A Query Sorting With A Query Showing & Hiding Fields Using Criteria In A
more...
Access 2002 Basic

...Zooming Out Displaying Multiple Pages Form Design View Data Access Pages Macros Modules Closing The Database Window Exiting Access Lesson 2: Working With Tables Introduction Lesson Objectives Opening Access Creating A New Database Using The Table Wizard Selecting Fields Removing A Field Renaming A Field Design View Entering Data Creating A New Record Resizing A Field
more...
Database Data Management

Database Data Management
To describe database data management and data access
more...
Oracle 11i Oracle Projects Security Model and Page Layouts

Oracle 11i: Oracle Projects Security Model and Page Layouts Oracle
To use Oracle Projects to secure function and data access within Projects applications, and use page layouts to manipulate views of project information
more...
Access XP Proficient Expert

...e To The World Wide Web - Access & The World Wide Web - Data Access Pages - Create A Data Access Page Access XP / 2002 (Expert) Build & Modify Databases Build A Relational Database - Defining Relationships - Establish A One-To-Many Relationship - Establish A Many-To-Many Relationship Control Data Entry In Tables - What Is A Validation Rule? - Use Validation Rules -
more...
Designing Access to SQL Server Data

Designing Access to SQL Server Data Microsoft
recognize how to design and utilize data access technologies to manage SQL Server and access SQL Server Data
more...
Designing Efficient Application Access

Designing Efficient Application Access Microsoft
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

Designing Queries in SQL 2005 Microsoft
recognize how to design and execute queries in SQL Server 2005, utilizing XQuery and the XML Data Modification Language
more...
Designing a SQL Server 2005 Cursor Strategy

Designing a SQL Server 2005 Cursor Strategy Microsoft
recognize how to design and implement an appropriate cursor strategy in SQL Server 2005
more...
Designing a SQL Server 2005 Transaction Strategy

Designing a SQL Server 2005 Transaction Strategy Microsoft
recognize the different levels of isolation and granularity to manage concurrency and execute a transaction strategy in SQL Server 2005
more...
SQL Server 2005 Error Handling Techniques

SQL Server 2005 Error Handling Techniques Microsoft
recognize how to design code for validating input, for error handling and for user-defined messages in SQL Server 2005
more...
Optimizing Query Performance and Index Strategies

Optimizing Query Performance and Index Strategies Microsoft
recognize how to optimize query performance and indexing strategies in SQL Server 2005
more...
Optimizing Storage in SQL Server 2005

Optimizing Storage in SQL Server 2005 Microsoft
recognize how to optimize database storage and SQL Server performance
more...
Scaling Applications and Resolving Performance Issues

Scaling Applications and Resolving Performance Issues Microsoft
recognize how to scale out applications to enterprise level and troubleshoot and identify performance issues that result
more...
Optimizing SQL Server 2005 Performance

Optimizing SQL Server 2005 Performance Microsoft
To identify ways of optimizing the performance of SQL Server 2005
more...
Optimizing a Database Data Recovery Plan for SQL Server 2005

Optimizing a Database Data Recovery Plan for SQL Server 2005 Microsoft
To identify potential causes of database failure, and select the appropriate fault tolerance and restore strategies for a scenario
more...
Monitoring and Maintaining a Database in SQL Server 2005

Monitoring and Maintaining a Database in SQL Server 2005 Microsoft
To monitor a database, automate database maintenance tasks, and configure reporting services for SQL Server 2005
more...
Managing Database Data in a SQL Server 2005 Environment

Managing Database Data in a SQL Server 2005 Environment Microsoft
To recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database
more...
Managing Data Between Servers and Databases

Managing Data Between Servers and Databases Microsoft
To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005
more...
Managing and Maintaining Database Security in SQL Server 2005

Managing and Maintaining Database Security in SQL Server 2005 Microsoft
To identify strategies for auditing database security at the server and user levels, and determine the appropriate way to protect against and respond to different types of attack on SQL Server
more...
MICROSOFT SQL SERVER 2005 DESIGNING OPTIMIZING DATA ACCESS

MICROSOFT SQL SERVER 2005: DESIGNING & OPTIMIZING DATA ACCESS Microsoft
more...
MICROSOFT SQL SERVER 2005 DATABASE MAINTENANCE

MICROSOFT SQL SERVER 2005: DATABASE MAINTENANCE Microsoft
more...
CompTIA Security 2008 Public Key Infrastructure Access Security

CompTIA Security 2008: Public Key Infrastructure & Access Security CompTIA SY0-201 CompTIA Security 2008 Edition
Access security, both within a network and on the Internet, is paramount to corporate security. Modern network environments use key encryption technologies in order to provide security and availability to both employees and customers. This course explores the use of certificate
more...
SAP BusinessObjects Crystal Reports

SAP BusinessObjects: Crystal Reports SAP
Business data comes from a variety of sources and is stored in various formats. The volume and variety of business data presents immense potential for understanding and responding to customer requirements and business process optimization. In order to realize this potential, SAP provides the Crystal Reports reporting tool. Crystal Reports has
more...
Access 2003 and the Web

Access 2003 and the Web Microsoft
To make Access databases use web resources with hyperlinks and data access pages
more...
Managing ADO NET Connections Commands with VB 2008

Managing ADO.NET Connections & Commands with VB 2008 Microsoft
ADO.NET connections and commands are crucial components of building data-driven applications. This course examines managing connections using connection pools and configuration files, as well as stored procedures, and using generic data-access code to establish a connection. Specific topics covered include optimizing ADO.NET
more...
Data Service Integration With VB 2008 and ASP NET 3 5

Data & Service Integration With VB 2008 and ASP.NET 3.5 Microsoft
Visual Basic 2008 and ASP.NET 3.5 provide developers with the ability to integrate both data and services into an ASP.NET 3.5 Web application. This course identifies the steps for displaying and modifying data in an ASP.NET Web application, by accessing data using data-bound and data source controls, as well as ADO.NET, and
more...
NET Framework 4 0 Data Integration with VB 2010

.NET Framework 4.0: Data Integration with VB 2010 Microsoft Microsoft Certified Technology Specialist .Net Framework 4, Web Applications Development (Exam 70-515)
Visual Basic 2010 and ASP.NET 4.0 provide developers with the ability to integrate both data and services into an ASP.NET 4.0 Web application. This course identifies the steps for displaying and modifying data in an ASP.NET Web
more...
Oracle Database 11g R2 Backup Recover Archive Repair Data

...offers new and improved features to ensure for continuous data access, even during unplanned failures and scheduled maintenance tasks. New RMAN features make it easier to backup, recover and duplicate databases in a timely manner while minimizing data loss. It also offers Flashback technology, giving DBAs additional protection against data loss, as well as the Data Recovery Advisor which
more...
Working with SharePoint Data

Working with SharePoint Data Microsoft Microsoft Certified Technology Specialist SharePoint 2010, Application Development (Exam 70-573)
Microsoft SharePoint 2010 is a business collaboration platform where people can collaborate, set up web sites, manage documents, and provide intelligence to make key business decisions. This course provides insight into SharePoint data access via the Client
more...
NET Framework 4 Data Integration with C 2010

.NET Framework 4: Data Integration with C# 2010 Microsoft Microsoft Certified Technology Specialist .Net Framework 4, Web Applications Development (Exam 70-515)
Visual Basic 2010 and ASP.NET 4 provide developers with the ability to integrate both data and services into an ASP.NET 4 Web application. This course identifies the steps for displaying and modifying data in an ASP.NET Web
more...
Getting Started With ADO NET 4 Connections Commands Using C 2010

...crosoft Certified Technology Specialist .Net Framework 4, Data Access (Exam 70-516)
ADO.NET allows developers to create applications that are driven by data and services. This course identifies the various ways to manage ADO.NET connections and also details how to access data by using command objects and the DataReader object. Specific topics covered in the course include an introduction
more...
Managing ADO NET 4 Connections Commands with C 2010

...crosoft Certified Technology Specialist .Net Framework 4, Data Access (Exam 70-516)
ADO.NET connections and commands are crucial components of building data-driven applications. This course examines managing connections using connection pools and configuration files, as well as stored procedures, and using generic data-access code to establish a connection. Specific topics covered include
more...
Getting Started with ADO NET 4 DataSets Using C 2010

...crosoft Certified Technology Specialist .Net Framework 4, Data Access (Exam 70-516)
ADO.NET DataSet objects allow developers to utilize cached versions of data when working within disconnected data environments. This course examines the various aspects of DataSets and their role as one of the key components of the ADO.NET architecture. Specific topics covered include creating DataSets
more...
Viewing Navigating Data with ADO NET 4 DataSets Using C 2010

...crosoft Certified Technology Specialist .Net Framework 4, Data Access (Exam 70-516)
The ability to view and navigate data in an efficient fashion is vital to any robust data application. This course explains how to accomplish this using ADO.NET DataSets and Visual C# 2010. Specific topics covered include how to manage and constrain data relationships in a DataSet using DataRelation
more...
Updating ADO NET DataSets With C 2010

...crosoft Certified Technology Specialist .Net Framework 4, Data Access (Exam 70-516)
ADO.NET DataSets allow developers to easily update and manage data sources using Visual C# 2010. This course examines how DataSets are used to update source data and also how to manage the integrity of the data being updated. Specific topics covered include updating data sources, committing changes to data
more...
ACCESSING DATA WITH MS NET FRAMEWORK FOR C DEVELOPERS 70-516

ACCESSING DATA WITH MS.NET FRAMEWORK FOR C# DEVELOPERS (70-516) Microsoft Microsoft Certified Technology Specialist .Net Framework 4, Data Access (Exam 70-516)
more...
From Online Training Directory
Client/Server Development and Remote Data Access in Visual Basic


...l Project. The first section teaches different methods of data access and manipulation by creating a standalone Visual Basic application that binds a MS Access database. The second section introduces the student to communicating over the Internet with TCP/IP by creating simple server and client Visual Basic applications that utilize the Winsock control. The final project section builds on
more...
Client/Server Development and Remote Data Access in Visual Basic
Access 2000 Expert



...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, reports, and data access pages. In
more...
Access 2000 Level 2



...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 learn techniques designed to
more...
Access 2000 Level 3



...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 maintenance features are covered in the
more...
Access 2000 MOUS



...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 reports.
Students will learn a
more...
Microsoft Access 2002 Expert



...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 maintenance features are covered in the
more...
Microsoft Access 2002 Level 2



...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 understanding of how to
more...
Microsoft Access 2002 Level 3



...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 maintenance features are covered,
more...
Office 2000 Advanced



...se 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 across applications, and prepare
more...
Office 2000 Intermediate



...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 presentations by working with
more...
Office XP (2002) Intermediate



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...
From 123-CBT Computer Based Training
Advanced Language Features of Microsoft VB NET
To explain the new object-oriented features of Visual Basic .NET, data access with ADO.NET, and strategies for migration
more...
Advanced Language Features of Microsoft VB NET
Data Access with ASP NET
To demonstrate how to use data binding and file management with Web Forms
more...
Access 2000 Expert
1. Access 2000 (Expert) Basics Work With Toolbars The Menu Bar & Other Toolbars Install Add-In Programs What Is An Add-In? Install & Load Add-Ins Unload Add-Ins Work With Previous Versions Of Access Access 2000 & Previous Versions Of Access Access 2000 & Access 97 Access 2000 & Access 95 Convert A Database Set Startup Options Set Startup Options Help In Access 2000 The Office Assistant Microsoft
more...
Visual InterDev 6 0 Active Server Pages and Data Access

C ourse Overview
This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to identify the features of Active Server Pages (ASP); create a server script and debug the server-side script;
more...
Visual InterDev 6 0 Accessing Remote Data

...ipulate database records by using SQL, stored procedures, data access models and cursors.
Implement business rules by using triggers.
Identify the components of Remote Data Services (RDS).
Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS).
Identify the benefits of using COM components.
Create a COM component
more...
C Programming - Part 4

...tisfied to delete a node in a given situation. Match the data access methods with their features. Identify the code used to create a linked list index. Identify the code used to write the linked list index to disk. Identify the code used to handle the insertion of a node in an existing linked list index. Identify the code used to handle deletions of records from an existing linked list
more...
Oracle SQL Tuning Diagnostics and Tuning Schema

...ormance problems with a SQL statement.
Use efficient data access methods that are available for the optimizer.
Create the appropriate database objects before starting to tune SQL statements.
C ontent Emphasis
Skills-Based
A udience
Application Developers, Database Administrators, and Designer/Developers.
T otal Learning Time
6 - 8 Hour(s)
Course
more...
Oracle Form Builder Including Reusable Oracle Components

...mplications specific to database calls using a particular data access mechanism.
Identify the guidelines to base a data block on a stored procedure.
Identify the restrictions on performing database operations on data source objects.
Unit 2: Charts, Reports and Timers: Integration in Forms
Duration: 2 Hour(s)
Create a chart item in a Form module by using the Chart Wizard.
more...
Oracle8 Performance Tuning Strategies and Techniques

...rprise Manager (OEM) tuning tools.
Use the available data access methods to tune the logical design of the database.
List the primary steps for operating system tuning.
Identify similarities between operating system and database tuning.
C ontent Emphasis
Skills-Based
A udience
Database administrators, system administrators, applications designers and
more...
Oracle8 Performance Tuning Managing Memory and Disk I O

...performance based on a smaller cache size.
Identify the data access methods that can cause extremes of hit ratios.
Select the appropriate guidelines in evaluating the cache hit ratio.
Match the buffer pool names with their functions.
Identify the initialization parameters used when creating multiple buffer pools.
Perform the steps to define the number of buffers for an instance using
more...
Office 2000 - Web Integration

...in Excel.
Add form fields to Word documents.
Create a data access page in Access.
Identify the functions of Office Web components.
Add a Spreadsheet component to a FrontPage Web page.
Add a chart component to a FrontPage Web page.
Add a PivotTable to a FrontPage Web page.
Unit 2: Publishing and Editing Documents
Duration: 2 - 3 Hour(s)
Preview Office documents as Web
more...
Visual InterDev 6 0 Active Server Pages and Data Access

Course Overview
This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to identify the features of Active Server Pages (ASP); create a server script and debug the server-side script; set
more...
Visual InterDev 6 0 Accessing Remote Data

...ipulate database records by using SQL, stored procedures, data access models and cursors.
Implement business rules by using triggers.
Identify the components of Remote Data Services (RDS).
Identify the methods of navigating and manipulating data by using the components of Remote Data Services (RDS).
Identify the benefits of using COM components.
Create a COM component
more...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 1

...tics. Students will also learn the strategy for Universal Data Access and the visual data access tools that make it easy for Visual Basic programmers to create data access applications. L earn To: Develop a simple application using Visual Basic 6.0. Access, organize, and present data using Visual Basic's Universal Data Access features. C ontent Emphasis Skills-Based A
more...
Visual C 6 0 Designing Implementing Desktop Applications - Part 2

...g a component interface. Identify the benefits of using data access, the data access capabilities of different libraries and the benefits of various data access technologies. C ontent Emphasis Skills-Based A udience This course is designed for programmers looking to develop applications using MFC library and Microsoft Visual C++. Participants should have completed the first
more...
Visual C 6 0 Designing Implementing Desktop Applications - Part 5

...antages of using DAO to connect to a database. Match the Data Access Objects (DAO) database classes supported by MFC with their functions. Create a DAO database application. Modify a DAO database application to manipulate the database. Modify the DAO application to filter the records that satisfy the criteria entered by the user. Match the data members of database exception classes with
more...
Visual C 6 0 Designing Implementing Distributed Applications - Part 3

...ess data from tables and manipulate the data. Implement data access in applications through stored procedure model and cursors. Create transactions and implement locking strategies. C ontent Emphasis Skills-Based A udience This course is designed for programmers looking to develop applications using MFC library and Microsoft Visual C++. Participants should have completed the
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4

... from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local Cubes, Client/Server Cache; identify the features of MS English Query; and create and deploy an English Query application. L earn To: Identify the methods of aggregating and accessing data from relational
more...
Access 2000 Expert User

Course Overview 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. L earn To: Create
more...
Oracle8i Performance Tuning Architecture Strategy

...dentify appropriate OEM tuning tools. Use the available data access methods to tune the logical design of the database. List the primary steps for operating system tuning. Identify similarities between operating system and database tuning. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support
more...
Enterprise Connectivity with J2EE V1 4 Web Services Patterns

This course will address the core and advanced features of J2EE SDK 1.4: Enterprise Connectivity.
Learn To:
Identify features of Web services.
Identify benefits of service-oriented architecture (SOA).
Identify features of Simple Object Access Protocol (SOAP).
Identify features of J2EE patterns.
Match J2EE patterns with their descriptions.
Identify features of the
more...
Enterprise Connectivity with J2EE V1 4 Web Services Patterns

This course will address the core and advanced features of J2EE SDK 1.4: Enterprise Connectivity.
Learn To:
Identify features of Web services.
Identify benefits of service-oriented architecture (SOA).
Identify features of Simple Object Access Protocol (SOAP).
Identify features of J2EE patterns.
Match J2EE patterns with their descriptions.
Identify features of the
more...
Office XP New Features Part 2 Access Outlook FrontPage

...ct as an XML document. Create a pivot table on a data access page. Identify the features of the complex script interface. Identify new features of Design View for data access pages. Save a form as a data access page. Unit 2: New Features in Outlook 2002 2 hours Identify the enhancements to the message header area in Outlook 2002.
more...
Access XP Proficient User

...et Wizard that are used to import an Excel worksheet to a data access page. Link an existing Microsoft Access table to a database. Publish a table to Microsoft Excel. Audience The intended audience for this course are Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, and Database Administrators. Typically learners will work in an
more...
Access XP Expert User

Course Overview 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. Learn To Create an update query. Create a delete query. Create an append query. Create a form in Design view.
more...
XML Building XML-Based Web Applications Part 3

...n covers treatment of Data Islands. The basic elements of data access and the Web are covered in addition to the binding of HTML elements to XML data and manipulation of data sources. Learn To Identify features of cascading style sheets. Identify features of XSL. Identify features of an XML document tree. Identify benefits of ActiveX Data Object (ADO)
more...
Office XP - Planning Collaborative Solutions Curriculum

...al areas of data sharing within SharePoint Portal Server, data access and search mechanisms. Digital dashboards are covered in considerable detail of setup, content management, Web parts and using with Office XP developer. Lastly, the curriculum then moves on to treatment of collaborative applications, covering principally Exchange 2000 Server and Web storage systems, workflow design and
more...
Office XP Collaborative Solutions Part 2

...al areas of data sharing within SharePoint Portal Server, data access and search mechanisms. Digital dashboards are covered in considerable detail of setup, content management, Web parts and using with Office XP developer. Lastly, the course then moves on to treatment of collaborative applications, covering principally Exchange 2000 Server and Web storage systems, workflow design and processes,
more...
Defining Microsoft NET Solution Architectures Part 3

This is the third of a four-part curriculum that prepares the learner for Exam 70-300. The course is devoted to the coverage of the Physical Design phase of the solution design process. Coverage is given in turn to Physical Design goals and models, Physical data modelling, the Presentation Layer, and Design Goals behind the Physical Design. A case study on the Physical Design phase completes the
more...
Defining Microsoft NET Solution Architectures Part 4

This is the fourth of a four-part curriculum that prepares the learner for Exam 70-300. This course focuses on security considerations within the solution design, and .NET Framework security strategies. It then looks in turn at the Stabilization and the Deployment stages of the project. It closes with coverage of Standards and Processes. Three case studies address the three main areas of the
more...
Defining Microsoft NET Solution Architectures Part 3

This is the third of a four-part curriculum that prepares the learner for Exam 70-300. The course is devoted to the coverage of the Physical Design phase of the solution design process. Coverage is given in turn to Physical Design goals and models, Physical data modelling, the Presentation Layer, and Design Goals behind the Physical Design. A case study on the Physical Design phase completes the
more...
Database Technologies Relational Database Fundamentals

...data design. This course will also cover the evolution of data access and the role that databases and associated enabling technologies play in today's corporate environments. Students should leave this course with a solid foundation in the 'what' and 'why' of relational databases, plus an introduction to the 'how' of data modeling and design. Learn To: o Identify database concepts,
more...
Database Technologies Introduction to SQL

... and associated variations, needed to perform fundamental data access and manipulation on a relational database. After taking this course, students will have a solid foundation in two basic aspects of SQL: Data Definition Language (DDL - creating databases and tables) and Data Manipulation Language (DML - adding, altering, and querying data). Learn To: o Identify what SQL is, why and where
more...
Visual Basic NET-Web Based Development Curriculum

..., user input validation, ADO.NET database connections and data access. The student is also taught the creation and use of XML Web services and the configuration and deployment of Web applications in Visual Basic.NET. This curriculum consists of five Skill Builder courses: Microsoft Visual Basic.NET-Web Development Part 1: Web Forms and Controls Microsoft Visual Basic.NET-Web Development
more...
Visual Basic NET-Web Based Development Curriculum

..., user input validation, ADO.NET database connections and data access. The student is also taught the creation and use of XML Web services and the configuration and deployment of Web applications in Visual Basic.NET. This curriculum consists of five Skill Builder courses: Microsoft Visual Basic.NET-Web Development Part 1: Web Forms and Controls Microsoft Visual Basic.NET-Web Development
more...
Visual Basic NET-Web Based Development Part 3

...T 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 authentication. o To mtch connection string parameters with their functions. o To identify characteristics of a
more...
Visual Basic NET-Web Based Development Part 3

...T 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 authentication. o To mtch connection string parameters with their functions. o To identify characteristics of a
more...
Visual Basic NET-Distributed Applications Curriculum

The MS Visual Basic.NET-Distributed Applications Curriculum includes the following courses: MS Visual Basic.NET-Distributed Applications: Part 1(Web Services) MS Visual Basic.NET-Distributed Applications: Part 2(COM+ and Interop) MS Visual Basic.NET-Distributed Applications: Part 3(Data Access) MS Visual Basic.NET-Distributed Applications: Part 4(Debugging) MS Visual Basic.NET-Distributed
more...
Visual Basic NET-Distributed Applications Part 3

...icrosoft Visual Basic .NET-Distributed Applications Pt 3: Data Access course teaches learners how to consume and manipulate data by using ADO.NET. Learn To: a To identify features of ADO.NET. a To identify benefits of ADO.NET. a To sequence the steps to read data from a database in a connected environment. a To identify features of DataSets. a To
more...
Windows 2000 Implementing Security Part 1

... To identify risks to data and data access on a network. To identify potential security threats to data on a network. To identify measures used to assess the security standard of a network. To identify guidelines for selecting a centralized administrative model.
more...
Windows 2000 Implementing Security Part 1

... To identify risks to data and data access on a network. To identify potential security threats to data on a network. To identify measures used to assess the security standard of a network. To identify guidelines for selecting a centralized administrative model.
more...
Defining Microsoft NET Solution Architectures parat 4

This is the fourth of a four-part curriculum that prepares the learner for Exam 70-300. This course focuses on security considerations within the solution design, and .NET Framework security strategies. It then looks in turn at the Stabilization and the Deployment stages of the project. It closes with coverage of Standards and Processes. Three case studies address the three main areas of the
more...
Essentials of Management Negotiating Skills

In "Essentials of Management: Negotiation Skills" you will learn about the basic types of negotiations and the skills required to use them. You will also learn how to prepare effectively for negotiation by setting your goals and limits and applying logic. Because negotiation is essentially about communication, you learn about the value of mutual benefit and positional negotiation and other
more...
Access 2003 Proficient User

...n to a form by using the View menu. Unit 2: Reports and Data Access Pages (1 - 1.5 hours) Identify options in the Report Wizard. Identify options in the Page Wizard. Set the sort order for a report. Identify options in the Page Setup dialog box for setting up a report.
more...
Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3

...ts of the ADO object model. Identify methods of handling data access errors. Connect to a database using ADO. Connect to a data source. Identify connection object events. Identify database connections. Identify the uses of the Command object. Identify the uses of the Recordset object. Identify ways of presenting data to the user. Identify the properties and methods that allow
more...
Site Server 3 0 Commerce Solutions - Part 1

...ole of Microsoft Open Database Connectivity (ODBC) in the data access process. Identify characteristics of ActiveX Data Objects (ADO). Perform the steps to enable connection pooling. Perform the steps to change the default connection string. Match query values with their descriptions. Sequence the steps to access an ODBC data source. Unit 3: Creating an Online Store Duration: 2
more...
XML Building XML-Based Web Applications Part 3

...n covers treatment of Data Islands. The basic elements of data access and the Web are covered in addition to the binding of HTML elements to XML data and manipulation of data sources. Learn To Identify features of cascading style sheets. Identify features of XSL. Identify features of an XML document tree. Identify benefits of ActiveX Data Object (ADO)
more...
From Software Training Academy, Inc
ADO NET for Windows Applications Using C

...erview of ADO. NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO. NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.
The next two chapters cover in detail Connection and Command objects, which are essential in both
more...
ADO NET for Web Applications Using C

...verview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO.NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.
The next two chapters cover in detail Connection and Command objects, which are essential in both
more...
ADO NET Using C

...verview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO.NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.
The next two chapters cover in detail Connection and Command objects, which are essential in both
more...
ADO NET Using VB NET

...verview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO.NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.
The next two chapters cover in detail Connection and Command objects, which are essential in both
more...
ASP NET Using Visual Basic

...ontrols are introduced, including menus and master pages. Data access is covered using the powerful data access controls provided by ASP.NET 2.0. There is further discussion of security using membership and roles, and personalization features such as themes, skins and Web parts are introduced. This section of the course is tied together by a progressive case study illustrating a Web site for a
more...
ASP NET Using C

...ontrols are introduced, including menus and master pages. Data access is covered using the powerful data access controls provided by ASP.NET 2.0. There is further discussion of security using membership and roles, and personalization features such as themes, skins and Web parts are introduced. This section of the course is tied together by a progressive case study illustrating a Web site for a
more...
From Serebra Learning Corporation
Advanced Language Features of Microsoft VB NET
To explain the new object-oriented features of Visual Basic .NET, data access with ADO.NET, and strategies for migration Application developers with experience using previous versions of Microsoft Visual Basic who wish to start working with Microsoft Visual Basic .NET
more...
Data Integration with C 2005 and ASP NET 2 0
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
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...
ADO NET Connections and Commands
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design C# programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
Building ADO NET DataSets
To describe how to use ADO.NET's disconnected DataSet object model, including DataSets, DataAdapters, DataTables, DataRelations, DataRows, and DataColumns C# programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
ADO NET Connections and Commands
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
more...
Building ADO NET DataSets
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
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...
Windows 2000 - Communication and Remote Access Security
To enable students to design protocol-level security, to secure network services, to secure connections from remote users and remote offices, and to provide remote users with secure access to local resources Students preparing for Microsoft exam 70-220; personnel in medium to very large computing environments that use the Windows 2000 network operating system
more...
Oracle 11i Oracle Projects Security Model and Page Layouts
To use Oracle Projects to secure function and data access within Projects applications, and use page layouts to manipulate views of project information Functional Implementers; Project Managers; Sales Consultants
more...
Oracle 11i Oracle Projects Security Model and Page Layouts
To use Oracle Projects to secure function and data access within Projects applications, and use page layouts to manipulate views of project information Functional Implementers; Project Managers; Sales Consultants
more...
Advanced Database Features in Access 2002
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...
Exchanging Data with Excel 2007
In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality 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
more...
Microsoft Office 2000 - Excel for Power Users
To bring proficient users of Excel 2000 to an advanced level of competence in using macros and sharing, displaying, formatting, and analyzing data End-users seeking proficiency in the use of Microsoft Excel 2000 at an advanced level; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2000 at Expert level
more...
Microsoft Office 2000 - New Features for Power Users
To describe the new web-integration and collaboration features of Office 2000 and other features for power users End user
more...
Access 2003 and the Web
To make Access databases use web resources with hyperlinks and data access pages 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 2000 Intermediate
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...
Microsoft Visual InterDev 6.0: Active Server Pages and Data Access
This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to identify the features of Active Server Pages (ASP); create a server script and debug the server-side script; set permissions for a
more...
Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 - Part 1
This is the first 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 be introduced to the Visual Basic environment and its main options and characteristics. Students will also learn the strategy for Universal Data Access and the visual data access tools that
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 4
This is the fourth course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from
more...
Creating Reports Charts Macros with Access 2002
The Creating Reports, Charts, & Macros with Access 2002 WBT is the third course of the Office XP: Access 2002 curriculum. This course familiarizes users with report and chart creation in Access 2002. The course also details the process of modifying the existing report and chart designs, and creating various types of handouts for them. Additionally, the course guides the users to use Access as a
more...
Microsoft Windows Server 2003 Designing Security Part 3
This multi-part curriculum will focus closely on the exam requirements. However to fully prepare for certification it should be used in conjunction with other learning/training resources in addition to ample real-world experience. The principal areas covered are the conceptual logical and physical designs for network infrastructure security data access control strategies and physical design for
more...
Microsoft Windows Server 2003 Designing Security Part 2
This course focuses on the requirements of Microsoft Exam 70-298. However to fully prepare for the certification it should be used in conjunction with other learning/training resources in addition to ample real-world experience. The principal areas covered are the conceptual logical and physical designs for network infrastructure security data access control strategies and physical design for
more...
MS VB .NET: Distributed Applications Part 3: Data Access


The Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access course teaches learners how to consume and manipulate data by using ADO.NET.
more...
MS VB .NET: Web Development Part 3: Data Access in Visual Studio and ADO.NET


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.
more...
MS Office 2000: Access for Experts II


This course teaches the student how to generate reports, create data access pages, and define macros. The course also teaches the student to integrate data and implement security.
more...
Microsoft Office XP - Planning Collaborative Solutions Part 2: SharePoint Portal Server and Collabo
This is the second course in a two-part series that provides the learner with an introduction to Knowledge Management and how SharePoint Portal Server facilitates this. Topics include portal servera s difference from team services principal areas of data sharing within SharePoint Portal Server data access and search mechanisms. Digital dashboards are covered in considerable detail of setup
more...
Microsoft Access 2000 Designing and Implementing Database Applications Part 2 - Handling Data
This is the second course in a five-part series that will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course students will learn to retrieve data from an Access 2000 database; customize forms use forms to accept validated data and navigate between controls and records in a form;
more...
Building XML-Based Web Applications Part 3: XSL and Data Islands
This is the third course in a five part series that presents a detailed treatment of Styling within XML concentrating on XSL. The evolution from CSS to XSL is covered in detail. XSL transformation mechanisms are dealt with along with linking technologies XML filtering and sorting language constructs and creating new XML elements and a coverage of XSLT. The course then covers treatment of Data
more...
MS VB .NET: Web Development Part 3: Data Access in Visual Studio and ADO.NET
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.
more...
MS VB .NET: Distributed Applications Part 3: Data Access
The Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access course teaches learners how to consume and manipulate data by using ADO.NET.
more...
Database Technologies Part 1: Relational Database Fundamentals


The first of a two-part series this course will introduce the learner to the fundamentals of relational databases and relational database design including an in-depth look at data modeling and data design. This course will also cover the evolution of data access and the role that databases and associated enabling technologies play in today's corporate environments. Students should leave this
more...
Database Technologies Part 2: Introduction to SQL


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 on a
more...
From White Box QA
White Box Testing with JUnit and Selenium Job Training
...n
Running tests using CI server Hudson
Creating API for data access
Integrating with Unit, DB and Performance Tests
Unit Testing with JUnit 4
JUnit 3. 8 and JUnit 4
Setting Up and Optimizing Your Unit Test Cases
Simple Performance Testing Using Timeouts
Checking for Exceptions the Easy Way
Parameterized Tests
Using assertThat and the Hamcrest Library
Using Stubs to eliminate
more...
From Interskill Learning
1.3 Java Data Access for the IBM Enterprise
This is course 3 of 3 in the Java Programming Series. The course is delivered via e-Learning. It can be accessed online, at any time, place or location with internet access, or delivered through your own internal LMS (if applicable). The course is available as part of the Java Programming Series, or in a Mainframe Bundle, comprising of the 100 most popular mainframe e-Learning titles.
more...
From Skillspride Online Training
Introduction to Programming and Development in Access 2000
This course is designed to introduce new MS Access 2000 programmers to features and facilities of programming and development in MS Access 2000. Readers will learn about events, reports, controls, macros, data access pages, importing and linking data, sharing an access 2000 database, Data Access Objects (DAO), ActiveX Data Objects (ADO), Data Access Objects (DAO) and ActiveX Data Objects (ADO).
more...
Microsoft Access XP 2002 Level 2; Intermediate
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 2003 Intermediate
This course is designed to help you to obtain the skills required to create a relational database. You will learn relational database concepts and practice and understand the importance of documenting and maintaining database files. You will learn to customise forms, reports, and Data Access Pages in design view. Finally, you will be able to calculate and summarise data and import and export data
more...
Microsoft Access XP 2002 Level 2; Intermediate
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...
