Sql Server Training on CD-ROM - Training Resources
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...
Oracle8iR2 Database Administration Set of 5
Level 1 (2 hrs 22 min) 1.0 Oracle8i Architecture (1 hr 20 min) 1.1 DBA Environment 1.2 Server Architectural Overview 1.3 Database Comps 1.4 Logical Storage Structure 1.5 Data Blocks 1.6 Tablespaces 1.7 Oracle8i JVM 1.8 Multithread Server 1.9 Optimal Flexible Architecture 1.10 DBA Products 1.11 Summary 2.0 Oracle Memory Structures & Processes (1 hr 2 min) 2.1 Setting up
more...
Level 1 (2 hrs 22 min) 1.0 Oracle8i Architecture (1 hr 20 min) 1.1 DBA Environment 1.2 Server Architectural Overview 1.3 Database Comps 1.4 Logical Storage Structure 1.5 Data Blocks 1.6 Tablespaces 1.7 Oracle8i JVM 1.8 Multithread Server 1.9 Optimal Flexible Architecture 1.10 DBA Products 1.11 Summary 2.0 Oracle Memory Structures & Processes (1 hr 2 min) 2.1 Setting up
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
... 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 Creating a Database 4.4 Database Size Planning 4.5 Using T-SQL to create a database Designing and Implementing Level 2 1.0 Creating Tables 1.1 SQL Server Data Types 1.2 Creating Tables 1.3 Adding Data to a
more...
... 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 Creating a Database 4.4 Database Size Planning 4.5 Using T-SQL to create a database Designing and Implementing Level 2 1.0 Creating Tables 1.1 SQL Server Data Types 1.2 Creating Tables 1.3 Adding Data to a
more...
SQL Server 2000 Design Implement Databases Set of 6
... 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 Creating a Database 4.4 Database Size Planning 4.5 Using T-SQL to create a database Designing and Implementing Level 2 1.0 Creating Tables 1.1 SQL Server Data Types 1.2 Creating Tables 1.3 Adding Data to a
more...
... 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 Creating a Database 4.4 Database Size Planning 4.5 Using T-SQL to create a database Designing and Implementing Level 2 1.0 Creating Tables 1.1 SQL Server Data Types 1.2 Creating Tables 1.3 Adding Data to a
more...
Dreamweaver MX Web Applications
...ng Queries How Queries are Created Creating Indexes MS SQL Server 2000 Upsizing to MS SQL 2000 What are Stored Procedures What are Views SQL What is SQL Select Statements Using Where & Order By Retrieving Data Using LIKE Connecting to Databases Web & Application Servers Types of Application Servers Installing Personal Web Server Configuring PWS Configuring IIS
more...
...ng Queries How Queries are Created Creating Indexes MS SQL Server 2000 Upsizing to MS SQL 2000 What are Stored Procedures What are Views SQL What is SQL Select Statements Using Where & Order By Retrieving Data Using LIKE Connecting to Databases Web & Application Servers Types of Application Servers Installing Personal Web Server Configuring PWS Configuring IIS
more...
Active Server Pages 3 Level 4
Level 4 (1 Hr 50 Mins) 1.0 Data Manipulation (1 Hr 36 Mins) 1.1 Adding Records 1.2 Updating Records 1.3 Deleting Records 1.4 Optional Parameters 2.0 Stored Procedures (14 Mins) 2.1 What is a Stored Procedure? 2.2 Stored Procedures versus Scripting 2.3 T/SQL versus PL/SQL 2.4 The Anatomy of a Stored Procedure
more...
Level 4 (1 Hr 50 Mins) 1.0 Data Manipulation (1 Hr 36 Mins) 1.1 Adding Records 1.2 Updating Records 1.3 Deleting Records 1.4 Optional Parameters 2.0 Stored Procedures (14 Mins) 2.1 What is a Stored Procedure? 2.2 Stored Procedures versus Scripting 2.3 T/SQL versus PL/SQL 2.4 The Anatomy of a Stored Procedure
more...
Active Server Pages 3 Level 4
Level 4 (1 Hr 50 Mins) 1.0 Data Manipulation (1 Hr 36 Mins) 1.1 Adding Records 1.2 Updating Records 1.3 Deleting Records 1.4 Optional Parameters 2.0 Stored Procedures (14 Mins) 2.1 What is a Stored Procedure? 2.2 Stored Procedures versus Scripting 2.3 T/SQL versus PL/SQL 2.4 The Anatomy of a Stored Procedure
more...
Level 4 (1 Hr 50 Mins) 1.0 Data Manipulation (1 Hr 36 Mins) 1.1 Adding Records 1.2 Updating Records 1.3 Deleting Records 1.4 Optional Parameters 2.0 Stored Procedures (14 Mins) 2.1 What is a Stored Procedure? 2.2 Stored Procedures versus Scripting 2.3 T/SQL versus PL/SQL 2.4 The Anatomy of a Stored Procedure
more...
Active Server Pages 3 Level 3
Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data Source, Username & Password 2.0 Basics of SQL (23 Mins) 2.1 Select 2.2 Order By 2.3 Joins 2.4 Group By 3.0 The Request Object (39 Mins) 3.1 Request.form 3.2 Request.QueryString 3.3 Request 3.4 Request.Cookies 4.0 The Application Object (18 Mins) 4.1 What is the Application Object? 4.2 What is an Application
more...
Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data Source, Username & Password 2.0 Basics of SQL (23 Mins) 2.1 Select 2.2 Order By 2.3 Joins 2.4 Group By 3.0 The Request Object (39 Mins) 3.1 Request.form 3.2 Request.QueryString 3.3 Request 3.4 Request.Cookies 4.0 The Application Object (18 Mins) 4.1 What is the Application Object? 4.2 What is an Application
more...
Active Server Pages 3 Level 3
Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data Source, Username & Password 2.0 Basics of SQL (23 Mins) 2.1 Select 2.2 Order By 2.3 Joins 2.4 Group By 3.0 The Request Object (39 Mins) 3.1 Request.form 3.2 Request.QueryString 3.3 Request 3.4 Request.Cookies 4.0 The Application Object (18 Mins) 4.1 What is the Application Object? 4.2 What is an Application
more...
Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data Source, Username & Password 2.0 Basics of SQL (23 Mins) 2.1 Select 2.2 Order By 2.3 Joins 2.4 Group By 3.0 The Request Object (39 Mins) 3.1 Request.form 3.2 Request.QueryString 3.3 Request 3.4 Request.Cookies 4.0 The Application Object (18 Mins) 4.1 What is the Application Object? 4.2 What is an Application
more...
Active Server Pages 3 Level 2
Level 2 (1 Hr 52 Mins) 1.0 ASP in Action (22 Mins) 1.1 Sample ASP Web Sites 1.2 Your Sample Application 2.0 The Server Object (19 Mins) 2.1 Server.Transfer & Server.Execute 2.2 Server.CreateObject 3.0 ActiveX COM DLL (32 Mins) 3.1 Authoring your Component in VB 3.2 Instantiating your Object & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1
more...
Level 2 (1 Hr 52 Mins) 1.0 ASP in Action (22 Mins) 1.1 Sample ASP Web Sites 1.2 Your Sample Application 2.0 The Server Object (19 Mins) 2.1 Server.Transfer & Server.Execute 2.2 Server.CreateObject 3.0 ActiveX COM DLL (32 Mins) 3.1 Authoring your Component in VB 3.2 Instantiating your Object & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1
more...
Active Server Pages 3 Level 2
Level 2 (1 Hr 52 Mins) 1.0 ASP in Action (22 Mins) 1.1 Sample ASP Web Sites 1.2 Your Sample Application 2.0 The Server Object (19 Mins) 2.1 Server.Transfer & Server.Execute 2.2 Server.CreateObject 3.0 ActiveX COM DLL (32 Mins) 3.1 Authoring your Component in VB 3.2 Instantiating your Object & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1
more...
Level 2 (1 Hr 52 Mins) 1.0 ASP in Action (22 Mins) 1.1 Sample ASP Web Sites 1.2 Your Sample Application 2.0 The Server Object (19 Mins) 2.1 Server.Transfer & Server.Execute 2.2 Server.CreateObject 3.0 ActiveX COM DLL (32 Mins) 3.1 Authoring your Component in VB 3.2 Instantiating your Object & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1
more...
Active Server Pages 3 Set of 6
... & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1 Creating a Database 4.2 Creating a Table 4.3 Creating a Login 4.4 Creating a Stored Procedure 4.5 Creating a View 4.6 Creating a Relationship 4.7 Creating a Trigger 5.0 Active X DataObjects (17 Mins) 5.1 Recordset Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data Source,
more...
... & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1 Creating a Database 4.2 Creating a Table 4.3 Creating a Login 4.4 Creating a Stored Procedure 4.5 Creating a View 4.6 Creating a Relationship 4.7 Creating a Trigger 5.0 Active X DataObjects (17 Mins) 5.1 Recordset Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data Source,
more...
Active Server Pages 3 Set of 6
... & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1 Creating a Database 4.2 Creating a Table 4.3 Creating a Login 4.4 Creating a Stored Procedure 4.5 Creating a View 4.6 Creating a Relationship 4.7 Creating a Trigger 5.0 Active X DataObjects (17 Mins) 5.1 Recordset Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data Source,
more...
... & Calling Methods from ASP 4.0 Designing a Database in SQL Server 7.0 (21 Mins) 4.1 Creating a Database 4.2 Creating a Table 4.3 Creating a Login 4.4 Creating a Stored Procedure 4.5 Creating a View 4.6 Creating a Relationship 4.7 Creating a Trigger 5.0 Active X DataObjects (17 Mins) 5.1 Recordset Level 3 (1 Hr 54 Mins) 1.0 Connection Object (15 Mins) 1.1 Data Source,
more...
Dreamweaver MX Web Applications
...ng Queries How Queries are Created Creating Indexes MS SQL Server 2000 Upsizing to MS SQL 2000 What are Stored Procedures What are Views SQL What is SQL Select Statements Using Where & Order By Retrieving Data Using LIKE Connecting to Databases Web & Application Servers Types of Application Servers Installing Personal Web Server Configuring PWS Configuring IIS
more...
...ng Queries How Queries are Created Creating Indexes MS SQL Server 2000 Upsizing to MS SQL 2000 What are Stored Procedures What are Views SQL What is SQL Select Statements Using Where & Order By Retrieving Data Using LIKE Connecting to Databases Web & Application Servers Types of Application Servers Installing Personal Web Server Configuring PWS Configuring IIS
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...
Cold Fusion 4 5 Level 1
Level 1 (1 hr 53 mins) 1.0 What is Cold Fusion? (18 mins) 1.1 Overview of Cold Fusion 1.2 Internet Protocols 1.3 Clients-Side Scripting 1.4 Server-Side Scripting 1.5 Comparing ASP and JSP to CF 1.6 When is Cold Fusion Better? 1.7 Who is Using Cold Fusion? 1.8 Allaire Product Suite 2.0 Your First Cold Fusion Page (39 mins) 2.1 Your First CFM Page 2.2 HTML vs. CFM 2.3 Setting
more...
Level 1 (1 hr 53 mins) 1.0 What is Cold Fusion? (18 mins) 1.1 Overview of Cold Fusion 1.2 Internet Protocols 1.3 Clients-Side Scripting 1.4 Server-Side Scripting 1.5 Comparing ASP and JSP to CF 1.6 When is Cold Fusion Better? 1.7 Who is Using Cold Fusion? 1.8 Allaire Product Suite 2.0 Your First Cold Fusion Page (39 mins) 2.1 Your First CFM Page 2.2 HTML vs. CFM 2.3 Setting
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...
Paradox 9 Volumes I II
Corel Paradox 9 Volume 1 Lesson 1: Exploring Paradox 9 And Database Concepts Introduction To Database Systems Paradox 9 And Normalization Opening Paradox 9 The Welcome Screen Opening An Existing Database Displaying Forms Displaying Reports Displaying Tables Opening The Table Examining Table Structure Navigating Through Records Appending A New Record Switching To
more...
Corel Paradox 9 Volume 1 Lesson 1: Exploring Paradox 9 And Database Concepts Introduction To Database Systems Paradox 9 And Normalization Opening Paradox 9 The Welcome Screen Opening An Existing Database Displaying Forms Displaying Reports Displaying Tables Opening The Table Examining Table Structure Navigating Through Records Appending A New Record Switching To
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...
Crystal Reports 8--Level 5
Crystal Reports 8 Level 5 (1 Hr 40 Mins) 1.0 Working with Data (54 Mins) 1.1 Databases Overview 1.2 Aliases 1.3 Indexes 1.4 Relationships 1.5 SQL & SQL Databases 1.6 Server-side Processing 1.7 Mapping Database Fields 1.8 Working with Different Types of Data 1.9 Advanced Database Features 1.10 Reporting on the NT Event Log 1.11 Reporting on Exchange or Outlook Data 2.0 Using SQL
more...
Crystal Reports 8 Level 5 (1 Hr 40 Mins) 1.0 Working with Data (54 Mins) 1.1 Databases Overview 1.2 Aliases 1.3 Indexes 1.4 Relationships 1.5 SQL & SQL Databases 1.6 Server-side Processing 1.7 Mapping Database Fields 1.8 Working with Different Types of Data 1.9 Advanced Database Features 1.10 Reporting on the NT Event Log 1.11 Reporting on Exchange or Outlook Data 2.0 Using SQL
more...
Cold Fusion 4 5 Level 1
Level 1 (1 hr 53 mins) 1.0 What is Cold Fusion? (18 mins) 1.1 Overview of Cold Fusion 1.2 Internet Protocols 1.3 Clients-Side Scripting 1.4 Server-Side Scripting 1.5 Comparing ASP and JSP to CF 1.6 When is Cold Fusion Better? 1.7 Who is Using Cold Fusion? 1.8 Allaire Product Suite 2.0 Your First Cold Fusion Page (39 mins) 2.1 Your First CFM Page 2.2 HTML vs. CFM 2.3 Setting
more...
Level 1 (1 hr 53 mins) 1.0 What is Cold Fusion? (18 mins) 1.1 Overview of Cold Fusion 1.2 Internet Protocols 1.3 Clients-Side Scripting 1.4 Server-Side Scripting 1.5 Comparing ASP and JSP to CF 1.6 When is Cold Fusion Better? 1.7 Who is Using Cold Fusion? 1.8 Allaire Product Suite 2.0 Your First Cold Fusion Page (39 mins) 2.1 Your First CFM Page 2.2 HTML vs. CFM 2.3 Setting
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...
SQL Server 7.0
Learn to manage data retrieval and exportation, create advanced queries, control security, configure, replicate, and monitor all information contained within your SQL 7.0 database. Then move on to data warehouse managment, cubes, MDX statements, and much more in the tutorial series for SQL Server 7.0.
12 levels - 224 training modules
more...
Learn to manage data retrieval and exportation, create advanced queries, control security, configure, replicate, and monitor all information contained within your SQL 7.0 database. Then move on to data warehouse managment, cubes, MDX statements, and much more in the tutorial series for SQL Server 7.0.
12 levels - 224 training modules
more...
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 |
