Working With Tables
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:
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.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.