Microsoft SQL Server 2000 Database Programming
Author:Bill Ferguson/Certified Instructor
Language:english
Category:Operating Systems,Certification,
Lessons:0 | 0 hrs
Buy Now or get more information about Microsoft SQL Server 2000 Database Programming
Virtual Training Company’s Microsoft SQL Server 2000 Database Programming tutorial is the perfect tool for learning how to use SQL Server 2000 in the real world. Mark Long, a Microsoft certified instructor, begins the course be introducing you to SQL Server 2000 and some of the new features, including data transformation service enhancements, failover clustering improvements, and XML support. The course is based on the criteria needed for the Microsoft Certification Exam 70-229, a necessary exam to achieve MCDBA certification. You will learn about data integrity, including primary and foreign keys and constraints, using Transact SQL to retrieve and modify data, how to import and export data, and how to link servers together. Then move on to programming business logic and topics such as creating, executing and altering stored procedures. Mark Long finishes the course by teaching you how to optimize access to your data with indexes, query optimizer, and SQL profiler. To start learning right away, click on one of the movie topics below.
Microsoft SQL Server 2000 Database ProgrammingMicrosoft SQL Server 2000 Database Programming: Discovery Computer Training Ős Microsoft SQL Server 2000 Admin tutorial is just what you need to learn how to administer SQL Server in the real world and to help you prepare for the Microsoft Certification Exam 70-228. Mark Long, a Microsoft certified instructor, will teach you installation and building and backing up databases. He begins with general information about databases and general administrative responsibilities. He will then instruct you on the specifics of the administration of SQL Server 2000, such as installation, data storage, and file groups. You will learn the two main administrative tools, enterprise manager and query analyzer, through real-life examples. In this tutorial, you will also learn how to automate the administration and how to monitor the SQL server. To start learning right away, click on one of the movie topics below. Listed below are all of the chapter and lesson contents for the Microsoft SQL Server 2000 Database Programming Try For Free Right Now To help you evaluate our training, we have made some of the tutorials for Microsoft SQL Server 2000 Database Programming freely available. Click on any of the linked lesson listings below to preview Free! Microsoft SQL Server 2000 Database Programming
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Microsoft SQL Server 2000 Database Programming

SQL Server Overview

Course Intro
SQL Server Terminology
SQL 2000 & Windows 2000
SQL 2000 Features
SQL Applications (2/3/n Tier)
Transact SQL

Course Description

Course Description

Logical Data Modeling

Logical Database Design
Naming Conventions
Normalization
Logical Layers
Accessing Data

Creating a Database

Creating a Database
Database Parameters
Data File Placement
Creating Tables
Data Types Explained
Data Types Used
NULLS
Altering Tables
Generating Values
Generating Scripts

Data Integrity

Types of Data Integrity
Enforcing Data Integrity
Primary Key
Foreign Key
Unique Constraints
Check Constraints
Default Constraints
Disabling Constraints
Cascading Referential Integrity

Using Transact SQL

Query Analyzer
Transact SQL Elements
Language Elements
Functions
Controlling Logic Flow
Commenting TSQL
Batches
Transactions
Scripts
XML (Brief XML tutorial)

Transact SQL Specifics

SELECT
Grouping Data with SELECT
Summarizing Data with SELECT
INSERT
UPDATE
DELETE
XML (XML in query)

Data Import/Export

Importing and Exporting Data
Data Import/Export Methods
Using DTS

Heterogenous Data

Distributed Queries
Linked Servers
OPENQUERY
OPENROWSET/OPENXML

Stored Procedures

What Is a Stored Procedure?
Creating and Executing Stored Procedures
Altering and Dropping Stored Procedures
Input Parameters
Returning Values with Output Parameters
Recompiling Stored Procedures
Error Handling
Permissions Required
Guidelines for Stored Procedures

User Defined Functions

What is a UDF?
Creating a UDF
UDF Guidelines
Scalar UDF
Multi-Statement UDF
InLine UDF

Triggers

What is a Trigger?
When to Use Triggers/Considerations
Creating a Trigger
Under the Hood
Nesting Triggers

