|
MS-2073
Programming a Microsoft SQL Server
Course Length:
5 days
Tuition:
$2125
Course Overview
This course provides students with the
technical skills required to program a database solution by using
Microsoft® SQL Server 2000.
Prerequisites
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 NTFS.
- 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, and
many-to-many).
- How data is stored in tables (rows and
columns)
- Knowledge
of basic Transact-SQL syntax (SELECT, INSERT, UPDATE, and DELETE
statements).
- Familiarity
with the role of the database administrator.
For students who do not meet these
prerequisites, the following course provides students with the necessary
knowledge and skills:
- Course 2151, Microsoft Windows 2000
Network and Operating System Essentials ·
- Course 2152, Implementing Microsoft
Windows 2000 Professional and Server ·
- Course 2071, Querying Microsoft SQL
Server 2000 ·
- Course 1609, Designing Data Services and
Data Models
Microsoft Certified Professional
Exams
This course will help the student prepare
for the following Microsoft Certified Professional exam:
- Exam 70-229, Designing and Implementing
Databases with Microsoft SQL Server 2000 Enterprise Edition
Skills Gained
At the end of the 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.
|
