Understanding Core Database Concepts

Introduction

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

1. Relational Database Concepts
2. Working with Data Manipulation Statements
3. Working with Data Definition Language

Exercise 1 - Relational Database Concepts

In this exercise, you will learn the following in Microsoft SQL Server 2008 R2:

• Demonstrate how relations are established between tables

Exercise 2 - Working with Data Manipulation Statements

In this exercise, you will learn the following in Microsoft SQL Server 2008 R2:

• Demonstrate data manipulation statements (DML)

Exercise 3 - Working with Data Definition Language

In this exercise, you will learn the following in Microsoft SQL Server 2008 R2:

• Demonstrate data definition language [DDL]