Training Course:Updating Your Database Development Skills to Microsoft SQL Server 2005 (Certificate)School/Trainer:New Horizons Computer Learning Centers of Pakistan
Karachi, Pakistan
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.
Who Should Attend:
This course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers.
At Course Completion:
After completing this course, students will be able to: - Use the Development Tools provided with SQL Server 2005. - Use Transact-SQL enhancements to perform database development tasks. - Develop XML-based Solutions using SQL Server 2005. - Build Message-Based Services with the Service Broker. - Implement Web Services using Native HTTP Endpoints. - Build Notification Services Applications. - Implement Database Functionality with Managed (.NET) Code. - Build Client Applications with the .NET Framework. - Build Administrative Applications with SQL Management Objects (SMO).
Prerequisite(s) or equivalent knowledge:
2073 Programming a Microsoft SQL Server 2000 Database
Prerequisite Comments:
MCDBA certification or equivalent knowledge
Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0
Outline: Top
Lesson 1: SQL Server 2005 Overview
SQL Server 2005 Components and Architecture
SQL Server Developer Tools
SQL Server 2005 Security Implementation
Top
Lesson 2: Transact-SQL Enhancements in SQL Server 2005
Data Definition Language Enhancements
Data Manipulation Language Enhancements
Structured Exception Handling
Lesson 3: Using XML in SQL Server 2005
XML Enhancements in SQL Server 2005
The xml Data Type
Using XQuery
Lesson 4: Using Service Broker
Service Broker Architecture
Using the Service Broker
Lesson 5: Using Native HTTP Support
Native HTTP Support in SQL Server 2005
Configuring Native HTTP Support
Top
Lesson 6: Using Notification Services
Notification Services Architecture
Building Notification Services Solutions
Lesson 7: Using the .NET CLR in SQL Server 2005
SQL Server and the .NET CLR
Implementing Managed Code in SQL Server 2005
Lesson 8: Developing Client Applications
Developing Client Applications with ADO.NET
Data Binding in the .NET Framework 2.0
Lesson 9: Using SQL Management Objects
Introduction to SQL Management Objects
Replication Management Objects
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.nhpakistan.com.pk/
Phone:+(92) 021-4382352-3-4
School Address:
49-C, Block 6, P.E.C.H.S, Shahra-e-Faisal, Karachi, Pakistan.
Jobs & Resumes: Karachi
Houses & Roommates: Karachi
Travel Agencies: Karachi
Search other schools for Updating Your Database Development Skills to Microsoft SQL Server 2005 training resources.
Other training courses offered by New Horizons Computer Learning Centers of Pakistan:
Analyzing Requirements and Defining Microsoft .NET Solution Architectures
Microsoft .NET Development
Foundations of Microsoft .NET 2.0 Development
Advanced Foundations of Microsoft .NET 2.0 Development
Developing Microsoft ASP.NET 2.0 Web Applications
Programming Microsoft .NET Applications with Microsoft Visual Studio 2005
Programming with the Microsoft .NET Framework using Microsoft Visual Studio 2005
Complete .NET Security
C# 3.0 Programming in the .NET Framework
SQL Server 2005
writing queries using microsoft sql server 2008 transact-sql
Maintaining a Microsoft SQL Server 2005 Database
Implementing a Microsoft SQL Server 2005 Database
Designing Microsoft SQL Server 2005 Server-Side Solutions
Designing Microsoft SQL Server 2005 Databases
designing the data tier for microsoft sql server 2005
tuning and optimizing queries using microsoft sql server 2005
Designing Microsoft SQL Server 2005 Infrastructure and Services
Designing Security for Microsoft SQL Server 2005
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:
ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges. |
|
| 
