Course Contents (24 sessions of 3hrs each)
Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET Microsoft .NET, ASP.NET and Visual Studio .NET • .NET Platform Technologies • Visual Studio .NET • Building Block Services • .NET Alerts • .NET Passport • .NET Enterprise Servers • .NET Framework
.NET Framework and its Components • Common Language Runtime (CLR) • Base Class Library (BCL) • Namespaces • .NET Framework Languages • Common Language Specification (CLS) • Common Type System (CTS) • Microsoft Intermediate Language (MSIL) • Compiling Source into managed modules • Structure of managed module. • What is Metadata?
Creating User Services Create ASP.NET pages. • set directives on ASP.NET pages • user interface
Web server controls, HTML server controls, user controls, and HTML code to ASP.NET pages. • Create Web custom controls and Web user controls • Set properties on controls. • Load controls dynamically. • Apply templates. • Set styles on ASP.NET pages by using cascading style sheets. • Instantiate and invoke an ActiveX control.
Implement navigation for the user interface. • view state. • Postback events. • Use session state.
Validate user input. • Validate non-Latin user input.
Implement error handling in the user interface. • Configure custom error pages. • Implement Global.asax, application, page-level, and page event error handling.
Implement online user assistance. • Incorporate existing code into ASP.NET pages. • Display and update data. • Instantiate and invoke Web services or components. • Implement globalization.
Handle events. • Create event handlers. • Raise events.
Implement accessibility features. Use and edit intrinsic objects. Intrinsic objects include response, request, session, server, and application. • Retrieve values from the properties of intrinsic objects. • Set values on the properties of intrinsic objects. • Use intrinsic objects to perform operations.
Creating and Managing Components and .NET Assemblies • Create and modify a .NET assembly. • Create and implement satellite assemblies. • Create resource-only assemblies.
Consuming and Manipulating Data • Access and manipulate data from a Microsoft SQL Server database by creating and using ad hoc queries and stored procedures. • Access and manipulate data from a data store. Data stores include relational databases, XML documents, and flat files. Methods include XML techniques and ADO.NET. • Handle data errors.
Testing and Debugging • Create a unit test plan. • Implement tracing. • Debug, rework, and resolve defects in code.
Deploying a Web Application • Plan the deployment of a Web application. • Create a setup program that installs a Web application and allows for the application to be uninstalled. • Deploy a Web application. • Add assemblies to the global assembly cache.
Maintaining and Supporting a Web Application • Optimize the performance of a Web application. • Diagnose and resolve errors and issues.
Configuring and Securing a Web Application Configure a Web application. • Modify the Web.config file. • Modify the Machine.config file. • Add and modify application settings.
Configure security for a Web application. • Configure authorization. Authorization methods include file-based methods and URL-based methods. • Configure role-based authorization. Implement impersonation.
Configure and implement caching. Caching types include output, fragment, and data. • Use a cache object. • Use cache directives.
Configure and implement session state in various topologies such as a Web garden and a Web farm. • Use session state within a process. • Use session state with session state service. • Use session state with Microsoft SQL Server.
Install and configure server services. • Install and configure a Web server. • Install and configure Microsoft FrontPage Server Extensions.
Create data types and tables. • Creating Data Types. • Creating Tables. • Creating Partitioned Tables.
Use XML-related features in Microsoft SQL Server 2005. • Retrieving XML by Using FOR XML. • Shredding XML by Using OPENXML. • Using the xml Data Type. • Mapping Relational Data and XML. • Storing XML Natively in the Database. Plan, create, and optimize indexes. • Planning Indexes. • Creating Indexes. • Optimizing Indexes. • Creating XML Indexes.
Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas. • Creating Constraints. • Creating Triggers. • Implementing XML Schemas. Implement views. • Creating Views. • Creating Indexed Views. • Creating Partitioned Views.
Implement stored procedures and functions. • Creating Stored Procedures. • Creating Functions.
Implement managed code in the database. • Importing an Assembly. • Creating Managed Database Objects. Use Service Broker to build a messaging-based solution. • Creating Service Broker Objects. • Implementing the Initiating Service. • Implementing the Target Service.
Install and configure SQL Server 2005. • Preparing to install SQL Server. • Installing SQL Server. • Managing a SQL Server 2005 Installation.
Manage database files. • Planning databases. • Creating databases. • Managing databases. Manage security. • Overview of SQL Server Security. • Securing the Server Scope. • Securing the Database Scope. • Managing Keys and Certificates in SQL Server. • Creating Logins. • Creating and Managing Users.
Perform administrative tasks. • Configuring the SQL Server Agent. • Creating Operators and Jobs. • Creating Alerts.
Automating Administrative Tasks • Automating Administrative Tasks in SQL Server 2005. • Configuring the SQL Server Agent. • Creating Jobs and Operators. • Creating Alerts. • Managing Multiple Servers. • Managing SQL Server Agent Security
Configuring Database Mirroring • Setting the Recovery Model. • Backing Up and Restoring the Database. • Starting Database Mirroring. • Performing an Automatic and Manual Failover.
Database Backup Recovery • Back up databases. • Restore databases.
Monitor SQL Server. • Viewing Current Activity. • Using System Monitor. • Using SQL Server Profiler. • Using DDL Triggers. • Using Event Notifications.
Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework Introduction to XML and Related Technologies • Introduction of XML • Features of XML • W3C Recommendation • Exchange Data • Complement with existing standards • Separation of Data and Presentation • Integration between Non Compatible Systems • XML and B2B • Software, Hardware, Technology, Device Independent • Data Storage • Human Understandable Format • Create New Languages • Difference between XML and HTML • Basic Overview of XML Related Technologies • Presentation Technologies • HTML, XHTML • Validation Technologies • DTD, XML Schema • Transforming Technologies • CSS, XSLT, XSLT FO • Other Technologies • XPath, XQuery, XLink • XML Web Services • SOAP, WSDL, UDDI • Writing XML Documents • XML Document Components • Comments • Declaration or Processing Instruction • Root Element • Nested Elements • Template Dat • Empty Elements • Attributes • Well formed XML Document • Displaying Well Formed XML Document in Browser
Microsoft .NET Framework and XML • Microsoft .NET Platform • .NET Platform Technologies • Visual Studio .NET • .NET Building Block Services • .NET Enterprise Servers • .NET Framework • Overview of .NET Framework • .NET Framework Components • Common Language Runtime (CLR) • Base Class Library (BCL) • .NET Framework Languages • Common Language Specification (CLS) • Common Type Specification (CTS) • Microsoft Intermediate Language (MSIL) • Managed Modules and metadata • .NET Assemblies • Structure of .NET Assembly and Assembly Manifest • Creating .NET Assemblies • Types of .NET Assemblies • Private Assemblies • Public or Shared Assemblies • Strong Name Assemblies • Global Assembly Cache (GAC) • Registration of Assemblies in Global Assembly Cache (GAC) • Role of XML in .NET • Working with XML Files in .NET • Reading and Writing XML Files in .NET • Working with XML and DataSets
Microsoft .NET and XML Web Services • Overview of Service Oriented Architecture • Understanding XML Web Services • Communication between client and xml web service • Searching Web Service Providers (UDDI) • Discovering Web Service (DISCO) • Describing Web Services Capabilities (WSDL) • Describing Web Service Data (XML) • Format of Communication (SOAP) • Creating XML Web Service • Creating XML Web Methods • Discovering XML Web Service • Publishing XML Web Services • Publishing XML Web Service • Adding Web Reference for XML Web Service • Generating Proxy Class • Accessing Web Services using Proxy Object • Calling the methods exposed by XML Web Service • Creating Web Client of XML Web Services • Creating Windows Client of XML Web Services • Advance XML Web Services Programming
Lecture 4: Microsoft .NET and Window Services • Overview of .NET Windows Services • Service Application • Service Controller Application • Service Control Application • Difference between Windows Services and Other .NET Applications • Creating Windows Service Application • Changing the Default Properties of Windows Service Application • Adding Functionality to a Service Application • Handling Events in window service • Logging Information from window service • Overview of Installers • Installing window services • Adding Installers to window service • Managing Windows Services
Database Programming using ADO.NET • Overview of ADO.NET • Architecture of ADO.NET • Data Sources, Data Providers, DataSets • ADO.NET Connected Architecture • Using ADO.NET Data Providers
Database Programming using ADO.NET • Accessing and Manipulating Data in .NET Applications • ADO.NET Discontented Architecture • Using ADO.NET DataSet Object
Microsoft .NET Remoting • Overview of .NET Remoting • Accessing Objects outside Remoting boundaries • Microsoft .NET Remoting Architecture • Types of Remoting Objects • Creating Server Activated Remoting objects
Microsoft .NET Remoting • Creating Client Activated Remoting objects • Configuring .NET Remoting objects • Creating a Client Application to Access Remote objects
