Katie and Emil exam guide to 98-364 database fundamentals

My Learning: Log in Learning Report [Log in]


Remove Ads or Log in
Remove Ads or Log in
+0  |  -0

Mini Learning Map

Welcome to Katie & Emil Exam Guide to 98-364 database fundamentals.

In this blog post you will find skills measured from Microsoft site and our exam guide that hopefully will help to learn more easily and pass the exam.

You will find many of these link on our SQL Tutorial page.

NOTE: Microsoft published a book that we recommend and you can buy it on amazon using this link Microsoft 98-364 Database Fundamentals

 

 

Understanding Core Database Concepts (23 percent)

understanding what a relational database is, the need for relational database management systems (RDBMS), and how relations are established

What is a database - This blog post gives high level, easy to understand introduction to database concepts including RDBMS and relations that are part of the requirements for the exam. 

understanding what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records What is a database table - Find out a simple explanation of a database table and one simple example of table with data.
This objective may include but is not limited to: understanding what DML is and its role in databases Data Manipulation Language - Find out what is DML used for and which SQL statements are part of DML.
This objective may include but is not limited to: understanding how T-SQL can be used to create database objects such as tables and views Data Definition Language - foind out what is DDL used for and which SQL Statements are part of DDL.

 

Creating Database Objects (23 percent)

understanding what data types are, why they are important, and how they affect storage requirements SQL Server 2012 Data Types - Data Type is a very important concept in SQL Server and we in this article you give you overview of data types and show key information related to them.

purpose of tables;

creating tables in a database by using proper ANSI SQL syntax

Purpose of tables - We briefly describe purpose of tables and this is not only to store data.

The second part creating table using proper ANSI SQL is a little bit confusing but I believe Microsoft just means how to use CREATE TABLE statement. 

SQL CREATE TABLE - Find out how to use CREATE TABLE. We start with very simple example and add extra options one step at a time.

understanding when to use views and how to create a view by using T-SQL or a graphical designer SQL CREATE VIEW - Find out how to create a view using T-SQL or Graphical Designer
selecting, inserting, updating, or deleting data

Not sure why Microsoft put this under "Creating Database Object". It is actually covered in next section "Manipulating Data".

 

Manipulating Data (26 percent)

Select data:
utilizing SELECT queries to extract data from one table; SQL Select - Learn basics of using SQL SELECT find examples how to retrieve data from one table.
extracting data by using joins;

SQL Join Example - We provide two simple examples of inner join and left outer join.

Later on we will put link with more info about joins.

combining result sets by using UNION and INTERSECT

SQL Union - Here you will found out how to combine two queries (returning the same fields)  into one query result.

SQL Except - If you have two queries returning the same fields and you want to return unique rows from first query but without the rows that exists in second query than EXCEPT can help. 

SQL Intersect - The last operator we will discuss is INTERSECT that returns rows that exists in both first and second query.


Insert data:
understanding how data is inserted into a database; Data is inserted into table using SQL INSERT statement. See below.
how to use INSERT statements SQL INSERT - Here we present the most basic example of SQL Insert statement

Update data:
understanding how data is updated in a database and how to write the updated data to the database by using the appropriate UPDATE statements; SQL UPDATE - In this article you will find out how to perform basic updates and see common challeanges with updates.
update by using a table  

Delete data:
deleting data from single or multiple tables; SQL DELETE - Find out how to delete data from single table.
ensuring data and referential integrity by using transactions  

 

Understanding Data Storage (17 percent)

understanding the reasons for normalization, the five most common levels of normalization, how to normalize a database to third normal form Reasons for normalization- Find out three main reasons for normalization.
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  
understanding clustered and non-clustered indexes and their purpose in a database  

 

Administering a Database (11 percent)

understanding the need to secure a database, what objects can be secured, what objects should be secured, user accounts, and roles  
understanding various backup types, such as full and incremental, importance of backups, how to restore a database How to restore a database - Using SQL Server 2012 we show how to restore a database.

 


Remove Ads or Log in

We need you!

By becoming a proud member we can:
  • Switch off annoying ads
  • Create more articles and videos
  • Develop more useful features supporting your learning
  • Provide FREE webinars (for members)
  • Feel our hard work since 2011 is appreciated
Become a proud member and get exclusive features.

If 2% of our 64,943 visitors (Last 30 days) become a proud member than we can quit our jobs and work full time on this website. We started membership in May 2014 and so far 0.07% of our visitors are members and we would like to say THANK YOU to those who become a proud member and support our efforts.

Thanks to members:
  • Education is for FREE and we create more FREE articles and videos
  • We provide new features (members) that can speed up learning.
  • 53% of our page views (82,000 each month) do not have page ads.
  • We switched video ads from 14% of our videos (50 out of 345).
We have invested 4 years of our time in this website and we estimate it will take about 5 years before we can quit our jobs and dedicate all our time to develop considerably our website which should help to truly achieve our vision of free education for everyone; all thanks to support of our members only. Become a proud member

Visitor Voting

Do you enjoy your job?
Visitor Voting: Yes +15  |  No -5
Add comment (no email required).



Add Comment
No data was returned.


Are you a member?

If yes than please log in

Learning Map is for members with Bronze, Silver and Gold Membership.
For more information visit membership options.


Close this window , log in or learn more about membership benefits
  Become a Proud Member