This course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques).
- Course Outline
This course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques). Students will also learn to incorporate security requirements throughout their design.
Module 1 - Steps to Designing Databases for SQL Server 2005
- Steps to Designing Databases for SQL Server 2005
- Steps to Designing Stable Databases
- Find a Plan and Stick To It
- Know the Core Scope
- Seek Knowledge
- Create a Contract
- Consider History..
- Upgrade and Integrate
- Demo - Requirements Document
- A Picture Is Worth...
- Decision Making
- Demo - Modeling
- Logical Levels of Modeling
- Move from Conceptual to Logical
- Focus On Real World Dependencies
- Primary Key: Substitutes or Real Attributes
- Move Toward Logical ER
- Model Theorys Functional Dependencies
- Demo - Generate a Logical ER Form
- Why Normalize?
- Normalize How?
- Demo - Normalization Examples
- OLAP Designs
- Creating the Fact Table
- Creating Dimensions
- Refactor a Logical Model
- Physical Levels of Modeling
- Naming Conventions for Identifiers
- Additional Naming Conventions for Identifiers
- Demo - Showing Identifiers at Work
- RDMS Specific Data Type Decisions
- CLR Thoughts
- XML Thoughts
- How to Store - Character Type vs. New XML Type
- Computed Columns Thoughts
- Thoughts on Column Constraints
- Thoughts on Table Constraints
- New Data Definition Triggers
- Demo - Creating DDL Triggers
- "Who Are You? What Do You Want?"
- Protect the Data
- Configuration Settings
- Improve I/O Performance
- Database Options
- Sample Your Design
- Performance Considerations to Make During Design
- Clustered Index Thoughts
- Non - Clustered Index Thoughts
- Thoughts on XML Data Indexes
- Demo - Defining XML Indexes
- Thoughts on Computed Column Indexing
- Why Use Views
- Thoughts on Indexed Views
- Demo - Balancing Indexes with Cost
- Benefit with Partition Tables
- Thoughts on Summary Tables
- You Might Denormalize Now
- Thoughts on Snapshot Isolation
- Tempdb Does a Lot of Work
- Demo - Evaluating Tempdb Resources
- Validate Database Solution
- Data Access Designs
- SQL 2005 Provides Great Granularity of Permissions
- Define Access Policies
- User Defined Functions
- Special User Defined Functions Thoughts
- New User Defined Aggregates
- Demo - User Defined Aggregates
- Stored Procedures
- Demo - EXECUTE AS
- Dependencies Count In Designs
- If You Must Cross-DB...
- Old School Procedures
- Demo - Creation of Least Privilege Accounts
- Reach Out To COM
- Demo - Wrap an OLE Automation Or Do in CLR
- Reach Beyond the Instance
- Spread Data Around
- High Availability
- Course Closure
- Prerequisites & Certificates
Certificate of Completion
- Cancellation Policy
Cancellations or postponements received more than ten business days prior to the first day of the course will be fully refunded less a $75 processing fee. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.
- Map & Reviews
Acend Corporate Learning
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 752 times.