|
|
|
Frequently Asked Questions
What is this course about?This course provides comprehensive coverage of Microsoft
SQL Server 2005, 2008 and 2008 R2 for database developers. You learn how to
use the power of .NET, and XML combined with Transact-SQL 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 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.
Does this course teach Transact-SQL?No. The main features of T-SQL such as writing stored procedures, functions and triggers are covered in
Course 532, SQL Server Transact-SQL® Programming: Hands-On. This course assumes this level of knowledge and covers extensions to those features such as Service Broker, End Points and data encryption.What versions of SQL Server are covered?This course covers SQL Server 2005, 2008 and 2008 R2.
When a particular part of the course is relevant only to a particular version
then this is clearly identified in the course material.
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 to the level of
Course 502, Programming with .NET: A Comprehensive Hands-On Introduction, 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 | 4.5 | | Encryption | 1.25 | | Service Broker | 4.0 | | .NET CLR | 4.0 | | LINQ | 2.5 | | Entity Framework | 3.0 |
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, 2008 and 2008 R2. Those experienced with earlier versions of SQL Server will benefit.What platform is used for the hands-on exercises?This course uses Microsoft SQL Server 2008 R2 running on Windows Server 2008.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: Retrieving data using LINQ to SQL and LINQ to Entity 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 Curriculum Q&As 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 and
related courses:
|
SQL Server is a registered trademark of Microsoft Corporation.
Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
|
|
Training Dates
 | Most events below can be taken in-class or live, online from your home or office with AnyWare. |
For AnyWare enrollments, please register at least 7 days prior to the start of the course.
More Dates and Locations.
Tuition for Course 133 (4 Days)
Bring this or any Learning Tree Course on-site to your location!
Your Course Tuition
Entitles You to...
- Class participation
- Team workshops
- Use of in-class hands-on equipment
- Comprehensive course materials
- Morning and afternoon refreshments
- Course Completion Certificate awarding Continuing Education Units
- FREE participation in Professional Certification
- FREE participation in College Credit programs (including related exams)
|
E-mail a Colleague
Course Details
Course Details PDF