"Using PHP with MySQL" was retired on March 1, 2017. You are now viewing the recommended replacement.

Library

SQL Basics

173-minute Databases Course

Start Course Play Watch trailer

About this Course

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

Teacher

  • Andrew Chalkley

    I'm an alien, I'm a legal alien, I'm an Englishman in Portland. All of my professional life I've worked with computers online. I'm a polyglot programmer and like using the right tools for the job. In my spare time I enjoy spending time with my family and when I get chance, sticking opponents in Halo 4.

Download videos

You need to sign up for Treehouse in order to download course videos.

Sign up