MCITP: Database Administrator / Developer

We offer 6 days of Administration, 6 days of developer and 3 days of combined Admin/Developer training covering nearly all aspects needed to pass the Microsoft certifications for the MCITP program.  If you're interested in just admin -or- developer, you can attend 9 days of training to receive just the specific certification (not both).

Our all-inclusive bootcamp prices include: Roundtrip Airfare to Sarasota, FL, Lodging right next door to training center, transportation to/from airport/hotel, meals (Breakfast/Lunch), books (shipped prior to class for pre-camp study), test(All vouchers needed for certification + 3 retake vouchers - if needed) and all study related material.

Our camps don't teach you "how to pass a test" or "what's on the test", rather - we teach the actual topics using lecture, lab, demo and videos.  Below is an outline of topics we cover in this camp. Please contact our bootcamp specialist Micah Clymer sales@advancedcustomtraining.com for more details on this intense 15 day camp.

Microsoft Administration Topics Covered in Camp - 6 Days

Exam 70–443

Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005

Designing a Database Server Infrastructure

• Design for capacity requirements.
• Specify software versions and hardware configurations.
• Design physical storage.
• Design instances.
• Design a database consolidation strategy.

Designing Security for a Database Server Solution

• Analyze business requirements.
• Integrate database security with enterprise-level authentication systems.
• Develop Microsoft Windows server-level security policies.
• Modify the security design based on the impact of network security policies.
• Analyze the risk of attacks to the server environment and specify mitigations.
• Design SQL Server service-level security.
• Design database-level security.
• Design object-level security.

Designing a Physical Database

• Modify an existing database design based on performance and business requirements.
• Design tables.
• Design file groups.
• Design index usage.
• Design views.
• Create database conventions and standards.
• Create database change control procedures.

Designing a Database Solution for High Availability

• Select high-availability technologies based on business requirements.
• Develop a strategy for migration to a highly available environment.
• Design a highly available database storage solution.
• Design a database-clustering solution.
• Design database mirroring.
• Design a high-availability solution that is based on replication.
• Design log shipping.

Designing a Data Recovery Solution for a Database

• Specify data recovery technologies based on business requirements.
• Design backup strategies.
• Create a disaster recovery plan.

Designing a Strategy for Data Archiving

• Select archiving techniques based on business requirements.
• Design the format of archival data.
• Specify what data to archive.
• Plan for data archival and access.
• Design the topology of replication for archiving data.
• Design the type of replication for archiving data.

Exam 70–444

Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005

Optimizing the Performance of Database Servers and Databases

• Troubleshoot physical server performance.
• Troubleshoot instance performance.
• Troubleshoot database performance.
• Troubleshoot and maintain query performance.
• Troubleshoot concurrency issues.

Optimizing and Implementing a Data Recovery Plan for a Database

• Diagnose causes of failures. Failure types include database failures, physical server failures, and SQL Server service failures.
• Plan for fault-tolerance.
• Recover from a failure of SQL Server 2005.
• Recover from a database disaster.
• Salvage good data from a damaged database by using restoration techniques.

Designing a Strategy to Monitor and Maintain a Database Solution

• Define and implement monitoring standards for a physical server.
• Choose the appropriate information to monitor.
• Create and implement a maintenance strategy for database servers.
• Design a database maintenance plan.
• Design a strategy to manage Reporting Services.

Designing a Database Data Management Strategy

• Design and manage SQL Server Integration Services (SSIS) packages.
• Enforce data quality according to business requirements.
• Design data integrity.
• Design a strategy to manage data across linked servers.
• Design a strategy to manage replication.
• Optimize a database control strategy to meet business requirements.

Designing a Strategy to Manage and Maintain Database Security

• Perform a security audit of the existing security infrastructure based on the security plan.
• Maintain a server-level security strategy.
• Maintain a user-level security strategy.
• Prepare for respond to threats and attacks.

 

Microsoft Developer Topics Covered in Camp - 6 Days

Exam 70–441

Designing Database Solutions by Using Microsoft SQL Server 2005

