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!

Time of free websites that are supported by ads only is over, due to increasing use of ad blocking.

Our website would die probably within a year; as there is no point investing free time and later on own money in something that is doomed.

Our only hope to survive (without any ads) is to ask our visitors like yourself to support it by becoming a member.

We know it's only going to be a tiny % of visitors who will do that but we hope that will be enough to keep our website for free and within a year switch off all ads. (54% page ads are switched off already for visitors from low income countries and 15% video ads are switched off for everyone).

Become a regular supporter (with benefits)
or make a one-off donation

Visitor Voting

Do you find our website helpful?
Visitor Voting: Yes +73  |  No -1
Add comment (no email required).



Add Comment
No data was returned.