“Apabila anda  mencari langkah pertama untuk membangun karir yang sukses di bidang teknologi ? MTA (Microsoft Technology Associate) merupakan cara untuk membedakan kompetisi teknologi dan mengeksplorasi pilihan akademis dan karir ….” – Certiport.com

Diatas adalah overview dari Microsoft Technologi Associate, memang secara teknis MTA ini merupakan sertifikasi yang banyak digunakan dalam karir di dunia industri dan akademisi, khususnya dalam dunia teknologi informasi dan komunikasi. Beberapa ujian-nya banyak dibutuhkan dalam lapangan pekerjaan, seperti: Front End Developer, Back End Developer, Junior/Senior Programer, DB Administrator, Networking Administrator, SysAdmin, Mobile Developer, dll.

Namun pada kesempatan kali ini saya hanya akan menulis mengenai exam objectives dari Database Administrator Fundamentals dan  Networking Fundamentals.  ada beberapa keuntungan yang diberikan oleh pihak microsoft apabila anda lulus dalam ujian sertifikasi tersebut, seperti dapat mengakses secara khusus sumber daya dan keuntungan dari Microsoft Certified Solutions Developer (MCSD) termasuk kesempatan untuk berhubungan pada jaringan yang luas dan jaringan global MCP (Microsoft Certified Professional).

Langsung  saja, saya akan menjelaskan beberapa exam objectives dari  Database  Administrator Fundamentals dan Networking Fundamentals adalah sebagai berikut:

Database Administration Fundamentals
EXAM 98-364

=> Understanding Core Database Concepts (20-25%)

  •  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 Object (20-25%)

  • 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 (25-30%)

  • 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

=> Understand Data Storage (15-20%)

  • 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  (10-15%)

  • 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

Catatan: untuk database administrator fundamentals  microsoft memberikan kita pengetahuan tambahan dengan memberikan informasi preparation resources  (persiapan sumber daya). Anda dapat melihat preparation resources  di-reference(s) yang ada  dibawah pada  poin ke-4.

 

Networking Fundamentals
EXAM 98-366

=> Understanding  network infrastructures (30-35%)

  • Understand the concepts of Internet, intranet, and extranet
    • Virtual Private Network (VPN), security zones, firewalls
  • Understand local area networks (LANs)
    • Perimeter networks; addressing; reserved address ranges for local use (including local loopback IP), VLANs; wired LAN and wireless LAN
  • Understand wide area networks (WANs)
    • Leased lines, dial-up, ISDN, VPN, T1, T3, E1, E3, DSL, cable, and more, and their characteristics (speed, availability)
  • Understand wireless networking
    • Types of wireless networking standards and their characteristics (802.11a,b,g,n, including different GHz ranges), types of network security (WPA, WEP, 802.1X, and others), point-to-point (P2P) wireless, wireless bridging
  • Understand network topologies and access methods
    • Star, mesh, ring

=> Understanding network hardware (20-25%)

  • Understand switches
    • Transmission speed, number and type of ports, number of uplinks, speed of uplinks, managed or unmanaged switches, VLAN capabilities, Layer 2 and Layer 3 switches and security options, hardware redundancy, support, backplane speed, switching types and MAC table, understand capabilities of hubs versus switches
  • Understand routers
    • Transmission speed considerations, directly connected routes, static routing, dynamic routing (routing protocols), default routes; routing table and how it selects best route(s); routing table memory, network address translation (NAT), software routing in Windows Server; Quality of Service (QoS)
  • Understand media types
    • Cable types and their characteristics, including media segment length and speed; fiber optic; twisted pair shielded or nonshielded; catxx cabling, wireless; susceptibility to external interference (machinery and power cables); susceptibility to electricity (lightning), susceptibility to interception

=> Understanding Protocols and  Services (45-45%)

  • Understand the Open Systems Interconnection (OSI) model
    • OSI model; Transmission Control Protocol (TCP) model; examples of devices, protocols, applications, and which OSI/TCP layer they belong to; TCP and User Datagram Protocol (UDP); well-known ports for most used purposes (not necessarily Internet); packets and frames
  • Understand IPv4
    • Subnetting, IPconfig, why use Internet Protocol version 4 (IPv4), addressing, ipv4toipv6 tunneling protocols to ensure backward compatibility, dual IP stack, subnetmask, gateway, ports, packets, reserved address ranges for local use (including local loopback IP)
  • Understand IPv6
    • Subnetting, IPconfig, why use IPv6, addressing, ipv4toipv6 tunneling protocols to ensure backward compatibility, dual IP stack, subnetmask, gateway, ports, packets, reserved address ranges for local use (including local loopback IP)
  • Understand names resolution
    • DNS, Windows Internet Name Service (WINS), steps in the name resolution process
  • Understand networking services
    • Dynamic Host Configuration Protocol (DHCP), remote access
  • Understand TCP/IP
    • Tools (such as ping), tracert, pathping, Telnet, IPconfig, netstat, reserved address ranges for local use (including local loopback IP), protocols

Catatan: untuk networking fundamentals  microsoft memberikan kita pengetahuan tambahan dengan memberikan informasi preparation resources  (persiapan sumber daya). Anda dapat melihat preparation resources  di-reference(s) yang ada  dibawah pada  poin ke-5.

 

Reference(s):

  1. http://www.certiport.com/Portal/desktopdefault.aspx?page=common/pagelibrary/MTA_overview.html
  2. http://www.certiport.com/Portal/desktopdefault.aspx?page=common/pagelibrary/MTA_certification-exams.html#Database
  3. https://www.microsoft.com/en-us/learning/mta-certification.aspx
  4. https://www.microsoft.com/en-us/learning/exam-98-364.aspx
  5. https://www.microsoft.com/en-us/learning/exam-98-366.aspx
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInPrint this pageEmail this to someone