Designing Microsoft SQL Server 2005 Databases
Short course
In London
Description
-
Type
Short course
-
Location
London
This two-day instructor-led course provides students with the knowledge and skills to design databases for Microsoft SQL Server 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modelling techniques). Students will also learn to incorporate security requirements throughout their design.
Facilities
Location
Start date
Start date
Reviews
Course programme
Lessons
- Overview of Database Design
- Gathering Database Requirements
- Creating a Conceptual Database Design
- Gathering Database Requirements
- Creating a Conceptual Design
- Apply a systematic approach to database design.
- Devise an appropriate strategy for gathering database requirements for a specified project.
- Formulate requirements into a conceptual model that serves as a basis for defining entities, attributes, and relationships.
Lessons
- Building a Logical Database Model
- Designing forOLTPActivity
- Designing for Data Warehousing
- Evaluating Logical Models
- Determine Entities, Attributes, Relationships, Keys, and Constraints
- Normalization and Schema Assignment
- Apply best practices to the task of building a new logical database model.
- Apply guidelines for normalization when designing anOLTPmodel.
- Apply guidelines for designing a data warehouse database.
- Evaluate an existing logical model of a database.
Lessons
- Designing Physical Database Objects
- Designing Constraints
- Designing for Database Security
- Designing Server and Database Options
- Evaluating the Physical Model
- Specify Database Object Naming Standards
- Define Tables and Columns and Choose Data Types
- Apply guidelines for designing physical database objects.
- Apply best practices when designing constraints.
- Include security best practices in the design of databases.
- Apply best practices when designing database and server options.
- Apply best practices when evaluating the physical model.
Lessons
- Designing Indexes
- Planning for Table Optimization
- Planning for Database Optimization
- Apply Optimization Techniques
- Apply best practices for designing indexes.
- Apply guidelines when planning for table optimization.
- Apply guidelines in choosing additional optimization techniques.
Lessons
- Designing for Secure Data Access
- Designing User-Defined Functions
- Designing Stored Procedures
- Design data retrieval objects
- Design security for data retrieval objects
- Apply best practices when designing for secure data access.
- Apply guidelines for designing user-defined functions.
- Apply best practices for designing stored procedures.
Lessons
- Modelling Local Database Dependencies
- Modelling Remote Database Dependencies
- Design Cross-Database Access
- Design Linked Servers
- Apply guidelines for modelling local database dependencies.
- Apply guidelines for modelling remote database dependencies.
Designing Microsoft SQL Server 2005 Databases