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

NDG Linux Essentials LPIC-1 Exam Objectives Mapping

4 Pages · 2015 · 91 KB · English

103.3 Perform basic file management. 2.4 Creating, Moving and . 108.3 Mail Transfer Agent (MTA) basics Topic 109: Networking Fundamentals.

70-517 Exam name: Recertification for MCSD

231 Pages · 2015 · 8.04 MB · English

File Version: 13.0 http://www.gratisexam.com/. Exam code: 70-517. Exam name: Recertification for MCSD: SharePoint Applications. Version 13.0 .. Franchise employees use Microsoft Excel 2013 to create a list of pick-up and drop-off locations for each bicycle .. Use the Global parameter to dispose of.

MySQL Database Administrator - Dotloop

1 Pages · 2010 · 83 KB · English

DotLoop, LLC 4445 Lake Forest Drive • Suite 415 • Cincinnati, OH 45242 Phone (513)257-0550 • Fax (888) 641-4111 MySQL Database Administrator

DATABASE ADMINISTRATOR (DBA) - Kern Community College District

3 Pages · 2013 · 24 KB · English

KERN COMMUNITY COLLEGE DISTRICT Database Administrator I May 2013 Page 1 of 3 CLASS TITLE: DATABASE ADMINISTRATOR I . BASIC FUNCTION: Under the direction of the

Research Directions in Object-Oriented Database Systems

15 Pages · 1998 · 1.93 MB · English

ments, and object-oriented advanced human interface Object-Oriented Programming Systems, Languages, and Applications, San Diego, Calif., Sept. 1988.

HS Exam Schedule May 22 - 24, 2013 Final 8th-Grade Exam Schedule

1 Pages · 2013 · 52 KB · English

A. Wednesday, 5/22, 11:30 - 1:00 E. Friday, 5/24 11:30 - 1:00 Your test in CAPS, monitoring in lower case English 9 JH Alg. 8

Windows Embedded CE 6.0 MCTS Exam Preparation Kit

340 Pages · 2008 · 17.05 MB · Korean

Midterm Exam

9 Pages · 2001 · 241 KB · English

ENCE 302 – Probability and Statistics for Civil Engineers (7) Statistics is the probability of successful performance of an engineering system. It is the 

2013 Massachusetts Municipal Police Civil Service Entrance Exam

1 Pages · 2012 · 16 KB · English

Civil Service Entrance Exam Preparation City_____ZIP _____ Phone With Area Code upcoming in April or May of 2013

New Exam Dumps Pass MB6-702 Exam By Training PassLeader Free MB6-702 Braindump

2 Pages · 2016 · 42 KB · English

[New Exam Dumps Pass MB6-702 Exam By Training PassLeader Free MB6-702 dumps,MB6-702 pdf dumps,MB6-702 practice tests,Microsoft Dynamics AX 2012 R3 Financials Each correct answer presents a complete solution.