Understanding Core Database Concepts

Practice Labs Module
Time
50 minutes
Difficulty
Intermediate

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.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or
View all SSO options

Already have an account? Sign In »

Overview

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]
Learning Partner
Practice Labs

IT & Cybersecurity certification hands on practice labs and practice exams for certifications and skill development.

Comprehensive Learning

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

Courses