Exam 98-364: Database Fundamentals/Understanding Core Database Concepts

This lesson covers Understanding Core Database Concepts. It looks at data storage, relational database concepts, data manipulation language and data definition language.

Activity 1 - Understand How Data is Stored in Tables
This objective may include but is not limited to: understanding what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records.
 * 1) Read Relational Database Components.
 * 2) Read Tables.

Activity 2 - Understand Relational Database Concepts
This objective may include but is not limited to: understanding what a relational database is, the need for relational database management systems (RDBMS), and how relations are established.
 * 1) Read Relational Database Components.
 * 2) Read Designing Relational Database Tables.
 * 3) Read Relational Database Engine Architecture Overview.

Activity 3 - Understand Data Manipulation Language (DML)
This objective may include but is not limited to: understanding what DML is and its role in databases.
 * 1) Read  Data manipulation language.
 * 2) Read DML Triggers.
 * 3) Read Performing Basic Insert, Update, Delete, and Select Operations.

Activity 4 - Understand Data Definition Language (DDL)
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.
 * 1) Read  Data definition language.
 * 2) Read DDL Triggers.
 * 3) Read How to use common Data Definition Language (DDL) SQL statements.