SQL Server 2005

Solartech, Inc
New York, NY, United States

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

Course Description:

'' This three-day instructor-led 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.

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

Prerequisites
Before attending this course, students must have:

• MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.
• Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
• Knowledge of SQL Server 2000/7.0:• Database and server architecture.
• Database Security
• Transact SQL
• Query Engine
• DDL
• DML
• Optimization
• Schema and Objects
• Programming Objects
• UDF
• Triggers
• Stored Procedures
• Optimization
• SQL XML
• .NET Development (Visual Basic .NET or C# .NET)
• ADO.NET

• In addition, it is recommended, but not required, that students have completed:• Course 2073, Programming a Microsoft SQL Server 2000 Database.

...''

Phone:877.SOLARTECH

School Address:

110 Wall Street, Level 2
New York, NY 10004

621 Route 46, Level 2
Hasbrouck Heights, NJ 07604-3118


Jobs & Resumes: New York
Houses & Roommates: New York

Windows SharePoint Services
Mobile Applications Using the Microsoft .NET Compact Framework
COM+ Applications using MS .NET Enterprise Services
C sharp Programming with Microsoft .NET
Upgrading Web Development Skills from ASP to Microsoft ASP .NET
Microsoft Access 2002 Programming
Programming with XML in the Microsoft .NET Framework
Internet Information Services 6.0
Microsoft Commerce Server 2002
Content Management Server 2002
Tuning and Optimizing Queries Using Microsoft SQL Server 2005
Network Security
Microsoft Security Guidance
Windows Public Key Infrastructure
Biztalk Server 2006 for Developers
Microsoft Windows Vista and the 2007 Office System Client Products
Windows Vista Developing
Microsoft Office 2007
Windows SharePoint Services 3.0

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: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.