|
Microsoft SQL Server 2000 Database Programming Tutorials Online |
![]() |
|
Description
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. |
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
sku |
|
