 |
Courses & Certifications
|
 |
MS2782 Designing Microsoft SQL Server 2005 Databases
| Course start date: |
01-Dec-2008, 23-Feb-2009, 27-Apr-2009, 25-May-2009 |
| Training Location |
9 Denison St, Newcastle West |
| Duration: |
2 Days |
| Price: | $1,200.00 Inc GST |
Overview
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.
Prerequisites
Before attending this course, students must:
- Have experience reading user requirements and business-need documents. For
example, development project vision/mission statements or business analysis reports.
- Have experience reading and drawing business process flow charts.
- Have experience reading and drawing entity relationship (ER) diagrams.
- Understand Transact-SQL syntax and programming logic.
- Be able to design a database to 3NF and know the tradeoffs when backing out of the
fully normalized design (denormalisation) and designing for performance and business
requirements in addition to being familiar with design models, such as Star and
Snowflake schemas.
- Have basic monitoring and troubleshooting skills.
- Have basic knowledge of the operating system and platform. That is, how the
operating system integrates with the database, what the platform or operating system
can do, and how interaction between the operating system and the database works.
- Have basic knowledge of application architecture. That is, how applications can be
designed in three layers, what applications can do, how interaction between the
application and the database works, and how the interaction between the database
and the platform or operating system works.
- Know how to use a data modelling tool.
- Be familiar with SQL Server 2005 features, tools, and technologies.
- Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential, or equivalent experience.
Course Outline
Module 1: Approaching Database Design Systematically
This module explains how to acquire the skills to
approach database design with a systematic
perspective. A systematic approach involves
formulating your database design process,
following guidelines on how to gather and
document database requirements, and following
best practices when formulating a conceptual
design.
Lessons
- Overview of Database Design
- Gathering Database Requirements
- Creating a Conceptual Database Design
Module 2: Modelling a Database at the Logical Level
This module explains the best practices followed
when you build a new logical database model. You
will also learn the guidelines for normalisation
when designing an OLTP model and when
designing a data warehouse database. Finally, you
will learn to evaluate the existing logical model of a
database.
Lessons
- Building a Logical Database Model
- Designing for OLTP Activity
- Designing for Data Warehousing
- Evaluating Logical Models
Module 3: Modelling a Database at the Physical Level
This module explains the guidelines to be followed
when designing physical database objects and
constraints. The module also covers the best
practices for designing database security and for
designing database and server options. Finally, this
module covers the best practices for evaluating the
physical model.
Lessons
- Designing Physical Database Objects
- Designing Constraints
- Designing for Database Security
- Designing Server and Database Options
- Evaluating the Physical Model
|
Module 4: Designing for Database Performance
This module explains the best practices to be
followed for designing indexes. The module also
covers the guidelines for planning table
optimisation, and choosing additional optimisation
techniques.
Lessons
- Designing Indexes
- Planning for Table Optimisation
- Planning for Database Optimisation
Module 5: Designing a Database Access Strategy
This module explains the best practices to be
followed when designing for secure data access.
The module also covers the guidelines for
designing user-defined functions. Finally, this
module explains the best practices for designing
stored procedures.
Lessons
- Designing for Secure Data Access
- Designing User-Defined Functions
- Designing Stored Procedures
Module 6: Modelling Database Dependencies
This module explains guidelines for modelling local
database dependencies. This module also covers
the guidelines for modelling remote database
dependencies.
Lessons
- Modelling Local Database Dependencies
- Modelling Remote Database Dependencies
|
|
Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications.
We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.
With our mobile training room we can provide a range of courses on-site at your premises.
|
|
|
|
