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
editThis 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.
- Read Relational Database Components.
- Read Tables.
Activity 2 - Understand Relational Database Concepts
editThis 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.
Activity 3 - Understand Data Manipulation Language (DML)
editThis objective may include but is not limited to: understanding what DML is and its role in databases.
Activity 4 - Understand Data Definition Language (DDL)
editThis objective may include but is not limited to: understanding how T-SQL can be used to create database objects such as tables and views.