Our E-learning curriculum is specifically designed with the busy professional in mind. All of our programs are produced using advanced learning concepts that encompass learning techniques that are designed for adult learning. E- learning is very popular today for a very good reason – It Works! People everywhere are discovering that they can fulfill their learning objectives conveniently (at their own pace, on their own time) and affordably.
Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software – saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format – allowing you to get the most out of your time online.
AUDIENCE PROFILE:
Candidates for this exam work on a team in a medium-sized or large development environment that uses Microsoft Visual Studio .NET 2003 Enterprise Developer or Visual Studio 2005. Candidates should have a working knowledge of Visual Studio 2005 and a sound knowledge of the new features of ASP.NET 2.0. Candidates should have at least two years of experience developing applications by using the Microsoft .NET Framework.
Candidates should have at least three to four years of on-the-job experience dedicated to Web application development. In most cases, candidates will be full-time developers who develop server-side ASP.NET code that creates the browser-based, client-side interface to an application.
Candidates should have worked in the following phases of the application life cycle:
•Technical envisioning and planning
•Design and development
•Stabilizing and releasing
Candidates should be able to design and develop the Web interface of common business applications, such as:
•Web-based client applications, both intranet and Internet, that may connect to data stores or middle-tier business logic
•Data-oriented applications that provide data entry, data analysis, and reporting capabilities
•Workflow and communication applications
•Inventory and resource planning applications
•Financial and accounting applications
•Applications for the insurance and pharmaceutical industries
•Business-to-business (B2B) applications
•Business-to-customer (B2C) applications
•Company Web sites
•Web-based shopping cart applications
COURSE FEATURES:
- Instructor led training by the industry’s finest experts delivered via streaming video online or DVD
- Software demonstrations where the instructor shows you how to perform a task onscreen.
- Interactive multimedia presentations
- Easy to navigate controls
- Course bookmarking which allows you to resume training where you left off the last session.
- Hands-on activities and labs
- Review Questions
- Practice Exam Simulators with three different training and testing modes. These simulators can also be used for pre- and post-testing.
- Free technology upgrades for one year
- Educational support
COURSE OUTLINE
Microsoft Exam 70-551:UPGRADE: MCAD skills to MCPD: Web Developer by Using the Microsoft .NET Framework Course Curriculum:
Core Data Access with Microsoft Visual Studio 2005
Module 1: Connecting to Databases and Reading Data
Connecting to a Database
Saving a Connection String Securely in an Application Configuration File
Retrieving Data from a Database
Handling Connection Events and Exceptions
Configuring and Using Connection Pooling
Module 2: Querying and Updating Databases by Using Commands
Creating and Running Query Commands
Creating and Running Parameterized Commands
Creating and Running Update Commands
Using Globalized Formats for Storing and Accessing Data (if time permits)
Module 3: Performing Transactional Operations
Performing Data Updates within a Transaction
Choosing an Appropriate Isolation Level for a Transaction
Enlisting in a Distributed Transaction
Managing Transactions in the Data Tier
Module 4: Performing Disconnected Operations Programmatically
Creating a DataSet Programmatically
Populating and Saving a DataSet
Adding, Modifying, and Deleting Data in a DataSet
Merging DataSets
Creating and Using DataViews
Module 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
Creating a Typed DataSet by Using the DataSet Designer
Loading, Displaying, and Saving Data in a Typed DataSet
Adding Code to a Typed DataSet
Creating a Typed DataSet by Using the Data Source Configuration Wizard
Adding Queries to a Table Adapter
Module 6: Performing XML Operations on Disconnected Data
Saving a DataSet as XML Data
Loading a DataSet from XML
Saving and Loading DataSet Schema Information
Module 7: Reading and Writing XML Data
Writing XML Data by Using XmlWriter
Reading XML Data by Using XmlReader
Module 8: Processing XML Data by Using DOM
Reading XML Data by Using DOM
Writing XML Data by Using DOM
Advanced Data Access with Microsoft Visual Studio 2005
Module 1: Minimizing and Handling Database Operation Conflicts
Reading Committed Data by Using Locks
Reading Committed Data by Using Statement-Level Snapshots
Reading Committed Data by Using Transaction-Level Snapshots
Handling Data Concurrency by Using ADO.NET
Module 2: Handling Large Objects
Reading Large Values from SQL Server
Writing Large Values to SQL Server
Conserving Resources When Writing Large Values to SQL Server
Module 3: Enhancing Database Performance
Accessing Multiple Result Sets Concurrently
Performing Asynchronous Data Access Operations
Performing a Batch Update
Performing a Bulk Data Copy
Module 4: Creating Managed Code Objects for SQL Server 2005
Creating Managed Stored Procedures and Triggers
Creating Managed User-Defined Functions
Creating a Managed Aggregate
Creating a Managed User-Defined Type
Importing Existing Assemblies into SQL Server 2005
Module 5: Querying XML by Using XPath
Selecting XML Data by Using XPathNavigator
Evaluating XPath Expressions by Using XPath Navigator
Creating and Using Compiled XPath Expressions
Editing XML Data by Using XPathNavigator
Module 6: Transforming XML by Using XSLT Style Sheets
Transforming an XML Document by Using an XSLT Style Sheet
Resolving External Resources During XSLT Processing
Passing Parameters into an XSLT Style Sheet
Creating and Using Extension Objects
Core Web Application Technologies with Microsoft Visual Studio 2005
Module 1: Creating a Web Application
Creating a New Web Application
Configuring and Building a Web Application
Module 2: Programming a Web Application
Implementing Non-Default Event Handlers
Detecting Browser Capabilities and Setting Page Header Properties
Handling Page-Level Exceptions
Module 3: Adding and Configuring Server Controls
Building Graphical User Interfaces with HTML Controls
Building Graphical User Interfaces with Web Server Controls
Programming Web Server Controls and Working with Postbacks
Module 4: Creating a Common Layout by Using Master Pages
Designing a Master Page
Adding and Configuring Content Pages
Designing Nested Master Pages
Module 5: Managing State for a Web Application
Configuring ViewState Properties for Web Server Controls
Storing and Retrieving Application and Session State
Implementing Out-of-Process Session State
Storing and Managing State Data in the Cache Object
Module 6: Accessing and Displaying Data
Creating and Retrieving Database Connections
Accessing Data by Using SqlDataSource Controls and Data Controls
Accessing Objects as Data with ObjectDataSource Controls
Accessing XML Data by Using XmlDataSource Controls
Module 7: Controlling Access to a Web Application
Configuring Authentication and Authorization for a Web Application
Implementing a Membership Registration Page
Implementing a Login Page and Adding Login Controls
Creating a Membership Management Administrative User Interface
Module 8: Deploying a Web Application
Deploying a Web Application by Using the Copy Web Site Utility
Precompiling and Deploying a Web Application by Using the Publish Web Site Utility
Building a Windows Installer Package for Deploying a Web Application
Module 9: Making Web Applications Available to Mobile Devices
Managing Redirection for Mobile Devices
Designing and Implementing a Mobile Web Form
Designing Device-Specific Features for a Mobile Web Application
Browsing a Mobile Web Application with Specific Device Emulators
Advanced Web Application Technologies
with Microsoft Visual Studio 2005
Module 1: Building Dynamic Web Applications
Dynamically Adding and Configuring Controls
Dynamically Applying Master Pages
Adding Localization Features
Dynamically Configuring Web Applications
Module 2: Creating Controls for Web Applications
Creating User Controls
Creating Custom Web Server Controls
Creating Composite Web Server Controls
Creating Templated Controls
Module 3: Optimizing Web Application Performance
Accessing the Page Scripting Object Model
Implementing ASP.NET Caching Techniques
Implementing Tracing and Instrumentation Techniques in Web Applications
Implementing Asynchronous Processing in Web Applications
Module 4: Implementing Personalization and Themes in Web
Applications
Configuring Personalization
Implementing Personalization Functionality
Adding Themes to the Web Application
Implementing Personalized Themes
Module 5: Building Web Part Pages and Web Parts
Creating a Web Part Page
Creating a Web Part
Creating Connected Web Parts
To order contact Specialized Solutions at:
Specialized Solutions
Corporate Training Division
3727 Jonlen Drive
Cincinnati, OH 45227
Toll Free – 1-877-291-9797
Direct – 513-878-1116
www.specializedsolutions.com