Views

What is a View?
Creating and Using a View
Advantages of Views

Indexes

Index Basics
Indexes in SQL Server 2000
Guidelines for Indexing
Selectivity
Creating an Index
Index Options
Maintaining Indexes
Rebuilding Indexes
Statistics
Index Tuning Wizard
Graphical Query Plan

Query Optimizer

Query Optimizer
Cost Limit
Viewing STATISTICS
Graphical Execution
General Query Guidelines

SQL Profiler

SQL Profiler
Using the SQL Profiler

Locking

Database Locking
Locking Levels
Lock Types
Session Locking Options
Deadlocks
Displaying Locking Info
01 SQL Server Overview 0101 Course Intro 0102 SQL Server Terminology 0103 SQL 2000 & Windows 2000 0104 SQL 2000 Features 0105 SQL Applications (2/3/n Tier) 0106 Transact SQL 02 Course Description 0201 Course Description 03 Logical Data Modeling 0301 Logical Database Design 0302 Naming Conventions 0303 Normalization 0304 Logical Layers 0305 Accessing Data 04 Creating a Database 0401 Creating a Database 0402 Database Parameters 0403 Data File Placement 0404 Creating Tables 0405 Data Types Explained 0406 Data Types Used 0407 NULLS 0408 Altering Tables 0409 Generating Values 0410 Generating Scripts 05 Data Integrity 0501 Types of Data Integrity 0502 Enforcing Data Integrity 0503 Primary Key 0504 Foreign Key 0505 Unique Constraints 0506 Check Constraints 0507 Default Constraints 0508 Disabling Constraints 0509 Cascading Referential Integrity 06 Using Transact SQL 0601 Query Analyzer 0602 Transact SQL Elements 0603 Language Elements 0604 Functions 0605 Controlling Logic Flow 0606 Commenting TSQL 0607 Batches 0608 Transactions 0609 Scripts 0610 XML (Brief XML tutorial) 07 Transact SQL Specifics 0701 SELECT 0702 Grouping Data with SELECT 0703 Summarizing Data with SELECT 0704 INSERT 0705 UPDATE 0706 DELETE 0707 XML (XML in query) 08 Data Import/Export 0801 Importing and Exporting Data 0802 Data Import/Export Methods 0803 Using DTS 09 Heterogenous Data 0901 Distributed Queries 0902 Linked Servers 0903 OPENQUERY 0904 OPENROWSET/OPENXML 10 Stored Procedures 1001 What Is a Stored Procedure? 1002 Creating and Executing Stored Procedures 1003 Altering and Dropping Stored Procedures 1004 Input Parameters 1005 Returning Values with Output Parameters 1006 Recompiling Stored Procedures 1007 Error Handling 1008 Permissions Required 1009 Guidelines for Stored Procedures 11 User Defined Functions 1101 What is a UDF? 1102 Creating a UDF 1103 UDF Guidelines 1104 Scalar UDF 1105 Multi-Statement UDF 1106 InLine UDF 12 Triggers 1201 What is a Trigger? 1202 When to Use Triggers/Considerations 1203 Creating a Trigger 1204 Under the Hood 1205 Nesting Triggers 13 Views 1301 What is a View? 1302 Creating and Using a View 1303 Advantages of Views 14 Indexes 1401 Index Basics 1402 Indexes in SQL Server 2000 1403 Guidelines for Indexing 1404 Selectivity 1405 Creating an Index 1406 Index Options 1407 Maintaining Indexes 1408 Rebuilding Indexes 1409 Statistics 1410 Index Tuning Wizard 1411 Graphical Query Plan 15 Query Optimizer 1501 Query Optimizer 1502 Cost Limit 1503 Viewing STATISTICS 1504 Graphical Execution 1505 General Query Guidelines 16 SQL Profiler 1601 SQL Profiler 1602 Using the SQL Profiler 17 Locking 1701 Database Locking 1702 Locking Levels 1703 Lock Types 1704 Session Locking Options 1705 Deadlocks 1706 Displaying Locking Info

Sponsors