Course Outline

Days 1-2: Developing and Implementing Web Applications with Microsoft Visual Basic® .NET and Microsoft Visual Studio .NET

• Creating user services
• Create ASP.NET pages
• Add web server controls, HTML server controls, user controls, and HTML code to ASP.NET pages
• Implement navigation for the user interface
• Validate user input
• Implement error handling in the user interface
• Incorporate existing code into ASP.NET pages
• Display and update data
• Instantiate and invoke web services or components
• Handle events
• Implement accessibility features
• Use and edit intrinsic objects, which include response, request, session, server, and application
• Creating and managing components and .NET assemblies
• Create web custom controls and web user controls
• Consuming and manipulating data from SQL Server and data stores
• Testing and debugging
• Implement tracing
• Debug, rework, and resolve defects in code
• Deploying a web application
• Configuring and securing a web application

Day 3: Microsoft Exam #70-305

Days 4-5: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework

• Creating and managing Microsoft Windows® services, serviced components, .NET Remoting objects, and XML web services
• Create and consume a serviced component
• Create and consume an XML web service
• Implement security for a Windows service, a serviced component, a .NET Remoting object, and an XML web service
• Access and manipulate data from a Microsoft SQL ServerT database by creating and using ad hoc queries and stored procedures
• Create and manipulate DataSets
• Access and manipulate XML data
• Deploying Windows services, serviced components, .NET Remoting objects, and XML web services

Day 6: Microsoft Exam #70-310

Days 7-8: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

• Developing a Logical Data Model
• Define entities: considerations include entity composition and normalization
• Design entity keys; FOREIGN KEY, PRIMARY KEY, and UNIQUE constraints
• Design attribute integrity - includes CHECK constraints, data types, and nullability
• Implementing the Physical Database
• Create and alter database objects: objects include constraints, indexes, stored procedures, tables, triggers, user-defined functions, and views
• Alter database objects to support replication and partitioned views
• Retrieve, filter, group, summarize, and modify data by using Transact-SQL
• Manipulate heterogeneous data: ,methods include linked servers, OPENQUERY, OPENROWSET, and OPENXML
• Manage result sets by using cursors and Transact-SQL: considerations include locking models and appropriate usage
• Programming Business Logic
• Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and views
• Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views
• Troubleshoot and optimize programming objects: objects include stored procedures, transactions, triggers, user-defined functions, and views
• Tuning and optimizing data access
• Designing a database security plan

Day 9: Microsoft Exam #70-229