SQL Server 2005 Training Curriculum

Below is a description of SetFocus' SQL Server Training curriculum for The Master's Program (as taught during its full-time day program). 

SetFocus utilizes the Microsoft Official Curriculum (MOC) seen below customized with its own training materials. In addition to the outline below SetFocus has developed labs, projects, and exams to test appropriate knowledge transfer. 

For a detailed description of the labs, projects, and exams incorporated into SetFocus' .NET Master's Program curriculum, please contact an Admissions Representative today.

Week 1
RDBMS Concepts
Designing Microsoft SQL Server 2005 Databases

• Introduction to Database Management System
• The Relational Model
• Data Modeling
• Normalization
• Data Integrity
• Advanced Database Objects
• Codds Rules
• Introduction to DBA Concepts
• Approaching Database Design Systematically
• Modeling a database at the logical level
  

Week 2
Querying using Transact SQL
Updating Your Database Development Skills to Microsoft SQL Server™ 2005

•  Describe the uses of and ways to execute the Transact-SQL language.
• Use querying tools • Write SELECT queries to retrieve data.
• Group and summarize data by using Transact-SQL.
• Join data from multiple tables.
• Write queries that retrieve and modify data by using subqueries.
• Modify data in tables
• Implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers.
• Design, create, and use stored procedures.
• Create and implement triggers.

Week 3
Introduction to XML
Updating Your Database Development Skills to Microsoft SQL Server 2005

• Basic XML
• Validating XML
• Technologies for handling XML data
• Using XPath to navigate a tree of nodes
• Using XQuery to link and query XML documents
• Using XML in SQL Server 2005

Week 4
Implementing a Microsoft SQL Server 2005 Database

• Create databases and database files.
• Create data types and tables.
• Use XML-related features in Microsoft SQL Server 2005.
• Plan, create, and optimize indexes.
• Implement data integrity in Microsoft SQL Server 2005 databases by using constraints.
• Implement data integrity in Microsoft SQL Server 2005 by using triggers.
• Implement views.
• Implement stored procedures.

Week 5
Implementing a Microsoft SQL Server 2005 Database continued
Updating Your Database Development Skills to Microsoft SQL Server 2005

• Implement functions.
• Implement managed code in the database.
• Manage transactions and locks.
• Use Service Broker to build a messaging-based solution.
• Use Notification Services to generate and send notifications.
• Use Native HTTP support

Week 6
SetFocus - Programming a database (SQL Server 2005) Project

Week 7
Maintaining a Microsoft SQL Server 2005 Database

• Install and configure SQL Server 2005.
• Manage database files.
• Backup and restore databases.
• Manage security.
• Monitor SQL Server.
• Transfer data into and out of SQL Server.
• Automate administrative tasks.
• Replicate data between SQL Server instances
• Maintain high availability.

Week 8
Designing a MS SQL Server 2005 infrastructure
Designing Security for Microsoft SQL Server 2005

• Analyzing Capacity Needs
• Designing a Strategy for Data Archiving
• Designing a Strategy for Database Server Consolidation
• Designing a Strategy for Data Distribution
• Designing a Database Server Infrastructure
• Designing a Strategy for Data Recovery
• Establishing Database Conventions and Standards
• Introduction to Designing SQL Server Security
• Designing a SQL Server Systems Infrastructure Security Policy
• Designing Security Policies for Instances and Databases
• Integrating Data Encryption into a Database Security Design
• Designing a Security Exceptions Policy
• Designing a Response Strategy for Threats and Attacks

Week 9
Designing High Availability Database Solutions Using Microsoft SQL Server 2005
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server¬ 2005
Tuning and Optimizing Queries using Microsoft SQL Server 2005

• Selecting the appropriate high availability solution
• Designing a database clustering solution
• Designing a highly available database storage solution
• Designing a log shipping solution
• Designing a database mirroring solution
• Designing a highly available solution based on replication
• Combining high availability technologies
• Documenting and testing a high-availability strategy
• Building a Monitoring Solution for SQL Server Performance Issues
• Troubleshooting SQL Server Connectivity Issues
• Troubleshooting SQL Server Data Issues
• Measuring Database Performance
• Optimizing Queries for Performance
• Optimizing an Indexing Strategy

Week 10
Admin Practical - Project Week

Week 11
SQL Server Reporting Services

• Introducing SQL Server Reporting Services
• Creating Reports
• Calculations and Formatting
• Grouping and Sorting
• Report Parameters
• Creating Matrix Reports and Charts
• Managing Reporting Services
• Reporting Services Security
• Snapshots and Subscriptions
• Ad-Hoc Reporting with Report Builder

Week12
Reporting Project Week & Final Project

Week 13
Completion of Final Project & Graduation

(subject to change)
 

Add the above content to:

Google   Y! MyWeb   Furl   Simpy   Spurl   Blink  Del.icio.us   Digg   Technorati