- Introduction to the .NET Platform.
- Overview of the .NET Framework.
- Benefits of the .NET Framework.
- he .NET Framework Components.
- Languages in the .NET Framework
- After completing this module, you will be able to list the major elements of the .NET Framework and explain how the C# language fits into the .NET Platform. This includes:
- Describing the .NET Platform.
- Listing the main elements of the .NET Platform.
- Explaining the language support in the .NET Framework.
- Describing the .NET Framework and its components.
The following topics are covered in this module:
Take a closer look: Download Sample Module 2(Portable Document Format, 953 KB.)
Module 2: Overview of C#
- Structure of a C# Program.
- Basic Input/Output Operations.
- Recommended Practices.
- Compiling, Running, and Debugging.
- After completing this module, you will be able to analyze the basic structure of a C# application and be able to document, debug,compile, and run a simple application. This includes:
- Explaining the structure of a simple C# program.
- Using the Console class of the System namespace to perform basic input/output operations.
- Handling exceptions in a C# program.
- Generating Extensible Markup Language (XML) documentation for a C# application.
Lessons
This module explains how to use the FOR XML clause and the OPENXML function. It also describes how to use the xml data type and its methods.Module 3: Using XML
- Retrieving XML by Using FOR XML.
- Shredding XML by Using OPENXML.
- Introducing Query.
- Using the xml Data Type.
Lab: Using XML.
- Using XML.
- Storing XML Natively in the Database.
- Using Query with xml Methods.
After completing this module, students will be able to:
- Retrieve XML by using the FOR XML clause.
- Shred XML by using the OPENXML function.
- Use XQuery expressions.
- Use the xml data type.
Lessons
This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.Module 4: Creating and Tuning Indexes
- Planning Indexes.
- Creating Indexes.
- Optimizing Indexes.
- Creating XML Indexes.
Lab: Creating and Tuning Indexes.
- Creating Indexes.
- Tuning Indexes.
- Creating XML Indexes.
After completing this module, students will be able to:
- Plan indexes.
- Create indexes.
- Optimize indexes.
- Create XML indexes.
Lessons
This module explains how to implement constraints and provides an overview of data integrity.Module 5: Implementing Data Integrity by Using Constraints
- Data Integrity Overview.
- Implementing Constraints.
Lab: Implementing Data Integrity by Using Constraints.
- Creating Constraints.
- Disabling Constraints.
After completing this module, students will be able to:
- Describe the options for enforcing data integrity in SQL Server 2005.
- Implement data integrity in SQL Server 2005 databases by using constraints.
Lessons
This module explains how to implement triggers and XML schemas.
Module 6: Implementing Data Integrity by Using Triggers and XML Schemas- Implementing Triggers.
- Implementing XML Schemas.
Lab: Implementing Data Integrity by Using Triggers and XML Schemas.
- Creating Triggers.
- Implementing XML Schemas.
After completing this module, students will be able to:
- Implement data integrity in SQL Server 2005 databases by using triggers.
- Implement data integrity in SQL Server 2005 databases by using XML schemas.
Lessons
This module explains how to create views.
Module 7: Implementing Views
- Introduction to Views.
- Creating and Managing Views.
- Optimizing Performance by Using Views.
Lab: Implementing Views.
- Creating Views.
- Creating Indexed Views.
- Creating Partitioned Views.
After completing this module, students will be able to:
- Describe the purpose of views.
- Create and manage views.
- Explain how to optimize query performance by using views.
Lessons
This module explains how to create stored procedures and functions. It also describes execution plans, plan caching, and query compilation.Module 8: Implementing Stored Procedures
- Implementing Stored Procedures.
- Creating Parameterized Stored Procedures.
- Working With Execution Plans.
- Handling Errors
Lab: Implementing Stored Procedures.
- Creating Stored Procedures.
- Working With Execution Plans.
After completing this module, students will be able to:
- Implement stored procedures.
- Create parameterized stored procedures.
- Work with execution plans.
- Handle errors in stored procedures.
Lessons
This module explains how to create functions. It also describes how to control the execution context.Module 9: Implementing Functions
- Creating and Using Functions.
- Working with Functions.
- Controlling Execution Context.
Lab: Implementing Functions.
- Implementing Functions.
- Controlling Execution Context.
After completing this module, students will be able to:
- Create and use functions.
- Work with functions.
- Control execution context.
Lessons
This module explains how to implement managed database objects.
Module 10: Implementing Managed Code in the Database
- Introduction to the SQL Server Common Language Runtime.
- Importing and Configuring Assemblies.
- Creating Managed Database Objects.
Lab: Implementing Managed Code in the Database.
- Importing an Assembly.
- Creating Managed Database Objects.
After completing this module, students will be able to:
- Identify appropriate scenarios for managed code in the database.
- Import and configure assemblies.
- Create managed database objects.
Lessons
This module explains how to use transactions and the SQL Server locking mechanisms to meet the performance and data integrity requirements of your applications.Module 11: Managing Transactions and Locks
- Overview of Transactions and Locks.
- Managing Transactions.
- Understanding SQL Server Locking Architecture.
- Managing Locks
Lab: Managing Transactions and Locks.
- Using Transactions.
- Managing Locks.
After completing this module, students will be able to:
- Describe how SQL Server 2005 transactions use locks.
- Execute and cancel a transaction.
- Describe concurrency issues and SQL Server 2005 locking .
- Manage locks.
Lessons
This module explains how to build a messaging-based solution with Service Broker.
Module 12: Implementing Views
- Service Broker Overview.
- Creating Service Broker Objects.
Lab: Using Service Broker (
- Sending and Receiving Messages.
Optional).
- Creating Service Broker Objects.
- Implementing the Target Service.
After completing this module, students will be able to:
- Describe Service Broker functionality and architecture..
- Create Service Broker objects.
- Send and receive Service Broker messages.
Lessons
This module explains how to develop applications that generate and send timely messages to subscribers.Module 13: Using Notification Services (Optional)
- Introduction to Notification Services.
- Developing Notification Services Solutions.
After completing this module, students will be able to:
- Describe how Notification Services operates.
- Develop a Notification Services application.
