Professional SQL 2005 (upgrading your skills from SQL Server 2000)
SQL Server 2005 is the latest upgrade of Microsoft Corporation's very popular database management system. Readify's Professional SQL 2005 (upgrading your skills from SQL Server 2000) training course provides developers and database administrators with the essential knowledge they require to take advantage of the new and enhanced capabilities in this version.
Attendees should have experience in SQL Server 2000 development or database administration, or will have attended our Professional SQL course.
The training offers a balance of topics from several SQL Server disciplines and the content may be delivered in several ways. Database administrators may wish to take only the first 3 days (common topics and the DBA skills) whilst developers should, in general, take the full 5 day course. It is also possible to take the first day as a stand-alone workshop which affords a summary of changes to the architecture and tools, along with modules on security and language enhancements.
Participants will rapidly become comfortable with how to manage the enhanced functionality in SQL Server 2005 and how to take advantage of the new capabilities of this upgraded version.
Course Outline |
Common topics |
- SQL Server 2005 Architecture
- Using the SQL Server 2005 Administrative Tools
- SQL Server 2005 Security Enhancements
- SQL Server 2005 T-SQL Enhancements
|
Upgrading administrative skills |
- Installing SQL Server 2005
- Upgrading to SQL Server 2005
- Monitoring SQL Server 2005
- Maintaining SQL Server 2005 Databases and Indexes
- SQL Server 2005 Disaster Recovery
- Maintaining Highly-Available Data with SQL Server 2005
- SQL Server 2005 Replication Enhancements
- Introduction to SQL Server 2005 Integration Services
|
Upgrading developer skills |
- Using SQL Server 2005 Service Broker
- Reporting Services Enhancements in SQL Server 2005
- Native HTTP Support in SQL Server 2005
- Using XML in SQL Server 2005
- SQL Server 2005 Notification Services
- .NET CLR Integration in SQL Server 2005
- Understanding Concurrency Options in SQL Server 2005
- ADO.NET v2 Enhancements for Accessing SQL Server 2005
| |
Learn the essentials required to take advantage of the new capabilities in the latest upgrade to Microsoft's database management system.
|
|
Our intensive .NET curriculum uses hands-on labs to teach experienced application developers the pillars of .NET 2.0 framework.
|
|
This highly interactive 5 day course comprises of 30 modules across 9 different topics in a hands on lab environment. Gain an understanding of the various components that form the standard developer tool kit in the world of .NET 3.5 including, WPF, WCF, ASP .NET and LINQ.
|
|
Professional BizTalk is a 5 day hands-on course for senior developers and solution architects, teaching best practices using BizTalk Server 2006.
|
|
This 2 day hands-on course imparts the knowledge and skill required to install and configure a computer running Microsoft BizTalk Server 2006, as well as how to deploy and manage BizTalk applications in a production environment.
|
|
This 3 day instructor-led course is based on Official Microsoft Learning Product course 5061 and provides students with the knowledge and skills required to successfully implement MOSS2007.
|
|
Intensive 4 day course exploring development within SharePoint Products and Technologies with a focus upon developing fundamental WSS building blocks, plus assembling and configuring business solutions using MOSS2007.
|
|
This 3 day course guides participants through all aspects of creating a Silverlight solution including Silverlight design, develop and using Silverlight on the Server.
|
|
This 5 day hands-on course provides experienced developers with the essential skills for developing and administering SQL Server 2000 and 2005.
|
|
This course provides a deep understanding of the architecture of Team System and Team Foundation Server, and how Team System's components can be utilised to build better software more efficiently, including how to extend and customise the built-in functionality of VSTS.
|
|
This 2 day workshop is based on Juval Lowy's (iDesign) 5 day WCF Master Class run exclusively in Australia for Readify.
|
|
This 2 day hands on course teaches participants how to develop real world applications using Windows Presentation Foundation.
|
|
|