Inquire About SQL 7.0 Training Videos for MCSE

MCSE WINDOWS and SQL 2000 Training CD's and Videos

MCSE Certification SQL 6.5 Training Videos Detailed Information

Level 1 Training Video Exam 70-26& 70-27	KYSQ51	$99.95	Order
Level 2 Training Video Exam 70-26 & 70-27	KYSQ52	$99.95	Order
Level 3 Training Video Exam 70-26 & 70-27	KYSQ53	$99.95	Order
System Administration Level 1 Training Video Exam 70-26	KYSQ54	$99.95	Order
System Administration Level 2 Training Video Exam 70-26	KYSQ55	$99.95	Order
Visual Basic Client/Server Level 1 Video Exam 70-26 & 70-27	KYSQ56	$99.95	Order
Visual Basic Client/Server Level 2 Video Exam 70-26 & 70-27	KYSQ57	$99.95	Order
SPECIAL! Order ALL Seven Videos	KYSQ5A	$499.95	Order

MCSE Certification SQL 6.5 Training Videos

Level 1 Training Video (1 hr 56 min)   #kysq51

 1.0 Relational Database Concepts (11 min)
 1.1 What is a Relational Database
 1.2 Tables
 1.3 Relationships
 1.4 Advantages & Disadvantages of a Relational Database
 1.5 Relational Database Terms
 1.6 Codd's 12 Rules
 2.0 SQL Server Features (9 min)
 2.1 What is SQL Server?
 2.2 SQL Server vs. Desktop DBMS
 2.3 Why use SQL Server
 2.4 When to use SQL Server
 2.5 Hardware & Software Recommended Configuration
 2.6 TRANSACT-SQL
 2.7 Capacities
 3.0 Installing SQL Server (12 min)
 3.1 The Installation Process
 3.2 What SQL Server Installs
 3.3 Registering the Server
 4.0 Devices, Databases, Tables & Field Types (56 min)
 4.1 Devices & Databases
 4.2 Creating a Device
 4.3 Creating a Database
 4.4 The Log File
 4.5 Tables
 4.6 Data Integrity
 4.7 Creating Tables
 4.8 Indexes Clustered & Non-Clustered
 4.9 Altering a Table
 4.10 Dropping Objects
 4.11 Creating Defaults
 4.12 Creating Rules
 4.13 User Defined Data type
 5.0 Data Retrieval (25 min)
 5.1 Select Statement & Where
 5.2 Distinct Clause & Calculating Columns
 5.3 Sorting
 5.4 Nulls & Aggregate Functions
 5.5 Group by Clause

Level 2 Training Video (1 hr 58 min)   #kysq52

 1.0 Joining Tables (20 min)
 1.1 Joins in SQL Server & Access Equi-join
 1.2 Inner Joins
 1.3 Outer Joins
 1.4 Sub queries
 1.5 Self Joins
 1.6 Union
 2.0 Data Modification (15 min)
 2.1 Inserting Data
 2.2 Creating Temporary Tables
 2.3 Updating Data
 2.4 Deleting data
 3.0 Stored Procedures, Triggers, Views (29 min)
 3.1 Creating Stored Procedures
 3.2 Executing Stored Procedures & Using Parameters with Stored Procedures
 3.3 Returning Information from Stored Procedures
 3.4 The EXEC Statement
 3.5 Triggers
 3.6 Views
 4.0 System Functions & Variables (24 min)
 4.1 Date Functions
 4.2 Mathematical Functions
 4.3 String Functions
 4.4 System Functions
 4.5 Convert Function
 4.6 System Variables
 5.0 Security in SQL Server (29 min)
 5.1 Logins
 5.2 Groups & Users
 5.3 Changing Passwords
 5.4 Changing Groups Using Scripts
 5.5 Changing Passwords & Revoking Rights
 5.6 Views & Stored Procedures
 5.7 Creating Tables & Object Security

