Course 3595: Establishing Database Conventions and Standards for Microsoft SQL Server 2005

Introduction In this online learning course you will establish database conventions and standards for Microsoft® SQL Server™ 2005 to help organize your server infrastructure and make your database administrator and developer teams more productive. This course also includes access to five searchable E-Reference books for quick just-in-time problem solving. This course will also help prepare you for certification exam 70-443. Objectives At the end of the course, students will be able to:

• Establish Database Naming Conventions
• Define Database Standards

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Establishing Database Conventions and Standards Module Introduction Establishing Database Naming Conventions Lesson Introduction Benefits of Implementing Database Naming Conventions Potential Problems with Common Naming Practices Guidelines for Establishing Database Naming Conventions Identifying Good Database Naming Conventions Self Test Defining Database Standards Lesson Introduction Types of Database Standards Guidelines for Defining Transact-SQL Coding Standards Guidelines for Establishing Database Access Standards Guidelines for Creating Deployment Process Standards Identifying Good Database Infrastructure Standards Self Test Lab: Establishing Database Conventions and Standards Lesson Introduction Scenario Exercise: Proposing Improved Object Naming Conventions Lab Review Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled