SQL Server 2000 Complete Bundle

SQL Server 2000 Training Videos on CD

This SQL Server 2000 training series teaches you to administer, troubleshoot, and develop information systems that incorporate the SQL Server™ 2000 Enterprise Edition. Learn how to install and configure a SQL 2000 Server, create SQL 2000 databases, manage, monitor and troubleshoot SQL 2000 databases, extract and transform data and manage and monitor SQL 2000 security. You will learn how to develop a logical data model and how to program SQL Server 2000 applications based upon the corresponding business logic.

Please note that the training may refer to sample files that are no longer available. Students are advised to use the material provided in the training as the actual samples.

SQL Server 2000 Training Sample Video Clips:

Sample Video Clip Length Size Demo
Video 1: What is SQL Server? 4:54 3.5 MB
Video 2: Creating a Database 4:25 3.3 MB
Video 3: Database Properties 2:17 1.8 MB
Video 4: Working with Tables 2:20 2.0 MB
Video 5: Working with Defaults 1:56 1.7 MB
Video 6: SQL Query Analyzer 8:06 7.3 MB
Video 7: Working with Keys 7:27 6.2 MB
High-Speed Connection Recommended (DSL, Cable, T1 or Higher)

SQL Server 2000 Bundle Clearance

SQL Server 2000 Training Bundle

Clearance item, All Sales are Final. WORKS ON WINDOW XP ONLY: SEE SYSTEM REQ BELOW

Part#: sk-sql00x | Contents: Set of 20 CDs

Format

Reg: $899.00
Sale: $179.00
*No tax except for Maryland (USA) residents.

Shipping: Economy shipping allow 4-7 business days for delivery*

Payment options:

Order securely online or call 1-888-797-4040 (301-589-3349)

All major credit cards (Visa, MasterCard, Amex, and Discover)

PayPal: Pay online quickly with your PayPal account

Company PO's accepted (Net 30); Call for multi-user license

CD-ROM based trainingMultimedia CD-ROM Based Training:
With CD based training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics.

System Requirements: 400 MHz Processor (minimum), CD-ROM Drive, 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, or Windows XP.
NOT COMPATIBLE with Windows XP 64-Bit Edition, Windows Vista, Windows 7, or Windows 8.

TrainerSQL Server 2000 Trainer:
Paul D. Sheriff is the owner of PDSA Inc., a Microsoft Solutions Provider for Visual Basic and SQL Server. Paul has 10 years experience and is Visual Basic certified. He is one of the top instructors on Visual Basic and speaks at Advisor Developer Conferences and Microsoft TechEd every year. He is also the author of over 25 articles in major publications.

Course Outline - SQL Server 2000 Training Bundle:

Approx 1.5 to 2 hours training per CD

Administering SQL Server 2000 Level 1 (2 hrs 2 mins)

1.0 An Overview of SQL Server (32 mins)
1.1 Why use SQL Server?
1.2 Graphical Tools
1.3 Transact SQL
1.4 Database Objects
1.5 Security
1.6 Services
1.7 Capacities
1.8 Connectivity
1.9 Other Features
2.0 Installing SQL Server 2000 (36 mins)
2.1 Operating Systems
2.2 Versions & Configurations
2.3 Multiple Instances
2.4 Licensing
2.5 File Locations
2.6 Sort Orders
2.7 Types of Installations
2.8 Installation Checklist
2.9 Performing an Installation
2.10 Upgrading
2.11 Troubleshooting an Upgrade
2.12 Unattended Installations
3.0 Database Setup and Maintenance (54 mins)
3.1 Database Objects
3.2 System Stored Procedures & Functions
3.3 Database Layout
3.4 Database Files & File Groups
3.5 Transaction Log
3.6 Database Growth
3.7 Creating Databases using Enterprise Manager
3.8 Creating Databases using T-SQL
3.9 Sp-helpdb
3.10 Expanding a Database
3.11 Shrinking a Database
3.12 Database Options
3.13 Recovery Models
3.14 Database Space Planning
3.15 Multiple Disk Usage

