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 SQL Basics!
You have completed SQL Basics!
Preview
Databases allow users to store data in well defined sections. This keeps the data uniform. However, the SQL you write can show the data in different ways which is handy for reporting subsets of data.
Further Reading
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
how the data is organized
called the schema.
0:00
The schema establishes how
that data should be stored and
0:00
divided into different sections.
0:03
The schema further determines how each of
the sections relates to other sections.
0:05
These sections are called tables.
0:10
It's easy to picture a database
by thinking of the spreadsheet.
0:13
You know what spreadsheets look like
from programs such as Microsoft Excel,
0:17
Apple Numbers, and Google Sheets.
0:21
They look like a large grid
composed of columns and rows.
0:23
Rows from left to right horizontally, and
the columns run top to bottom, vertically.
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