Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Treehouse

SQL Basics Course (How To)

via Treehouse

Overview

In SQL Basics, we’ll take a look at what databases are and how you can retrieve information from them. Databases can store massive amounts of information to be retrieved at a later date. Databases act as the memory for dynamic web sites or mobile apps.

What you'll learn

  • Write SELECT statement to query data from a relational database
  • Select specific columns
  • Searching tables using `WHERE`
  • Filter by comparing values

Syllabus

Data, Databases and SQL

We'll take a look at databases, the types of structures inside them, what data is and what SQL is.

Chevron 6 steps
  • Why This Course?

    1:08

  • Data is Everywhere

    3:21

  • Talking to Databases with SQL

    2:40

  • Organizing Data with Databases

    2:58

  • Types of Data

    2:45

  • Data, Databases and SQL Review

    8 questions

Getting Data from a Database

Reading information is the most common operation performed on a database. Whether you're a Business Analyst, Web Developer or Mobile App developer reading from databases is a must-have skill.

Chevron 9 steps
  • Tools We'll be Using

    3:57

  • Your First SQL Statement

    4:01

  • Selecting All Information From a Table

    5 objectives

  • Retrieving Specific Columns of Information

    2:53

  • Retrieving Specific Columns of Information

    5 objectives

  • Categorizing Your Output with 'AS'

    4:33

  • Categorizing Your Output with 'AS'

    4 objectives

  • Review & Practice with SQL Playgrounds

    1:50

  • Getting Data From a Database Review

    8 questions

Finding the Data You Want

Getting all the information back at once isn't always what you want. Finding the desired information by writing specialized SQL queries is the way to do it.

Chevron 19 steps
  • Searching Tables with 'WHERE'

    7:27

  • Searching Tables with 'WHERE'

    3 objectives

  • Filtering by Comparing Values

    3:58

  • Filtering by Comparing Values

    3 objectives

  • Filtering on More than One Condition

    2:51

  • Filtering on More than One Condition

    2 objectives

  • Filtering by Dates

    2:30

  • Filtering by Dates

    1 objective

  • Searching Within a Set of Values

    2:35

  • Searching Within a Set of Values

    2 objectives

  • Searching Within a Range of Values

    2:57

  • Searching Within a Range of Values

    2 objectives

  • Finding Data that Matches a Pattern

    2:43

  • Finding Data that Matches a Pattern

    2 objectives

  • Filtering Out or Finding Missing Information

    1:58

  • Filtering Out or Finding Missing Information

    2 objectives

  • Review & Practice with SQL Playgrounds

    3:50

  • instruction

    Need SQL Practice?

  • Finding the Data You Want Review

    15 questions

Reviews

Start your review of SQL Basics Course (How To)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.