Courses Images


Candidates for this exam are seeking to prove introductory knowledge of and skills with databases, including relational databases such as Microsoft SQL Server or Windows Azure SQL Database. It is recommended that candidates be familiar with the concepts of and have hands-on experience with the technologies described here either by taking relevant training courses or by working with tutorials and samples available on MSDN and in Microsoft Visual Studio. Although minimal hands-on experience with the technologies is recommended, job experience is not assumed for these exams.Candidates for this exam are in the process of expanding their knowledge and skills in the following areas:  core database concepts • relational database concepts • security requirements for databases and the data stored in them • database objects, such as tables and views • graphical tools and T-SQL scripts • database queries • stored procedures


Understanding Core Database Concepts

Understand how data is stored in tables
Understand relational database concepts
(Understand data manipulation language (DML
(Understand data definition language (DDL

Choose Data Types
Understand Tables and How to Create Them
Create Views
Create Stored Procedures and Functions

Select Data
Insert Data
Update Data
Delete Data

Understand Normalization.
Understand primary, foreign, and composite keys.
Understand Indexes.


Understand Database Security Concepts.
Understand Database Backups and Restore.