SQL - Introduction to Querying Databases | Jon Avis | Skillshare

SQL - Introduction to Querying Databases

Jon Avis, IT Systems Engineer

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
15 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.

223

Students

1

Project

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Jon Avis

IT Systems Engineer

My name is Jon. I am from the UK and currently work in Hong Kong as an IT Systems Engineer for an investment bank. I have over four years experience as an IT Systems Engineer. 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

Report class