|
Designing Microsoft SQL Server 2005 Databases
(24912732) |
|
Return to Search Results | Request More Information | Pre-Register | View Comments | Recommend this Course |
 |
Summary:
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 Offered By:
New Horizons Computer Learning Centers
460 Amherst Street
Nashua, New Hampshire 03063
Courses by this Learning Provider |
|
 | | Since 1982, New Horizons Computer Learning Centers has grown to become the largest independent IT training company worldwide. |
|
|
|
Course Cost:
$995.00
|
Promotions:
Dice Learning users - take any SQL Server training course from New Horizons and receive a fully-licensed copy of SQL Server 2008 Standard Edition with 1 CAL License—FREE ($850 Value)! See http://www.newhorizons.com/FreeSQL2008.aspx for details.
|
Start Date - End Date:
02/22/2010 - 02/23/2010 (More dates) (More dates at this location)
|
Start Time - End Time:
8:30 am - 4:30 pm
|
Classroom Type:
Physical Classroom
|
Geographic Location:
Nashua, New Hampshire 03063
|
|
Description:
Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience
Core Vendor Technology: Microsoft
Content Category: MOC |
|
Objectives:
Lesson 1: Approaching Database Design Systematically
Overview of Database Design
Gathering Database Requirements
Creating a Conceptual Database Design
Lesson 2: Modeling a Database at the Logical Level
Building a Logical Database Model
Designing for OLTP Activity
Designing for Data Warehousing
Evaluating Logical Models
Lesson 3: Modeling a Database at the Physical Level
Designing Physical Database Objects
Designing Constraints
Designing for Database Security
Designing Server and Database Options
Evaluating the Physical Model
Lesson 4: Designing for Database Performance
Designing Indexes
Planning for Table Optimization
Planning for Database Optimization
Lesson 5: Designing a Database Access Strategy
Designing for Secure Data Access
Designing User-Defined Functions
Designing Stored Procedures
Lesson 6: Modeling Database Dependencies
Modeling Local Database Dependencies
Modeling Remote Database Dependencies
|
|
Applicable Vendor Technologies:
Microsoft
|
|
Associated Disciplines:
Databases
Software
|
|
RECOMMEND THIS COURSE
You must be logged in as a Candidate to recommend courses
|
|
|
|
