123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Education >> View Article

Earning Recognition Through 98-364: Microsoft Database Fundamentals Exam

Profile Picture
By Author: Damian A. Kao
Total Articles: 112
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

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: 350Word Count: 399See All articles From Author

Add Comment

Education Articles

1. Achieving Cloud Security Mastery: Your Guide To Ccsp Certification Training
Author: Passyourcert

2. Crack The Assistant Public Prosecutor Exam: Latest Syllabus, Eligibility Rules & Guidance For Aspirants
Author: Tamilnadujudicialservice

3. How The New Age Criteria Will Roll Out In Delhi Schools
Author: ezykrsna

4. Azure Devops Training In Ameerpet | Azure Devops Course
Author: visualpath

5. Leading Dynamics Crm Online Training Institutes In Hyderabad
Author: krishna

6. Salesforce Data Cloud Training Chennai | Data Cloud Classes
Author: Visualpath

7. Snowflake Data Engineer Training | Engineer Online Training
Author: Visualpath

8. Top Azure Ai Training In Ameerpet | Azure Ai-102 Training
Author: gollakalyan

9. Top 5 Cbse Schools Near Me In Howrah — Compare Fees & Curriculum
Author: Siya

10. Mastering Global Data Protection: The Definitive Guide To Cipp Online Courses
Author: Passyourcert

11. A Guide On East London University For Kottayam Students
Author: Ritik Kumar

12. Jumpstart Your Healthcare Career With Cna Training At Panat
Author: Margaret Pearson

13. Master Material Management Concepts With Sap Mm Training In Hyderabad
Author: Vinitha

14. Affordable And Globally Recognized Medical Education For Indian Students
Author: Mbbs Blog

15. Mbbs In Nepal: Your Pathway To Global Medical Excellence Near Home
Author: Mbbs Blog

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