SQL Server 2005 Implementation

This 5-day course will prepare students for Microsoft's 70-431 exam (TS: Microsoft SQL Server 2005-Implementation and Maintenance). In addition, the course is appropriate for any person pursuing Database Administrator, Database Developer, or Business Intelligence Developer careers, or for any other persons who need a technical understanding of SQL Server 2005 features and implementation.

On course completion, students will be able to:

• Install SQL Server 2005.
• Use SQL Server management tools.
• Create and manage databases.
• Develop a database design for data.
• Create tables, constraints, and indexes.
• Retrieve data from SQL Server 2005 databases.
• Create programmable objects.
• Manage data in a SQL Server 2005 database.
• Support XML data in a SQL Server 2005 database
  

Target audience

This course is appropriate for anyone who will be implementing and maintaining SQL Server 2005 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.

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

Course content

SQL Server 2005 Installation   SQL Server features . SQL Server installation . Alternative installations

SQL Server management tools   SQL Server 2005 services . Management tools . SQL Server settings . Database Mail

Database management   SQL Server data storage . Database management . Capacity planning and management

Data design   The data design process . Table and data design . Data normalization . Data types

Tables, constraints, and indexes   Objects . Tables and constraints . Indexes

Data retrieval   Queries . Transact-SQL functions . Data organization . Multiple table queries . Data modification . Query Designer

Programmable objects   Programming fundamentals . User views . Stored procedures . User-defined functions

Data management   Multiple language support . Full-text search . Partitions . Error handling . Transactions and locking . Triggers

XML support   XML fundamentals . The XML data type . XML methods and indexes . XML and relational data integration

Data transfers   Bulk transfers . SQL Server 2005 Integration Services . XML import and export

SQL Server security   Principles . Server securables . Database and schema securables . SQL auditing . Encryption . CLR security

Management and maintenance SQL Server Agent . Distributed queries . Replication

SQL Server optimization   Monitoring and optimization . Database optimization . Database tune-ups . Query optimization concepts

Reliability and availability   Database backup . Database restore . Log shipping . Database snapshots . Mirrored databases

Applications   Service Broker . HTTP endpoints

Troubleshooting and repair   Blocks and deadlocks . SQL Server errors . Recovery

Appendix A: Outlander Spices case study

Appendix B: Command reference

Appendix C: MCTS 70-431 exam objectives map

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