Exam 98-364 MTA: Database Fundamentals

Exam 98-364 MTA: Database Fundamentals

3 Pages · 2014 · 106 KB · English

Exam 98-364 MTA: Database Fundamentals Exam Design The Basics This is a Microsoft Technology Associate (MTA) exam designed to assess candidates’ fundamental

Exam 98-364 MTA: Database Fundamentals free download

Exam%98(364%%Database%Administration%Fundamentals%!Target'Audience'Candidates!for!this!exam!are!seeking!to!prove!introductory!knowledge!of!and!skills!with!databases,!including!relational!databases!such!as!Microsoft!SQL!Server!or!Windows!Azure!SQL!Database.!It!is!recommended!that!candidates!be!familiar!with!the!concepts!of!and!have!handsEon!experience!with!the!technologies!described!here!either!by!taking!relevant!training!courses!or!by!working!with!tutorials!and!samples!available!on!MSDN!and!in!Microsoft!Visual!Studio.!Although!minimal!handsEon!experience!with!the!technologies!is!recommended,!job!experience!is!not!assumed!for!these!exams.!!Candidates!for!this!exam!are!in!the!process!of!expanding!their!knowledge!and!skills!in!the!following!areas:!? core!database!concepts!? relational!database!concepts!? security!requirements!for!databases!and!the!data!stored!in!them!? database!objects,!such!as!tables!and!views!!? graphical!tools!and!TESQL!scripts!? database!queries!? stored!procedures!Objective)Domain 1. Understanding Core Database Concepts 1.1. Understand!how!data!is!stored!in!tables.!This!objective!may!include!but!is!not!limited!to:!understanding!what!a!table!is!and!how!it!relates!to!the!data!that!will!be!stored!in!the!database;!columns/fields,!rows/records!!1.2. Understand!relational!database!concepts.!This!objective!may!include!but!is!not!limited!to:!understanding!what!a!relational!database!is,!the!need!for!relational!database!management!systems!(RDBMS),!and!how!relations!are!established!!1.3. Understand!data!manipulation!language!(DML).!This!objective!may!include!but!is!not!limited!to:!understanding!what!DML!is!and!its!role!in!databases! !1.4. Understand!data!definition!language!(DDL).!This!objective!may!include!but!is!not!limited!to:!understanding!how!TESQL!can!be!used!to!create!database!objects!such!as!tables!and!views!!2. Creating Database Objects 2.1. Choose!data!types.!This!objective!may!include!but!is!not!limited!to:!understanding!what!data!types!are,!why!they!are!important,!and!how!they!affect!storage!requirements!!2.2. Understand!tables!and!how!to!create!them.!This!objective!may!include!but!is!not!limited!to:!purpose!of!tables;!creating!tables!in!a!database!by!using!proper!ANSI!SQL!syntax!!!2.3. Create!views.!This!objective!may!include!but!is!not!limited!to:!understanding!when!to!use!views!and!how!to!create!a!view!by!using!TESQL!or!a!graphical!designer.!!2.4. Create!stored!procedures!and!functions.!This!objective!may!include!but!is!not!limited!to:!selecting,!inserting,!updating,!or!deleting!data!3. Manipulating Data 3.1. Select!data.!This!objective!may!include!but!is!not!limited!to:!utilizing!SELECT!queries!to!extract!data!from!one!table;!extracting!data!by!using!joins;!combining!result!sets!by!using!UNION!and!INTERSECT!!3.2. Insert!data.!This!objective!may!include!but!is!not!limited!to:!understanding!how!data!is!inserted!into!a!database;!how!to!use!INSERT!statements!!3.3. Update!data.!!This!objective!may!include!but!is!not!limited!to:!understanding!how!data!is!updated!in!a!database!and!how!to!write!the!update!data!to!the!database!by!using!the!appropriate!UPDATE!statements;!update!by!using!a!table!!3.4. Delete!data.!This!objective!may!include!but!is!not!limited!to:!deleting!data!from!single!or!multiple!tables;!ensuring!data!and!referential!integrity!by!using!transactions!! 4. Understanding Data Storage 4.1. Understand!normalization.!!!This!objective!may!include!but!is!not!limited!to:!understanding!the!reasons!for!normalization,!the!five!most!common!levels!of!normalization,!how!to!normalize!a!database!to!third!normal!form!!!4.2. Understand!primary,!foreign,!and!composite!keys.!!!This!objective!may!include!but!is!not!limited!to:!understanding!the!reason!for!keys!in!a!database,!choosing!appropriate!primary!keys,!selecting!appropriate!data!type!for!keys,!selecting!appropriate!fields!for!composite!keys,!understanding!the!relationship!between!foreign!and!primary!keys!!4.3. Understand!indexes.!This!objective!may!include!but!is!not!limited!to:!understanding!clustered!and!nonEclustered!indexes!and!their!purpose!in!a!database!5. Administering a Database 5.1. Understand!database!security!concepts.!This!objective!may!include!but!is!not!limited!to:!!understanding!the!need!to!secure!a!database,!what!objects!can!be!secured,!what!objects!should!be!secured,!user!accounts,!and!roles!!5.2. Understand!database!backups!and!restore.!This!objective!may!include!but!is!not!limited!to:!understanding!various!backup!types,!such!as!full!and!incremental,!importance!of!backups,!how!to!restore!a!database!!