Administering SQL Server 2000 Level 2 (2 hrs 11 mins)

1.0 Security (56 mins)
1.1 Introduction to Security
1.2 Authentication
1.3 Creating Logins
1.4 Server Roles
1.5 Assigning Server Roles
1.6 Database Roles
1.7 Managing Database Roles
1.8 Permissions
1.9 Managing Permissions
1.10 Views and Security
1.11 Stored Procedures and Security
1.12 Application Roles
2.0 Operators, Jobs, Alerts & Mail (1 hr 15 mins)
2.1 Definitions
2.2 SQL Server Agent Configuration
2.3 Operators
2.4 Jobs
2.5 Alerts
2.6 SQL Mail
2.7 Troubleshooting

Administering SQL Server 2000 Level 3 (2 hrs 4 mins)

1.0 DBCC (23 mins)
1.1 Maintenance Statements
1.2 Pin Statements
1.3 Trace Flags
1.4 Informational Statements
1.5 Check Statements
1.6 Old Statements
2.0 Backup and Restore (42 mins)
2.1 Why do a Backup?
2.2 Considerations of the Backup Process
2.3 Managing the Backup Devices
2.4 System Database Backup
2.5 Multiple Backup Devices
2.6 Backup Planning
2.7 Media Choices
2.8 Backup Types
2.9 Backup Scenarios
2.10 Copying/Moving
2.11 Stand-by Servers & Clustering
2.12 Performing a Backup
2.13 Restore a Backup
3.0 Database Maintenance Plan Wizard (14 mins)
3.1 What is the DMPW?
3.2 Running the Wizard
3.3 Jobs Created by the Wizard
4.0 Web Assistant (19 mins)
4.1 What is the Web Assistant?
4.2 Running the Web Assistant
4.3 Using a Template File
4.4 Triggers generated by Web Assistant
5.0 SQL Server Configuration Options (26 mins)
5.1 SQL Server Registration Properties
5.2 SQL Server Properties Dialog

Administering SQL Server 2000 Level 4 (1 hr 42 mins)

1.0 Transferring Objects & Scripting (32 mins)
1.1 Methods of Data Transfer
1.2 DTS Designer
1.3 Copy Database Wizard
1.4 sp_attach_db and sp_detach_db
1.5 Scripting Objects
2.0 Error Logs (13 mins)
2.1 Windows Event Logs
2.2 SQL Server Error Logs
2.3 Demo of Windows Logs
2.4 Demo of SQL Server Logs
3.0 Distributed Management Objects (20 mins)
3.1 DMO Object Hierarchy
3.2 Logging into SQL Server
3.3 Loading a list of Databases
3.4 Loading Tables
3.5 Users & Table Scripts
3.6 Indexes & Columns
4.0 Tips & Tricks (37 mins)
4.1 General Tips & Tricks

Administering SQL Server 2000 Level 5 (Approx: 2 hrs)

1.0 Replication Concepts
1.1 What is Replication?
1.2 The Publisher/Subscriber Metaphor
1.3 Replication Types
2.0 Planning a Replication Strategy
2.1 Basic Requirements
2.2 Autonomy vs. Integrity
2.3 Evaluating Business Objects
2.4 Physical Replication
2.5 Network Consideration
2.6 Security Issues
2.7 Capacity Planning
2.8 Triggers and Constraints
2.9 Planning Updating Subscribers
3.0 Implementing Snapshot Replication
3.1 How Snapshot Replication Works
3.2 Configuring Snapshot Replication
4.0 Implementing Transactional Replication
4.1 How Transactional Replication Works
4.2 Configuring Transactional Replication
5.0 Merge Replication
5.1 How Merge Replication Works
5.2 Configuring Merge Replication
5.3 Conflict Detection and Resolution

Administering SQL Server 2000 Level 6 (Approx: 2 hrs)

