Microsoft ... Training on CD-ROM
From 123-CBT Computer Based Training
SQL Server 2000 Design Implement Databases Set of 6
Designing and Implementing Level 1 1.0 Relational Databases 1.1 What is a Database? 1.2 Relational Algebra 1.3 Relational Database Terms 2.0 Database Normalization 2.1 How to Normalize a Database 2.2 Case study: Employee Time Tracking System 3.0 An Overview of SQL Server 3.1 Features & Capacities 4.0 Creating Databases 4.1 SQL Server Databases & Logs 4.2 Files & FileGroups 4.3
more...
Visual Basic 6 0 Automation Programming LV 14
Level 14 Automation Programming (2 Hours 14 Minutes)
1.0 Introduction to Automation Programming (5
min)
1.1 What is Automation
1.2 How to use Automation
1.3 Programming the Server
2.0 Automating Microsoft Excel (26
min)
2.1 Help on Excel
2.2 Excel Object Hierarchy
2.3 Declaring Excel
2.4 Looking at the Code
2.5 Printing and Loading Data from an Access Database
2.6 Building a
more...
Outlook 2000 Intermediate
Outlook 2000 Intermediate (1 Hour 50 Minutes)
1.0 Enhanced Messaging Techniques (36 Minutes)
1.1 Customizing Outlook Today
1.2 How to Use Formatting In Your Messages
1.3 How to Use Microsoft Word as Your E-mail Editor
1.4 Working with WordMail Templates (Themes) and Custom Signatures
1.5 How to Re-send Messages
1.6 Recalling a Message
1.7 Working with Distribution Lists
1.8 Creating
more...
SQL Server 7 0 Data Warehousing Set of 4
SQL 7.0 Data Warehousing Level 1 (1 Hr 41 Mins) 1.0 Prerequisites (28 Mins) 1.1 Course Prerequisites 1.2 System Setup 1.3 Defining Data Warehousing 1.4 Operational & Analytical Systems 1.5 Comparing Transactional and Data Warehousing Solutions 1.6 Data Marts 1.7 Know the Flow 1.8 Microsoft Data Warehouse Tools 1.9 Data Warehouse Characteristics 2.0 Designing a Data Warehouse (1 Hr
more...
SQL Server 7 0 Data Warehousing Level 1
SQL 7.0 Data Warehousing Level 1 (1 Hr 41 Mins) 1.0 Prerequisites (28 Mins) 1.1 Course Prerequisites 1.2 System Setup 1.3 Defining Data Warehousing 1.4 Operational & Analytical Systems 1.5 Comparing Transactional and Data Warehousing Solutions 1.6 Data Marts 1.7 Know the Flow 1.8 Microsoft Data Warehouse Tools 1.9 Data Warehouse Characteristics 2.0 Designing a Data Warehouse (1 Hr
more...
SQL Server 7 0 Data Warehousing Level 2
SQL 7.0 Data Warehousing Level 2 (1 Hr 48 Mins) 1.0 Building the Data Warehouse (15 Mins) 1.1 Overview 1.2 Build Database 1.3 Build Dimension Tables 1.4 Using Scripts & Building a Fact Table 2.0 Validating and Transforming Data (53 Mins) 2.1 Process Overview 2.2 Methods of Populating a Data Warehouse 2.3 Tools for Populating a Data Warehouse 2.4 Transact-SQL 2.5 Distributed Query
more...
SQL Server 7 0 Data Warehousing Level 3
SQL 7.0 Data Warehousing Level 3 (1 Hr 28 Mins) 1.0 Storing & Processing Cubes (32 Mins) 1.1 MOLAP, ROLAP, & HOLAP Storage Structures 1.2 Comparing ROLAP & MOLAP 1.3 Review & Compare Storage Options 1.4 Storing Partitions & Processing Cubes 1.5 Calculated Members 1.6 The Virtual Cube, Cube Security & Roles 2.0 Analyzing Data Using Clients (28 Mins) 2.1 Navigating Warehouse Data &
more...
SQL Server 7 0 Data Warehousing Level 4
SQL 7.0 Data Warehousing Level 4 (1 Hr 32 Mins) 1.0 Building OLAP Clients (27 Mins) 1.1 Overview of Client/Server Architecture 1.2 ADO MD, Catalog Object & Cubedef Object 1.3 Retrieving Data About Cubes & Using Cellsets 1.4 Creating Local Cubes through MDX & ADO MD 2.0 Microsoft English Query (35 Mins) 2.1 Introduction to Microsoft English Query 2.2 Domains, Entities, &
more...
Network 2002 Level 3
Network + Level 3 (1 Hour 47 Minutes) 1.0 Protocols (23 Minutes) 1.1 TCP/IP History 1.2 Internet Standards Process 1.3 Address Resolution Protocol (ARP) 1.4 Internet Protocol (IP) 1.5 Transmission Control Protocol (TCP) 1.6 User Datagram Protocol (UDP) 1.7 Application Protocols 1.8 SNMP (Simple Network Management Protocol) 1.9 Ports 2.0 IP Addressing (8 Minutes) 2.1 Network and
more...
From Makau Corporation
SQL 2005 - Querying Microsoft SQL Server 2005 Database with Transact-SQL

Learn about the Transact-SQL programming language, what it is and how to query Microsoft SQL Server 2005. Then move on to how to use Transact-SQL query tools to retrieve data, format results, grouping and summarizing data. And then learn how to join multiple tables, work with subqueries, modify data in existing tables, and use programming objects.
3 levels - 49 training modules
more...