Designing Database Testing and Code Management Procedures

• Design a unit test plan for a database.
• Create a performance baseline and benchmarking strategy for a database.
• Create a plan for deploying a database.
• Control changes to source code.

Designing an Application Solution for SQL Server 2005

• Select and design SQL Server services to support business needs.
• Design a logical database.
• Design an application solution to support security.
• Design an application solution that uses appropriate database technologies and techniques.
• Design an application solution that supports reporting.
• Design data distribution.

Designing Database Objects

• Design objects that define data.
• Design objects that retrieve data.
• Design objects that extend the functionality of a server.
• Design objects that perform actions.

Designing a Database

• Design attributes.
• Design entities.
• Design entity relationships (ER).
• Design database security.

Developing Applications That Use SQL Server Support Services

• Develop applications that use Reporting Services.
• Develop applications for Notification Services.
• Develop packages for Integration Services.

Exam 70–442

Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

Designing Efficient Access to a SQL Server Service

• Design appropriate data access technologies.
• Design an appropriate data access object model.
• Design a cursor strategy for a data access component.
• Design caching strategies.
• Design client libraries to write applications that administer a SQL Server service.
• Design queries that use multiple active result sets (MARS).

Designing a Database Query Strategy

• Write and modify queries.
• Design queries for retrieving data from XML sources.
• Design a cursor strategy.

Designing Error-Handling Routines

• Design code that validates input data and permissions.
• Design code that detects and reacts to errors.
• Design user-defined messages to communicate application events.

Designing a Transaction Strategy

• Manage concurrency by selecting the appropriate transaction isolation levels.
• Design the locking granularity level.
• Design transaction scopes.
• Design code that uses transactions.

Performance Tuning a Database and a Database Application

• Optimize and tune queries for performance.
• Optimize indexing strategies.
• Scale database applications.
• Resolve performance problems.
• Optimize data storage.

Microsoft SQL 2005 Topics Covered in Both Dev & Admin - 3 Days

Exam 70–431

Microsoft SQL Server 2005 — Implementation and Maintenance

Installing and Configuring SQL Server 2005

• Install SQL Server 2005.
• Configure SQL Server 2005 instances and databases.
• Configure SQL Server security.
• Configure linked servers by using SQL Server Management Studio (SSMS).

Implementing High Availability and Disaster Recovery

• Implement database mirroring.
• Implement log shipping.
• Manage database snapshots.

Supporting Data Consumers

• Retrieve data to support ad hoc and recurring queries.
• Manipulate relational data.
• Manage XML data.
• Implement an HTTP endpoint.
• Implement Service Broker components.
• Import and export data from a file.
• Manage replication.

Maintaining Databases

• Implement and maintain SQL Server Agent jobs.
• Manage databases by using Transact-SQL.
• Back up a database.
• Restore a database.
• Move a database between servers.

Monitoring and Troubleshooting SQL Server Performance

• Gather performance and optimization data by using the SQL Server Profiler.
• Gather performance and optimization data by using the Database Engine Tuning Advisor.
• Monitor and resolve blocks and deadlocks.
• Diagnose and resolve database server errors.
• Monitor SQL Server Agent job history.
• Gather performance and optimization data by using DMVs.

Creating and Implementing Database Objects

• Implement a table.
• Implement a view.
• Implement triggers.
• Implement functions.
• Implement stored procedures.
• Implement constraints.
• Implement indexes.
• Create user-defined types.
• Implement a full-text search.
• Implement partitions.

MCPD: Enterprise Application Developer

We offer 3 days of Desktop, 3 Days of Web (ASP.NET), 3 Days of Distributed and 3 Days of Core Foundations in .NET 2.0 training. If you attend the 15 day program - you achieve the MCPD: Enterprise Architect Premier Microsoft certification. If you're interested in just desktop -or- web, you can attend 6 days of training (3 days is foundations training) to receive just the specific MCTS: Web / Windows .NET certification.

 

 Our all-inclusive bootcamp prices include: Roundtrip Airfare to Sarasota, FL, Lodging right next door to training center, transportation to/from airport/hotel, meals (Breakfast/Lunch), books (shipped prior to class for pre-camp study), test(All vouchers needed for certification + 3 retake vouchers - if needed) and all study related material.

