Professional SQL Server (for newcomers to SQL Server 2000 or 2005)
Professional SQL 2005 (for newcomers to SQL 2000 or 2005) is a 5 day hands-on training course that provides experienced developers with the essential skills for developing and administering SQL Server 2000 and 2005.
Currently over 90% of applications developed with .NET Framework technologies involve data and as SQL Server is the logical choice for most .NET applications, gaining a thorough understanding is an asset for both a developer and their employer.
Participants will rapidly become comfortable with developing applications against SQL Server and following further practical experience at this level, should undertake our Advanced SQL Server course to learn about upgrading SQL Server 2000 to 2005.
Participants should have previous experience with Visual Basic, C#, C, Java or similar OO development languages.
Whilst the hands-on labs in this course are primarily based on SQL Server 2005, we also understand that many customers will still be using SQL Server 2000 for some time. Participants will therefore be refreshed in the SQL Server 2000 toolset to ensure that they can work within both environments. The content comprises a balance of topics from each of the key SQL Server disciplines:
- A good grounding in the T-SQL language (2 days)
- SQL Server development skills (1 day)
- SQL Server administration skills (1 day)
- SQL Server business intelligence, reporting and basic troubleshooting skills (1 day)
Course Outline |
T-SQL Development |
- Introduction to SQL Server and the use of SQL Server Management Studio
- Retrieving information from a single table
- Grouping the returned rows
- Retrieving information from more than one table
- Using the results of queries in other queries
- Thinking in sets rather than using cursors
- Transactions and Isolation Levels
- Handling errors in T-SQL
|
Developing Database Objects |
- Developing Views
- Developing Stored Procedures in T-SQL
- Developing User-Defined Functions in T-SQL
- Developing Triggers in T-SQL
|
Essential SQL Server Administration |
- Installing and configuring SQL Server
- Creating and maintaining databases
- Managing users, schemas and security
- Backing up and restoring databases
|
Business Intelligence Options in SQL Server |
- Creating reports
- Importing and exporting data
- Introduction to Analysis Services
|
Keeping Productive with SQL Server |
- SQL Server troubleshooting fundamentals
| |
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.
|
|
|
Copyright 2007 - Readify Pty Ltd