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)
|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.
|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|
|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|
|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.|
Mini Learning Map
Did you find this page helpful?
Yes! [+0] | No? [-0]