MS SQL Database Designe

Summary:

Microsoft's SQL Server 2005 meets the most demanding database management system requirements of the world's largest organizations. It offers increased ease of use and scalability, and provides extensive administration capabilities that improve the scalability, reliability and availability of the enterprise DBMS.

In this hands-on course, you explore many of the SQL Server 2005 capabilities using the graphical tools provided by Microsoft. You will gain a solid foundation on which to build specific SQL Server 200 database development or administration skills.

• What Is SQL Server
  
• SQL Server Integration
  
• SQL Server Databases
  
• SQL Server Security
  
• Working with 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

Module 3: Creating and Managing Databases

• Creating Databases
  
• Creating Filegroups
  
• Managing Databases
  
• Introduction to Data Structures
  

Module 4: Creating Data Types and Tables

• Creating Data Types
  
• Creating Tables
  
• Generating Column Values
  
• Generating Scripts
  

Module 5: 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

Module 6: 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
  

Module 7: 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

• Introduction to Views
  
• Advantages of Views
  
• Defining Views
  
• Modifying Data Through Views
  
• Optimizing Performance by Using Views
  
• Performance Considerations

• 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
  
  

Module 13: Optimizing Query Performance