Online Data Access eLearning - Training Resources

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...

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...

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...

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...

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...

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...

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

Designing Efficient Application Access 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 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 recognize how to design and implement an appropriate cursor strategy in SQL Server 2005  more...

Designing a SQL Server 2005 Transaction Strategy 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 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 recognize how to optimize query performance and indexing strategies in SQL Server 2005  more...

Optimizing Storage in SQL Server 2005 recognize how to optimize database storage and SQL Server performance  more...

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

Data Access with ASP NET To demonstrate how to use data binding and file management with Web Forms  more...

XML Data Access in C To explain how to use the .NET Framework to manage XML data  more...

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...

XML Data Access in VB NET To use the .NET Framework to manage XML data  more...

Database Data Management To describe database data management and data access  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  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 Session Facade  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 Session Facade  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...

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...

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 the  more...

Oracle8 Performance Tuning Strategies and Techniques ...terprise 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 developers, and  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. Identify  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...

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...

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...

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 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 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...

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 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 in Visual  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 in Visual  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 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...

Oracle SQL Tuning Diagnostics and Tuning Schema ...rformance 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 Contents Unit  more...

Office 2000 - Web Integration ...y 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 pages.  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...

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...