Core Database Concepts

The Core Database Concepts practice lab provides you with the instruction and server hardware to develop your hands-on skills in the defined topics. This module includes the following exercises:

Overview

Learning Outcomes:

In this module, you will complete the following exercises:

  • Exercise 1 - Relational Database Concepts

  • Exercise 2 - Working with Data Manipulation Statements

  • Exercise 3 - Working with Data Definition Language

After completing this lab, you will be able to:

  • Create a table and establish table relationships

  • Use data manipulation statements

  • Use data definition language

Exam Objectives:

The following exam objectives are covered in this module:

  • 5.1 Explain database concepts and the purpose of a database.

  • 5.3 Summarize methods used to interface with databases.

Courses