Our camps don't teach you "how to pass a test" or "what's on the test", rather - we teach the actual topics using lecture, lab, demo and videos.  Below is an outline of topics we cover in this camp. Please contact our bootcamp specialist Micah Clymer sales@advancedcustomtraining.com for more details on this intense 15 day camp.

 

 

 

Microsoft .NET Desktop Topics Covered in Camp - 3 Days

Exam 70–526

Microsoft .NET Framework 2.0 - Windows-Based Client Development

Creating a UI for a Windows Forms Application by Using Standard Controls

• Add and configure a Windows Form.
• Manage control layout on a Windows Form.
• Add and configure a Windows Forms control.
• Create and configure menus.
• Create event handlers for Windows Forms and controls.

Integrating Data in a Windows Forms Application

• Implement data-bound controls.
• Manage connections and transactions.
• Create, add, delete, and edit data in a connected environment.
• Create, add, delete, and edit data in a disconnected environment.
• Manage XML with the XML Document Object Model (DOM).
• Read, write, and validate XML by using the XmlReader class and the XmlWriter class.

Implementing Printing and Reporting Functionality in a Windows Forms Application

• Manage the print process by using print dialogs.
• Construct print documents.
• Create a customized PrintPreview component.

Enhancing Usability

• Perform drag-and-drop operations.
• Implement globalization and localization for a Windows Forms application.
• Implement accessibility features.
• Create and configure multiple-document interface (MDI) forms.
• Create, configure, and customize user assistance controls and components.
• Persist Windows Forms application settings between sessions.

Implementing Asynchronous Programming Techniques to Improve the User Experience

• Manage a background process by using the BackgroundWorker component.
• Implement an asynchronous method.

Developing Windows Forms Controls

• Create a composite Windows Forms control.
• Create a custom Windows Forms control by inheriting from the control class.
• Create an extended control by inheriting from an existing Windows Forms control.

Configuring and Deploying Applications

• Configure the installation of a Windows Forms application by using ClickOnce technology.
• Create a Windows Forms setup application.
• Add functionality to a Windows Forms setup application.

Microsoft .NET Foundations Topics Covered in Camp - 3 Days

Exam 70–536

Microsoft .NET Framework 2.0 — Application Development Foundation

Developing applications that use system types and collections

• Manage data in a .NET Framework application by using the .NET Framework 2.0 system types. (Refer System namespace)
• Manage a group of associated data in a .NET Framework application by using collections. (Refer System.Collections namespace)
• Improve type safety and application performance in a .NET Framework application by using generic collections. (Refer System.Collections.Generic namespace)
• Manage data in a .NET Framework application by using specialized collections. (Refer System.Collections.Specialized namespace)
• Implement .NET Framework interfaces to cause components to comply with standard contracts. (Refer System namespace)
• Control interactions between .NET Framework application components by using events and delegates. (Refer System namespace)

Implementing service processes, threading, and application domains in a .NET Framework application

• Implement, install, and control a service. (Refer System.ServiceProcess namespace)
• Develop multithreaded .NET Framework applications. (Refer System.Threading namespace)
• Create a unit of isolation for common language runtime in a .NET Framework application by using application domains. (Refer System namespace)

Embedding configuration, diagnostic, management, and installation features into a .NET Framework application

• Embed configuration management functionality into a .NET Framework application. (Refer System.Configuration namespace)
• Create a custom Microsoft Windows Installer for the .NET Framework components by using the System.Configuration.Install namespace, and configure the .NET Framework applications by using configuration files, environment variables, and the .NET Framework Configuration tool (Mscorcfg.msc).
• Manage an event log by using the System.Diagnostics namespace.
• Manage system processes and monitor the performance of a .NET Framework application by using the diagnostics functionality of the .NET Framework 2.0. (Refer System.Diagnostics namespace)
• Debug and trace a .NET Framework application by using the System.Diagnostics namespace.
• Embed management information and events into a .NET Framework application. (Refer System.Management namespace)

