StationX
Start free

Browse › Database Fundamentals with T-SQL

Can You Create and Manipulate Tables in a Database?

Expert

Part of Database Fundamentals with T-SQL Topic: Data Science

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this lab, you will create and manipulate tables by using Transact-SQL (T-SQL).

  1. Create database tables by using Data Definition Language (DDL)
  2. Create primary and foreign keys
  3. Manipulate rows in the tables by using Data Manipulation Language (DML)
  4. Create a view, Finally, you will create a stored procedure that uses an input parameter
  5. Extract data by using a MERGE statement

Note: Once you begin the lab, you will not be able to pause, save, or exit and then return to your lab. Please ensure that you have set aside enough time to complete the lab before you start.

  • ⏱ About 60 minutes