SQL Tutorial - Introduction to Querying Databases | Jon Avis | Skillshare

SQL Tutorial - Introduction to Querying Databases

Jon Avis, IT Systems Engineer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
14 Lessons (50m)
    • 1. Introduction

      1:04
    • 2. What is a Database

      1:38
    • 3. What is SQL

      1:01
    • 4. How to Install PostgreSQL

      2:24
    • 5. PostgreSQL Setup

      6:01
    • 6. The Select Statement

      3:22
    • 7. Select Where

      5:30
    • 8. In Not In

      5:36
    • 9. Between

      3:36
    • 10. Like

      5:11
    • 11. Order By

      5:58
    • 12. Limit

      3:15
    • 13. Alias

      4:30
    • 14. Project

      1:08
19 students are watching this class

About This Class

In this class you will learn the basics for how to query a database. You will learn how to:

  • Use the SELECT statement to return data from a table.
  • Filter your data selection using the WHERE clause.
  • Use the IN, LIKE and BETWEEN statements to filter your results in more detail. 
  • Order your results sets.
  • Limit the number of records returned from an SQL query.
  • Set column name aliases.

By the end of this class you will know everything you need to begin querying databases.