Course Name:	SQL 2000 Server Design Training MCDBA CBT Boot Camp
Deployment Options:	Interactive CDs with Exclusive LearningZone 7x24 Live Mentor
Course Price:	$795.00
Purchase Training Online:

Detailed Description

Schedule our instructor led classroom trainings at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the best SQL Trainers in the industry to help us develop the ultimate training & certification program. Our SQL Server 2000 Implementing Database Design training course will teach you how to design and implement a powerful, functional database with Microsoft SQL Server 2000. Expert instructor Paul D. Sheriff friendly presentation style makes this complex technical subject matter easy to understand. At the conclusion of this course you will understand the core techniques of implementing database design and will be prepared to pass exam #70-229 which provides core credit toward Microsoft Certified Database Administrator certification, elective credit toward Microsoft Certified Systems Engineer certification, and elective credit toward Microsoft Certified Solution Developer

Included with this Program:

6 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components with over 12+ hours of instruction Focused on practical solutions to real-world development Comprehensive, understandable, and reusable as reference material

Course Outline:

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

Please contact E&A Education and Consulting Services Group for details and a complete course outline.You can also order by calling sales at 888-742-3214

Other Expertise:

CBT's and Online Training Catalog Oracle Applications Training and Consulting Peoplesoft Applications Training and Consulting SAP Applications Training and Consulting Security Technologies Training and Consulting Telecommunications Training and Consulting Wireless Technology Training and Consulting