Our Decisions Incorporated

If you are a database developer or designer, then this course is for you. This course is designed for the application developer who wants to know and effectively utilize the critical elements of SQL server. Our training will help you avoid some of the pitfalls associated with SQL Server elements

Learning Objectives

Effectively administer SQL Server 2005 using Enterprise Manager, Query Analyzer and SQL Profiler
Effectively use Tables, Views, Stored Procedures, Triggers and User Defined Functions
Effectively use SQL Server Agent
Effectively Administer Database Security
Effectively Transfer and Transform data using Data Transformation Services

Who Should Attend This

This course will benefit software developers, engineers, analysts and report writers

Name	Description	Activity
Scheduled Jobs And Alerts	SQL Server Agent Configuring the Agent Setting up SQL Mail Defining jobs for routine tasks Relating logs, errors and alerts Creating an alert for operators Automating tasks with jobs	SQL Server Agent Configure the Agent to create an alert that runs a job and notifies an operator
Implementing The Physical Database	Implementing The Physical Database A SQL Server Database MDF, LDF and primary files Filegroups Putting data and indexes on different files to speed up processing Managing the size of your database	Implementing The Physical Database Create a database with primary and secondary files as part of a filegroup.
Tables, Views, Stored Procedures, Triggers and User Defined Functions	Tables, Views, Stored Procedures, Triggers and User Defined Functions Clustered and Non-Clustered Indexes, primary keys and foreign keys Creating Views and using Check Option and Schema Binding Views that use a Federation of Servers Muliple input and output from a stored procedure (SPROC). User Defined Functions, the table data type and when to use a SPROC BCP command line calls, Data Transformation Services Database Replication, comparing snapshot, transactional and merge replication	Implementing The Physical Database Create a sample database with a table, view, stored procedure and UDF
BCP, Data Transformation Services (DTS) and Replication	BCP, Data Transformation Services (DTS) and Replication BCP command line calls, Data Transformation Services Database Replication, comparing snapshot, transactional and merge replication	BCP, Data Transformation Services (DTS) and Replication Set up Snapshot replication and use DTS to transfer data
Database Security	Database Security Understanding Fixed Server and Fixed Database Roles Understanding Precedence of Roles Mananging statement and object permissions Ownership chains	Database Security Adding users to the Server and Datbase Roles

Microsoft SQL Server 2005 Developer 2 Day Course