Updating your Database Development Skills to Microsoft SQL Server 2005

Product Code: MS2734 Overview 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. What’s Included? All our public scheduled training courses offer delegates the following facilities which are all included at no extra cost: - Mini Continental Breakfast, with a choice of Croissants, Pastries, Cereals, Juices, and of course Tea and Coffee Buffet Lunch A Selection of Soft Beverages are available throughout the Training Day Full Course Manual (Official Curriculum Courseware for Technical Courses) Course Exercise Files on CD or Floppy Disk Course Stationery Pack (Pen, Pencil and Paper) Framed Course Certificate (Vendor Accredited where required) Objectives 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). 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. 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 Optimisation Schema and Objects Programming Objects UDDT 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. Code You may also know this course as: MS2734 MS 2734 MOC2734 MOC 2734 M2734 2734

More Products in SQL Server 2005 Administering and Automating Microsoft SQL Server 2005 Databases and Servers Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 Designing a Microsoft SQL Server 2005 Infrastructure Designing a Reporting Solution Architecture using Microsoft SQL Server 2005 Reporting Services Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services Designing an ETL Solution Architecture using Microsoft SQL Server 2005 Integration Services Designing High Availability Database Solutions Using Microsoft SQL Server 2005 Designing Microsoft SQL Server 2005 Databases Designing Microsoft SQL Server 2005 Server-Side Solutions Designing Security for Microsoft SQL Server 2005 Designing the Data Tier for Microsoft SQL Server 2005 Implementing a Microsoft SQL Server 2005 Database Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services Implementing and Maintaining Microsoft SQL Server 2005 Integration Services Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services Maintaining a Microsoft SQL Server 2005 Database Microsoft SQL Server 2005 for the Experienced Oracle Database Administrator Troubleshooting and Optimising Database Servers Using Microsoft SQL Server 2005 Tuning and Optimising Queries Using Microsoft SQL Server 2005 Updating Your Database Administration Skills to Microsoft SQL Server 2005 Updating your Database Development Skills to Microsoft SQL Server 2005 Upgrading to Microsoft SQL Server 2005

More Categories In Learning & Development

MCSE From Scratch, Business Strategies, MCSD From Scratch, HR Development, Sales & Marketing Training, Management Training, Essential Communication Skills, Microsoft .NET, Office 2007, Microsoft Security, SharePoint Server, Small Business Server 2003, SQL Server 2005, SQL Server 2008, Windows NT4 Server, Windows Server 2003, View More Learning & Development...