HiTech Institute
Published on HiTech Institute (http://www.htinstitute.com)

Home > MCTS Exam 70 - 561: Microsoft.NET Framework 3.5, ADO.NET

MCTS Exam 70 - 561: Microsoft.NET Framework 3.5, ADO.NET

Vendor: 
Microsoft [1]
Subject: 
Programming [2]
Course Contents: 

Chapter 1: Creating Database Connections;
1.1 Before You Begin;
1.2 Lesson 1: Connecting to a Data Source;
1.3 Lesson 2: Using Data Providers and More Complex Connection Scenarios;
1.4 Lesson 3: Working with Multiple Active Result Sets;
1.5 Chapter Review;
1.6 Suggested Practice;
1.7 Take a Practice Test;

Chapter 2: Selecting and Querying Data;
2.1 Lesson 1: Building Command Objects;
2.2 Lesson 2: Consuming Data Before You Begin;
2.3 Chapter Review;
2.4 Suggested Practice;
2.5 Take a Practice Test;

Chapter 3: DataSets;
3.1 Before You Begin;
3.2 Lesson 1: Introduction to DataSets;
3.3 Lesson 2: Working with Typed DataSets;
3.4 Chapter Review;
3.5 Suggested Practices;
3.6 Take a Practice Test;

Chapter 4: Updating Data;
4.1 Before You Begin;
4.2 Lesson 1: Updating Data;
4.3 Lesson 2: Data Integrity and Transactions;
4.4 Chapter Review;
4.5 Suggested Practices;
4.6 Take a Practice Test;

Chapter 5: Synchronizing Data;
5.1 Before You Begin;
5.2 Lesson 1: Caching Data;
5.3 Lesson 2: Microsoft Sync Framework;
5.4 Chapter Review;
5.5 Suggested Practices;
5.6 Take a Practice Test;

Chapter 6: Introducing LINQ;
6.1 Before You Begin;
6.2 Lesson 1: Constructing Queries with LINQ;
6.3 Lesson 2: Shaping Results with LINQ;
6.4 Chapter Review;
6.5 Suggested Practices;
6.6 Take a Practice Test;

Chapter 7: XML;
7.1 Before You Begin;
7.2 Lesson 1: DataSets and XML;
7.3 Lesson 2: Querying XML with LINQ;
7.4 Chapter Review;
7.5 Suggested Practices;
7.6 Take a Practice Test;

Chapter 8: LINQ to SQL;
8.1 Before You Begin;
8.2 Lesson 1: Introduction to LINQ to SQL;
8.3 Lesson 2: Updating Data;
8.4 Using Stored Procedures;
8.5 Chapter Review;
8.6 Suggested Practices;
8.7 Take a Practice Test;

Chapter 9: Using the Entity Framework;
9.1 Before You Begin;
9.2 Lesson 1: Generating and Querying an Entity Data Model;
9.3 Chapter Review;
9.4 Suggested Practice;
9.5 Take a Practice Test;

Chapter 10: ADO.NET Data Services;
10.1 Before You Begin;
10.2 Lesson 1: Exposing the Data Service;
10.3 Lesson 2: Consuming the Data Service;
10.4 Chapter Review;
10.5 Suggested Practices;
10.6 Take a Practice Test;

Objective: 

Connect to data sources; query and retrieve data

Manage data integrity and transactions

Use LINQ to query data across types, including XML

Work with DataSets and in-memory stores

Synchronize data-including smart-caching strategies

Generate an EDM using the Entity Framework

Use ADO.NET Data Services for Internet applications

Prerequisites: 

Candidates for this course/exam use Microsoft Visual Studio to develop data-access portions of applications.
Candidates should have a minimum of two to three years of experience developing Web, Windows, or distributed applications by using the Microsoft .NET Framework.
Candidates should have a thorough understanding of relational database concepts and should have a minimum of one to two years of experience using Microsoft SQL Server and other relational database management systems, such as Oracle, DB2, and MySQL.

Benefits: 

Credit Toward Certification Exam 70-561: TS: Microsoft .NET Framework 3.5, ADO.NET Application Development: counts as credit toward the following certification(s):

  • Microsoft Certified Technology Specialist (MCTS): .NET Framework 3.5, ADO.NET Applications
  • Microsoft Certified Professional Developer (MCPD): Enterprise Applications Developer 3.5
  • Duration: 
    40 hours

    Business Analysis (BA)

    Business Analysis (IIBA) Courses
    About IIBA
    CBAP Certification
    CCBA Certification
    Business Analysis Certification Benefits
    Business Analysis Training at HiTech Institute

    -->

    Six Sigma

    Six Sigma Certifications
    Six Sigma Training
    Six Sigma FAQs
    Why Six Sigma Training @ HiTech

    Project Management (PMP®)

    Project Management (PMP®) Courses
    PMP® Training at HiTech Institute
    PMP® FAQs
    PMP® Certification
    About Project Management Institute
    PMP® Testimonials

    ITIL®

    ITIL® Courses
    ITIL® Consulting Services
    ITIL® Training & Certification
    ITIL® Practitioner
    ITIL® - FAQs
    IT Infrastructure Library® - ITIL®

    Quality Assurance (QA)

    Quality Assurance (QAI) Courses
    Software Quality Certifications
    Software Testing & Quality Certification Objectives
    Benefits of QA Certification
    About QAI Global Institute
    Copyright © 1998-2013 HiTech Institute | Acknowledgements | Registration Policy
    PMP, CAPM, PMI, PMBOK, PMI-ACP, PMI-RMP are registered marks of the Project Management Institute, Inc.
    PMP®Training Toronto, ITIL® Training Toronto, Six Sigma Training Toronto, QA Training Toronto, Online Training Toronto

    Source URL: http://www.htinstitute.com/courses/mcts-exam-70-561-microsoftnet-framework-35-adonet

    Links:
    [1] http://www.htinstitute.com/vendors/microsoft
    [2] http://www.htinstitute.com/htnteam/programming