1.0 Monitoring and Tuning Replication 
1.1 Introduction to the Replication Monitor
1.2 Overview of Replication Agents
1.3 Viewing Agent History
1.4 Replication Alerts
1.5 Performance Issues
2.0 Replication with non-SQL Server Data Sources
2.1 Heterogeneous Subscribers
2.2 Heterogeneous Publishers 3.0 Replication and Database Maintenance
3.1 Backup Issues
3.2 Transactional Replication
4.0 Overview of Programmatic Replication
4.1 Using ActiveX Controls
4.2 Using the SQL DMO
4.3 The Replication Distributor Interface
4.4 Using Transact SQL Stored Procedures

Administering SQL Server 2000 Level 7 (1 hr 52 mins)

What's New in SQL Server 2000

1.0 New Features (56 mins)
1.1 Interface Changes
1.2 Multiple Instances
1.3 Index Enhancements
1.4 New Data Types
1.5 Text in Row
1.6 Triggers
1.7 Cascade Delete and Update
1.8 User-Defined Functions
1.9 Misc. Enhancements
1.10 New Functions
2.0 Using XML Extensions (51 mins)
2.1 Creating a Virtual Root
2.2 Using a Virtual Root
2.3 Returning Element Based XML
2.4 Passing Parameters
2.5 Multiple Result Sets
2.6 Using Stored Procedures
2.7 Inserting Data using XML
2.8 Joining Tables
2.9 Retrieving Data from VB

Implementing SQL Server 2000 Level 1 (1 hr 53 mins)

1.0 Relational Databases (34 mins)
1.1 What is a Database?
1.2 Relational Algebra
1.3 Relational Database Terms
2.0 Database Normalization (16 mins)
2.1 How to Normalize a Database
2.2 Case study: Employee Time Tracking System
3.0 An Overview of SQL Server (18 mins)
3.1 Features and Capacities
4.0 Creating Databases (45 mins)
4.1 SQL Server Databases and Logs
4.2 Files and FileGroups
4.3 Creating a Database
4.4 Database Size Planning
4.5 Using T-SQL to create a database

Implementing SQL Server 2000 Level 2 (2 hrs 17 mins)

1.0 Creating Tables (53 mins)
1.1 SQL Server Data Types
1.2 Creating Tables
1.3 Adding Data to a Table
1.4 Creating Tables Using T-SQL
2.0 Constraints and Indexes (50 mins)
2.1 Data Integrity
2.2 Indexes
2.3 Creating CHECKS and Rules
2.4 Using T-SQL to Create Constraints
3.0 Retrieving Data (34 mins)
3.1 Select Statement
3.2 WHERE Clause
3.3 DISTINCT and Calculated Columns
3.4 ORDER BY Clause
3.5 Using SLQ Query Analyzer

Implementing SQL Server 2000 Level 3 (2 hrs 17 mins)

1.0 Advanced Queries (39 mins)
1.1 Aggregated Functions
1.2 Grouping Data
1.3 Advanced Queries
1.4 Distributed Queries
2.0 Joining Tables (30 mins) 
2.1 Inner Joins
2.2 Outer Joins
2.3 Cross Join & Self Join
2.4 Subqueries
2.5 Unions
3.0 Data Modification (14 mins)
3.1 INSERT Statements
3.2 Creating Temporary Tables
3.3 UPDATE Statements
3.4 DELETE Statement
4.0 System Functions (54 mins)
4.1 Date Functions
4.2 Mathematical Functions
4.3 String Functions
4.4 System Functions
4.5 Security Functions
4.6 Conversion Functions
4.7 User-Defined Functions
4.8 System Variables

Implementing SQL Server 2000 Level 4 (2 hrs 1 min)

1.0 Stored Procedures (48 mins)
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 (37 mins)
2.1 Update Triggers
2.2 Insert Triggers
2.3 Delete Triggers
2.4 INSTEAD OF Triggers
2.5 Views
3.0 Locking Issues (36 mins)
3.1 Locking Scenarios
3.2 Isolation Levels
3.3 Resource Lock Types
3.4 Lock Modes
3.5 Lock Escalation
3.6 Viewing Locks
3.7 Setting the Isolation Level
3.8 Locking Hints

