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

From Wikiversity
Jump to navigation Jump to search

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]

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[edit]

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)[edit]

This objective may include but is not limited to: understanding what DML is and its role in databases.

  1. Read Wikipedia: Data manipulation language.
  2. Read DML Triggers.
  3. Read Performing Basic Insert, Update, Delete, and Select Operations.

Activity 4 - Understand Data Definition Language (DDL)[edit]

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 Wikipedia: Data definition language.
  2. Read DDL Triggers.
  3. Read How to use common Data Definition Language (DDL) SQL statements.

See Also[edit]

References[edit]