Overview

Introduction

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:

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.

Lab Duration

It will take approximately 30 minutes to complete this lab.

Exercise 1 - Relational Database Concepts

A relational database is a means of storing and accessing information through relationships between tables. In relational databases, you can retrieve data from more than one related table. You must enforce certain integrity rules in relational tables so that the data stored is accurate and always accessible. For this, all rows in a table must have a unique identifier, known as the primary key value. Any column that is defined as a primary key cannot be null.

Learning Outcomes

After completing this exercise, you will be able to:

  • Create a table and establish table relationships

Exercise 2 - Working with Data Manipulation Statements

You can use data manipulation statements (DML) to work with the data in the database tables. DML statements allow you to modify or retrieve data from the table. The commonly used DML statements include:

  • INSERT: This statement inserts new rows (data) into a table.
  • UPDATE: This statement modifies existing data in a table.
  • DELETE: This statement deletes data from a table.
  • SELECT: This statement retrieves data from a table.

Learning Outcomes

After completing this exercise, you will be able to:

  • Use Data manipulation statements

Exercise 3 - Working with Data Definition Language

You can use the data definition language (DDL) to define the structure of database objects. For example, you can use the DDL to create databases and tables in a database. Also, the DDL statements help you to alter and drop data structures. Commonly used DDL statements include:

  • CREATE: This statement helps you to create new objects. For example, you can use CREATE DATABASE to create a new database in a SQL Server instance.
  • ALTER: This statement helps you to modify the definition of an existing object. For example, you can use the ALTER DATABASE statement to alter the options of an existing database.
  • DROP: This statement helps you to remove existing objects. For example, you can use the DROP TABLE statement to remove a table from a database.

Learning Outcomes

After completing this exercise, you will be able to:

  • Use data definition language

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.