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 a Recruiting Specialist today.

RDBMS Concepts

  • Introduction to Database Management System
  • The Relational Model
  • Data Modeling
  • Normalization
  • Data Integrity
  • Advanced Database Objects

 Writing Queries using MS SQL Server 2008 T-SQL

  • Getting Started with Databases and Transact-SQL in SQL Server 2008
  • Querying and Filtering Data
  • Grouping and Summarizing Data
  • Joining Data from Multiple Tables
  •  Working with Subqueries
  • Modifying Data in Tables
  • Querying Metadata, XML, and Full-Text Indexes
  • Using Programming Objects for Data Retrieval
  • Using Advanced Querying Techniques

Implementing a Microsoft SQL Server 2008 Database

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

SQL Programming Project

Advanced SQL Querying and Programming

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

Microsoft SQL Server 2008 Integration Services

  • Guided tour of SSIS
  • Control Flow
  • Data Flows
  • Variables and Configurations
  • Advanced Control Flow
  • Error logging and handling
  • Advanced Data Flow
  • Package Deployment
  • Package Management
  • Scripting and custom components
  • Best Practices
  •  

Microsoft SQL Server 2008 Reporting Services

  • Introducing SQL Server Reporting Services
  • Creating Tabular and List Reports
  • Calculation and Formatting
  • Grouping and Sorting
  •  Working with Parameters
  • Creating Matrix Reports and Charts
  • Managing Reporting Services
  • Security
  • Snapshots and Subscriptions
  • Ad-Hoc Reporting with Report Builder 2.0
  • Programming Reporting Services
  • Advanced Reporting Services Programming
  •  

SSIS/SSRS Project

Final Project & Graduation

Note: This curriculum is subject to change without notice.