My Key Skills 2015-2016

Methodologies

OOP, Design Patterns, Waterfall, Kanban, Scrum

Languages

C#.NET, T-SQL, PL-SQL, PHP,

Web

IIS 8, IIS 8.5, Apache, HTML5, CSS3, Bootstrap, JavaScript, jQuery, WCF Services, ASP.NET Web Forms, MVC, Modernizer, DotNetNuke, AngularJS

Databases / Data Access

MS SQL Server 2014, MySQL, Oracle, ADO.NET, LINQ

IDE

Visual Studio 2013; 2015, NetBeans

Software Testing

Unit Testing, Coded UI, Automated Test, Selenium

Team Management

Team Foundation Server (TFS), Slack, JIRA, Office 365

Operating system

Windows 7, Windows 8.1, Windows Server 2008R2, Windows Server 2012, Windows Server 2012 R2, Embedded Systems, Windows Phone.

MTA Exam 98-375: HTML5 Application Development Fundamentals

Manage the application life cycle

Build the user interface (UI) by using HTML5

Format the user interface by using Cascading Style Sheets (CSS)

Code by using JavaScript

Manage the application life cycle

Understand the platform fundamentals

Packaging and the runtime environment: app package, app container, credentials/permission sets, host process, leverage existing HTML5 skills and content for slate/tablet applications

Manage the state of an application

Manage session state, app state, and persist state information; understand states of an application; understand the differences between local and session storage

Debug and test an HTML5-based, touch-enabled application

Touch gestures; understand which gestures you test on a device

Build the user interface (UI) by using HTML5

Choose and configure HTML5 tags to display text content

Choose and configure HTML5 tags to display graphics

When, why, and how to use Canvas; when, why, and how to use scalable vector graphics (SVG)

Choose and configure HTML5 tags to play media

Video and audio tags

Choose and configure HTML5 tags to organize content and forms

Tables, lists, sections; semantic HTML

Choose and configure HTML5 tags for input and validation

Format the user interface by using Cascading Style Sheets (CSS)

Understand the core CSS concepts

Separate presentation from content (create content with HTML and style content with CSS); manage content flow (inline versus block flow); manage positioning of individual elements( float versus absolute positioning); manage content overflow (scrolling, visible, and hidden); basic CSS styling

Arrange UI content by using CSS

Use flexible box and grid layouts to establish content alignment, direction, and orientation; proportional scaling and use of "free scale" for elements within a flexible box or grid; order and arrange content; concepts for using flex box for simple layouts and grid for complex layouts; grid content properties for rows and columns; use application templates

Manage the flow of text content by using CSS

Regions and using regions to flow text content between multiple sections (content source, content container, dynamic flow, flow-into, flow-from, msRegionUpdate, msRegionOverflow, msGetRegionContent); columns and hyphenation and using these CSS settings to optimize the readability of text; use "positioned floats" to create text flow around a floating object

Manage the graphical interface by using CSS

Graphics effects (rounded corners, shadows, transparency, background gradients, typography, and Web Open Font Format); two-dimensional (2-D) and three-dimensional (3-D) transformations (translate, scale, rotate, skew, and 3-D perspective transitions and animations); SVG filter effects; Canvas

Code by using JavaScript

Manage and maintain JavaScript

Create and use functions; jQuery and other third-party libraries

Update the UI by using JavaScript

Locate/access elements; listen and respond to events; show and hide elements; update the content of elements; add elements

Code animations by using JavaScript

Use animation; manipulate the canvas; work with images, shapes, and other graphics

Access data access by using JavaScript

Send and receive data; transmit complex objects and parsing; load and save files; App Cache; datatypes; forms; cookies; localStorage

Respond to the touch interface

Gestures, how to capture and respond to gestures

Code additional HTML5 APIs

GeoLocation, Web Workers, WebSocket; File API

Access device and operating system resources

In- memory resources, such as contact lists and calendar; hardware capabilities, such as GPS, accelerometer, and camera

MTA Exam 98-382: Introduction to Programming Using JavaScript

Program with JavaScript Operators, Methods, and Keywords

Program with Variables, Data Types, and Functions

Implement and Analyze Decisions and Loops

Interact with the Document Object Model

Interact with HTML Forms

Program with JavaScript Operators, Methods, and Keywords

Complete or debug code that uses assignment and arithmetic operators

