5 Databases Training on CD-ROM

Dreamweaver MX Web Applications This is the second course in a series of tutorials from the Virtual Training Company for Dreamweaver MX. It covers all that techniques required to construct a data driven web site. Author Mark Fletcher (a member of Team Macromedia) will teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet  more...

Cold Fusion 4 5 Level 3 Level 3 (1 hr 33 mins) 1.0 Editor (22 mins) 1.1 Overview of the Editor 1.2 Working with Documents 1.3 Editor Window and Gutter 1.4 Indenting your Code 1.5 Tag Settings 2.0 Toolbars (19 mins) 2.1 Edit 2.2 Standard 2.3 View 52 2.4 Tools 3.0 Resource Windows (42 mins) 3.1 Files 3.2 Databases 3.3 Projects 3.4 Snippets 3.5 Help 3.6 Tag Inspector  more...

Visual InterDev 6 0 Set of 6 Level 1: Intro to Web Application Development (2 Hours 4 Minutes) 1.0 Overview (46 min) 1.1 Course Overview 1.2 What is Visual InterDev & Intended Audiences 1.3 Visual Studio 6.0 1.4 Client/Server Model 1.5 Client Browser 1.6 Hyper-text Mark up Language(HTML) 1.7 Hyper-text Transfer Protocol (HTTP) 1.8 Client-side Scripting 1.9 JavaScript 1.10 Visual Basic Scripting Edition  more...

Access 2002 Basic Lesson 1: The Access Interface & Database Objects Introduction Lesson Objectives About Databases Access Database Files Opening Access The Title Bar The Menu Bar The Ask A Question List Box The Database Toolbar The Task Pane Navigating Between Task Panes The Clipboard Task Pane The Basic & Advanced Search Task Panes Closing The Task Pane The Status Bar Database Objects Opening A  more...

Access 2002 Intermediate Lesson 1: The Access Interface Introduction Lesson Objectives Opening Access Opening The Northwind Database Customizing The Interface Creating A New Folder Other Options Changing The Default Database Folder Specifying Keyboard Behavior Setting Default Field Types & Sizes Creating A New Database Opening A Table Using Find Search Options Using Replace Filtering By Form Removing A  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...

Excel 2002 Advanced Lesson 1: Sorting & Filtering Data Introduction Lesson Objectives Opening Excel Importing Data From A Web Page The New Web Query Dialog Box Selecting A Table Navigating Pages Web Query Options Saving A Web Query Placing Data The External Data Toolbar Editing A Query Data Range Properties Refreshing Data Running A Saved Query Full Screen View Sorting Data Then By Sorting Using  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...

Paradox 8 Volumes I II Paradox 8 Paradox 8.0 for Windows 95 Volumes I & II Lesson 1: Introduction, Starting Corel Paradox 8 for Windows The Startup Expert, Major Components of the Paradox 8 Window, The File Menu, The Edit Menu, The Tools Menu, The Window Menu, The Help Menu, The Paradox 8 Toolbar, The Status Bar, An Intro to the Project Viewer, Opening the Project Viewer, The Project Viewer  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 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 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 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 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...

Windows 2000 Network Infrastructure Level 4 Level 4 (1 hr 52 mins) 1.0 WINS (23 mins) 1.1 Name Resolution 1.2 NetBIOS Databases & Name Release 2.0 Implementation of WINS (23 mins) 2.1 WINS Requirements 2.2 Installing a WINS Server 2.3 Configuring & Registering Clients 2.4 The WINS Database 3.0 Advanced WINS Topics (1 hr 6 mins) 3.1 WINS Proxy Agents & Non-WINS Clients 3.2 Static Mapping 3.3 Time-to-Live 3.4 Data  more...

Windows 2000 Network Infrastructure Level 4 Level 4 (1 hr 52 mins) 1.0 WINS (23 mins) 1.1 Name Resolution 1.2 NetBIOS Databases & Name Release 2.0 Implementation of WINS (23 mins) 2.1 WINS Requirements 2.2 Installing a WINS Server 2.3 Configuring & Registering Clients 2.4 The WINS Database 3.0 Advanced WINS Topics (1 hr 6 mins) 3.1 WINS Proxy Agents & Non-WINS Clients 3.2 Static Mapping 3.3 Time-to-Live 3.4 Data  more...

Crystal Reports 8 Complete Set of 7 The largest challenge with data and databases is creating the reports people will use and that provide useful information. Upon completion of this Crystal Reports 8.x course you will quickly create and customize reports that will be useful and informative. The Crystal Reports 8--Set of 7 includes the following courses: Crystal Reports 8--Level 1 Crystal Reports 8--Level 2 Crystal Reports  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...

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 &  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 &  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...