Implementing SQL Server 2000 Level 5 (2 hrs 2 min)

1.0 Transaction Processing (20 mins)
1.1 What is a Transaction?
1.2 Nesting Transactions
1.3 Transactions in Triggers
1.4 Trying out Transactions
1.5 Deadlocks
2.0 Data Transfer (26 mins)
2.1 Services Available
2.2 BCP
2.3 BULK INSERT
2.4 DTS
3.0 Full Text Search (28 mins)
3.1 What is Full Text Search?
3.2 Setting up Full Text Search
3.3 Performing a Full Text Search
3.4 Full Text System Procedures
3.5 FTS Enhancements in SQL 2000
4.0 Optimization (33 mins)
4.1 Optimizing your Server
4.2 Database design
4.3 Query Optimization
4.4 Index Usage
4.5 Statistics & Index Analyzer
4.6 SQL Server Profiler
4.7 Performance Monitor
5.0 System Databases & Tables (15 mins)
5.1 System Databases
5.2 System Tables

Implementing SQL Server 2000 Level 6 (1 hr 50 mins)

1.0 Using XML Extensions (61 mins)
1.1 Creating a Virtual Root
1.2 Using a Virtual Root
1.3 Returning Element Based XML
1.4 Passing Parameters
1.5 Multiple Result Sets
1.6 Using Stored Procedures
1.7 Inserting Data using XML
1.8 Joining Tables
1.9 Retrieving Data from VB
2.0 Application Development (49 mins)
2.1 OLE DB, ODBC and ADO
2.2 Using ADO

Data Warehouse Level 1 (2 hrs)

1.0 Introduction (20 min)
1.1 Topic Overview
1.2 Transactional vs. Analytical Data Systems
1.3 Data Warehouse Defined
1.4 Data Warehouses vs. Data Marts/OLAP
2.0 Dimensional Modeling & Planning (40 min)
2.1 Entity-Relationship Modeling vs. Dimensional Modeling 
2.2 Elements of the Dimensional Model
2.3 The Role of User Requirements
2.4 Identifying Source Data
2.5 Implementing the Data Warehouse Bus
3.0 Planning Facts (20 min)
3.1 What is a fact?
3.2 Measures
4.0 Planning Dimensions (40 min)
4.1 Planning Dimension Tables
4.2 Planning a Hierarchy
4.3 Special dimensions

Data Warehouse Level 2 (1 hr 45 min)

1.0 Building a Data Mart (40 min)
1.1 Creating the Database
1.2 Creating the Fact Table
1.3 Creating Dimension Tables
1.4 Creating Constraints and Indexes
2.0 Loading the Data Mart (50 min)
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 (15 min)
3.1 Backup and Restoration Considerations
3.2 Handling Changing Facts
3.3 Handling Changing Dimensions
3.4 Securing the Data Mart

Data Warehouse Level 3 (2 hrs)

1.0 Introduction to OLAP (15 min)
1.1 OLAP Concepts
1.2 Analysis Services Architecture
2.0 Cube Basics (20 min)
2.1 Cube Basics & Measures
2.2 Dimensions & Hierarchies
2.3 Aggregations
2.4 Using the Analysis Manager
3.0 Creating Dimensions (45 min)
3.1 Defining Terms
3.2 Creating Dimensions with the Dimension Wizard
3.3 Creating Time Dimensions
3.4 Using the Dimension Editor
3.5 Basic Dimension Properties
3.6 Using Member Properties
3.7 Virtual Dimensions
3.8 Multiple Hierarchies
4.0 Creating Cubes (40 min)
4.1 Selecting Facts and Measures
4.2 Choosing Dimensions
4.3 Creating Calculated Measures
4.4 Storage Models
4.5 Processing Dimensions
4.6 Processing Cubes
4.7 Using Cube Properties

Data Warehouse Level 4 (1 hr 40 min)

