Ado Training on CD-ROM
From 123-CBT Computer Based Training
NET Set of 7
...ation 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 Creating a New Project 2.5 VS.NET Integrated Development Environment (IDE) 3.0 Introduction to
more...
NET Set of 7
...ation 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 Creating a New Project 2.5 VS.NET Integrated Development Environment (IDE) 3.0 Introduction to
more...
XML Building XML-Based Web Applications Set of 3
...e Server Pages (ASP) 1.4 Microsoft ActiveX Data Objects (ADO) 2.0 The eXtensible Style Language (XSL) 2.1 XSL vs. CSS 2.2 Transformations (XSLT) 2.3 XSL Templates 2.4 XSL Filters 2.5 XSL Sorting 2.6 Control-of-Flow and Decision-Making Constructs 2.7 Looping in XML 2.8 Creating & Updating Elements/Attributes 3.0 HTML/XML Integration 3.1 Presentation 3.2 Content / Context 3.3
more...
XML Building XML-Based Web Applications Set of 3
...e Server Pages (ASP) 1.4 Microsoft ActiveX Data Objects (ADO) 2.0 The eXtensible Style Language (XSL) 2.1 XSL vs. CSS 2.2 Transformations (XSLT) 2.3 XSL Templates 2.4 XSL Filters 2.5 XSL Sorting 2.6 Control-of-Flow and Decision-Making Constructs 2.7 Looping in XML 2.8 Creating & Updating Elements/Attributes 3.0 HTML/XML Integration 3.1 Presentation 3.2 Content / Context 3.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...
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 Getting Started Set of 8 LV 1-8
...og 2.4 Common Dialog 2.5 Building a Custom Dialog 3.0 ADO Data Control (39 min) 3.1 Methods of Getting Data 3.2 Universal Data Access 3.3 ADO Data Control 3.4 Setting up an ODBC Datasource 3.5 Using the Data Control 3.6 Data List Control 3.7 The Data Grid Level 4 (1 Hour 51 Minutes) 1.0 Programming the ADO Data Control (39 min) 1.1 The Recordset Property and Data Control
more...
Visual Basic 6 0 Complete Set of 17
...og
2.4 Common Dialog
2.5 Building a Custom Dialog
3.0 ADO Data Control (39
min)
3.1 Methods of Getting Data
3.2 Universal Data Access
3.3 ADO Data Control
3.4 Setting up an ODBC Datasource
3.5 Using the Data Control
3.6 Data List Control
3.7 The Data Grid
Level 4 (1 Hour 51 Minutes)
1.0 Programming the ADO Data Control (39
min)
1.1 The Recordset Property and Data
more...
Visual Basic 6 0 LV 7
...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 window
2.4 SQL Editor
2.5 Database Diagram Window
2.6
more...
Visual Basic 6 0 LV 4
...ADO Data Control (39
min)
1.1 The Recordset Property and Data Control Events
1.2 Order of Events
1.3 Adding Features
1.4 Deleting Data
1.5 Canceling Changes
1.6 Data Validation
1.7 The Error Event
1.8 Displaying Records
1.9 Finding Records
2.0 MDI (35
min)
2.1 Overview of MDI
2.2 Adding a Project to MDI
2.3 Positioning the Project
2.4 Listing open Child Windows
2.5 Right
more...
Visual Basic 6 0 LV 3
Level 3 (1 Hour 58 Minutes)
1.0 Procedures & Functions (47
min)
1.1 Procedures
1.2 Creating and Calling Procedure
1.3 Sub Main
1.4 Functions
1.5 Parameters/Arguments
1.6 Call by Reference
1.7 Built-in Functions
1.8 Methods
2.0 Dialog Boxes (30
min)
2.1 What is a Dialog Box?
2.2 Message Box
2.3 Input Box Dialog
2.4 Common Dialog
2.5 Building a Custom Dialog
3.0 ADO Data
more...
Visual Basic 6 0 Client Server Techniques LV 13
... ODBC Components
2.3 ODBC Architecture
2.4 OLE DB
3.0 ADO (51
min)
3.1 Asynchronous Connections
3.2 Asynchronous Recordset 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
more...
Visual Basic 6 0 ActiveX Control LV 12
Level 12 ActiveX Controls (1 Hour 59 Minutes)
1.0 Creating ActiveX Controls (46
min)
1.1 What are ActiveX Controls?
1.2 Steps in ActiveX Control Creation
1.3 Creating an ActiveX Control
1.4 Properties
1.5 Lifetime Events
1.6 The ActiveX Control Wizard
1.7 Events
1.8 Methods
1.9 Using the Control
2.0 Advanced ActiveX Control Topics (11
min)
2.1 Creating an About Box
2.2 Adding
more...
Access 2000 Application Developer Set of 16
...s 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 CursorType
2.2 LockType
2.3 Options Parameter
3.0 Working with ADO Recordset Properties and Methods (28 Minutes)
3.1 Record-Movement Methods
3.2 Detecting Limits of a Recordset
3.3 Counting
more...
Access 2000 Application Developer Set of 16
...s 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 CursorType
2.2 LockType
2.3 Options Parameter
3.0 Working with ADO Recordset Properties and Methods (28 Minutes)
3.1 Record-Movement Methods
3.2 Detecting Limits of a Recordset
3.3 Counting
more...
Access 2000 Application Developer Set of 16
...s 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 CursorType
2.2 LockType
2.3 Options Parameter
3.0 Working with ADO Recordset Properties and Methods (28 Minutes)
3.1 Record-Movement Methods
3.2 Detecting Limits of a Recordset
3.3 Counting
more...
Access 2000 Application Developer Set of 16
...ccess 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 CursorType
2.2 LockType
2.3 Options Parameter
3.0 Working with ADO Recordset Properties and Methods (28 Minutes)
3.1 Record-Movement Methods
3.2 Detecting Limits of a Recordset
3.3 Counting Records in a Recordset
3.4 Sorting,
more...
Access 2000 Application Developer LV 6
...ccess 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 CursorType
2.2 LockType
2.3 Options Parameter
3.0 Working with ADO Recordset Properties and Methods (28 Minutes)
3.1 Record-Movement Methods
3.2 Detecting Limits of a Recordset
3.3 Counting Records in a Recordset
3.4 Sorting,
more...
SQL Server 7 0 Data Warehousing Set of 4
...7 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, & Relationships 2.3 Database Normalization 2.4 Identify Schema & Defining Entities 2.5
more...
SQL Server 7 0 Data Warehousing Level 4
...7 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, & Relationships 2.3 Database Normalization 2.4 Identify Schema & Defining Entities 2.5
more...
Active Server Pages NET Set of 5
...Application-level trace Level 4 Accessing Data with ADO.NET What is ADO.NET? ADO.NET Concepts ADO.NET vs ADO Recordsets vs. DataSets Basic ADO.NET Operations Opening a Connection DataSets and DataTables Parameter Making data modifications Advanced ADO.NET Operations Connection Pooling Transactions Using Stored Procedures Using Data-Binding
more...
Active Server Pages NET Set of 5
...Application-level trace Level 4 Accessing Data with ADO.NET What is ADO.NET? ADO.NET Concepts ADO.NET vs ADO Recordsets vs. DataSets Basic ADO.NET Operations Opening a Connection DataSets and DataTables Parameter Making data modifications Advanced ADO.NET Operations Connection Pooling Transactions Using Stored Procedures Using Data-Binding
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...
