All Courses

Programming in HTML5 with JavaScript & CSS3 480 Developing ASP.net 4.5 MVC Web Applications 486 Developing Windows Azure and Web Services 487 Programming in HTML5 with JavaScript & CSS3        480 Implement and Manipulate Document Structures and Objects (24%) Create the document structure. This objective may include but is not limited to: structure the UI by using semantic markup, including for search engines and screen readers (Section, Article, Nav, Header, Footer, and Aside); create a layout container in HTML Write code that interacts with UI controls. This objective may include but is not limited to: programmatically add and modify HTML elements; implement media controls; implement HTML5 canvas and SVG graphics Apply styling to HTML elements programmatically. This objective may include but is not limited to: change the location of an element; apply a transform; show and hide elements Implement HTML5 APIs. This objective may include but is not limited to: implement storage APIs, AppCache API, and Geolocation API Establish the scope of objects and variables. This objective may include but is not limited to: define the lifetime of variables; keep objects out of the global namespace; use the “this” keyword to reference an object that fired an event; scope variables locally and globally Create and implement objects and methods. This objective may include but is not limited to: implement native objects; create custom objects and custom properties for native objects using prototypes and functions; inherit from an object; implement native methods and create custom methods Implement Program Flow (25%) Implement program flow. This objective may include but is not limited to: iterate across collections and array items; manage program decisions by using switch statements, if/then, and operators; evaluate expressions Raise and handle an event. This objective may include but is not limited to: handle common events exposed by DOM (OnBlur, OnFocus, OnClick); declare and handle bubbled events; handle an event by using an anonymous function Implement exception handling. This objective may include but is not limited to: set and respond to error codes; throw an exception; request for null checks; implement try-catch-finally blocks Implement a callback. This objective may include but is not limited to: receive messages from the HTML5 WebSocket API; use jQuery to make an AJAX call; wire up an event; implement a callback by using anonymous functions; handle the “this” pointer Create a web worker process. This objective may include but is not limited to: start and stop a web worker; pass data to a web worker; configure timeouts and intervals on the web worker; register an event listener for the web worker; limitations of a web worker Access and Secure Data (26%) Validate user input by using HTML5 elements. This objective may include but is not limited to: choose the appropriate controls based on requirements; implement HTML input types and content attributes (for example, required) to collect user input Validate user input by using JavaScript. This objective may include but is not limited to: evaluate a regular expression to validate the input format; validate that you are getting the right kind of data type by using built-in functions; prevent code injection Consume data. This objective may include but is not limited to: consume JSON and XML data; retrieve data by using web services; load data or get data from other sources by using XMLHTTPRequest Serialize, deserialize, and transmit data. This objective may include but is not limited to: binary data; text data (JSON, XML); implement the jQuery serialize method; Form.Submit; parse data; send data by using XMLHTTPRequest; sanitize input by using URI/form encoding Use CSS3 in Applications (25%) Style HTML text properties. This objective may include but is not limited to: apply styles to text appearance (color, bold, italics); apply styles to text font (WOFF and @font-face, size); apply styles to text alignment, spacing, and indentation; apply styles to text hyphenation; apply styles for a text drop shadow Style HTML box properties. This objective may include but is not limited to: apply styles to alter appearance attributes (size, border and rounding border corners, outline, padding, margin); apply styles to alter graphic effects (transparency, opacity, background image, gradients, shadow, clipping); apply styles to establish and change an element’s position (static, relative, absolute, fixed) Create a flexible content layout. This objective may include but is not limited to: implement a layout using a flexible box model; implement a layout using multi-column; implement a layout using position floating and exclusions; implement a layout using grid alignment; implement a layout using regions, grouping, and nesting Create an animated and adaptive UI. This objective may include but is not limited to: animate objects by applying CSS transitions; apply 3-D and 2-D transformations; adjust UI based on media queries (device adaptations for output formats, displays, and representations); hide or disable controls Find elements by using CSS selectors and jQuery. This objective may include but is not limited to: choose the correct selector to reference an element; define element, style, and attribute selectors; find elements by using pseudo-elements and pseudo-classes (for example, :before, :first-line, :first-letter, :target, :lang, :checked, :first-child) Structure a CSS file by using CSS selectors. This objective may include but is not limited to: reference elements correctly; implement inheritance; override inheritance by using !important; style an element based on pseudo-elements and pseudo-classes (for example, :before, :first-line, :first-letter, :target, :lang, :checked, :first-child)   Developing ASP.net 4.5 MVC Web Applications         486 Design the Application Architecture Plan the application layers. This objective may include but is not limited to: plan data access; plan for separation of concerns; appropriate use of models, views, and controllers; choose between client-side and server side processing; design for scalability Design a distributed application. This objective may include but is not limited to: design a hybrid application (on premise vs. off premise, including Windows Azure); plan for session management in a distributed environment; plan web farms Design and implement the Windows Azure role life cycle. This objective may include but is not limited to: identify and implement Start, Run, and Stop events;identify startup tasks (IIS configuration [app pool], registry configuration,

MCTS Exchange Server A. Configuring MS Exchange Server 2007 236 B. Configuring MS Exchange Server 2010 662   A. Configuring MS Exchange Server 2007    236 Installing and Configuring Microsoft Exchange Servers Prepare the infrastructure for Exchange installation. Prepare the servers for Exchange installation. Install Exchange. Configure Exchange server roles. Configuring Recipients and Public Folders Configure recipients. Configure mail-enabled groups. Configure resource mailboxes. Configure public folders. Move mailboxes. Implement bulk management of mail-enabled objects. Configuring the Exchange Infrastructure Configure connectors. Configure the antivirus and anti-spam system. Configure transport rules and message compliance. Configure policies. Configure public folders. Configure client connectivity. Monitoring and Reporting Monitor mail queues. Monitor system performance. Perform message tracking. Monitor client connectivity. Create server reports. Create usage reports. Configuring Disaster Recovery Configure backups. Recover messaging data. Recover server roles. Configure high availability.   B. Configuring MS Exchange Server 2010    662 Installing and Configuring Exchange Servers (15 percent) Prepare the infrastructure for Exchange. This objective may include but is not limited to: prepare schema; prepare domain; prepare Active Directory; ensure the domain functionality level is correct; domain controller service packs; Exchange readiness check; coexistence; migration from 2003 or 2007; disable LinkState; Exchange Server Service Pack level; remove unsupported legacy components; configuring DNS to support the Exchange deployment Install Exchange prerequisites. This objective may include but is not limited to: install MMC 3.0, Windows PowerShell 2.0; Microsoft .NET 3.5, WinRM 2.0, IIS, Windows roles and features, use ServerManagerCMD, use Exchange prerequisite scripts Install Exchange roles. This objective may include but is not limited to: from the command line and the GUI; adding and modifying roles; add server roles to existing Exchange 2003 or 2007 organizations; verify Exchange installation; Security Configuration wizard (SCW); Windows Firewall, including port requirements; installing Exchange Server using standard and custom installation; installing Exchange Server using the command line; provisioning an Exchange Server and delegating server installation; troubleshooting a failed installation; adding Exchange Server roles after an initial installation Create and configure databases. This objective may include but is not limited to: set database limits; set retention limits; set role-based access control (RBAC) permissions for database creation; naming conventions; create and use GUI and Windows PowerShell; create and manage public folder databases; set default public folder database; maintenance; mount and dismount databases; create new mailbox databases; configure mailbox database settings; move the mailbox database and transaction log locations; configure public folder database settings; mount and dismount databases Create and configure address lists. This objective may include but is not limited to: update legacy address lists; configure offline address lists; publish address lists; filterable properties; creating and configuring e-mail address policies; creating and configuring address lists; creating and configuring offline address books Configuring Exchange Recipients and Public Folders (14 percent) Create and configure mailboxes. This objective may include but is not limited to: deleted items; deleted mailbox; mailbox quota; message size; warning thresholds; move from and to previous Exchange versions; online and offline moves; intra-orgs and cross-orgs; create proxy addresses; create mailboxes; configure client access protocols; configure spam confidence level (SCL) and phishing confidence level (PCL); send as permissions; delegation; forwarding; mailbox permissions; create and configure linked mailboxes Configure RBAC. This objective may include but is not limited to: create and assign RBAC roles; define RBAC scopes; configure RBAC for specific roles, such as help desk and address list administrator Create and configure resource mailboxes and shared mailboxes. This objective may include but is not limited to: equipment; room; permissions; set mailbox calendaring options; autoaccept; custom resource types Create and configure recipients and distribution groups. This objective may include but is not limited to: create and modify; security enabled; configure moderation, including Exchange Control Panel (ECP) options; dynamic distribution groups; create proxy addresses; configure mail-enabled users; contacts; send as permissions; forwarding Create and configure public folders. This objective may include but is not limited to: mail-enabled public folders; configure public folder permissions; deleted items; message size; item age; public folder size; create public folders in Enterprise Content Management (EMC) and Microsoft Outlook, and OWA; configure public folder permissions; configure public folder limits Configuring Client Access (15 percent) Configure POP, IMAP, and Microsoft ActiveSync. This objective may include but is not limited to: enable, configure, and secure POP and IMAP; manage certificates; configure mobile device policies; autodiscover; authentication; configure the Exchange ActiveSync virtual directory; configure the external name for Exchange ActiveSync; configure client access settings for Exchange ActiveSync, including Windows SharePoint Services and Windows File Share integration; Direct Push; configure Exchange ActiveSync mailbox policies; configure autodiscover for Exchange ActiveSync Configure Outlook Anywhere and RPC Client Access. This objective may include but is not limited to: autodiscover; MAPI; create client access arrays; certificates; subject alternative name (SAN); configure virtual directories; enable and configure Outlook Anywhere on the CAS; troubleshoot Outlook Anywhere connectivity Configure federated sharing. This objective may include but is not limited to: certificates; enrollment; DNS; calendar and free/busy; subject alternative name (SAN); assign policies; create and configure a federated trust; create and configure a federated organization identifier; create and configure a sharing relationship; create and configure a sharing policy; assign sharing policies to user accounts Configure Outlook Web App (OWA). This objective may include but is not limited to: customize the OWA interface; certificates; file share and SharePoint access; public folders; verify multi-browser support; ECP; SAN; configure virtual directories; coexistence scenarios; authentication; configure the external name for OWA; configure client access settings for OWA, including Windows SharePoint Services and Windows File Share integration; segmentation settings; configure OWA mailbox policies Configuring Message Transport (15 percent) Create and configure transport rules. This objective may include but is not limited to: enable and configure; disclaimers; moderated transport; install the Windows Rights Management Services (RMS) pre-licensing agent; configure rights protection by using transport rules Configure hub transport. This objective may include but is not limited to: configure transport dumpster; accepted domains; remote domains; authoritative domains; e-mail address policies Configure Edge transport. This objective may include but is not limited to: create, configure, and test Edge Sync; configure Edge Transport

A. SQL Server 2008, Implementation & Maintenance 432 B. SQL Server 2008, DB Development 433 C. SQL Server 2008 BI Development & Maintenance 448   A. SQL Server 2008, Implementation & Maintenance    432 Implementing an SSIS Solution (17%) Implement control flow. This objective may include but is not limited to: checkpoints; debug control flow; transactions; implement the appropriate control flow task to solve a problem; data profiling and quality Implement data flow. This objective may include but is not limited to: debug data flow; implement the appropriate data flow components Implement dynamic package behavior by using property expressions. Implement package logic by using variables. This objective may include but is not limited to: system variables; user variables; variable scope Implement package configurations. Implement auditing, logging, and event handling. This objective may include but is not limited to: use system variables for auditing; use event handlers; propagate events; use log providers; data profiling Extend SSIS packages by using .NET code. This objective may include but is not limited to: use the script task; use the script component; use custom assemblies Configuring, Deploying, and Maintaining SSIS (15%) Install and maintain SSIS components. This objective may include but is not limited to: implement disaster recovery for SSIS Deploy an SSIS solution. This objective may include but is not limited to: deploy SSIS packages by using DTUTIL; deploy SSIS packages by using the deployment utility; deploy SSIS packages to SQL or file system locations Manage SSIS package execution. This objective may include but is not limited to: schedule package execution by using SQL Server Agent; execute packages by using DTEXEC; execute packages by using SQL Server Management Studio; execute packages by using the SSIS .NET API Configure SSIS security settings. This objective may include but is not limited to: MSDB database roles; package protection levels Identify and resolve issues related to SSIS solution deployment. This objective may include but is not limited to: validate deployed packages; deploy packages and dependencies between servers Implementing an SSAS Solution (21%) Implement dimensions in a cube. This objective may include but is not limited to: translations; attribute relations; hierarchies Implement measures in a cube. This objective may include but is not limited to: measure groups Implement a data source view. This objective may include but is not limited to: named calculations; named queries Configure dimension usage in a cube. This objective may include but is not limited to: implement reference dimensions; implement many to many relationships; implement fact relationships; implement role-playing relationships; define granularity Implement custom logic in a cube by using MDX. This objective may include but is not limited to: actions; key performance indicators (KPI); calculated members; calculations Implement data mining. This objective may include but is not limited to: implement data mining structures and models; query data mining structures by using DMX; data mining views Implement storage design in a cube. This objective may include but is not limited to: aggregations; partitions; storage modes; proactive caching Configuring, Deploying, and Maintaining SSAS (17%) Configure permissions and roles in SSAS. This objective may include but is not limited to: server roles; SSAS database roles; cube roles; enable client application access; implement custom access to data Deploy SSAS databases and objects. This objective may include but is not limited to: Deployment Wizard; BIDS; SSMS; SSIS Analysis Services Execute DDL task Install and maintain an SSAS instance. This objective may include but is not limited to: disaster recovery Diagnose and resolve performance issues. This objective may include but is not limited to: use SQL Profiler; performance monitor counters; DMVs; Usage Based Optimization Wizard Implement processing options. Implementing an SSRS Solution (17%) Implement report data sources and datasets. This objective may include but is not limited to: query types; dynamic data sources; filter location (dataset vs. query) Implement a report layout. This objective may include but is not limited to: apply conditional formatting; page configuration; headers and footers Extend an SSRS solution by using code. This objective may include but is not limited to: custom .NET assembly; private code Create an SSRS report by using an SSAS data source. This objective may include but is not limited to: MDX in an SSRS report; DMX in an SSRS report Implement report parameters. This objective may include but is not limited to: databound parameters; multi-value parameters Implement interactivity in a report. This objective may include but is not limited to: drilldown; drillthrough; interactive sorting Implement report items. This objective may include but is not limited to: matrix; table; chart; image; list; grouping Embed SSRS reports in custom applications. This objective may include but is not limited to: use the Windows Forms Report Viewer; use the Web Forms Report Viewer; use the SSRS Web service Configuring, Deploying, and Maintaining SSRS (13%) Configure report execution and delivery. This objective may include but is not limited to: subscriptions; report caching; schedules; snapshot history Install and configure SSRS instances. This objective may include but is not limited to: deploy an SSRS Web farm Configure authentication and authorization for a reporting solution. This objective may include but is not limited to: configure server-level and item-level role-based security; configure Windows authentication and custom authentication Deploy an SSRS solution. This objective may include but is not limited to: RS.exe scripts; Report Builder; BIDS Configure SSRS availability. This objective may include but is not limited to: key management; migrate SSRS databases   B. SQL Server 2008, DB Development    433 Implementing Tables and Views (14 percent) Create and alter tables. This objective may include but is not limited to: computed and persisted columns; schemas; scripts to deploy changes to multiple environments, for example, dev, test, production; manage permissions (GRANT, DENY, REVOKE) Create and alter views. This objective may include but is not limited to: WITH ENCRYPTION; WITH SCHEMABINDING; WITH CHECK OPTION; manage permissions (GRANT, DENY, REVOKE) Create and alter indexes. This objective may include but is not limited to: filtered, included columns, unique, clustered, non-clustered, FILL FACTOR; CREATE STATISTICS; indexing views, compression Create and modify constraints. This objective