Microsoft SQL Server 2005 Database Developer

Hands On Technology Transfer - Canada
Calgary, Edmonton, Mississauga, Montreal, Ottawa, Toronto, Vancouver, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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).
...''

Phone:1-800-413-0939

School Address:

75 Watline Avenue
Suite 129
Mississauga, Ontario
L4Z3E5 Canada

Jobs & Resumes: Calgary, Edmonton, Mississauga, Montreal, Ottawa, Toronto, Vancouver, Winnipeg
Houses & Roommates: Calgary, Edmonton, Mississauga, Montreal, Ottawa, Toronto, Vancouver, Winnipeg

MFC Programming for C++ Programmers
COM/DCOM
Microsoft Windows System Programming
Advanced Visual Basic Programming
ASP.NET 2.0 Programming Using C#
ASP.NET 2.0 Programming Using Visual Basic.NET
C# 2.0 Programming for Windows Applications
Visual Basic.NET 2.0 Programming for Windows Applications
SQL Programming
Microsoft SQL Server 2005 Administration
SQL Server 2005 Reporting Services
SQL Server 2005 Business Intelligence Application Development
Windows 2003 Server and XP Administration
Windows Server 2003 Active Directory
MCSE 2003
MCSA 2003
MCDBA
MCTS: SQL Server 2005 Certification
MCITP: Database Administrator Certification

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.