SQL Training on CD-ROM
SQL 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
Access 2000 Application Developer Set of 16
...ab Queries
3.5 Outer Joins and Self Joins
3.6 SQL & Union Queries
3.7 Passing Parameters Queries
Access 2000 Application Development Level 6 (2 Hours 7 Minutes)
1.0 ActiveX Data Objects and Data Access Objects Introduced (20 Minutes)
1.1 Understanding ADO and DAO
1.2 ADO versus DAO
1.3 The ADO Object Model
2.0 ADO Recordset Types (12 Minutes)
more...
Access 2000 Application Developer Set of 16
...ab Queries
3.5 Outer Joins and Self Joins
3.6 SQL & Union Queries
3.7 Passing Parameters Queries
Access 2000 Application Development Level 6 (2 Hours 7 Minutes)
1.0 ActiveX Data Objects and Data Access Objects Introduced (20 Minutes)
1.1 Understanding ADO and DAO
1.2 ADO versus DAO
1.3 The ADO Object Model
2.0 ADO Recordset Types (12 Minutes)
more...
Access 2000 Application Developer Set of 16
...ab Queries
3.5 Outer Joins and Self Joins
3.6 SQL & Union Queries
3.7 Passing Parameters Queries
Access 2000 Application Development Level 6 (2 Hours 7 Minutes)
1.0 ActiveX Data Objects and Data Access Objects Introduced (20 Minutes)
1.1 Understanding ADO and DAO
1.2 ADO versus DAO
1.3 The ADO Object Model
2.0 ADO Recordset Types (12 Minutes)
more...
...ab Queries
3.5 Outer Joins and Self Joins
3.6 SQL & Union Queries
3.7 Passing Parameters Queries
Access 2000 Application Development Level 6 (2 Hours 7 Minutes)
1.0 ActiveX Data Objects and Data Access Objects Introduced (20 Minutes)
1.1 Understanding ADO and DAO
1.2 ADO versus DAO
1.3 The ADO Object Model
2.0 ADO Recordset Types (12 Minutes)
more...
Access 2000 Application Developer Set of 16
...ab Queries
3.5 Outer Joins and Self Joins
3.6 SQL & Union Queries
3.7 Passing Parameters Queries
Access 2000 Application Development Level 6 (2 Hours 7 Minutes)
1.0 ActiveX Data Objects and Data Access Objects Introduced (20 Minutes)
1.1 Understanding ADO and DAO
1.2 ADO versus DAO
1.3 The ADO Object Model
2.0 ADO Recordset Types (12 Minutes)
more...
...ab Queries
3.5 Outer Joins and Self Joins
3.6 SQL & Union Queries
3.7 Passing Parameters Queries
Access 2000 Application Development Level 6 (2 Hours 7 Minutes)
1.0 ActiveX Data Objects and Data Access Objects Introduced (20 Minutes)
1.1 Understanding ADO and DAO
1.2 ADO versus DAO
1.3 The ADO Object Model
2.0 ADO Recordset Types (12 Minutes)
more...
Dreamweaver MX Web Applications
...ow to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia's Live Object and Server Behaviors with ASP, ASP.NET and ColdFusion
more...
...ow to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia's Live Object and Server Behaviors with ASP, ASP.NET and ColdFusion
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
... Cross-tab Queries
3.5 Outer Joins and Self Joins
3.6 SQL & Union Queries
3.7 Passing Parameters Queries
Access 2000 Application Development Level 6 (2 Hours 7 Minutes)
1.0 ActiveX Data Objects and Data Access Objects Introduced (20 Minutes)
1.1 Understanding ADO and DAO
1.2 ADO versus DAO
1.3 The ADO Object Model
2.0 ADO Recordset Types (12 Minutes)
2.1
more...
... Cross-tab Queries
3.5 Outer Joins and Self Joins
3.6 SQL & Union Queries
3.7 Passing Parameters Queries
Access 2000 Application Development Level 6 (2 Hours 7 Minutes)
1.0 ActiveX Data Objects and Data Access Objects Introduced (20 Minutes)
1.1 Understanding ADO and DAO
1.2 ADO versus DAO
1.3 The ADO Object Model
2.0 ADO Recordset Types (12 Minutes)
2.1
more...
Access 2000 Application Developer LV 5
Access 2000 Application Development Level 5 (2 Hours 7 Minutes)
1.0 Advanced Report Techniques (23 Minutes)
1.1 Report Events
1.2 Sequence of Events
1.3 Section Events
1.4 Sequence of Section Events
1.5 Report Properties
2.0 Report Events & Properties (27 Minutes)
2.1 Changing Reports Record Source
2.2 Displaying Summary and Detail Information
2.3 Printing Mailing Labels
more...
Access 2000 Application Development Level 5 (2 Hours 7 Minutes)
1.0 Advanced Report Techniques (23 Minutes)
1.1 Report Events
1.2 Sequence of Events
1.3 Section Events
1.4 Sequence of Section Events
1.5 Report Properties
2.0 Report Events & Properties (27 Minutes)
2.1 Changing Reports Record Source
2.2 Displaying Summary and Detail Information
2.3 Printing Mailing Labels
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...
Paradox 9 Volumes I II
...ith The Visual Query Builder Creating A Query Using The SQL Editor Conclusion Lesson 3: Charts And Crosstabs Creating A New Form Creating A Crosstab Creating A Data Model Defining Column Fields Defining Row Fields (Categories) Defining Summary Fields Running A Crosstab Changing The Size Of The Entire Crosstab Filtering A Crosstab Saving A Crosstab Creating A
more...
...ith The Visual Query Builder Creating A Query Using The SQL Editor Conclusion Lesson 3: Charts And Crosstabs Creating A New Form Creating A Crosstab Creating A Data Model Defining Column Fields Defining Row Fields (Categories) Defining Summary Fields Running A Crosstab Changing The Size Of The Entire Crosstab Filtering A Crosstab Saving A Crosstab Creating A
more...
Paradox 8 Volumes I II
...r Table, Running the Complex Multi-Table Query, Exploring SQL, The SQL Editor, Creating a Simple SQL Query, Running a SQL Query, Learning More About SQL, Lesson 7 Review
Lesson 8: Introduction, Advanced Topics, Summary Operators, Entering the Calc Sum Expression, Finding Help-FAST, Using Summary Operators in a Multi-Table, Selecting Multiple Tables, Joining the Tables, Changing Number
more...
...r Table, Running the Complex Multi-Table Query, Exploring SQL, The SQL Editor, Creating a Simple SQL Query, Running a SQL Query, Learning More About SQL, Lesson 7 Review
Lesson 8: Introduction, Advanced Topics, Summary Operators, Entering the Calc Sum Expression, Finding Help-FAST, Using Summary Operators in a Multi-Table, Selecting Multiple Tables, Joining the Tables, Changing Number
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
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
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
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
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
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
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...
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 3
...s) 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 Variable? 4.3 Assigning a Value 4.4 Reading a Value
more...
...s) 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 Variable? 4.3 Assigning a Value 4.4 Reading a Value
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...
Crystal Reports 8--Level 5
...verview 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 (Structured Query Language) (16 Mins) 2.1 What is SQL? & Creating a Report Based on an
more...
...verview 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 (Structured Query Language) (16 Mins) 2.1 What is SQL? & Creating a Report Based on an
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
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
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
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
more...
SQL Server 2000 Data Warehousing Set of 5
...e Data Mart 2.1 Using Staging Tables 2.2 Using Transact SQL for Data Migration 2.3 Loading Data using Data Transformation Services 2.4 Advanced DTS Issues 2.5 Evaluating a Typical Load Scenario 3.0 Maintaining the Data Mart 3.1 Backup and Restoration Considerations 3.2 Handling Changing Facts 3.3 Handling Changing Dimensions 3.4 Securing the Data Mart Data Warehousing Level 3
more...
...e Data Mart 2.1 Using Staging Tables 2.2 Using Transact SQL for Data Migration 2.3 Loading Data using Data Transformation Services 2.4 Advanced DTS Issues 2.5 Evaluating a Typical Load Scenario 3.0 Maintaining the Data Mart 3.1 Backup and Restoration Considerations 3.2 Handling Changing Facts 3.3 Handling Changing Dimensions 3.4 Securing the Data Mart Data Warehousing Level 3
more...
Oracle8iR2 Database Administration Set of 5
...ints 1.3 Server Processes 1.4 Background Processes 1.5 SQL Statement Parsing 1.6 Optimizers 1.7 Parallel Operations 1.8 Summary 2.0 Data Dictionary (39 min) 2.1 Metadata 2.2 Static Views 2.3 Dynamic Views 3.0 DBA Utilities (43 min) 3.1 Administration Utilities 3.2 Installation Features Level 3 (2 hrs 15 min) 1.0 Creating an Oracle Instance & Database (1 hr 25 min) 1.1
more...
...ints 1.3 Server Processes 1.4 Background Processes 1.5 SQL Statement Parsing 1.6 Optimizers 1.7 Parallel Operations 1.8 Summary 2.0 Data Dictionary (39 min) 2.1 Metadata 2.2 Static Views 2.3 Dynamic Views 3.0 DBA Utilities (43 min) 3.1 Administration Utilities 3.2 Installation Features Level 3 (2 hrs 15 min) 1.0 Creating an Oracle Instance & Database (1 hr 25 min) 1.1
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...
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...
JAVA JDBC Servlets Set of 4
...les 1.6 Related Data 1.7 Structured Query Language 1.8 Sql Language Types 1.9 Proprietary SQLs 1.10 Ides with Database Support 1.11 Rdbmss and JAVA 2.0 Learning SQL 2.1 About mysql? 2.2 Installing and Running mysql 2.3 Mysql Syntax 2.4 Database Structure 2.5 Creating and Droping Databases 2.6 Accessing a Database 2.7 Creating Tables 2.8 Common SQL Data Types 2.9 Column
more...
...les 1.6 Related Data 1.7 Structured Query Language 1.8 Sql Language Types 1.9 Proprietary SQLs 1.10 Ides with Database Support 1.11 Rdbmss and JAVA 2.0 Learning SQL 2.1 About mysql? 2.2 Installing and Running mysql 2.3 Mysql Syntax 2.4 Database Structure 2.5 Creating and Droping Databases 2.6 Accessing a Database 2.7 Creating Tables 2.8 Common SQL Data Types 2.9 Column
more...
JAVA JDBC Servlets Set of 4
...les 1.6 Related Data 1.7 Structured Query Language 1.8 Sql Language Types 1.9 Proprietary SQLs 1.10 Ides with Database Support 1.11 Rdbmss and JAVA 2.0 Learning SQL 2.1 About mysql? 2.2 Installing and Running mysql 2.3 Mysql Syntax 2.4 Database Structure 2.5 Creating and Droping Databases 2.6 Accessing a Database 2.7 Creating Tables 2.8 Common SQL Data Types 2.9 Column
more...
...les 1.6 Related Data 1.7 Structured Query Language 1.8 Sql Language Types 1.9 Proprietary SQLs 1.10 Ides with Database Support 1.11 Rdbmss and JAVA 2.0 Learning SQL 2.1 About mysql? 2.2 Installing and Running mysql 2.3 Mysql Syntax 2.4 Database Structure 2.5 Creating and Droping Databases 2.6 Accessing a Database 2.7 Creating Tables 2.8 Common SQL Data Types 2.9 Column
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
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
more...
Visual Basic 6 0 Client Server Techniques LV 13
...Operations
3.3 Asynchronous Samples
3.4 Submitting an SQL Statement Asynchronously
3.5 Transaction Processing
3.6 Long Text Fields
3.7 Multiple Result Sets
3.8 Get Rows and Get String Methods
3.9 Recordset Persistence
3.10 Cursor and Lock Types
3.11 Examining Database Structure
4.0 Command Objects (15
min)
4.1 Command Objects
4.2 Command Object Example
4.3 Insert
more...
...Operations
3.3 Asynchronous Samples
3.4 Submitting an SQL Statement Asynchronously
3.5 Transaction Processing
3.6 Long Text Fields
3.7 Multiple Result Sets
3.8 Get Rows and Get String Methods
3.9 Recordset Persistence
3.10 Cursor and Lock Types
3.11 Examining Database Structure
4.0 Command Objects (15
min)
4.1 Command Objects
4.2 Command Object Example
4.3 Insert
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
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
more...
Visual Basic 6 0 LV 7
Level 7 (1 Hour 48 Minutes)
1.0 Using ADO Objects (48
min)
1.1 Properties and Methods of the Connection Object
1.2 Properties and Methods of the Recordset Object
1.3 Recordset Types
1.4 Creating a Data Entry form Using ADO
1.5 Error Handling
1.6 Multi-User Concepts
2.0 Visual Database Tools (43
min)
2.1 Data Environment
2.2 Data View Window
2.3 Query Designer
more...
Level 7 (1 Hour 48 Minutes)
1.0 Using ADO Objects (48
min)
1.1 Properties and Methods of the Connection Object
1.2 Properties and Methods of the Recordset Object
1.3 Recordset Types
1.4 Creating a Data Entry form Using ADO
1.5 Error Handling
1.6 Multi-User Concepts
2.0 Visual Database Tools (43
min)
2.1 Data Environment
2.2 Data View Window
2.3 Query Designer
more...
Visual InterDev 6 0 Level 5
Level 5: Databases (1 Hour 32 Minutes) 1.0 Visual Data Source (30 min) 1.1 Creating a Database Project 1.2 Working with Tables 1.3 Creating a View 1.4 Database Diagram 1.5 Stored Procedures 1.6 Triggers 2.0 Connecting the Database to the Web Application (4 min) 2.1 Connecting to the Database 3.0 Data Aware DTC's (30 min) 3.1 Creating Data Enabled Pages & Recordset Options 3.2
more...
Level 5: Databases (1 Hour 32 Minutes) 1.0 Visual Data Source (30 min) 1.1 Creating a Database Project 1.2 Working with Tables 1.3 Creating a View 1.4 Database Diagram 1.5 Stored Procedures 1.6 Triggers 2.0 Connecting the Database to the Web Application (4 min) 2.1 Connecting to the Database 3.0 Data Aware DTC's (30 min) 3.1 Creating Data Enabled Pages & Recordset Options 3.2
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...
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 3
...s) 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 Variable? 4.3 Assigning a Value 4.4 Reading a Value
more...
...s) 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 Variable? 4.3 Assigning a Value 4.4 Reading a Value
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...
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...
Delphi 5 Advanced Level 4
Advanced Level 4 (1 Hr 51 Mins) 1.0 Graphics & Animation (50 Mins) 1.1 Bitmaps 1.2 TCanvas 1.3 Loading & Saving Images 1.4 Loading & Copying TBitMaps 1.5 A 'Paint' Program 1.6 Animation 2.0 Making a Connection (20 Mins) 2.1 Error Messages to Expect 2.2 Logging On & Logging Off 3.0 Creating an Alias (10 Mins) 3.1 Using the Database Explorer 3.2 Creating a New Interbase Alias &
more...
Advanced Level 4 (1 Hr 51 Mins) 1.0 Graphics & Animation (50 Mins) 1.1 Bitmaps 1.2 TCanvas 1.3 Loading & Saving Images 1.4 Loading & Copying TBitMaps 1.5 A 'Paint' Program 1.6 Animation 2.0 Making a Connection (20 Mins) 2.1 Error Messages to Expect 2.2 Logging On & Logging Off 3.0 Creating an Alias (10 Mins) 3.1 Using the Database Explorer 3.2 Creating a New Interbase Alias &
more...
Dreamweaver MX Web Applications
...ow to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia's Live Object and Server Behaviors with ASP, ASP.NET and ColdFusion
more...
...ow to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia's Live Object and Server Behaviors with ASP, ASP.NET and ColdFusion
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 |
