|
|
Class Outline*
|
|
| Request Info | Contact Us
|
|
Introduction to .NET for DBAs using Visual Studio 2008
Duration:
2 Days
Overview:
This 2-day class will give the working DBA sufficient skills with .NET that can be effectively used in all areas supported by SQL Server. The course starts with learning of Visual Basic language concepts, including Data Types, Variables, Classes, and Objects, while building simple console applications, and then steps up to Handling Exceptions by using try/catch blocks and other programming tools. The agenda then covers ADO.NET used for connecting to data sources and related topics. Students then learn to work with SQL 2008’s features, like SQL Server Management (SSMS), Object Explorer, Query Editor, plus others, and then the development feature SQL CLR (Common Language Runtime). Finally, an overview of SQL Business Intelligence is discussed.
Audience:
This course is intended for SQL Server 2005 or 2008 Database Administrators who need to work with various components of .NET in a support role.
Prerequisites:
No previous experience required with Visual Studio; basic understanding of SQL Server and core DBA concepts is needed.
|
|
Outline:
|
Chapter 1: Getting Started with .NET
|
- Learn the advantages and architecture of the .NET Framework.
- Examine sample Microsoft Intermediate Language code.
- Setup a development profile in Visual Studio .NET.
- Create Console Application projects in Visual Studio .NET 2008.
- View the code that Visual Studio generates and understand what it does.
- Explore the Object Browser in the Integrated Development Environment.
- Take advantage of Visual Studio's exception-handling features.
|
|
Chapter 2: Data Types and Variables
|
- Understand how to create variables and assign values.
- Review the data types available in Visual Basic and see how they are based on the .NET Framework.
- See how to convert a variable from one data type to another.
- Explore operators and see how they can be used to change values and compare expressions.
|
|
Chapter3: Classes and Objects
|
- Investigate .NET Framework classes, to see how classes can be consumed in code.
- Learn about properties, methods, and fields.
- Create instances of classes using class constructors.
- Generate and test classes using the Class Designer and Object Test Bench tools.
- Investigate class details, including reference vs. value types, object finalization, manipulating object references, and shared members.
|
|
Chapter 4: Handling Exceptions
|
- Learn to use try/catch blocks to handle runtime errors.
- Use Exception objects to determine what error has occurred.
- Throw exceptions back to procedure callers.
- Use the finally block to run code unconditionally.
- Create and handle user-defined exceptions.
|
|
Chapter 5: Accessing Data Using ADO.NET
|
- Connect to data sources using .NET data providers.
- Handle connection events.
- Take advantage of connection pooling.
- Work with provider statistics.
|
|
Chapter 6: Working with SQL Server Management Studio
|
- Learn to configure and use SQL Server Management Studio (SSMS).
- Increase productivity by using the Object Explorer.
- Create and execute queries with the Query Editor.
- Learn to get help efficiently with SQL Server Books Online.
|
|
Chapter 7: Advanced SQLCLR Code Techniques
|
- Learn how to create advanced SQLCLR code modules
- Create custom aggregates, user-defined types
- Explore how performance can be improved when ordered table-valued functions are used.
- See how to manage SQLCLR code modules in a database.
|
|
Chapter 8: Business Intelligence
|
- Learn about how Integration Services allows moving and transforming data between myriad data stores.
- Understand the features Analysis Services provides to analyze data and extract information from it.
- Explore Reporting Services and how it provides reports to get data to users in a form they can readily use.
|
|
|
|
|
*Content, days, and times vary depending on your location. Please view the outline prior to purchase or contact the local center for more information.
|