SQL Server Server-Side Programming: Hands-On

Frequently Asked Questions

What is this course about? This course provides comprehensive coverage of Microsoft SQL Server 2005 and 2008 for database developers. You learn how to use the power of Transact-SQL, .NET, and XML to build truly flexible, scalable and robust applications that meet today's business demands. The extensive hands-on exercises provide you with valuable opportunities to practice solving business problems with Microsoft's Transact-SQL and .NET programming languages. You also gain the skills needed to develop XML-based messaging applications. What background knowledge do I need? You should be comfortable with basic features of SQL Server and have experience with T-SQL programming at the level of Course 532, SQL Server Transact-SQL® Programming: Hands-On, or equivalent. You should also have experience with .NET programming ideally in C#. Who will benefit from this course? Typical participants include: Programmers, analysts, developers, designers, consultants and others who design and write applications that access Microsoft SQL Server databases Database professionals currently working with other DBMSs such as Oracle, DB2, Informix, IMS, or IDMS Is XML knowledge required? No. This course provides background information on XML as well as hands-on experience producing and using XML. What is SQL Server? What is Transact-SQL? SQL Server is a key component of Microsoft's Windows Server System. SQL Server is a full-featured relational database management system with support for robust server-side development. It runs on the Windows 2000/ 2003/2008 operating systems. Transact-SQL is Microsoft's dialect of SQL. It is used to manipulate data in databases and to administer databases. Knowledge of this language is essential for anyone developing applications for SQL Server. How much of this class is focused on Transact-SQL? Approximately 1.5 days of this 3 day course are dedicated to T-SQL programming related topics. The remaining days are focused on .NET and XML. Do I need to know the SQL language prior to attending this course? Yes. A basic knowledge of SQL is sufficient for this course. What is .NET CLR? .NET is Microsoft's virtual execution environment and tool set for programming languages and components. It provides a component-based architecture that is capable of distributing applications across an intranet or the Internet. The Common Language Runtime (CLR) forms the core of the Microsoft .NET framework and provides the execution environment for all .NET code. Do I need to have experience with C#, VB.NET or Visual Studio .NET? What .NET programming language is used in the course? Basic experience with a .NET programming language and C# in particular is assumed. This course presents code examples in the C# programming language. Is this course useful to me if I have limited SQL Server experience? No, this course requires T-SQL programming experience. Ideally, you will have T-SQL programming at the level of Course 532, SQL Server Transact-SQL® Programming: Hands-On. How much time is spent on each topic? Content Hours Architecture and tools 2.0 Querying and Storing XML 3.25 Web Service and HTTP EndPoints 1.25 Encryption 1.0 Service Broker 2.0 .NET CLR 3.0 LINQ 1.25 Entity Framework 1.75 Times, including the workshops, are estimates; exact times may vary according to the needs of each class. Is this course useful to me if I have already been developing for SQL Server 7.0 or 2000? Yes, most of the features discussed in the course are new in SQL Server 2005 and 2008. Those experienced with earlier versions of SQL Server will benefit. Why should I take this course instead of one offered by Microsoft? Learning Tree is dedicated to helping accelerate the careers of our clients by providing them with world-class technology and management training. Our independence from Microsoft (and any other vendor) allows us to give an unbiased view of what works and what does not. This course is objective in its approach, having been developed independently from Microsoft by industry experts who bring their real-world experience to the classroom. How much time is devoted to hands-on exercises? 45 % of class time is spent doing hands-on exercises. Exercises in this course include the following: Constructing and executing Transact-SQL stored procedures, user-defined functions, views, and triggers. Developing procedures in .NET CLR. Storing and retrieving XML. Encrypting data These and other hands-on exercises provide immediate reinforcement of material covered in the course lectures. How does this course relate to other Learning Tree courses? The SQL Server courses you take vary depending on the role you play in your organization. Please refer to the SQL Server 2005 and 2008 Curriculum Q&A for details on which courses are most appropriate to your role and the order in which you should take them. You may be interested in these SQL Server 2005 and 2008 and related courses: 382, Relational Database Design, Tools and Techniques: Hands-On  523, SQL Server® 2005 Reporting Services: Hands-On  134, SQL Server® 2005 Integration Services: Hands-On  534, Developing SQL Queries for SQL Server®: Hands-On  535, Developing High-Performance SQL Server® Databases: Hands-On  296, Project Management: Skills for Success

SQL Server is a registered trademark of Microsoft Corporation.