|
Introduction
This course provides students with the technical skills required to program a database solution by using Microsoft SQL Server™ 2000.
At Course Completion
After completing this course, students will be able to:
- Describe the elements of SQL Server 2000;
- Design a SQL Server enterprise application architecture;
- Describe the conceptual basis of programming in Transact-SQL;
- Create and manage databases and their related components;
- Implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers;
- Plan for the use of indexes; create and maintain indexes;
- Create, use, and maintain data views; implement user-defined functions;
- Design, create, and use stored procedures;
- Create and implement triggers; program across multiple servers by using distributed queries, distributed transactions, and partitioned views;
- Optimize query performance; analyze queries;
- Manage transactions and locks to ensure data concurrency and recoverability.
Prerequisites
Before attending this course, students must have:
- Experience using the Microsoft Windows® 2000 operating system to:• Connect clients running Windows 2000 to networks and the Internet.
- Configure the Windows 2000 environment.
- Create and manage user accounts.
- Manage access to resources by using groups.
- Configure and manage disks and partitions, including disk striping and mirroring.
- Manage data by using the NTFS file system.
- Implement Windows 2000 security.
- Optimize performance in Windows 2000.
- An understanding of basic relational database concepts, including:
- Logical and physical database design.
- Data integrity concepts.
- Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, many-to-many).
- How data is stored in tables (rows and columns).
- Course 2071: Querying Microsoft SQL Server 2000 with Transact-SQL or knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements).
- Familiarity with the role of the database administrator.
Course Outline
- SQL Server Overview
- What Is SQL Server?
- SQL Server Integration
- SQL Server Databases
- SQL Server Security
- Working with SQL Server
- Overview of Programming SQL Server
- Designing Enterprise Application Architecture
- SQL Server Programming Tools
- The Transact-SQL Programming Language
- Elements of Transact-SQL
- Additional Language Elements
- Ways to Execute Transact-SQL Statement
- Creating and Managing Databases
- Creating Databases
- Creating Filegroups
- Managing Databases
- Introduction to Data Structures
- Creating Data Types and Tables
- Creating Data Types
- Creating Tables
- Generating Column Values
- Generating Scripts
- Implementing Data Integrity
- Types of Data Integrity
- Enforcing Data Integrity
- Defining Constraints
- Types of Constraints
- Disabling Constraints
- Using Defaults and Rules
- Deciding Which Enforcement Method to Use
- Planning Indexes
- Introduction to Indexes
- Index Architecture
- How SQL Server Retrieves Stored Data
- How SQL Server Maintains Index and Heap Structures
- Deciding Which Columns to Index
- Creating and Maintaining Indexes
- Creating Indexes
- Creating Index Options
- Maintaining Indexes
- Introduction to Statistics
- Querying the sysindexes Table
- Setting Up Indexes Using the Index Tuning Wizard
- Performance Considerations
- Implementing Views
- Introduction to Views
- Advantages of Views
- Defining Views
- Modifying Data Through Views
- Optimizing Performance by Using Views
- Performance Considerations
- Implementing Stored Procedures
- Introduction to Stored Procedures
- Creating, Executing, Modifying, and Dropping Stored Procedures
- Using Parameters in Stored Procedures
- Executing Extended Stored Procedures
- Handling Error Messages
- Performance Considerations
- Implementing User-defined Functions
- What Is a User-defined Function?
- Defining User-defined Functions
- Examples of User-defined Functions
- Implementing Triggers
- Introduction to Triggers
- Defining Triggers
- How Triggers Work
- Examples of Triggers
- Performance Considerations
- Programming Across Multiple Servers
- Introduction to Distributed Queries
- Executing an Ad Hoc Query on a Remote Data Source
- Setting Up a Linked Server Environment
- Executing a Query on a Linked Server
- Managing Distributed Transactions
- Modifying Data on a Linked Server
- Using Partitioned Views
- Optimizing Query Performance
- Introduction to the Query Optimizer
- Obtaining Execution Plan Information
- Using an Index to Cover a Query
- Indexing Strategies
- Overriding the Query Optimizer
- Analyzing Queries
- Queries That Use the AND Operator
- Queries That Use the OR Operator
- Queries That Use Join Operations
- Managing Transactions and Locks
- Introduction to Transactions and Locks
- Managing Transactions
- SQL Server Locking
- Managing Locks
Microsoft Certified Professional Exams
Exam 70-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Course Materials
The student kit includes a comprehensive workbook and other necessary materials for this class.
Related courses:
|
What is Software Assurance?
Software Assurance (SA) provides an easy way for Microsoft's Volume Licensing customers to stay current with the latest and most innovative Microsoft products. Under the SA program, customers acquire the right to install any new release of products covered in the agreement during the term of their coverage. Companies can acquire tomorrow's technology at today's prices and have the ability to spread payments annually instead of paying up front. Visit www.microsoft.com/licensing to learn more about Microsoft's licensing programs.
What is the SA Enhancement Offering?
The SA Enhancement Offering is designed to increase customer satisfaction by giving customers more value from Software Assurance and a better Microsoft product experience. The Enhancement Offering contains tools, training, and support as well as additional licensing benefits which meet different customer needs across product segments and across customer segments. The many benefits include:
- Training vouchers redeemable
- Employee Purchase Program
- Home Use Program
- Problem Resolution Support
- TechNet Subscription
- Technology & Tools
What is the Software Assurance (SA) Training Voucher Program?
Qualifying organizations that purchase Software Assurance receive training credits from Microsoft. Each training credit is worth the equivalent of one day of training at Networking Technologies™. Customers can redeem these credits for SA Training Vouchers for select Microsoft courses from «Networking Technologies»™.
How to Get Started?
Contact the individual in your organization responsible for software purchases to verify that you purchased volume licensing with Software Assurance. We can help you activate your benefits and administer the training vouchers. To register for a training contact Education Center «Networking Technologies»™ directly via e-mail edu@tex.kiev.ua
|
