Procedures Training on CD-ROM - Training Resources
Procedures Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Access 2002 Advanced
Lesson 1: Sharing Data Introduction Lesson Objectives Opening Access Opening The Northwind Sample Database Exporting Data Viewing Exported Data Exporting Data In HTML Format Opening An HTML File Sharing Reports Emailing A Report The Snapshot Viewer Viewing An Attachment Printing A Report Creating Backward Compatible Databases Renaming A Database Opening A Converted Database The Upsizing Wizard
more...
Access 2002 Advanced
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
...et 3.7 Deleting Rows in a DataSet 4.0 ADO.NET & Stored Procedures 4.1 Executing Stored Procedures 4.2 Updating Data Using Stored Procedures 5.0 Introduction to XML 5.1 What is XML? 5.2 Displaying XML 6.0 Processing XML 6.1 Using System.XML in VB.NET 6.2 XMLTextReader & XMLTextWriter 6.3 DataSets & XML 6.4 Using the StringReader Class 7.0 COM Components from .NET 7.1
more...
JAVA JDBC Servlets Set of 4
...ns 2.5 Prepared Statements 2.6 Transactions 2.7 Stored Procedures 2.8 Scrollable Result Sets 2.9 Updatable Result Sets 2.10 Updatable Result Set Interaction 2.11 Database Meta Data 2.12 Result Set Meta Data Level 3 1.0 Introduction to HTML 1.1 What is a Markup Language? 1.2 How Does the Web Work? 1.3 Documentation 1.4 Html Components 1.5 Html Colors 1.6 Changing the
more...
JAVA JDBC Servlets Set of 4
...ns 2.5 Prepared Statements 2.6 Transactions 2.7 Stored Procedures 2.8 Scrollable Result Sets 2.9 Updatable Result Sets 2.10 Updatable Result Set Interaction 2.11 Database Meta Data 2.12 Result Set Meta Data Level 3 1.0 Introduction to HTML 1.1 What is a Markup Language? 1.2 How Does the Web Work? 1.3 Documentation 1.4 Html Components 1.5 Html Colors 1.6 Changing the
more...
SQL Server 2000 Design Implement Databases Set of 6
...iables Designing and Implementing Level 4 1.0 Stored Procedures 1.1 Intro to Stored Procedures 1.2 Passing Parameters 1.3 Returning information from Stored Procedures 1.4 OUTPUT Parameters 1.5 Dynamic SQL 1.6 Cursors 2.0 Triggers & Views 2.1 Update Triggers 2.2 Insert Triggers 2.3 Delete Triggers 2.4 INSTEAD OF Triggers 2.5 Views 3.0 Locking Issues 3.1 Locking Scenarios 3.2
more...
SQL Server 2000 Design Implement Databases Set of 6
...iables Designing and Implementing Level 4 1.0 Stored Procedures 1.1 Intro to Stored Procedures 1.2 Passing Parameters 1.3 Returning information from Stored Procedures 1.4 OUTPUT Parameters 1.5 Dynamic SQL 1.6 Cursors 2.0 Triggers & Views 2.1 Update Triggers 2.2 Insert Triggers 2.3 Delete Triggers 2.4 INSTEAD OF Triggers 2.5 Views 3.0 Locking Issues 3.1 Locking Scenarios 3.2
more...
Dreamweaver MX Web Applications
...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 Interfacing with Databases Database Drivers Setting up a DSN
more...
Delphi 5 Advanced Level 5
Advanced Level 5 (1 Hr 45 Mins) 1.0 Using a Stored Procedure (20 Mins) 1.1 When to Use Stored Procedures 1.2 Input/Output Parameters 1.3 Internal Variables 1.4 Exceptions 2.0 Overview of Creating a Backend (21 Mins) 2.1 Databases 2.2 Tables 2.3 Views 3.0 DBMS in General (59 Mins) 3.1 Handling Text Data 3.2 Getting a List of Tables 3.3 Retrieving Field Values 4.0
more...
Delphi 5 Advanced Level 1
Advanced Level 1 (2 Hrs) 1.0 Installing the Sample Code & Data 2.0 Creating Custom Components 2.1 Creating a Component Unit 2.2 Constructors and Destructors 2.3 Testing the Component 2.4 Properties, Methods, and Events 2.5 Providing a Component Icon 3.0 More on Basic Component Creation 3.1 Procedures 3.2 Using the Component
more...
Paradox 9 ObjectPAL
Lesson 1: Introduction To ObjectPAL Opening Paradox 9 Opening A Form Introduction To ObjectPAL The Object Explorer Window The Object Tree Pane Introduction To Object Trees The Tabbed Pane The Appearance Tab The Properties Tab The Methods Tab ObjectPAL Code The If Structure The VCR Control The Back Event The FastBack Event The FastForward Event The FirstRecord Event The Forward
more...
Active Server Pages 3 Level 5
Level 5 (1 Hr 51 Mins) 1.0 ADODB.Command (1 Hr 44 Mins) 1.1 What is the Command Object? 1.2 Why do I need it? 1.3 Stored Procedures 2.0 Global.asa (32 Mins) 2.1 Application_OnStart & Application_OnEnd 2.2 IIS Configuration Settings 2.3 Session_OnStart & Sesstion_OnEnd 3.0 IIS Settings (35 Mins) 3.1 Home Directory Settings 3.2 Application Options 3.3 Document Settings 3.4
more...
Active Server Pages 3 Level 5
Level 5 (1 Hr 51 Mins) 1.0 ADODB.Command (1 Hr 44 Mins) 1.1 What is the Command Object? 1.2 Why do I need it? 1.3 Stored Procedures 2.0 Global.asa (32 Mins) 2.1 Application_OnStart & Application_OnEnd 2.2 IIS Configuration Settings 2.3 Session_OnStart & Sesstion_OnEnd 3.0 IIS Settings (35 Mins) 3.1 Home Directory Settings 3.2 Application Options 3.3 Document Settings 3.4
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...
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...
Active Server Pages 3 Set of 6
...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 Level 5 (1 Hr 51 Mins) 1.0 ADODB.Command (1 Hr 44 Mins) 1.1 What is the Command Object? 1.2 Why do I need it? 1.3 Stored Procedures 2.0 Global.asa (32 Mins) 2.1
more...
Active Server Pages 3 Set of 6
...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 Level 5 (1 Hr 51 Mins) 1.0 ADODB.Command (1 Hr 44 Mins) 1.1 What is the Command Object? 1.2 Why do I need it? 1.3 Stored Procedures 2.0 Global.asa (32 Mins) 2.1
more...
Access 2002 Advanced
Lesson 1: Sharing Data Introduction Lesson Objectives Opening Access Opening The Northwind Sample Database Exporting Data Viewing Exported Data Exporting Data In HTML Format Opening An HTML File Sharing Reports Emailing A Report The Snapshot Viewer Viewing An Attachment Printing A Report Creating Backward Compatible Databases Renaming A Database Opening A Converted Database The
more...
Dreamweaver MX Web Applications
...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 Interfacing with Databases Database Drivers Setting up a
more...
Visual Basic 6 0 Getting Started Set of 8 LV 1-8
...r 54 Minutes) 1.0 Events (33 min) 1.1 Overview Event Procedures 1.2 Form and Control Events 2.0 Variables, Constants, Arrays and User Defined Types (56 min) 2.1 Variables 2.2 Scope of Variables 2.3 Variable Declarations 2.4 Naming Variables and Relational Operators 2.5 Operator Precedence 2.6 Constants 2.7 The Variant Data Type 2.8 Arrays 2.9 User-Defined Types 3.0
more...
Visual Basic 6 0 Complete Set of 17
...54 Minutes)
1.0 Events (33
min)
1.1 Overview Event Procedures
1.2 Form and Control Events
2.0 Variables, Constants, Arrays and User Defined Types (56
min)
2.1 Variables
2.2 Scope of Variables
2.3 Variable Declarations
2.4 Naming Variables and Relational Operators
2.5 Operator Precedence
2.6 Constants
2.7 The Variant Data Type
2.8 Arrays
2.9 User-Defined Types
3.0
more...
Visual Basic 6 0 LV 3
...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 Control (39
min)
3.1 Methods of
more...
Visual Basic 6 0 LV 2
...54 Minutes)
1.0 Events (33
min)
1.1 Overview Event Procedures
1.2 Form and Control Events
2.0 Variables, Constants, Arrays and User Defined Types (56
min)
2.1 Variables
2.2 Scope of Variables
2.3 Variable Declarations
2.4 Naming Variables and Relational Operators
2.5 Operator Precedence
2.6 Constants
2.7 The Variant Data Type
2.8 Arrays
2.9 User-Defined Types
3.0
more...
Visual Basic 6 0 Multi-Tier Techniques LV 16
Level 16 - Multi-Tier Architecture a a B (1 Hour 31 Minutes)
1.0 Data Aware Classes (27
min)
1.1 Overview
1.2 Data Source Class
1.3 Data Consumer Class
1.4 Data Object Wizard
2.0 Distributed Computing (15
min)
2.1 Overview
2.2 COM Issues
3.0 Microsoft Transaction Server (48
min)
3.1 What is MTS?
3.2 Why Use MTS?
3.3 Hardware and Software Requirements to Install MTS
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...
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...
Access 2000 Application Developer Set of 16
...atomy of a Module
1.4 Option Explicit
1.5 Event Procedures
1.6 User-defined Procedures
1.7 Scope of Procedures
2.0 Working with Variables (16 Minutes)
2.1 Declaring Variables
2.2 Data Types
2.3 Scope and Lifetime of Variables
3.0 Comments and Line Continuation (5 Minutes)
3.1 Adding Comments & Line Continuation
4.0 Control Structures (11 Minutes)
more...
Access 2000 Application Developer Set of 16
...atomy of a Module
1.4 Option Explicit
1.5 Event Procedures
1.6 User-defined Procedures
1.7 Scope of Procedures
2.0 Working with Variables (16 Minutes)
2.1 Declaring Variables
2.2 Data Types
2.3 Scope and Lifetime of Variables
3.0 Comments and Line Continuation (5 Minutes)
3.1 Adding Comments & Line Continuation
4.0 Control Structures (11 Minutes)
more...
Access 2000 Application Developer Set of 16
...atomy of a Module
1.4 Option Explicit
1.5 Event Procedures
1.6 User-defined Procedures
1.7 Scope of Procedures
2.0 Working with Variables (16 Minutes)
2.1 Declaring Variables
2.2 Data Types
2.3 Scope and Lifetime of Variables
3.0 Comments and Line Continuation (5 Minutes)
3.1 Adding Comments & Line Continuation
4.0 Control Structures (11 Minutes)
more...
Access 2000 Application Developer Set of 16
...
1.3 Anatomy of a Module
1.4 Option Explicit
1.5 Event Procedures
1.6 User-defined Procedures
1.7 Scope of Procedures
2.0 Working with Variables (16 Minutes)
2.1 Declaring Variables
2.2 Data Types
2.3 Scope and Lifetime of Variables
3.0 Comments and Line Continuation (5 Minutes)
3.1 Adding Comments & Line Continuation
4.0 Control Structures (11 Minutes)
4.1 If-Then-Else
4.2
more...
Access 2000 Application Developer LV 3
...
1.3 Anatomy of a Module
1.4 Option Explicit
1.5 Event Procedures
1.6 User-defined Procedures
1.7 Scope of Procedures
2.0 Working with Variables (16 Minutes)
2.1 Declaring Variables
2.2 Data Types
2.3 Scope and Lifetime of Variables
3.0 Comments and Line Continuation (5 Minutes)
3.1 Adding Comments & Line Continuation
4.0 Control Structures (11 Minutes)
4.1 If-Then-Else
4.2
more...
Access 2000 Application Developer LV 9
Access 2000 Developer Level 9 (1 Hour 59 Minutes)
1.0 Client/Server Techniques (1 Hour 18 Minutes)
1.1 Client/Server - An Introduction
1.2 The Client/Server Model
1.3 Client/Server Buzz Words
1.4 Preparing for Upsizing
1.5 The Upsizing Wizard
1.6 Defining an ODBC Data Source
1.7 Connecting to a Database Server
1.8 Building a Client/Server Application from the Get Go
2.0
more...
Active Server Pages NET Set of 5
...Managing Events Page Event LifeCycle Creating Event Procedures Page Navigation ASP.NET Controls ASP:Label ASP:TextBox ASP:Button ASP:DropDownList ASP:ListBox ASP:RadioButton ASP:HyperLink Validation Margins & Page Setup RequiredFieldValidator Control CompareValidator Control RangeValidator Control RegularExpressionValidator Control
more...
Active Server Pages NET Set of 5
...Managing Events Page Event LifeCycle Creating Event Procedures Page Navigation ASP.NET Controls ASP:Label ASP:TextBox ASP:Button ASP:DropDownList ASP:ListBox ASP:RadioButton ASP:HyperLink Validation Margins & Page Setup RequiredFieldValidator Control CompareValidator Control RangeValidator Control RegularExpressionValidator Control
more...
Visual Basic Net Set of 7
...nstants Type Conversion Structures Arrays Using Procedures What is a Procedure? Creating & calling Sub Procedures Creating & calling Function Procedures Using Arguments -Passing Standard Arguments -Passing ByRef -Passing Arrays -Optional Arguments -Overloading Using Built-in Functions Using the Sub Main Operators & Expressions VB.NET Operators
more...
Visual InterDev 6 0 Level 5
...es 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 Form Manager 3.3 Remote Data Services 4.0 Active X Data Objects (ADO) (27 min) 4.1 Overview of the ADO Model 4.2 Tables and
more...
Network 2002 Level 4
...k + Level 4 (1 Hour 50 Minutes) 1.0 Standard Operating Procedures (28 Minutes) 1.1 Overview 1.2 Naming Conventions 1.3 Password Conventions 1.4 Protocol Standards & Configurations 2.0 Environmental Factors (15 Minutes) 2.1 Climate Control 2.2 Power Conditions 2.3 Error Messages 3.0 Identifying Network Components (10 Minutes) 3.1 Patch Panels, Hubs, & Routers 3.2 UPS 3.3
more...
Visual Basic Net Set of 7
...nstants Type Conversion Structures Arrays Using Procedures What is a Procedure? Creating & calling Sub Procedures Creating & calling Function Procedures Using Arguments -Passing Standard Arguments -Passing ByRef -Passing Arrays -Optional Arguments -Overloading Using Built-in Functions Using the Sub Main Operators & Expressions VB.NET Operators
more...
