Home sep Microsoft Technical Training sep Computer Training Videos

Designing Databases with Microsoft SQL Server 2000 CBT Training Videos on CD

designing databases training videos

Price: $595.00

Course ID: 2071-2073-tv

Microsoft Course Number:2071 / 2073

CBT Planet’s convenient, instructor led classroom training can be scheduled at your convenience. You’ll love the convenience of the format while receiving expert instruction. The best SQL Trainers in the industry assisted us in the development of this ultimate certification training program.

The self-study SQL Server 2000 Implementing Database Design CBT training video course teaches you design and implementation of a powerful, functional database using Microsoft SQL Server 2000. Our expert instructor, Linda Harris, takes a complex technical subject and makes it easy to understand.

When you complete this SQL Designing training video course, you will understand core techniques for implementing database design. You will also be prepared to pass exam #70-229. This exam provides core credit towards Microsoft Certified Database Administrator certification as well as elective credit towards the Microsoft Certified Systems Engineer certification and elective credit towards the Microsoft Certified Solution Developer certification.

Training Course Includes:

  • Six multi-media CD-ROMs. Live instructor-led classroom sessions take advantage of full audio and video
  • Demonstration components
  • Printable course materials for offline study
  • Exclusive LearningZone Live Mentor, valued at $195, offers online help whenever you need it, night or day!
  • Certified instructors answer your questions through live chats, anytime 24/7
  • Focused content with practical solutions to real development problems
  • Microsoft Authorized MeasureUp Exam Simulation
  • We share our proven technique: Actual Exam Secrets Review
  • CBT Planet’s Certification Exam Pass Guarantee
  • Free: One-year upgrade policy





Designing Databases with Microsoft SQL Server 2000 Training Video CBT Features:
   
   


Microsoft Course 2071 / 2073 Outline:

Level One

SQL Server & Database Concept
Introduction to SQL Server
SQL Server Services
Databases, Objects, & Systems Tables
Metadata retrieval
SQL Server Security
4 Stages of Implementing a SQL Server Database
Database Normalization

 

Level Two

Programming SQL Server
Layers
Data Access
Programming Tools
Transact- SQL
Statements
3 Language Statements
Batch Directives
Identifiers
Color Codes
Query Analyzer Demo
Additional Language Elements
Aggregate & Scalar Functions
Different Types of Statements
Executing Transact-SQL Statements
SQL Syntax Review

 

Level Three

Databases and Database Files
Defining Databases
Creating a Database
How the Transaction Log Works
Setting Database Options
Creating Filegroups
Recommendations
Review

 

Level Four

Creating Data Types & Tables
Data Types
Create & Drop a Table
User Defined Data Types
Data Type Guidelines
Generating Column Values
The Identity Property
Automatically Generating Scripts
Review

 

Level Five

Implementing Data Integrity
Data Integrity & Constraints
Adding a Default Constraint
CHECK Constraints
Adding a CHECK Constraint
Primary Key, Unique & Foreign Constraint
Review


Level Six

Indexing Overview
Storing & Retrieving Data
Storing Heaps
B-tree Structures
Clustered Indexes
Non-Clustered Indexes
Querying the Sysindexes Table
Page Splits, Design & Performance
Indexing Guidelines
Performance Considerations
Review


Level Seven

Creating and Maintaining Indexes
Creating Indexes
Computed Columns
Viewing a List of Indexes
Indexing Options
Statistic Binary Column
Creating, Updating & Viewing Statistics
DBCC Command
The Turning Wizard & Performance Considerations
Review


Level Eight

Implementing Views
Introduction to Views
Creating Views
Using Indexed Views
Review

 

Level Nine

Transact-SQL Stored Procedure
Defining Stored Procedures
Looking at a Stored Procedure
Using Parameters
Creating & Calling a Stored Procedure
Recompiling Stored Procedures
Executing an Extended Stored Procedure
Handling Error Messages
Review


Level Ten

User-defined Functions
What is a User Defined Function
Creating a User Defined Function
Examples of User Defined Functions
Review


Level Eleven

Implementing Triggers
Using & Creating Triggers
Different types of Triggers
Creating a Delete Trigger
Enforcing Data Integrity & Business Rules
Review


Level Twelve

Programming Multiple Servers
Interlocation to Distributed Queries
Setting Up a Linked Server
Working with Linked Servers
Review


Level Thirteen

Optimizing Query Performance
Introduction to the Query Optimizer
Viewing STATISTICS Statements Output
STATISTICS & Show plan Options
The Graphical Execution Plan
Comer Queries
Creating Indexes That Cover a Query
Creating Indexes That Cover a Query
Review
Monitoring Functionality
SQL Profiler
Execution Plan


Level Fourteen

Analyzing Queries
Different Types of Queries & Joins
Review


Level Fifteen

Managing Transactions & Locks
Introduction to Transactions & Locks
Examples of Transactions
Locks
Basic Trips
Review