Microsoft SQL Server 2005 Database Developer

Duration: 5 days | Price: Contact a Career Consultant for pricing

Students Will Learn:
  • Reporting and Analysis
  • Data Mining
  • XML Integration
  • Triggers, Functions, and Stored Procedures
  • .NET integration
  • Aggregates
  • Database Engine Management
  • Development Studio
  • Full-text Search
  • CLR

Description: This class consists of five days of training that focuses on the new features available in SQL Server 2005. You will learn how to install SQL Server 2005; use the SQL Server 2005 client tools to administer databases and create database applications; administer the database engine; use SQL Server Integration Services (SSIS) to import, export, and transform data; use SQL Server Replication to synchronize data between databases; use SQL Server Reporting Services (SSRS) to create dynamic database reports; perform intelligent and complex queries using SQL Server Full-Text Search (SSFTS); use SQL Server Notification Services (SSNS) to push data updates to subscribing users; and use SQL Server Service Broker to establish asynchronous communications between database applications. You will also learn how to create international database applications; integrate XML with a database; monitor and improve database and server performance; and optimize data availability for an environment.

This course also includes an introduction to using SQL Server Analysis Services (SSAS) to create and manage data warehouse and implement data mining and discusses in detail the new security concepts available in SQL Server 2005. A multitude of new programmability features are covered including integration of the .NET Common Language Runtime (CLR).

Students who are new to database concepts and database programming should attend the 3-day course Relational Database Design prior to this course.

Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at HOTT's 3-day SQL Programming course, or equivalent knowledge, is helpful but not required.

Microsoft SQL Server 2005 Database Developer Course Overview:

An Overview of SQL Server 2005
  • New Features
  • Database Roles
  • Client Tools
   Installing SQL Server 2005
  • Preparing For Installation
  • Setup User Interface
  • Installing Express Edition
  • Configuring an New Instance
SQL Server Database Engine
  • Managing Services
  • Managing Servers
  • Database Projects
  • Database Objects
   SQL Server Integration Services (SSIS)
  • What Happened To DTS?
  • What is ETL?
  • Integration Services Projects
  • SSIS Objects
  • Expressions
SQL Server Analysis Services (SSAS)
  • OLAP vs. OLTP
  • Data Warehousing
  • Data Mining
  • Architecture
  • Analysis Services Projects
  • Analysis Services Scripting Language (ASSL)
  • XML for Analysis (XMLA)
  • Predictive Mining Model Language (PMML)
  • Data Mining Extensions (DMX)
  • Multidimensional Expression Language (MDX)
   SQL Server Replication
  • Overview
  • Replication Types
  • Agents
  • Implementing
  • Administering
  • Enhancements
SQL Server Reporting Services (SSRS)
  • Overview
  • Creating, Managing, and Delivering
  • Administering
   SQL Server Full-Text Search (SSFTS)
  • Overview
  • Architecture
  • Writing Queries
  • Administering
SQL Server Notification Services (SSNS)
  • Overview
  • Subscription Management
  • Event Collection
  • Subscription Processing
  • Formatting and Delivery
   SQL Server Service Broker
  • Overview
  • Conversations
  • Message Ordering and Coordination
  • Transactional Asynchronous Programming
  • Loosely Coupled Applications
  • Components
  • Administering
Security
  • Overview
  • Catalog Views
  • Security Functions
  • Cryptographic Functions
  • CLR Integration
  • Native XML Web Services
  • Integration Services
  • Analysis Services
  • Replication
  • Reports
  • Notifications
  • Service Broker
   International Databases
  • Unicode Data
  • Date and Time Issues
  • Collations
  • International SQL
  • Integration Services
  • Analysis Services
  • Reports
  • Notifications
  • Service Broker
  • Full-Text Searches
Working with XML
  • Data Type
  • Indexes
  • Schema Collections
  • For XML
  • OpenXML
  • Native XML Web Services
   Data Availability
  • Disaster Recovery
  • High Availability
  • Backup
  • Restore
Monitoring and Performance
  • Windows Performance Monitor
  • SQL Server Profiler
  • Database Engine Tuning Advisor (DTA)
  • Federated Database Servers
  • Partitioned Tables
  • Partitioned Indexes
  • Query Performance Issues
  • Transactions and Locks
  • Best Practices for Native XML Web Services
   Programming SQL Server 2005
  • Transact-SQL
  • CLR Integration Overview
  • Stored Procedures
  • User-Defined Functions
  • User-Defined Types
  • DML Triggers
  • DDL Triggers
  • SQL Management Objects (SMO)
  • Integration Services
  • Replication Management Objects (RMO)
  • Reports
  • Notifications

Student Testimonials

"I really enjoyed the class. It was a very good overview of SQL Server 2005 and components. I gained a lot of knowledge and new ideas on how we can accomplish things better with SQL 2005."
– C.V., Access

"I felt the course was very beneficial. The instructor was professional and knew the material very well. I thought the hands-on portion was excellent. I felt it really tied the class together well."
– N.M., Cardinal 16

"The instructor was excellent! The material was presented in a well thought out, friendly, easily digestible way. I would recommend this class to anyone."
– G.B., Wells Fargo Financial

Hands On Technology Transfer, Inc.
1 Village Square, Suite 8
14 Fletcher Street
Chelmsford, MA 01824
1-800-413-0939 | 1-978-250-4299

Copyright© 2008 Hands On Technology Transfer, Inc.