------------- Read More -------------

Download exam-98-364-mta-database-fundamentals.pdf

Exam 98-364 MTA: Database Fundamentals related documents

Fundamentals of Thermodynamics and Applications

1 Pages · 2016 · 321 KB · English

engineering, chemistry and physics. ▷ Based on the successful German textbook Müller: Grundzüge der. Thermodynamik, 3rd edition engineering, chemistry, physics, and physical chemistry for years theory in the fields of engineering, physics, chemistry, physical chemistry, and materials science

MTA ProfessionAl DeveloPMenT - The Massachusetts Teachers Association

36 Pages · 2010 · 830 KB · English

• MTA will provide participants with a record of sessions attended. Professional License Renewal X X 27 Taking and reviewing practice reading test 2.

Fundamentals of Electrical Engineering

42 Pages · 2010 · 2.52 MB · English

Thales of Miletus(ca. 624–ca. 546 BC), a Greek, found that amber attracted different light electric displacement D coulomb per square metre C/m2

Geography June Exam Paper Grade 10 2013 PDF

4 Pages · 2016 · 22 KB · English

Geography June Exam Paper Grade 10 2013 - Are you looking for ebook geography . [PDF] Grammar Exercise Workbook Prentice Hall Answer Key.

Fundamentals of Database Systems

1201 Pages · 2010 · 5.72 MB · English

Senior Manufacturing Buyer: Alan Fischer. Senior Media Buyer: Fundamentals of database systems / Ramez Elmasri, Shamkant B. Navathe.—6th ed. p. cm. A solutions manual is available to qualified instructors. Visit Addison-.

STATE EXAM FOR NURSING HOME ADMINISTRATORS

109 Pages · 2010 · 309 KB · English

Nursing Home Administrators Board STATE EXAM FOR NURSING HOME ADMINISTRATORS The following are the regulations for Nursing Facilities in Oregon on which you will be

Fundamentals Of Physics 9th Edition Solution Manual Free PDF

4 Pages · 2016 · 22 KB · English

manual free PDF is available on our online library. With our online resources, you can find fundamentals of physics 9th edition solution manual free 

Database Architecture

26 Pages · 2003 · 302 KB · English

• Three-level Architecture – External, Conceptual and Internal view of DBMS structure A data definition language for creating entities and relationships

Autodesk Inventor 2009 Certification Exam Guide

10 Pages · 2008 · 261 KB · English

Inventor 2009 Certified Associate and Certified Professional exams. Get the training you need: While taking the exam, you may not use calculators, books,

Fundamentals Of Corporate Finance 8th Canadian Edition PDF

4 Pages · 2016 · 22 KB · English

Fundamentals Of Corporate Finance 8th Canadian Edition.pdf. Download [PDF] Fundamentals Of Engineering Economics 1st Solution Manual.