Assignment; increment; decrement; addition; subtraction; division; multiplication; modulus; compound assignment operators

Apply JavaScript best practices  

Comments; indentations; naming conventions; noscript; constants; reserved keywords; debugger keyword; setting breakpoints; console.log

Evaluate the use of inline and external scripts

When to use, how to use, and what happens when both are used

Implement exception handling

try; catch; finally

Complete and debug code that interacts with the Browser Object Model (BOM)

Manage state; display dialogs; determine screen size

Program with Variables, Data Types, and Functions

Declare and use variables of primitive data types 

Number; Boolean; String; Null; Undefined; typeof operator; type checking functions; use strict; converting between data types; formatting numbers; string operations; single quote vs double quote (nesting); initialization

Declare and use arrays

Single-dimensional arrays; multi-dimensional arrays; iteration; initialization; define an array; sort and search an array; use push, pop, shift, and unshift methods; use the length property; access an array element;

Complete and debug code that uses objects

Properties; methods; instantiation; Date object; retrieve date and time parts; localize date format (MM/DD vs DD/MM); add and subtract dates

Complete and debug code that uses built-in Math functions

Random; round; abs; floor; ceiling; min; max; pow; sqrt

Complete and debug a function that accepts parameters and returns a value

Reusable code; local versus global scope, redefine variables, pass parameters, value versus reference, return values

Implement and Analyze Decisions and Loops

Evaluate expressions that use logical and comparison operators

==; !=; <, >; <=; >=; !; &&; ||

Complete and debug decision statements

if; else if; switch; nested if

Complete and debug loops

for; while; do; break; continue

Interact with the Document Object Model

Identify and construct the Document Object Model (DOM) tree

window; document; body; other HTML elements

Identify and handle HTML events

onchange; onmouseover; onload; onclick; onmouseout; onkeydown

Complete and debug code that  outputs to an HTML document

innerHTML; document.write

Complete and debug code that locates, modifies, and adds HTML elements and attributes

getElementByld; getElementsByTagName; getElementsByClassName; setAttribute; createElement

Interact with HTML Forms

Complete and debug code that retrieves input from forms and sets form field values

Retrieve form values; identify the DOM path; get values from different types of elements; prepopulate values; mask values

Complete and debug code that performs input validation

Case; string comparisons; Not-A-Number (NaN)

Describe the form submission process

onsubmit; post versus get; potential targets for submission

MTA Exam 98-383: Introduction to Programming Using HTML and CSS

Understand HTML Fundamentals

Understand CSS Fundamentals

Structure Documents Using HTML

Present Multimedia Using HTML

Style Web Pages Using CSS

Understand HTML Fundamentals

Construct markup that uses metadata elements

Script; noscript; style; link; meta tags, including encoding, keywords, viewport, and translate

Construct well-formed markup that conforms to industry best practices  

DOCTYPE declaration; HTML; head; body; proper syntax, including closing tags and commonly used symbols; comments

Understand CSS Fundamentals

Analyze the impact of using inline styles, internal style sheets, and external style sheets

When to use inline styles; when to use internal style sheets; when to use external style sheets; precedence when using a combination of inline styles and style sheets

Construct and analyze rule sets

Valid syntax for the CSS rule set; selectors, including class, id, elements and pseudo-class

Construct well-formed style sheets that conform to industry best practices

Reusing rules and rule sets; commenting; testing on multiple browsers; web safe fonts

Structure Documents Using HTML

Construct and analyze markup to structure content and organize data

Table tags; h1-h6; p; br; hr; div; span; ul; ol; li

Construct and analyze markup that uses HTML5 semantic elements

Semantic tags; header; nav; section; article; aside; footer; details; summary; figure; caption

Construct and analyze markup that implements navigation

Image links; a; target; bookmark; relative versus absolute links; navigating simple folder hierarchies

Construct and analyze markup that uses form elements

Form attributes; action; method; submission methods; accessibility; input types and restrictions; select; textarea; button; output; option; datalist; fieldset

Present Multimedia Using HTML

Construct and analyze markup that displays images

img and picture elements and their attributes

Describe the appropriate use of the img, svg, and canvas elements

Construct and analyze markup that plays video and audio

Video; audio; track; source; simple iframe implementations

Style Web Pages Using CSS

Construct and analyze styles that position content

Positioning, including float, relative, absolute, max-width, overflow, height, width, and align; inline versus block; visibility; box model, including margins and padding

