Microsoft SQL 2000 Programming for Certification Training
Also Available: Crystal Reports Training
learn to provide useful information from databases, create and manage your own reports, integrate reports with SQL, format and more.
MS SQL 2000 Programming - Implementing and Design Videos and CDs - MCSD, MCSE and MCDBA Certification
 This 6 volume course teaches you to administer and troubleshoot 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.
Also available as on 11 volumes, the entire course prepares you for Exams 70-228 and 70-229. MCSD, MCDBA and MCSE Certification Electives
Boot Camp and Self Study Courses for MCSD and MCDBA
|
5 Video Set MCSD SQL 2000 Implementing and Design (I&D) (Exam 70-229) Description
Six Video Set
|
kysq2b
|
$395.00
|
|
|
5 CD Set MCSD SQL 2000 Implementing and Design (I&D) (Exam 70-229) Description
Six CD Set,
|
kysq2bm
|
$395.00
|
|
|
10 Video Set Server Administration and Implementing & Design for the SQL Server 2000 with What's
New? and MeasureUp Exams (Exam 70-228 and 70-229)
|
kysq2a
|
$795.00
|
|
|
10 CD Set Server Administration and Implementing & Design for the SQL Server 2000
and MeasureUp Exams (Exam 70-228 and 70-229)
|
kysq2am
|
$795.00
|
|
Implementing SQL Server 2000 Training 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 Training 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 Training 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 Training 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
|
|
|
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
|
|
Back to SQL Server Administration.
|
