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.

9 of 9 students recommendSee All

I have an awesome experience with this course....it's too user friendly
Good refresher type class for those who recently learned or have been doing SQL work. Keep up the great work!
Ron Kane

Hello!

166

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