Construct and analyze styles that format text

Font-family; color; font-style; font-size; font-weight; link colors; text formatting, including text alignment, text decoration, and indentation

Construct and analyze styles that format backgrounds and borders

Border-color; border-style; border-width; backgrounds; divs; colors

Analyze styles that implement a simple responsive layout

Units of measure; responsive effects with CSS, including viewport and media query; percentages versus pixels; frameworks and templates; max width

MTA Exam 98-364: Database Fundamentals

Understand core database concepts

Create Database Objects

Manipulate data

Understand data storage

Administer a database

Understand core database concepts

Understand how data is stored in tables

Understand what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records

Understand relational database concepts

Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established

Understand data manipulation language (DML)

Understand what DML is and its role in databases

Understand data definition language (DDL)

Understand how T-SQL can be used to create database objects, such as tables and views

Create Database Objects

Choose data types

Understand what data types are, why they are important, and how they affect storage requirements

Understand tables and how to create them

Purpose of tables; create tables in a database by using proper ANSI SQL syntax

Create views

Understand when to use views and how to create a view by using T-SQL or a graphical designer

Create stored procedures and functions

Select, insert, update, or delete data

Manipulate data

Select data

Utilize SELECT queries to extract data from one table, extract data by using joins, combine result sets by using UNION and INTERSECT

Insert data

Understand how data is inserted into a database, how to use INSERT statements

Update data

Understand how data is updated in a database and how to write the updated data to the database by using the appropriate UPDATE statements, update by using a table

Delete data

Delete data from single or multiple tables, ensure data and referential integrity by using transactions

Understanding data storage

Understand normalization

Understand the reasons for normalization, the five most common levels of normalization, how to normalize a database to third normal form

Understand primary, foreign, and composite keys

Understand the reason for keys in a database, choose appropriate primary keys, select appropriate data type for keys, select appropriate fields for composite keys, understand the relationship between foreign and primary keys

Understand indexes

Understand clustered and non-clustered indexes and their purpose in a database

Administer a database

Understand database security concepts

Understand the need to secure a database, what objects can be secured, what objects should be secured, user accounts, and roles

Understand database backups and restore

Understand various backup types, such as full and incremental, importance of backups, how to restore a database

MTA Exam 98-361: Software Development Fundamentals

Understand programming

Understand object-oriented programming

Understanding general software development

Understanding desktop applications

Understand web applications

Understanding databases

Understand programming

Understand computer storage and data types

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

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

For loops, While loops, do-While loops, and recursion

Understand error handling

Structured exception handling

Understand object-oriented programming

Understand the fundamentals of classes

Properties, methods, events, and constructors; how to create a class; how to use classes in code

Understand inheritance

Inheriting the functionality of a base class into a derived class

Understand polymorphism

Extending the functionality in a class after inheriting from a base class, overriding methods in the derived class

Understand encapsulation

Creating classes that hide their implementation details while still allowing access to the required functionality through the interface, access modifiers

Understanding general software development

Understand application life cycle management

Phases of application life cycle management, software testing

Interpret application specifications

Reading application specifications and translating them into prototypes, code, select appropriate application type, and components

Understand algorithms and data structures

Arrays, stacks, queues, linked lists, and sorting algorithms; performance implications of various data structures; choosing the right data structure

Understanding desktop applications

Understand Windows apps

UI design guideline categories, characteristics and capabilities of Store Apps, identify gestures

Understand console-based applications

Characteristics and capabilities of console-based applications

Understand Windows Services

Characteristics and capabilities of Windows Services

Understand web applications

Understand web page development

HTML, Cascading Style Sheets (CSS), JavaScript

Understand Microsoft ASP.NET web application development

Page life cycle, event model, state management, client-side versus server-side programming

Understand web hosting

Creating virtual directories and websites, deploying web applications, understanding the role of Internet Information Services

Understand web services

Web services that will be consumed by client applications, accessing web services from a client application, SOAP and Web Service Definition Language (WSDL)

Understanding databases

Understand relational database management systems

Characteristics and capabilities of database products, database design, Entity Relationship Diagrams (ERDs), normalization concepts

Understand database query methods

Structured query language (SQL), creating and accessing stored procedures, updating data and selecting data

Understand database connection methods

Connecting to various types of data stores, such as flat file; XML file; in-memory object; resource optimization