Software Development Fundamentals (MTA)

Course details

This course prepares students for the Microsoft MTA exam in Software Development Fundamentals, which is designed to provide candidates with an assessment of their knowledge of fundamental software development concepts. It can also serve as a stepping stone to the Microsoft Certified Technology Specialist exams. In addition all students who complete the course will receive a CCT Certification.

Programme Audience

The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.

Programme Aims and Objectives

This MTA exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.The higher the percentage, the more questions you are likely to see on that content area on the exam.

The information after “This objective may include but is not limited to” is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area. You may be tested on other skills and topics related to the objective that are not explicitly listed here.

Course Outline

Understanding Core Programming (18 percent)

Understand computer storage and data types.

• This objective may include but is not limited to: how a computer stores programs and the instructions in computer memory; memory stacks and heaps; memory size requirements for the various data storage types; numeric data and textual data

Understand computer decision structures.

• This objective may include but is not limited to: various decision structures used in all computer programming languages; If decision structures; multiple decision structures such as If…Else and switch/Select Case; reading flowcharts; decision tables; evaluating expressions

Identify the appropriate method for handling repetition.

• This objective may include but is not limited to: For loops, While loops, Do..While loops, and recursion.

Understand error handling.

This objective may include but is not limited to: structured exception handling

Understand the fundamentals of classes.

• This objective may include but is not limited to: properties, methods, events, and constructors; how to create a class; how to use classes in code

Understand inheritance.

• This objective may include but is not limited to: inheriting the functionality of a base class into a derived class

Understand polymorphism.

• This objective may include but is not limited to: extending the functionality in a class after inheriting from a base class; overriding methods in the derived class

Understand encapsulation.

• This objective may include but is not limited to: creating classes that hide their implementation details while still allowing access to the required functionality through the interface; access modifiers

Understanding General Software Development (14 percent)

Understand application life cycle management.

• This objective may include but is not limited to: phases of application life cycle management; software testing

Interpret application specifications.

• This objective may include but is not limited to: reading application specifications and translating them into prototypes, code, and components

Understand algorithms and data structures.

• This objective may include but is not limited to: arrays, stacks, queues, linked lists, and sorting algorithms; performance implications of various data structures; choosing the right data structure

Understanding Web Applications (20 percent)

Understand Web page development.

• This objective may include but is not limited to: HTML, Cascading Style Sheets (CSS), JavaScript

Understand Microsoft ASP.NET Web application development.

• This objective may include but is not limited to: page life cycle; event model; state management; client-side vs. server-side programming

Understand Web hosting.

• This objective may include but is not limited to: creating virtual directories and Web sites; deploying Web applications; understanding the role of Internet Information Services

Understand Web services.

• This objective may include but is not limited to: Web services that will be consumed by client applications; accessing Web services from a client application; SOAP and Web Service Definition Language (WSDL)Understanding Desktop Applications (12 percent)

Understand Windows Forms applications.

• This objective may include but is not limited to: Windows Forms event model; visual inheritance; UI design; use of Multiple Document Interface (MDI) and Single Document Interface [and here] (SDI) applications

Understand console-based applications.

• This objective may include but is not limited to: characteristics and capabilities of console-based applications

Understand Windows Services.

• This objective may include but is not limited to: characteristics and capabilities of Windows Services

Understanding Databases (17 percent)

Understand relational database management systems.

• This objective may include but is not limited to: characteristics and capabilities of database products; database design; Entity Relationship Diagrams (ERDs); normalization concepts

Understand database query methods.

• This objective may include but is not limited to: structured query language (SQL), creating and accessing stored procedures, updating data and selecting data

Understand database connection methods.

• This objective may include but is not limited to: connecting to various types of data stores such as flat file; XML file; in-memory object; resource optimization