JAVA JDBC Servlets Set of 4 Level 1 1.0 Introduction to Databases 1.1 What is an rdbms? 1.2 Why are rdbmss Used? 1.3 Rdbms Choices 1.4 Structure of a Relational Database 1.5 Tables 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  more...

JAVA JDBC Servlets Set of 4 Level 1 1.0 Introduction to Databases 1.1 What is an rdbms? 1.2 Why are rdbmss Used? 1.3 Rdbms Choices 1.4 Structure of a Relational Database 1.5 Tables 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  more...

Access XP Essentials Set of 3 Beginning 1.0 Introduction 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database 2.1 Viewing & Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting & Deleting Records 2.5 Find & Replace 2.6 Modifying the Appearance of a  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...

Visual InterDev 6 0 Level 1 Level 1: Intro to Web Application Development (2 Hours 4 Minutes) 1.0 Overview (46 min) 1.1 Course Overview 1.2 What is Visual InterDev & Intended Audiences 1.3 Visual Studio 6.0 1.4 Client/Server Model 1.5 Client Browser 1.6 Hyper-text Mark up Language(HTML) 1.7 Hyper-text Transfer Protocol (HTTP) 1.8 Client-side Scripting 1.9 JavaScript 1.10 Visual Basic Scripting Edition  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...

Access 2000 - Proficient DiscoverWare's Discover Access 2000 is an interactive productivity tool for users of Microsoft Access 2000.Access 2000 builds on the database capabilities of previous versions of the program to provide powerful tools for building and maintaining professional databases.Topics include basic database concepts,planning a database, creating and modifying tables and forms,finding and sorting  more...

Cold Fusion 4 5 Level 3 Level 3 (1 hr 33 mins) 1.0 Editor (22 mins) 1.1 Overview of the Editor 1.2 Working with Documents 1.3 Editor Window and Gutter 1.4 Indenting your Code 1.5 Tag Settings 2.0 Toolbars (19 mins) 2.1 Edit 2.2 Standard 2.3 View 52 2.4 Tools 3.0 Resource Windows (42 mins) 3.1 Files 3.2 Databases 3.3 Projects 3.4 Snippets 3.5 Help 3.6 Tag Inspector  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...

iNet Level 3 Level 3 (1 Hr 29 Mins) 1.0 Network Security (22 Mins) 1.2 Fundamentals of Network Security 1.3 Dealing with Suspicious Activities & Attacks 1.4 Security Requirements 2.0 Internet Development (36 Mins) 2.1 Network Software Concepts 2.2 Programming Languages 2.3 Databases 2.4 Multimedia 3.0 Internet Site Design (31 Mins) 3.1 Functionality Issues 3.2 Technical & Content Related  more...

Dreamweaver MX Web Applications This is the second course in a series of tutorials from the Virtual Training Company for Dreamweaver MX. It covers all that techniques required to construct a data driven web site. Author Mark Fletcher (a member of Team Macromedia) will teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet  more...

Access XP Proficient Expert DiscoverWare's a Discover Access XP a ? is an interactive productivity tool for users of Microsoft Access XP. Access XP builds on the database capabilities of previous versions of the program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. Topics cover basic database concepts such as planning, forms, and  more...

Access 2000 Suite The Access 2000 Training Suite consists of the following courses: Access 2000 Introduction Access 2000 Intermediate Access 2000 Advanced To review individual course descriptions, please return to the previous page and select the desried title(s). Save $30 by ordering the suite.  more...

Access 2000 Intermediate LESSON_STR Access 2000 Intermediate Lesson 1: Working With Tables, Introduction - Installing The Northwind Database, Opening Microsoft Access 2000, The Single-Click Option, The Find Feature, The Find In Field Dialog Box, Search Options, Using Replace, Filtering By Form, Creating Advanced Filters, Sorting In Form View, Printing Your Data In Form Style, The Compact On Close Option Lesson 2:  more...

Access 2000 Advanced LESSON_STR   Access 2000 Advanced Lesson 1: Working With Menus And Toolbars,Opening An Existing Database,Access Sample Databases, Installing The Northwind Database, The Show Me Menu, Customizing Toolbars And Menus, Customizing Toolbars, Customizing Menus, Creating Custom Toolbars, Adding Commands To A Custom Toolbar, Sorting Records, Hiding A Toolbar, Deleting A Toolbar, Grouping Toolbar  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 Edit Mode Entering Record Details  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 Event The LastRecord  more...