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

Solidworks 2006 Fundamentals - FREE CATIA Solidworks Siemens NX

50 Pages · 2012 · 2.26 MB · English

Solid Features Surfaces Assembly Design 2D Drawing Design Table & Equation. Solidworks 2006 Fundamentals www.dicksonsham.com Sweep A. Swept Boss/Base

Aqa Exam Style Questions Answers Biology Chapter 13 PDF

4 Pages · 2016 · 22 KB ·

Aqa Exam Style Questions Answers Biology Chapter 13 - Are you looking Answers, Lab Development Of Human Fetus Answer, and many other in 

Accelerating Ceph Distributed Database Using ThunderX and CloudSpeed Ultra

18 Pages · 2017 · 607 KB · English

shipping ThunderX for two quarters and it meets Microsoft's OCP Project Olympus requirements for cloud data centers.2. SSDs now have orders of . replication) for its NoSQL-as-a-Service, with copies across multiple availability zones. Ceph Block Storage Architecture. Ceph12 is a distributed, 

Public Law 98-430 98th Congress An Act

5 Pages · 2011 · 749 KB · English

98th Congress An Act United States of America in Congress assembled, That this Act may be cited as the "Florida Wilderness Act of 1983". WILDERNESS DESIGNATION

How do I connect to a database with ASP.NET 2.0?

3 Pages · 2008 · 95 KB · English

Web Hosting, Free Web Site Builder & Domain Name, Web Hosting Ma http://kb.brinkster.com/Kb.asp?kb=112505 1 de 3 28/03/2008 07:16 a.m. About Us . Contact Us .

Enhancing Overlay Metrology Productivity and Stability Using an Off-line Recipe Database Manager

6 Pages · 2000 · 277 KB ·

tion tool without requiring a wafer, and be able to dis- by maximizing tool utilization and minimizing engineering resources make the best economic.

In-Database Raster Algebra and Image Processing: Parallel

6 Pages · 2012 · 1.44 MB · English

IN-DATABASE RASTER ANALYTICS: MAP ALGEBRA AND PARALLEL PROCESSING IN ORACLE SPATIAL GEORASTER Qingyun (Jeffrey) Xie*, Zhihai Zhang, Siva Ravada

Grade 9 Maths Exam Question Papers PDF

4 Pages · 2016 · 22 KB ·

Grade 9 Maths Exam Question Papers - Are you looking for ebook grade 9 Chemfiesta Answers, Anatomy Review Sheet Exercise Blood Answers,.

Fundamentals of Edible Oils Refining and Special Considerations in Oil

2 Pages · 2013 · 74 KB · English

Fundamentals of Edible Oils Refining and Special Considerations in Sunflower Oil Processing Thursday and Friday, 4–5 April 2013 · Ukrainian House · Kiev

Cross Country Exam Guide

30 Pages · 2015 · 321 KB ·

Proper preparation is the key to success at each of the levels of Nordic . PSIA-E. The minimum requirements are skiing at an intermediate level and LEVEL II EXAM: A two-day event which tests the ability to teach beginner and . Uphill diagonal, double pole with kick, skate turn, wedge christie, bas