1.0 Managing Cube Partitions (15 min)
1.1 Partitions Concepts
1.2 Creating Cube Partitions
1.3 Merging Partitions
2.0 Optimizing Cubes (25 min)
2.1 Optimizing Aggregations with Storage Models
2.2 Usage-Based Optimizations
2.3 Tuning the Analysis Server
3.0 Special Features (15 min)
3.1 Using Drillthrough
3.2 Creating and Using Actions
4.0 Connecting Clients Using OLE DB (30 min)
4.1 Analysis Application Architecture
4.2 Using Excel as an Analysis Server Client
4.3 Overview of Client Interfaces
5.0 Introduction to Data Mining
5.1 Data Mining Basics
5.2 Creating Data Mining Models

Data Warehouse Level 5 (1 hr 40 min)

1.0 MDX Concepts Overview (15 min)
1.1 What is MDX?
1.2 Role of MDX in Application Architecture
1.3 MDX Examples
2.0 Creating Simple MDX Expressions (20 min)
2.1 Understanding the Hierarchy
2.2 Using Brackets
2.3 Identifying Members
2.4 Qualifying Sets of Members
2.5 Creating Calculated Members
3.0 Interacting with Cubes (20 min)
3.1 Anatomy of an MDX Query
3.2 Basic MDX Queries
3.3 Tuple Expressions
4.0 Performing Aggregations (25 min)
4.1 Calculating data in an MDX Query
4.2 Using Aggregate Functions
4.3 Using Time Set Functions
5.0 Using MDX with ADOMD (20 min)
5.1 Connecting to an Analysis Server
5.2 Executing an MDX Query
5.3 Manipulating Results

XML Enabled Applications Bonus Level 1 (Approx: 2 hrs)

1.0 SQL Primer
1.1 Using Hierarchical Data
1.2 XML Document Structure
1.3 Formatting with XSL
1.4 Validating Data with Schema
2.0 XPath Concepts for SQL Server
2.1 General Syntax & SQL Limitations
2.2 Location Paths
2.3 Filters
2.4 Operators & Functions
3.0 Using the FOR XML Transact SQL Statement
3.1 Basic Concepts
3.2 Using the RAW Mode
3.3 Using the AUTO Mode
3.4 Using the EXPLICIT Mode
4.0 Using the OPENXML Transact
SQL Statement
4.1 OPENXML Basics
4.2 Mapping Columns to XML
4.3 Defining Complex Mappings
4.4 Performance Issues

XML Enabled Applications Bonus Level 2 (Approx: 2 hrs)

1.0 Accessing SQL Data through HTTP
1.1 Working with Virtual Directories
1.2 Executing SQL Statements
1.3 Executing Stored Procedures
2.0 Using XML Templates
2.1 Creating Templates
2.2 Passing Parameters to Templates
2.3 Using XSL Style sheets with Templates
2.4 Accessing Database Objects
3.0 Using Annotated XDR Schemas
3.1 Annotated Schema Concepts
3.2 Mapping XML Elements to Columns
3.3 Specifying Explicit Mappings
3.4 Specifying Relationships
3.5 Other Annotations
4.0 Using XML with ADO
4.1 Persisting ADO Data as XML
4.2 Executing XML Queries using CommandStream
4.3 Attaching an XSL Style to XML Stream
5.0 Using the XML for SQL Update
5.1 Enhancements
5.2 Using Updategrams
5.3 Using the XML Bulk Load Utility

Hands-on, Multimedia, and Self-paced Training
Featured Customers
Free Newsletter
Reg. price: $899.00
Sale price: $179.00

Format

Product Details
  • Part#: sk-sql00x
  • Contents: Set of 20 CDs
  • Economy Shipping: Allow 4-7 business days for delivery*
Payment Options
  • Order securely online or call 1-888-797-4040 (301-589-3349)
  • All major credit cards (Visa, MasterCard, Amex, and Discover)
  • PayPal: Pay online quickly with your PayPal account
  • Company PO's accepted (Net 30); Call for multi-user license
  • *No tax except for Maryland (USA) residents.
Guarantees

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player