Understanding Core Database Concepts
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.
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:
- Relational Database Concepts
- Working with Data Manipulation Statements
- 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]
See the full benefits of our immersive learning experience with interactive courses and guided career paths.