SQL Server 2000 Implementation

This intensive five day course will introduce students to the major topics of building database applications with Microsoft SQL Server 2000. On course completion, students will be able to:

• Identify SQL Server features and editions. Explain how SQL Server is organized and identify SQL Server objects
• Analyze business requirements and design a database solution
• Create and manage a database and files
• Create and manage user-defined data types and user tables
• Use bulk loading procedures to load and transfer data. Design a replication solution to meet business requirements
• Use SQL queries to retrieve, organize, and summarize table data
• Create and test batches, views, stored procedures, and user-defined functions (UDFs)
• Use INSERT, UPDATE, and DELETE to manipulate data. Manage transactions, cursors, and triggers
• Monitor and optimize database performance

Target audience

This course is appropriate for anyone who will be implementing and maintaining SQL Server 2000 databases and database applications. This includes implementations in small LANs, large enterprises, or any environment in between. It will also be helpful for anyone involved with database application design and anyone considering SQL Server as part of a business solution. This course can be used for test preparation for Microsoft Exam 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.

Students should have attended a SQL Server 2000 Administration course or have equivalent knowledge and experience.

Course content

SQL Server fundamentals Introduction • Access and object basics • Tools and utilities

Database design Business analysis • Data modeling • Application design and database implementation

Database implementation Database design • Creating and modifying databases • Managing databases

Implementing tables Database objects • Data types • Table management • Managing constraints, rules, and defaults • Managing indexes

Data load and transfer Using bulk copy program (bcp) and BULK INSERT • Using Data Transformation Services (DTS) • Designing for replication

Data retrieval Data retrieval • T-SQL functions • Organizing data • Joins and subqueries • Heterogeneous data sources • XML data manipulation

SQL programming Programming fundamentals • Security and error fundamentals • Control-of-flow statements • Views • Stored procedures • User-defined functions (UDFs)

Data manipulation Data modification • Transactions and locking • Using server cursors • Using triggers

Database optimization Management tools • Managing locks • Database object optimization • Query optimization

Case study Business description • Project concerns • Project goals

Additional object references System tables • System functions • Data types and precision storage • DBCC command statements

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today