Online Access Data eLearning - Training Resources

Accessing Data and Manipulating DB2 UDB Database Objects To access data and manipulate database objects  more...

Oracle9i SQL Data Retrieval Techniques ...ariables. 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 rows from two tables by using an  more...

ASP NET Part 2 ADO NET Partitioning Tracing ...provides the learner with instruction on using ADO.NET to access data, on separating code from content, and on using the ASP.NET trace feature. The course will cover using ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display. The course then describes the different methods of separating code from content. Learners will  more...

ASP NET Part 2 ADO NET Partitioning Tracing ...provides the learner with instruction on using ADO.NET to access data, on separating code from content, and on using the ASP.NET trace feature. The course will cover using ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display. The course then describes the different methods of separating code from content. Learners will  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 ...values in the aggregated data by using the CUBE keyword. Access data from multiple tables by using Joins. Access data by using Subqueries. Create views using by using SQL statements. Sequence the steps to access data from a remote server. Unit 2: Data Access: Multidimensional Structures Duration: 1 - 2 Hour(s) Match the components of a multidimensional schema with their  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3 ...base by using the Enterprise Manager. Create a Microsoft Access data mart for subscribing to a publication by using the Program Manager. Set up a Microsoft Access data mart as a subscriber by using the Enterprise Manager. Push a publication to a subscriber by using the Enterprise Manager. Verify that a publication that was sent to a subscriber has been successfully delivered using the  more...

Visual C 6 0 Designing Implementing Distributed Applications - Part 3 ...data integrity and import data. Write SQL statements to access 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  more...

SQL Server 7 0 - Implementing a Database - Part 2 ...by SQL Server 7.0. Select the methods SQL Server uses to access data. Identify when it is useful to create an index. Select the columns to index. Select the characteristics of a clustered index. Sequence the steps SQL Server goes through to access data. Select the architectural features of nonclustered indexes. Identify the key difference between accessing data with a clustered index and  more...

SQL Server 7 0 - Implementing a Database - Part 5 ...ution with Microsoft SQL Server 7.0. L earn To: Access data by using the Stored Procedure model. Access data using triggers. Set up a distributed environment to access, modify and manage remote data. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database solution with Microsoft SQL Server 7.0.  more...

SQL and PL SQL Data Retrieval Techniques ...n 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 use SQL*Plus commands to build on basic SQL statements and create customized queries that  more...

Oracle SQL for End Users--Part 2 ...d 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 functions. Embed single-row and multiple-row subqueries in a SQL statement. Create, format, and execute interactive reports. C ontent Emphasis Skills-Based A udience End  more...

Office XP Collaborative Solutions Part 2 ...atures of the Web Storage System. o Identify methods to access data in the Web Storage System. Audience The intended audience for this course includes business decision makers, IT Executives and Managers, and knowledge workers who make strategic decisions about implementing collaborative solutions. Candidates will be proficient in Microsoft Office (any version). It would be an advantage  more...