123ArticleOnline Logo
Welcome to 123ArticleOnline.com!

ALL >> Education >> View Article

Earning Recognition Through 98-364: Microsoft Database Fundamentals Exam

By Expert Author: Damian A. Kao

This certification validates that a candidate has essential knowledge needed to begin building a career using Microsoft technologies. It is suggested that candidates not only be familiar with the concepts of the technologies mentioned here but also have hands-on experience. This can be done either by taking appropriate training courses or by working with lectures.

Exam Outline:
This exam helps build an understanding of the following topics:
Module 1: Core Database Concepts:
 How data is stored in tables and links to the data that is stored in the database
 What a relational database concept is, why is there a requirement for relational database management systems (RDBMS), and how relations are established
 What is data manipulation language (DML) and its role in databases
 Understand the data definition language (DDL) and how T-SQL can be used to make database objects such as tables and views
Module 2: Creating Database Objects
 Understanding what data types are, what is their importance, and how they affect storage requirements
 Understand tables and how to create them
 Create views using the T-SQL or a graphical designer and understand when to use views
 Create stored procedures and functions by selecting, inserting, updating, or deleting data
Module 3: Manipulating Data
 Select data by utilizing the SELECT queries
 Understanding how data is inserted in a database
 Understanding how data is updated in a database and how to write the updated data to the database
 Deleting data from single or multiple tables
Module 4: Data Storage:
 What normalization is, the reasons for normalization, the five common levels of normalization, and how to normalize a database
 What primary, foreign, and composite keys are
 Understand clustered and non-clustered indexes and what their purpose in a database
Module 5: Administering a Database:
 Understand database security concepts and why it is required secure a database
 Knowledge of the various types of database backups, the importance of backups and how to restore a database
Recommended Prerequisite Skills and Knowledge
Microsoft learning recommends candidates to have hands-on experience with the product and use the following training resources, such as attending a 3 day course and doing practice tests. Job experience is not necessary for these exams.

Exam Information:
Candidates appearing for the exam through an academic institute can schedule their exams through Certiport.
Candidates that are not with any academic institute can schedule their exam through Prometric.

ExamCertify offers 15% discount for 98-364 and 74-344 and other IT Certifications material with instant download and 90 days free updates.

Total Views: 42Word Count: 398See All articles From Author

Education Articles

1. Aws-solution-architect-associate Exam Dumps /all Q&a – Amazondumps.us
Author: amazon dumps

2. Myob Assignment Help- Promising You To Successfully Complete Your Myob Assignments
Author: onlineassignmentexpertt

3. Five Reasons For Studying Ayurveda In India
Author: anil kumar

4. Tips To Prepare Well For Hotel Management Entrance Exam
Author: Mahender Rana

5. How To Cope With The Subject That You Hate The Most?
Author: Instant Essay Writing

6. The Education Conferences Australia
Author: stevewiliamcro

7. Makeup Artist As A Career And Scopes In India
Author: anil kumar

8. Sap Certified Development Specialist – Sap E_hanaaw142 Exam Material
Author: Robert hoover

9. The Essentials Of The Ideal Geometry Box
Author: Vijay Singh

10. Designing Hpe Backup Solutions Hpe0-j80 Exam Preparation
Author: James Stiles

11. Delta Storage And Backup Solutions Hpe0-j78 Exam Question
Author: James Stiles

12. Proliant Server Solutions Hp0-s45 Exam Question
Author: James Stiles

13. How Self-paced Learning Is Changing The Way “typical Learning” Works
Author: Multisoft Virtual Academy

14. Microsoft Project - Learn Effective Project Management Skills To Attain Career Growth!
Author: Multisoft Virtual Academy

15. What All Matlab Online Training Offers And Should Anyone Learn It
Author: Multisoft Virtual Academy


Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: