Master's Program: SQL Server 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' SQL Server Master's Program curriculum, please contact an Admissions Representative today.


Writing Queries using MS SQL Server 2008 T-SQL

  • Querying, Filtering, Grouping and Summarizing Data
  • Joins and Subqueries
  • Modifying Data in Tables
  • Querying Metadata, XML, and Full-Text Indexes
  • Using Programming Objects for Data Retrieval and Advanced Querying Techniques

Implementing a Microsoft SQL Server 2008 Database

  • Create databases and database files
  • Create data types, tables and Indexes
  • Implementing Data Integrity by Using Constraints and Triggers
  • Using XML
  • Implementing Views, Stored Procedures, Functions, Managed Code
  • Managing Transactions and Locks
  • Using Service Broker

SQL Programming Project

Advanced SQL Querying and Programming

  • SQL 2005 and SQL 2008 new features workshop
  • Hierarchies, Recursive querying, Spatial data
  • Working with dates, Concurrency and locking
  • Query performance tuning, Database security and encryption

Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

  • Developing Integration Services Solutions
  • Implementing Control Flow, Data Flow, Logging
  • Debugging and Error Handling
  • Implementing Checkpoints and Transactions
  • Configuring, Deploying, Managing and Securing Packages

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

  • Basic Reports
  • Manipulating Data Sets, using Report Models
  • Publishing and Executing Reports, using Subscriptions
  • Administering and Programming Reporting Services

SSIS/SSRS Project

Final Project & Graduation


Note: This curriculum is subject to change without notice.