Working With Tables

Introduction

The Working with Tables 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:

Learning Outcomes

In this module, you will complete the following exercises:

• Exercise 1 - Storing Data in Tables
• Exercise 2 - Create Tables using Transact SQL and SQL Management Studio

After completing this lab, you will be able to:

• Create tables and store data

Exam Objectives

The following exam objective is covered in this lab:

• 1.1 Understand how data is stored in tables
• 1.4 Understand Data Definition Language

Lab Duration

It will take approximately 20 minutes to complete this lab.

Exercise 1 - Storing Data in Tables

A table is a collection of rows that have associated columns. In other words, a table stores the data you provide in rows and columns. You create a table by providing a name for the table and defining its column names and column data type. Each column then holds the respective data to be stored. Each row in a table contains each of the column’s data.

Learning Outcomes

After completing this exercise you will be able to:

• Create tables and store data

Exercise 2 - Create Tables using Transact SQL and SQL Management Studio

Data in a database are stored in tables. Hence, you need to first define the respective tables to store your data. For example, consider you need to store the details of company products. For this, you need to define a table with columns corresponding to the information to be stored.

A table definition contains the table name, column names, and column data types. Therefore, before creating a table, you must decide on the table name, the field names or column names and their data types to be included in the table definition. A column name should be unique to a specific table. However, the same column name can be used in different tables within the same database. You can also specify whether a specific column can contain null values or not in the table definition. If you do not specify NULL or NOT NULL constraint, the SQL Server 2016 default is NULL.