SQL for Beginners

Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system.

Start Series

16 Lessons | 2h 30m | Beginner

SQL Learning Path - Getting Setup

Apr 01, 2023

In this lesson, we look at the tools we will need to have installed so that we can start on our journey to learning SQL.

SQL Learning Path - Creating and Dropping Databases

Apr 01, 2023

In this lesson, we will learn how to create and drop databases with SQL commands.

10m

SQL Learning Path - Creating and Dropping Tables

Apr 01, 2023

In this lesson, we will learn how to create and drop tables in our database with SQL commands.

10m

SQL Learning Path - Insert Statement

Apr 01, 2023

In this lesson, we will look at how to insert data into our database table.

SQL Learning Path - Select Statement

Apr 01, 2023

In this lesson, we will look at how to select rows of data from our database tables.

17m

SQL Learning Path - Calculations with Columns

Apr 01, 2023

In this lesson, we will look at how to perform calculations on the data we retrieve from columns in our database tables.

SQL Learning Path - String Functions

Apr 01, 2023

In this lesson, we will look at how to manipulate string data returned from our queries.

10m

SQL Learning Path - Where Clause

Apr 01, 2023

In this lesson, we will look at how to filter the results from our database queries.

SQL Learning Path - Where Calculations

Apr 01, 2023

In this lesson, we will look at how to use calculations with the where clause to filter the results from our database queries.

12m

SQL Learning Path - Update Delete Statements

Apr 01, 2023

In this lesson, we will look at how to update the data and delete rows of data from our database tables.

SQL Learning Path - Primary Keys

Apr 01, 2023

In this lesson, we will look at how to setup auto-incrementing integers ids for our rows in our database tables.

18m

Sql Learning Path Foreign Keys

Apr 01, 2023

In this lesson, we will begin to explore how we can relate rows from one table to rows in another table by using foreign keys.

SQL Learning Path - Join Statements

Apr 01, 2023

In this lesson, we will look at using the foreign keys to join tables together to return results from both tables.

10m

SQL Learning Path - Group By Statement

Apr 01, 2023

In this lesson, we will look at how to group rows by a given column and then use aggregate functions to perform calculations on the results.

SQL Learning Path - Group By with Joins

Apr 01, 2023

In this lesson, we will look at how to use joins together with group by clauses to group by columns from other tables.

11m

SQL Learning Path - Having Statements

Apr 01, 2023

In this lesson, we will look at how to filter the groups resulting from writing group by clauses with the HAVING clause.

Next Series

Finished this series? Continue learning in the next series

For our very first Rails app, we're going to start very simple. We'll build a blog completely from scratch to learn routes, models, views, and controllers. Plus, we'll deploy our code to production, add migrations to improve our blog, and lastly we'll add rich text and file uploads with ActionText and ActiveStorage.

Your Teachers Chris Oliver

21 Lessons

5h 17m

Beginner

Start Series

Courses

Rails for Beginners

Advanced Ruby: Behind the Magic

Payments with Rails Master Class

Refactoring Rails

Apps

Hatchbox.io

Jumpstart Rails SaaS Template

Other

Remote Ruby Podcast

Rails Hackathon

Beginner Bounties

Ruby on Rails Job Board

SQL for Beginners

SQL Learning Path - Getting Setup

Apr 01, 2023

SQL Learning Path - Creating and Dropping Databases

Apr 01, 2023

SQL Learning Path - Creating and Dropping Tables

Apr 01, 2023

SQL Learning Path - Insert Statement

Apr 01, 2023

SQL Learning Path - Select Statement

Apr 01, 2023

SQL Learning Path - Calculations with Columns

Apr 01, 2023

SQL Learning Path - String Functions

Apr 01, 2023

SQL Learning Path - Where Clause

Apr 01, 2023

SQL Learning Path - Where Calculations

Apr 01, 2023

SQL Learning Path - Update Delete Statements

Apr 01, 2023

SQL Learning Path - Primary Keys

Apr 01, 2023

Sql Learning Path Foreign Keys

Apr 01, 2023

SQL Learning Path - Join Statements

Apr 01, 2023

SQL Learning Path - Group By Statement

Apr 01, 2023

SQL Learning Path - Group By with Joins

Apr 01, 2023

SQL Learning Path - Having Statements

Apr 01, 2023

Next Series

Build a Blog with Rails 7

Solutions

Support

Company

Legal