Microsoft Sql Server Training on CD-ROM - Training Resources
Microsoft Sql Server Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From 123-CBT Computer Based Training
NET Set of 7
Level 1 1.0 Overview of the .NET Platform 1.1 Overview of .NET 1.2 Common Language Specification 1.3 Common Type System 1.4 .NET Applications 1.5 ADO.NET 1.6 Security Services 1.7 Why Migrate to .NET 1.8 Benefits of Using.NET 1.9 How to Migrate 2.0 Introduction to Visual Studio.NET 2.1 Overview to Visual Studio.NET 2.2 Project Templates 2.3 Getting Started with VS.NET 2.4
more...
NET Set of 7
Level 1 1.0 Overview of the .NET Platform 1.1 Overview of .NET 1.2 Common Language Specification 1.3 Common Type System 1.4 .NET Applications 1.5 ADO.NET 1.6 Security Services 1.7 Why Migrate to .NET 1.8 Benefits of Using.NET 1.9 How to Migrate 2.0 Introduction to Visual Studio.NET 2.1 Overview to Visual Studio.NET 2.2 Project Templates 2.3 Getting Started with VS.NET 2.4
more...
SQL Server 2000 Data Warehousing Set of 5
Data Warehousing Level 1 1.0 Introduction 1.1 Topic Overview 1.2 Transactional vs. Analytical Data Systems 1.3 Data Warehouse Defined 1.4 Data Warehouses vs. Data Marts/OLAP 2.0 Dimensional Modeling & Planning 2.1 Entity-Relationship Modeling vs. Dimensional Modeling 2.2 Elements of the Dimensional Model 2.3 The Role of User Requirements 2.4 Identifying Source Data 2.5 Implementing
more...
Data Warehousing Level 1 1.0 Introduction 1.1 Topic Overview 1.2 Transactional vs. Analytical Data Systems 1.3 Data Warehouse Defined 1.4 Data Warehouses vs. Data Marts/OLAP 2.0 Dimensional Modeling & Planning 2.1 Entity-Relationship Modeling vs. Dimensional Modeling 2.2 Elements of the Dimensional Model 2.3 The Role of User Requirements 2.4 Identifying Source Data 2.5 Implementing
more...
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...
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...
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...
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...
Active Server Pages 3 Set of 6
Level 1 (1 Hr 52 Mins) 1.0 Overview of Web Development (23 Mins) 1.1 What is ASP? 1.2 What software do I need? 1.3 What can I do with ASP? 1.4 Server-side Script Tags 1.5 Competing Products 1.6 ASP Object Model 2.0 The Response Object (49 Mins) 2.1 Response.Write 2.2 Response.End 2.3 Response.Redirect 2.4 Response.Cookies 3.0 Introduction to Scripting (40 Mins) 3.1
more...
Level 1 (1 Hr 52 Mins) 1.0 Overview of Web Development (23 Mins) 1.1 What is ASP? 1.2 What software do I need? 1.3 What can I do with ASP? 1.4 Server-side Script Tags 1.5 Competing Products 1.6 ASP Object Model 2.0 The Response Object (49 Mins) 2.1 Response.Write 2.2 Response.End 2.3 Response.Redirect 2.4 Response.Cookies 3.0 Introduction to Scripting (40 Mins) 3.1
more...
Active Server Pages 3 Set of 6
Level 1 (1 Hr 52 Mins) 1.0 Overview of Web Development (23 Mins) 1.1 What is ASP? 1.2 What software do I need? 1.3 What can I do with ASP? 1.4 Server-side Script Tags 1.5 Competing Products 1.6 ASP Object Model 2.0 The Response Object (49 Mins) 2.1 Response.Write 2.2 Response.End 2.3 Response.Redirect 2.4 Response.Cookies 3.0 Introduction to Scripting (40 Mins) 3.1
more...
Level 1 (1 Hr 52 Mins) 1.0 Overview of Web Development (23 Mins) 1.1 What is ASP? 1.2 What software do I need? 1.3 What can I do with ASP? 1.4 Server-side Script Tags 1.5 Competing Products 1.6 ASP Object Model 2.0 The Response Object (49 Mins) 2.1 Response.Write 2.2 Response.End 2.3 Response.Redirect 2.4 Response.Cookies 3.0 Introduction to Scripting (40 Mins) 3.1
more...
Visual Basic 6 0 Power Developer Set of 9 LV 9-17
Level 9 (2 Hours 13 Minutes) 1.0 Package & Deployment Wizard (29 min) 1.1 What is a Setup 1.2 Steps to Distribution 1.3 VB Runtime Files 1.4 Setup Runtime Files 1.5 Types of Setups 1.6 Creating a Package 1.7 Deploying the Package 1.8 Testing the Setup 2.0 Advanced Common Controls (1 Hour 1 min) 2.1 Flex Grid Control 2.2 Hierarchical Flex Grid Control 2.3 Tree View & List View
more...
Level 9 (2 Hours 13 Minutes) 1.0 Package & Deployment Wizard (29 min) 1.1 What is a Setup 1.2 Steps to Distribution 1.3 VB Runtime Files 1.4 Setup Runtime Files 1.5 Types of Setups 1.6 Creating a Package 1.7 Deploying the Package 1.8 Testing the Setup 2.0 Advanced Common Controls (1 Hour 1 min) 2.1 Flex Grid Control 2.2 Hierarchical Flex Grid Control 2.3 Tree View & List View
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...
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...
Visual Basic 6 0 Client Server Techniques LV 13
Level 13 Client/Server Techniques (2 Hours 15 Minutes)
1.0 What is Client/Server (18
min)
1.1 Concepts
1.2 Network File Server
1.3 Splitting the Application
1.4 Where do you put the Logic
1.5 Dead Vs Live Data
1.6 Multi-User Considerations
1.7 Cursors
1.8 Lock Types
1.9 Cursor Limitations
2.0 ODBC and OLE DB Overview (6
min)
2.1 What is ODBC?
2.2 ODBC Components
2.3 ODBC
more...
Level 13 Client/Server Techniques (2 Hours 15 Minutes)
1.0 What is Client/Server (18
min)
1.1 Concepts
1.2 Network File Server
1.3 Splitting the Application
1.4 Where do you put the Logic
1.5 Dead Vs Live Data
1.6 Multi-User Considerations
1.7 Cursors
1.8 Lock Types
1.9 Cursor Limitations
2.0 ODBC and OLE DB Overview (6
min)
2.1 What is ODBC?
2.2 ODBC Components
2.3 ODBC
more...
Visual Basic 6 0 Component Development LV 11
Level 11 Component Development (2 Hours)
1.0 Introduction to ActiveX Technology (6
min)
1.1 COM
1.2 DCOM
1.3 Compound Documents
1.4 In-Place Activation
1.5 Active X Container
1.6 Active X Server Components
1.7 Active Automation
2.0 Creating ActiveX Components (39
min)
2.1 Types of Components
2.2 Building an Active X DLL
2.3 Compiling the DLL
2.4 Debugging the DLL
2.5
more...
Level 11 Component Development (2 Hours)
1.0 Introduction to ActiveX Technology (6
min)
1.1 COM
1.2 DCOM
1.3 Compound Documents
1.4 In-Place Activation
1.5 Active X Container
1.6 Active X Server Components
1.7 Active Automation
2.0 Creating ActiveX Components (39
min)
2.1 Types of Components
2.2 Building an Active X DLL
2.3 Compiling the DLL
2.4 Debugging the DLL
2.5
more...
Access 2000 Application Developer Set of 16
Access 2000 Application Development Level 1 (2 Hours 5 Minutes)
1.0 Access as a Development Tool (37 Minutes)
1.1 Types of Applications You Can Develop
1.2 What Exactly is a Database
1.3 Getting to Know the Database Objects
1.4 Object Naming Conventions
1.5 Hardware Requirements
1.6 Getting Started Developing an Application
2.0 Tables (39 Minutes)
2.1
more...
Access 2000 Application Development Level 1 (2 Hours 5 Minutes)
1.0 Access as a Development Tool (37 Minutes)
1.1 Types of Applications You Can Develop
1.2 What Exactly is a Database
1.3 Getting to Know the Database Objects
1.4 Object Naming Conventions
1.5 Hardware Requirements
1.6 Getting Started Developing an Application
2.0 Tables (39 Minutes)
2.1
more...
Access 2000 Application Developer Set of 16
Access 2000 Application Development Level 1 (2 Hours 5 Minutes)
1.0 Access as a Development Tool (37 Minutes)
1.1 Types of Applications You Can Develop
1.2 What Exactly is a Database
1.3 Getting to Know the Database Objects
1.4 Object Naming Conventions
1.5 Hardware Requirements
1.6 Getting Started Developing an Application
2.0 Tables (39 Minutes)
2.1
more...
Access 2000 Application Development Level 1 (2 Hours 5 Minutes)
1.0 Access as a Development Tool (37 Minutes)
1.1 Types of Applications You Can Develop
1.2 What Exactly is a Database
1.3 Getting to Know the Database Objects
1.4 Object Naming Conventions
1.5 Hardware Requirements
1.6 Getting Started Developing an Application
2.0 Tables (39 Minutes)
2.1
more...
Access 2000 Application Developer Set of 16
Access 2000 Application Development Level 1 (2 Hours 5 Minutes)
1.0 Access as a Development Tool (37 Minutes)
1.1 Types of Applications You Can Develop
1.2 What Exactly is a Database
1.3 Getting to Know the Database Objects
1.4 Object Naming Conventions
1.5 Hardware Requirements
1.6 Getting Started Developing an Application
2.0 Tables (39 Minutes)
2.1
more...
Access 2000 Application Development Level 1 (2 Hours 5 Minutes)
1.0 Access as a Development Tool (37 Minutes)
1.1 Types of Applications You Can Develop
1.2 What Exactly is a Database
1.3 Getting to Know the Database Objects
1.4 Object Naming Conventions
1.5 Hardware Requirements
1.6 Getting Started Developing an Application
2.0 Tables (39 Minutes)
2.1
more...
Access 2000 Application Developer Set of 16
Access 2000 Application Development Level 1 (2 Hours 5 Minutes)
1.0 Access as a Development Tool (37 Minutes)
1.1 Types of Applications You Can Develop
1.2 What Exactly is a Database
1.3 Getting to Know the Database Objects
1.4 Object Naming Conventions
1.5 Hardware Requirements
1.6 Getting Started Developing an Application
2.0 Tables (39 Minutes)
2.1 Building a New Table
2.2
more...
Access 2000 Application Development Level 1 (2 Hours 5 Minutes)
1.0 Access as a Development Tool (37 Minutes)
1.1 Types of Applications You Can Develop
1.2 What Exactly is a Database
1.3 Getting to Know the Database Objects
1.4 Object Naming Conventions
1.5 Hardware Requirements
1.6 Getting Started Developing an Application
2.0 Tables (39 Minutes)
2.1 Building a New Table
2.2
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 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 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 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 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...
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...
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...
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...