Implementing serialization and input/output functionality in a .NET Framework application

• Serialize or deserialize an object or an object graph by using runtime serialization techniques. (Refer System.Runtime.Serialization namespace)
• Control the serialization of an object into XML format by using the System.Xml.Serialization namespace.
• Implement custom serialization formatting by using the Serialization Formatter classes.
• Access files and folders by using the File System classes. (Refer System.IO namespace)
• Manage byte streams by using Stream classes. (Refer System.IO namespace)
• Manage the .NET Framework application data by using Reader and Writer classes. (Refer System.IO namespace)
• Compress or decompress stream information in a .NET Framework application (refer System.IO.Compression namespace), and improve the security of application data by using isolated storage. (Refer System.IO.IsolatedStorage namespace)

Improving the security of the .NET Framework applications by using the .NET Framework 2.0 security features

• Implement code access security to improve the security of a .NET Framework application. (Refer System.Security namespace)
• Implement access control by using the System.Security.AccessControl classes.
• Implement a custom authentication scheme by using the System.Security.Authentication classes. (Refer System.Security.Authentication namespace)
• Encrypt, decrypt, and hash data by using the System.Security.Cryptography classes. (Refer System.Security.Cryptography namespace)
• Control permissions for resources by using the System.Security.Permission classes. (Refer System.Security.Permission namespace)
• Control code privileges by using System.Security.Policy classes. (Refer System.Security.Policy namespace)
• Access and modify identity information by using the System.Security.Principal classes. (Refer System.Security.Principal namespace)

Implementing interoperability, reflection, and mailing functionality in a .NET Framework application

• Expose COM components to the .NET Framework and the .NET Framework components to COM. (Refer System.Runtime.InteropServices namespace)
• Call unmanaged DLL functions in a .NET Framework application, and control the marshaling of data in a .NET Framework application. (Refer System.Runtime.InteropServices namespace)
• Implement reflection functionality in a .NET Framework application (refer System.Reflection namespace), and create metadata, Microsoft intermediate language (MSIL), and a PE file by using the System.Reflection.Emit namespace.
• Send electronic mail to a Simple Mail Transfer Protocol (SMTP) server for delivery from a .NET Framework application. (Refer System.Net.Mail namespace)

Implementing globalization, drawing, and text manipulation functionality in a .NET Framework application

• Format data based on culture information. (Refer System.Globalization namespace)
• Enhance the user interface of a .NET Framework application by using the System.Drawing namespace.
• Enhance the text handling capabilities of a .NET Framework application (refer System.Text namespace), and search, modify, and control text in a .NET Framework application by using regular expressions. (Refer System.RegularExpressions namespace)

Microsoft Web Applications (ASP.NET) Topics Covered in Camp - 3 Days

Exam 70–528

Microsoft .NET Framework 2.0 - Web-Based Client Development

Creating and Programming a Web Application

• Create and configure a Web application.
• Add and configure Web server controls.
• Create event handlers for pages and controls.
• Manage state and application data.
• Implement globalization and accessibility.
• Implement site navigation and input validation.
• Write an ASP.NET handler to generate images dynamically for display on a Web page.
• Configure settings for a Web application.
• Program a Web application.

Integrating Data in a Web Application by Using ADO.NET, XML, and Data-Bound Controls

• Implement data-bound controls.
• Manage connections and transactions of databases.
• Create, delete, and edit data in a connected environment.
• Create, delete, and edit data in a disconnected environment.
• Manage XML data with the XML Document Object Model (DOM).
• Read and write XML data by using the XmlReader and XmlWriter.

Creating Custom Web Controls

• Create a composite Web application control.
• Create a custom Web control that inherits from the WebControl class.
• Create a composite server control.
• Develop a templated control.

Tracing, Configuring, and Deploying Applications