Level 3 Training Video (1 hr 35 min)   #kysq53

 1.0 System databases & Tables (17 min)
 1.1 Master
 1.2 MSDB
 1.3 Model
 1.4 TEMPDB
 1.5 PUBS
 1.6 System Tables
 1.7 Looking at the Data in the System Tables
 1.8 Tips & Tricks
 2.0 System Procedures (9 min)
 2.1 Examples of Configuration Options
 2.2 sp_configure, sp_dboptions, sp_spaceused
 3.0 Transaction Processing & Locking (11 min)
 3.1 Lock Types
 3.2 Transaction Processing
 4.0 Scripts & Transferring Data (9 min)
 4.1 Generating Scripts
 4.2 Transferring
 4.3 Backing Up & Restoring
 5.0 Optimization (11 min)
 5.1 Server Side Optimization
 5.2 Hardware
 5.3 Memory
 5.4 Query Optimization
 5.5 I/O Statistics & SHOWPLAN
 6.0 Using the SQL Server Web Assistant (10 min)
 6.1 Using the SQL Server Web Assistant
 7.0 SQL-DMO (17 min)
 7.1 What are Distributed Management Objects
 7.2 Retrieving Devices & Databases
 7.3 Retrieving Tables, Columns, Indexes & Scripts
 7.4 Using DMO with Excel
 8.0 Performance Monitor (10 min)
 8.1 What are the Different Charts
 8.2 How you can Create an Alert

System Administration Level 1 Training Video (2 hr. 7 min)   #kysq54

1.0 Providing Access to a SQL Server
1.1 The SQL Server Login ID
1.2 Database Groups
2.0 SQL Security Models
2.1 Mixed Security
2.2 Integrating with the SQL Interface
3.0 Various Ways to Protect your Data
3.1 Using a Backup "Standby" Server
3.2 When to Backup User & System Databases
3.3 Checking the Database Consistency
4.0 Restoring your Database
4.1 Restore Overview
4.2 Restoring a Database and Transaction Log
4.3 Restoring a Database where original was lost
4.4 Restoring the Master Database

System Administration Level 2 Training Video (1 hr. 36 min)  #kysq55

1.0 Setting up Tasks & Alerts
1.1 Relationships Among Managers
1.2 Implementing SQL Mail
1.3 Managing Alerts
2.0 Replication
2.1 SQL Server 6.5 Replication Overview
2.2 Vertical & Horizontal partitioning
2.3 Distribution Server
2.4 Prerequisites for setting up Replication
2.5 Setting Memory allocation
2.6 Setting up the Server
2.7 Configuring the Subscription Server
3.0 Bulk Copy Program
3.1 Permissions needed to execute BCP
3.2 Looking at the Syntax of the BCP
3.3 BCP Copying Option
3.4 Performing a Bulk Copy
4.0 Removable Media
4.1 Looking at the status of the Database
4.2 Taking Database Offline

Visual Basic 5.x Client/Server Level 1 Training Video (1 hr 56 min)   #lysq56

1.0 What is a Client Server?
2.0 Open Database Connectivity (ODBC)
2.1 ODBC Conformance
2.2 SQL Grammar Conformance
3.0 Application Design
4.0 Jet & ODBC
4.1 Common Routines
4.2 Data Init & Data Open
4.3 Form Loading Process
4.4 Combo Box Routine
5.0 Jet & Stored Procedures
6.0 The ODBC API
6.1 Environment, Connection & Statement
6.2 Handles
6.3 Wrapper Function
6.4 Closing the ODEC Data Source
6.5 Taking a Look at the Form
6.6 Delete Function

Visual Basic 5.x Client/Server Level 2 Training Video (1 hr 56 min)   #kysq67

1.0 The ODBC API (cont.)
2.0 Advance ODBC API
2.1 Retrieving Memo-Text Fields
2.2 Asynchronous Queries
2.3 Schema Viewer
3.0 ODBC Direct
3.1 Error Handling
3.2 Multiple Result sets
3.3 Asynchronous Queries
3.4 Prepared Statements
4.0 Remote Data Objects
4.1 Adding Editing & Deleting
4.2 Error Handling
4.3 Multiple Result sets
4.4 Prepared Statements
4.5 Asynchronous Queries
4.6 Schema Viewer
5.0 Using Active Data Objects
5.1 ADD Features
5.2 Multiple Result Sets
6.0 A Comparison of Database Access Methods
6.1 Jet Data Control
6.2 ODBC Direct
6.3 ActiveX Data Objects

Return to Main Page