Welcome to our 98-364 database fundamentals Exam Guide. This is an Entry level exam and no prior knowledge is required, ideal for those who:
- Are new to SQL Server world.
- Would like to master the basics of SQL Server.
- Aim to get first certification in SQL Server.
- Would like increase their confidence and get a new job.
There are 5 sections that you should study (Microsoft page).
- Understanding Core Database Concepts (23 percent)
- Creating Database Objects (23 percent)
- Manipulating Data (26 percent)
- Understanding Data Storage (17 percent)
- Administering a Database (11 percent)
Below we provide learning plans in sequence we recommend to study it with links to other pages.
The first step is to gain good understanding of database concepts which can help you have strong foundations and make further learning easier. I recommend to start with the learning plan below.
It is not part of the exam to install SQL Server however from my experience it is highly benefitial to do it and it helps a lot when you apply for jobs or have to do real life work therefore we have included it. This learning plan also helps you set up Microsoft AdventureWorks Samples Databases.
It's time to learn the basics of T-SQL Querying using Microsoft AdventureWorks Sample Database.
We will insert here several more learning plans once we created them so next one is performance tuning.
Below are links to additional resources which are currently not part of a learning plan:
Data Manipulation Language - Find out what is DML used for and which SQL statements are part of DML.
Data Definition Language - foind out what is DDL used for and which SQL Statements are part of DDL.
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.
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.
SQL CREATE VIEW - Find out how to create a view using T-SQL or Graphical Designer
SQL Select - Learn basics of using SQL SELECT find examples how to retrieve data from one table.
SQL Join Example - We provide two simple examples of inner join and left outer join.
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.
SQL INSERT - Here we present the most basic example of SQL Insert statement
SQL UPDATE - In this article you will find out how to perform basic updates and see common challeanges with updates.
SQL DELETE - Find out how to delete data from single table.
Reasons for normalization- Find out three main reasons for normalization.
How to restore a database - Using SQL Server 2012 we show how to restore a database.
We are working on adding more content to exam guide.
Hope that helps
Katie & Emil