SQL Server Course Descriptions

SF 8001 - SetFocus Fundamentals

Course Length: 40 hours

This first week is designed to give the student a review of RDBMS concepts as well as an introduction to XML.

· Introduction to Database Management System

· The Relational Model

· Data Modeling

· Normalization

· Data Integrity

· Advanced Database Objects

· Codd’s Rules

· Introduction to DBA Concepts

· Basic XML

· Validating XML

· Windows Administration Basics

SF 8002 - Writing Queries using MS SQL Server 2008 T-SQL

Course Length: 40 hours

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

· 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

SF 8003 - Implementing a Microsoft SQL Server 2008 Database

Course Length: 40 hours

This SQL Server training class provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The class focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a 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

SF 8005 - Advanced SQL Querying and Programming

Course Length: 40 hours

The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2008. In this course you will learn the details and capabilities of T-SQL.

· 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

SF 8006 - Maintaining a Microsoft SQL Server 2008 Database

Course Length: 40 hours

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

· Installing and Configuring SQL Server

· Managing Databases and Files

· Disaster Recovery

· Managing Security

· Transferring Data

· Automating Administrative Tasks

· Implementing Replication

· Maintaining High Availability

· Monitoring SQL Server

· Troubleshooting and Performance Tuning

SF 8008 - Implementing and Maintaining MS SQL Server 2008 Integration Services

Course Length: 40 hours

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. This course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

· Introduction to SQL Server 2008 Integration Services

· Developing Integration Services Solutions

· Implementing Control Flow

· Implementing Data Flow

· Implementing Logging

· Debugging and Error Handling

· Implementing Checkpoints and Transactions

· Configuring and Deploying Packages

· Managing and Securing Packages

SF 8009 - Implementing and Maintaining MS SQL Server 2008 Reporting Services

Course Length: 40 hours

Microsoft SQL Server 2008 Reporting Services (SSRS) provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality. This course teaches students how to implement a Reporting Services solution in an organization. It discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.