In this challenge lab, you will create and access multiple tables by using Transact-SQL (T-SQL). First, you will launch Microsoft SQL Server Management Studio (SSMS), and then you will create tables by using Data Definition Language (DDL). Next, you will access the tables by using Data Manipulation Language (DML). Finally, you will create primary and foreign keys. Note: Once you begin the challenge lab, you will not be able to pause, save, or exit and then return to your challenge lab. Please ensure that you have set aside enough time to complete the challenge lab before you start.
Learning Objectives
In this challenge lab, you will create and access multiple tables by using Transact-SQL (T-SQL). First, you will launch Microsoft SQL Server Management Studio (SSMS), and then you will create tables by using Data Definition Language (DDL). Next, you will access the tables by using Data Manipulation Language (DML). Finally, you will create primary and foreign keys. Note: Once you begin the challenge lab, you will not be able to pause, save, or exit and then return to your challenge lab. Please ensure that you have set aside enough time to complete the challenge lab before you start.