SQL - Introduction to Querying Databases

Jon Avis, Application Support Analyst

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

      1:04
    • What is a Database

      1:38
    • What is SQL

      1:01
    • How to Install PostgreSQL

      2:24
    • PostgreSQL Setup

      6:01
    • The Select Statement

      3:22
    • Select Where

      5:30
    • In Not In

      5:36
    • Between

      3:36
    • Like

      5:11
    • Order By

      5:58
    • Limit

      3:15
    • Alias

      4:30
    • Project

      1:08

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.

24

Students

1

Project

Jon Avis

Application Support Analyst

My name is Jon. I am from the UK and currently work in Hong Kong as an application support analyst for an investment bank. I have over three years experience as a support analyst. This has allowed me to become an expert on SQL and Unix systems.

In my spare time I enjoy hiking, cycling, photography and traveling.

See full profile