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

Paradigm of Computer science Courses

Paradigm of Computer Science Courses

• Principles of Computer Science
• Fundamentals of Programming Languages
• Scientific Computation I & II
• Theoretical Foundation of Computer Science
• Formal Language and Automata
• Computer Systems and Architecture
• Microprocessors and Communication Circuits
• Operating Systems
• File Structures
• Computer Networks
• Data Communications
• Compilers
• Systems Simulations
• Algorithms
• Data Structure and Databases
• Data Mining
• Artificial Intelligence
• Distributed Computing
• Object-Oriented Programming and C++

Computer Fundamentals

• Applications
• Generations
• Types and Classification
• Components
• CPU (Central Processing Unit)
• Input Devices
• Output Devices
• Memory and Memory Units
• Motherboard
• Ports
• Operating System
• Hardware
• Software
• Number System
• Data and Information
• Networking
• Internet and Intranet
• Programming Languages
• Multimedia
• Security

Fundamentals of Programming languages

• Inductive Definitions
• Levels of Syntax
• Binding and Scope
• Static and Dynamic Semantics
• Functional Core Language
• Recursion
• Iteration
• Fixed Points
• Products and Records
• Sums and Variants
• Polymorphism
• Data Abstraction
• Recursive Types
• Subtyping
• Programming Languages; BASIC, Pascal

Scientific Computation

• Computational Problem solving
• Programming Languages; FORTRAN, C
• Numerical Software Packages
• Methods of Random number generators
• Interval Computation
• Some problems in Computational physics
• Some problems in Computational Chemistry
• Soft Computing
• Neural Networks

Theoretical Foundations of CS

• Mathematical Background
• Automata and grammars
• Solvable and unsolvable problems
• The Complexity of computing
• Formal Semantics
• Proving program properties
• Nondeterminism and parallel computing

Formal Language and Automata

• Mathematical preliminaries
• Proof techniques
• Finite Automata and Regular Languages
• Context-Free Languages
• Turing Machines and the Church-Turing Thesis
• Decidable and Undecidable Languages
• Programming Languages; Prolog

Computer Architecture

• Design of a basic computer
• Design concepts of Processors
• Design of channels and controllers
• Interconnections
• Memory structures and design
• Memory management
• Cache memory systems
• Firmware design
• Reliability
• Testing and fault tolerance
• CISC computers
• RISC computers
• Computer interfacing
• Design of network interface cards
• Examples of computer architecture

Operating Systems

• Types of operating systems
• Operating Systems structures
• System components and services
• Virtual machines
• Process management
• CPU scheduling
• Scheduling concepts
• performance criteria
• Scheduling algorithm
• Memory organization and management
• Secondary storage management
• Disk scheduling
• Virtual memory

File Organization and processing

• File design
• File manipulation
• Blocking and buffering
• Single and double buffering
• Types of storage devices
• Space and time calculation
• Sequential file
• Relative file
• Indexed sequential file
• Multiple key file
• Direct access file
• External sort/merge algorithms
• File systems-disk scheduling

Computer Networks

• Computer Network Types
• Network LAN Technologies
• Computer Network Topologies
• Computer Network Models
• Computer Network Security
• Physical Layer Introduction
• Digital Transmission
• Analog Transmission
• Transmission Media
• Wireless Transmission
• Multiplexing
• Network Switching
• Data-link Layer Introduction
• Error Detection & Correction
• Data-link Control & Protocols
• Network Layer Introduction
• Network Addressing
• Network Layer Routing
• Internetworking
• Network Layer Protocols
• Transport Layer Introduction
• Transmission Control Protocol
• User Datagram Protocol
• Application Layer Introduction
• Client Server Model
• Application Protocols
• Network Services

Data Communications

• Concepts and Terminology
• Types of data
• Types of signals
• Data communication model
• Data Transmission techniques
• Information theory
• Information sources
• Information measure
• Data encoding and decoding
• Transmission media types and characteristics
• Transmission impairments
• Analog and digital transmission
• Multiplexing techniques

Compilers

• Architecture
• Phases of Compiler
• Lexical Analysis
• Regular Expressions
• Finite Automata
• Finite Automata
• Types of Parsing
• Top-Down Parser
• Bottom-Up Parser
• Error Recovery
• Semantic Analysis
• Run-Time Environment
• Symbol Table
• Intermediate Code Generation
• Code Generation
• Code Optimization

Simulations

• Concepts & Classification
• Verification & Validation
• Discrete System Simulation
• Continuous Simulation
• Monte Carlo Simulation
• Modelling & Simulation - Database

Algorithms

• The Role of Algorithms in Computing
• Insertion sort
• Analyzing and Designing algorithms
• Growth of Functions
• Recurrences
• Probabilistic Analysis and Randomized Algorithms
• Sorting and Order Statistics
• Algorithms and Data Structures
• Advanced Design and Analysis Techniques
• Greedy Algorithms
• Advanced Data Structures
• Graph Algorithms

Data structures

• Software Engineering Principles
• Data design and Implementation
• Abstract Data Type (ADT)
• Unsorted List and Sorted List
• Stack and Queue
• Linked Structures
• Linked Lists
• Recursion
• Binary Search Trees
• Priority Queues
• Heaps, Graphs and Sets
• Sorting and searching algorithms

Databases

• Introduction to DB System
• Operational Data
• Data independence
• Relational System
• The architecture of DB System
• Relational Algebra and Calculus
• Recovery and concurrence
• security and integrity
• SQL Language

Data Mining

• Data Mining Overview
• Data Warehouse
• Data Preprocessing
• Classification
• Clustering
• Prediction
• Logistic Regression
• Association Rules

Distributed Computing

• Parallel and Distributed Architecture
• Parallel Algorithm design
• Message-passing Programming
• Sharing-memory Programming
• Performance analysis
• Applications

Object Oriented Programming

• Structured Programming
• Concepts of object-oriented programming
• Classes and Objects
• Interfaces
• Dynamic dispatch/message passing
• Class-based versus prototype-based
• Encapsulation
• Composition, inheritance, and delegation
• Polymorphism
• Open recursion
• Programming Languages; C++

Artificial Intelligence

• Intelligent Systems
• Research Areas
• Agents & Environments
• Popular Search Algorithms
• Fuzzy Logic Systems
• Natural Language Processing
• Expert Systems
• Robotics
• Neural Networks
• Issues and Terminology

Computer Security

• Elements and Terminologies
• Layers
• Securing OS
• Antiviruses and Malwares
• Encryption
• Data Backup
• Disaster Recovery
• Policies and Checklist
• Network Security
• Wireless Security
• Internet Security
• Software Security
• Database Security
• Security Testing

Cryptography

• Basic of Modern Cryptography
• Cryptographic Tasks
• Public key Cryptography
• Ciphers and Hashes
• Cryptanalysis
• Cryptographic Software

Programming Languages

• BASIC Programming Language (Fundamentals of Programming Languages Course)
• Pascal Programming Language (Fundamentals of Programming Languages Course)
• Fortran Programming Language (Scientific Computation Course)
• C Programming Language (Scientific Computation Course)
• Prolog Programming Language (Formal Language and Automata Course)
• C++ Programming Language (OOP Course)

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