Training Course:SQL Server 2005School/Trainer:KnowledgeAir
Buffalo, New York, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This two-day instructor-led 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.
After completing this course, students will be able to:
- Approach database design from a systematic perspective, gather database requirements, and formulate a conceptual design.
- Analyze and evaluate a logical database design.
- Apply best practices for creating a physical database design.
- Apply best practices when designing for database scalability.
- Design a database access strategy.
- Use best practices to model database dependencie
--------------------------------------------------------------------------------
Course Outline
--------------------------------------------------------------------------------
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
...''
Please go to the school's official website for training price and schedule:
http://knowledgeair.com/
Phone:866-322-3685
School Address:
KnowledgeAir Buffalo
726 Exchange St, Suite 628
Buffalo, NY 14210
KnowledgeAir Rochester
100 Allens Creek Road
Rochester, NY 14618
Jobs & Resumes: Buffalo
Houses & Roommates: Buffalo
Search other schools for SQL Server 2005 training resources.
Other training courses offered by KnowledgeAir:
Crystal Reports 11
Access 2003
Excel 2003
Excel 2007
OneNote 2007
PowerPoint 2003
Word 2007
Illustrator CS3
InDesign CS3
Photoshop CS3
Implementing a Microsoft SQL Server 2005 Database
Maintaining a Microsoft SQL Server 2005 Database
SQL Advanced Querying
SQL
Windows 2003 Active directory
Exchange Server 2007
ACT!
CISSP
Advanced Administration of Blackberry Enterprise Server
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Facts:
We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa. |
|
|
