Boston Computer School

You are here:  Home » Courses » Microsoft » SQL Server Developer 

SQL Server Developer

A Tour of SQL Server 2008

  • SQL Server 2008 Editions, Components, and Tools
  • Using SQL Server Management Studio (SSMS)
  • Working with Tables and Queries
  • New Transact-SQL Features
  • Business Intelligence Services

Installing SQL Server 2008

  • Preparing for Installation
  • Upgrading an Earlier Version
  • Installation Steps
  • Configuring the Server

Designing and Creating a Database

  • Relational Database Design Principles
  • Implementing the Design

Data Selection Queries

  • Understanding Transact-SQL
  • The SELECT Statement
  • The WHERE Clause
  • Using ORDER BY to Sort Data
  • The GROUP BY Clause
  • Joining Tables

Modifying Data

  • Modifying Data
  • Inserting Data
  • Updating Data
  • ·Deleting Data
  • Understanding Transaction Isolation

Working with SQL Server Management Studio

  • Getting Started with SSMS
  • Exploring the Object Explorer
  • Working with the Query Editor

Transact-SQL Programming

  • Overview of Transact-SQL
  • Using Built-In Functions
  • Controlling Flow
  • Ranking Results

Transactions and Error Handling

  • Transaction Concepts
  • Using TRY/CATCH Error Handling

Creating Views, Stored Procedures, Cursors and Triggers

  • What Is a View?
  • Creating Views
  • Creating Stored Procedures
  • Creating Cursors
  • Creating Triggers

Creating User-Defined Functions

  • User-Defined Function Overview
  • Scalar Functions
  • Inline Table-Valued Functions
  • Multi-Statement Table-Valued Functions
  • Using Functions, Views, and Stored Procedures

Advanced Query Techniques

  • Generating XML with FOR XML
  • Using APPLY
  • Creating Recursive Queries
  • Creating Pivot Queries
  • Executing Dynamic SQL

Understanding and Implementing Security

  • Security Overview
  • Authentication
  • Authorization
  • Permissions

Analyzing and Tuning Performance

  • Evaluating Performance
  • Monitoring with SQL Server Profiler
  • Tuning Queries
  • Indexes