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 Intro to Data Analysis!
You have completed Intro to Data Analysis!
Preview
Learn what a SQL is and how it is used to interact with a database.
- SQL vs. NoSQL
- SQL Basics - If you’re in a track or Techdegree, this SQL course may come later. You’re more than welcome to jump into SQL now if you’re interested in the topic, but we suggest following the order of your track or Techdegree.
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
Working with data means that
you'll often work with databases.
0:00
Databases store information and
0:05
are usually the more reliable and
recent form of data, a company has,
0:07
compared to a spreadsheet.
0:12
For projects, you may only need to access
your company's database, but in others,
0:14
you may need to access various databases
to gather the information you need.
0:20
Databases come in two main forms,
relational and non-relational.
0:26
Relational databases or SQL databases
are similar to a spreadsheet.
0:33
They hold data in fixed columns and rows.
0:38
Non-relational databases
also called no-SQL
0:41
databases are less rigid and
allow for more flexibility.
0:46
They don't use tables, rows or columns.
0:51
Between the two, SQL
databases are more common.
0:55
Check out the Teacher's Notes if you
wanna dig into this a bit more.
0:59
In order to access and dig around in a SQL
database, you will need to use SQL or
1:03
Structured Query Language. SQL
is a way to organize your data
1:09
searches, or queries, to find
the information you're looking for.
1:14
Let's take a quick peek at
what this will look like.
1:20
Don't worry about needing to
understand SQL right now.
1:23
This is just a quick preview.
1:27
Here's a small database of books, I want
to return the information about each book.
1:30
To perform that task I need
to write a SQL statement.
1:37
When writing a SQL statement,
you always start with the keyword SELECT,
1:41
and then the columns you want to grab,
1:47
which is all of them right now
using a star asterisk, and
1:49
then the keyword FROM, and the table
where it will grab the information.
1:53
Finally, you end a statement with
a semicolon, which is like a period.
2:01
It ends the statement.
2:06
When it's run, I get back all
the information in the books table.
2:08
These statements can be customized to
grab whatever data you need, like just
2:15
the authors or
2:20
books written after 1999.
2:27
Companies with large data sets may even
hold their data in data warehouses
2:45
where you would pull the information
you need from multiple tables.
2:50
This was just a quick look
into databases in SQL.
2:56
Don't forget to check the Teacher's Notes
if you want to dive a bit deeper already.
3:00
Knowing how to access a database and
run queries with SQL
3:06
is another skill that will help you on
your path to becoming a data analyst.
3:11
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