SQL Server Database Administration & Development

Week 1:
The History of SQL Server and relational databases

• Relational database history
• The evolution of SQL Server
• SQL Server and ANSI standards

Installing and configuring SQL Server

• Pre-installation steps
• Installing SQL Server
• Configuring the run-time SQL Server system
• Patching SQL Server - Service packs

SQL Server data storage management

• ACID
• SQL Server file management architecture
• Creating database files
• Creating SQL Server log files
• Using SQL Server file groups

Week 2:
T-SQL Language

• Data Types
• DDL
• DML
• SQL Functions
• Indexes
• Stored Procedures
• Triggers

Week 3:
SQL Server Job scheduling

• Common database scheduled jobs
• Configuring SQLMail
• Setting SQL Server and server alert thresholds
• Creating customized error conditions
• Scheduling multi-step job streams

SQL Server Security management

• Windows security management for the server
• Windows authentication mode
• SQL Server rights and role management

Week 4:
SQL Server Backup & Recovery

• Overview of SQL Server backup & recovery
• Incremental backups
• Restoring a SQL Server database
• Standby database overview
• Shipping SQL Server log files to standby databases

Week 5:
SQL Server database Replication

• Microsoft replication architectures
• Creating a replication topology
• Configuring SQL Server replication

Week 6:
SQL Server database Logshipping

• Microsoft Logshipping architectures
• Configuring Primary Server
• Configuring Secondary Server

Week 7:
Performance Tuning for the SQL Server DBA

• SQL Server monitoring for performance
• SQL Server startup parameter tuning
• T-SQL tuning
• SQL tuning for SQL Server
• Diagnosing storage and system problems
• Diagnosing session and O/S issues

 Week 8:

Introduction to Integration Services

• Defining SQL Server Integration Services
• Exploring the need for migrating diverse data
• The role of business intelligence (BI)

Week 9:
Introduction to SQL Server 2008 Integration Services

• Overview of SQL Server Integration Services
• Using Integration Services Tools
• What is new in SQL Server 2008 Integration Services

Developing Integration Services Solutions

• Creating an Integration Services Solution
• Using Variables
• Building and Running a Solution

Implementing Control Flow

• Control Flow Tasks
• Control Flow Precedent Constraints
• Control Flow Containers

Week 10:
Implementing Data Flow

• Data Flow Sources and Destinations
• Business Intelligence Transformations
• Row Transformations
• Row Set Transformations
• Auditing Transformations

Implementing Logging

• Overview of Integration Services Logging
• Enabling and Configuring Logging

Debugging and Error Handling

• Debugging a Package
• Implementing Error Handling

Week 11:
Implementing Checkpoints and Transactions

• Implementing Checkpoints
• Implementing Transactions

Configuring and Deploying Packages

• Package Configurations
• Deploying Packages
• Managing and Securing Packages

Week 12:

• Connecting to relational and multidimensional data sources
• Generating a Tablix reporting structure
• Building an interactive chart
• Creating reports with richly formatted text

• Multiple-level grouping and categorizing the results
• Applying aggregate functions

Producing various outputs from a Tablix

• Creating parallel dynamic group report formats
• Combining dynamic and static columns

Week 13:

• Building personalized reports with Model Designer
• Defining data source views
• Creating and refining models

• Improving data visualization with sparklines, data bars, maps and indicators
• Dragging and dropping entities onto charts and tabular reports
• Exploiting Analysis Services cubes as report models

• Accessing and controlling reports using URLs
• Leveraging RS Web services
• Embedding reports in applications with the Report Viewer

Week 14:

• Identifying measures and their suitable granularities
• Adding new measure groups and creating custom measures

• Implementing a Star and Snowflake Schema
• Identifying role-play dimensions
• Adding dimension attributes and properties

 Attendance
Good Attendance is imperative in order to keep up with your classes and to maintain good standing in school.  Since this institution is a business college, we encourage students to always conduct themselves in a professional manner and develop a positive attitude toward consistent attendance that can be carried with them in to the business community.  Absences should be documented in writing upon the first day of return.

Assignments/Projects/Exams
All school work activities/exercises and reading assignments are to be done as per instructors orders, and will be due upon request.  All tests are timed and must be completed within the specified time given.

• Make up work will be accepted, without penalty, with and excused absence.
• A grade of no more than 90% will be given for all work that is one day late.
• No work will be accepted after 3 days late and a grade of 0% will be assigned.
• Exams may only be made up the day of return from an excused absence with a grade of no more than 90% given.

Career Assistance

• Producing a professional resume
• Effective interview techniques
• The best interview answer styles
• Questions to ask an employer during an interview
• Professional networking opportunities
• Job search
• Job Fairs

 Student Surveys
Students are given an evaluation survey at the conclusion of the each class, and asked to provide constructive feedback.

The above is tentative and subject to change. Any changes will be announced in class. Students are held responsible for any changes announced in class.

Career Services:
Career assistance is an important part of the course curriculum.   Attendance at one career workshop is mandatory for all students. Individual resume and cover letter critiques are available with the career advisor by appointment weekdays between the hours of 9:00am – 1:00pm. 

Student Surveys
Students are given an evaluation survey at the conclusion of the each class, and asked to provide constructive feedback.

The above is tentative and subject to change. Any changes will be announced in class. Students are held responsible for any changes announced in class.