Monday, February 24, 2014
Wednesday, February 5, 2014
MTA Microsoft Technology Associate Certification Paths
MTA Certification Exams
DATABASE EXAM | |||
Database Administration Fundamentals
EXAM 98-364
| |||
|
IT PROFESSIONAL EXAMS | |||
Windows
Server Administration Fundamentals
EXAM 98-365
|
Networking Fundamentals
EXAM 98-366 |
Security Fundamentals
EXAM 98-367 |
Windows Operating System Fundamentals
EXAM 98-349
|
|
|
|
|
شرح
6.3. Understand database connection methods.
6.3. 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.
6.2. Understand database query methods.
6.2. Understand database query methods.
This objective may include but is not limited to: structured query language (SQL), creating and accessing stored procedures, updating data, selecting data.
6.1. Understand relational database management systems.
6.1. 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.
5.3. Understand Windows Services.
5.3. Understand Windows Services.
This objective may include but is not limited to: characteristics and capabilities of Windows Service.
5.2. Understand console-based applications.
5.2. Understand console-based applications.
This objective may include but is not limited to: characteristics and capabilities of console-based applications.
5.1. Understand Windows Forms applications.
5.1. 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 (SDI) applications.
4.4. Understand Web services.
4.4. 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).
4.3. Understand Web hosting.
4.3. 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.
4.2. Understand Microsoft ASP.NET Web application development.
4.2. 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.
4.1. Understand Web page development.
4.1. Understand Web page development.
This objective may include but is not limited to: HTML, Cascading Style Sheets (CSS), JavaScript.
3.3. Understand algorithms and data structures.
3.3. 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.
NOT: algorithm analysis.
3.2. Interpret application specifications.
3.2. Interpret application specifications.
This objective may include but is not limited to: reading and translating application specifications into prototypes, code, and components.
3.1. Understand application life cycle management.
3.1. Understand application life cycle management.
This objective may include but is not limited to: phases of application life cycle management; software testing.
2.4. Understand encapsulation.
2.4. 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.
2.3. Understand polymorphism.
2.3. 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.
2.2. Understand inheritance.
2.2. Understand inheritance.
This objective may include but is not limited to: inheriting the functionality of a base class into a derived class.
2.1. Understand the fundamentals of classes.
2.1. 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.
1.4. Understand error handling.
1.4. Understand error handling.
This objective may include but is not limited to: structured exception handling.
1.3. Identify the appropriate method for handling repetition.
1.3. 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.
1.2. Computer decision structures.
1.2. 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.
1.1. computer storage and data types.
1.1. 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.
Guiding
Questions
1.How are program instructions stored
in a computer?
2.Identify the different data types
that can be used and the values they can hold.
Activator
§Name
the components of a computer.
§What
components are involved in storing program instructions?
Review
Terms
§Data
type—a definition of a set of data that specifies the possible range of values
of the set, the operations that can be performed on the values, and the way in
which the values are stored in memory.
§Garbage
collection—a process for automatic recovery of heap memory.
§Heap—a
portion of memory reserved for a program to use for the temporary storage of
data structures whose existence or size cannot be determined until the program
is running.
§Memory
—a device where information can be stored and retrieved.
§Stack—a
region of reserved memory in which programs store status data such as procedure
and function call addresses, passed parameters, and sometimes local variables.
How a computer stores programs in memory
§A
computer keeps data and programs in storage as follows:
§Primary
storage—Otherwise known as random access memory (RAM), it is made of memory
chips. In common usage, it refers only to a computer’s main memory, the fast
semiconductor storage (RAM) directly connected to the processor.
§Secondary
storage—Otherwise known as a hard drive, it consists of a read/write head that
floats above rotating platters coated with a magnetic material.
Memory–Stacks
and Heaps
§Variables
are stored in either a stack or heapbased on their type:
§Value
types (e.g.: int,
double,
float)
go on the stack.
§Reference
types (String,
Object)
go on the heap.
* Value types in classes are stored with the
instance of the class on the heap.
The
stack
§Values
in the stack are managed without garbage collection because items are added and
removed from the stack as last in, first out (LIFO) every time you enter or
exit a scope, like a method or statement
A
StackOverFlowExceptionoccurs because you have used up all the available space in the stack.
Memory–Stacks
and Heaps (continued)
§The
heap
§A
heap-based memory allocation occurs when
we create a new object, at which point the compiler figures out how much memory
is needed and allocates an appropriate amount of memory space and returns a
reference representing the memory address.
§A
heap is used for dynamic allocation of memory.
§The
Microsoft .NET Framework uses garbage collection to free up space during run
time.
§Garbage
collection
is an automatic process for recovery of heap memory. Blocks of memory that had been allocated but
are no longer in use are freed, and blocks of memory still in use may be moved
to consolidate the free memory into larger blocks.
Data
Types
§Numeric
data types
§Integral
types (e.g.: byte, char, int)
§Floating-point
types (float,
double)
§Decimal
§Example: bool done
= false;
Decimal
Type
Using
the Numeric Data Types
byte numKids
= 15;
char letter = ‘p’;
int
worldPopulation
= 6692030277;
float money = 201.00f;
double lotsaMoney
= 2.4E+12;
decimal testGrade
= 89.5m;
Lesson
Review
§Describe
how the program statement below is stored in memory:
int
tennisPoints
= 30;
§Identify
the appropriate data types for each of the following values.
§4233423.93
§100
§-2323
§true
Subscribe to:
Posts (Atom)