Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Creating and Modifying Database Tables!
You have completed Creating and Modifying Database Tables!
Preview
In this video we'll learn about the CREATE statement as well as shine some light on how datatypes are used in SQLite.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
In this course, we will be using SQLite.
0:00
But SQLite isn't the only
implementation of SQL.
0:00
So if you find yourself using
a different version of SQL,
0:03
just know that things might
look a little different.
0:06
Okay, let's get back to
creating those tables and
0:09
learning about data definition language.
0:12
The first DDL statement we need to
know about is the create statement,
0:14
which is used to create tables.
0:18
If you'd like to follow along,
go ahead and
0:21
click Launch SQL Playground
in the bottom right.
0:23
Let's start by first getting
rid of this comment and
0:27
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up