Overview

Introduction

The Create and Alter Tables (Complex Statements) 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:

  • Create Schema and Tables
  • Create Temporary Tables and Table Variables

Exercise 1 - Create Schema and Tables

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

  • Create a Database
  • Create a Schema
  • Create a table with a complex statement

Exercise 2 - Create Temporary Tables and Table Variables

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

  • Implement a local temporary table
  • Implement a global temporary table
  • Implement table variables

Comprehensive Learning

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