From the course: Microsoft SQL Server 2022 Essential Training

Unlock this course with a free trial

Join today to access over 24,100 courses taught by industry experts.

Solution: Create tables with T-SQL commands

Solution: Create tables with T-SQL commands - SQL Server Tutorial

From the course: Microsoft SQL Server 2022 Essential Training

Start my 1-month free trial Buy for my team

Solution: Create tables with T-SQL commands

“

(upbeat music) - [Instructor] In this challenge, we were tasked with creating a table to hold details about fitness classes for a local gym. We're given a list of requirements and we just need to make sure that the table that we create has columns that are appropriately structured for the given data that we want to insert into the table. Now, we're given this sample answer that has the insert statement down below, so we can see that it'll eventually add in three rows of information into the FitnessClassSchedule. And we just need to make a table that will accommodate all of this data. All right, let me come up here to line number three, and we'll get started with a CREATE TABLE statement, and the name of the table is going to be FitnessClassSchedule. Then we'll just open a parenthese, and I'll move that closing parenthese down. And I'm going to add my semicolon at the very end right now just for good measure so that I don't…

Contents