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
[edit | edit source]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.
- Read Relational Database Components.
- Read Tables.
Activity 2 - Understand Relational Database Concepts
[edit | edit source]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.
- Read Relational Database Components.
- Read Designing Relational Database Tables.
- Read Relational Database Engine Architecture Overview.
Activity 3 - Understand Data Manipulation Language (DML)
[edit | edit source]This objective may include but is not limited to: understanding what DML is and its role in databases.
- Read Wikipedia: Data manipulation language.
- Read DML Triggers.
- Read Performing Basic Insert, Update, Delete, and Select Operations.
Activity 4 - Understand Data Definition Language (DDL)
[edit | edit source]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.
- Read Wikipedia: Data definition language.
- Read DDL Triggers.
- Read How to use common Data Definition Language (DDL) SQL statements.