Designing Microsoft SQL Server 2005 Server-Side Solutions

Product Code: MS2781 Overview This three-day, instructor-led course provides students with the knowledge and skills required to design Server-Side solutions for Microsoft SQL ServerT 2005. The course focuses on teaching Database Developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organisation. 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 At the end of the course, students will be able to: Select SQL Server Services to Support Business Needs Design a Security Strategy Design a Data Modelling Strategy Design a Transaction Strategy for a SQL Server 2005 Solution Evaluate Advanced Query and XML Techniques Design a Service Broker Solution Plan for Source Control, Unit Testing and Deployment Design a Notification Services Solution Audience This course is intended for Professional Database Developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment. Prerequisites Before attending this course, students must have: Experience reading User Requirements and Business-need Documents An understanding of Security Requirements Skills to design a database to 3NF, know the tradeoffs when backing out of the fully Normalised Design and being familiar with Design Models, such as Star and Snowflake Schemas Basic Monitoring and Troubleshooting skills Basic knowledge of the Operating System, Platform and of Application Architecture Some experience with a Reporting Tool In addition, it is recommended, but not required, that students have completed Course MS2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL, Course MS2779: Implementing a Microsoft SQL Server 2005 Database and Course MS2780: Maintaining a Microsoft SQL Server 2005 Database Code You may also know this course as: MS2781 MS 2781 MOC2781 MOC 2781 M2781 2781

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