• Use a Web setup project to deploy a Web application to a target server.
• Copy a Web application to a target server by using the Copy Web tool.
• Precompile a Web application by using the Publish Web utility.
• Optimize and troubleshoot a Web application.

Customizing and Personalizing a Web Application

• Implement a consistent page design by using master pages.
• Customize a Web page by using themes and user profiles.
• Implement Web Parts in a Web application.

Implementing Authentication and Authorization

• Establish a user's identity by using forms authentication.
• Use authorization to establish the rights of an authenticated user.
• Implement Microsoft Windows authentication and impersonation.
• Use login controls to control access to a Web application.

Creating ASP.NET Mobile Web Applications

• Create a mobile Web application project.
• Use device-specific rendering to display controls on a variety of devices.
• Use adaptive rendering to modify the appearance of Web server controls.
• Use the mobile Web controls to display content on a device.

Microsoft Distributed Application Topics Covered in Camp - 3 Days

Exam 70–529

Microsoft .NET Framework 2.0 - Distributed Application Development

Creating and Accessing XML Web Services

• Create and configure an XML Web service method.
• Configure a Web service method by using the properties of the WebMethodAttribute attribute.
• Use discovery files to publish a list of Web services that are installed on a Web server.
• Build and deploy a Web service application.

Configuring and Customizing a Web Service Application

• Configure SOAP messages.
• Configure the Web services communication protocol.
• Manage session state in Web services.
• Implement SOAP headers.
• Implement SOAP extensions.

Creating, Configuring, and Deploying Remoting Applications

• Create and configure a server application.
• Create a client application to access a remote object.
• Debug and deploy a remoting application.
• Create and serialize remotable types.
• Manage the lifetime of remote objects.

Implementing Asynchronous Calls and Remoting Events

• Call Web methods asynchronously.
• Call remoting methods asynchronously.
• Implement events in remoting applications.

Implementing Web Services Enhancements (WSE) 3.0

• Enable WSE in client and server applications.
• Add a digital signature to a SOAP message and verify an existing SOAP message signature.
• Encrypt and decrypt a SOAP message.
• Implement a policy for a Web service application.
• Implement filters in a Web service application.
• Implement WSE SOAP messaging.
• Route SOAP messages by using a WSE router.
• Add and verify security credentials.

Creating and Accessing a Serviced Component and Using Message Queuing

• Create, configure, and access a serviced component.
• Create, delete, and set permissions on a message queue.
• Send messages to a message queue and delete messages from a message queue.
• Sign and encrypt messages.
• Receive messages.
• Process messages.

Microsoft Enterprise Topics Covered in Camp - 3 Days

Exam 70–549

Designing and Developing Enterprise Applications by Using the Microsoft .NET Framework

Envisioning and Designing an Application

• Evaluate the technical feasibility of an application design concept.
• Evaluate the technical specifications for an application to ensure that the business requirements are met.
• Evaluate the design of a database.
• Evaluate the logical design of an application.
• Evaluate the physical design of an application. Considerations include the design of the project structure, the number of files, the number of assemblies, and the location of these resources on the server.

Designing and Developing a Component

• Establish the required characteristics of a component.
• Create the high-level design of a component.
• Develop the public API of the component.
• Develop the features of a component.
• Develop a component feedback mechanism.
• Develop the data access and data handling features of a component.
• Develop a component to include profiling requirements
• Choose an appropriate mechanism to deliver multimedia data across distributed applications by using Web services and Message Queuing.

Designing and Developing an Application Framework

• Consume a reusable software component.
• Choose an appropriate implementation approach for the application design logic.
• Choose an appropriate event logging method for the application.
• Monitor specific characteristics or aspects of an application.

Testing and Stabilizing an Application

• Perform a code review.
• Evaluate the testing strategy.
• Design a unit test.
• Perform integration testing.
• Resolve a bug.

Deploying and Supporting an Application

• Evaluate the performance of an application based on the performance analysis strategy.
• Analyze the data received when monitoring an application.
• Evaluate the deployment plan.
• Create an application flow-logic diagram.
• Validate the production configuration environment.