SQL Episodes - Ruby on Rails Screencast Tutorials

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.

Filter By

All Episodes Free Episodes Pro Episodes

Sort By

Published Date Popularity

Categories

ActionCable ActionMailbox ActionText ActiveJob ActiveModel ActiveRecord ActiveStorage ActiveSupport Administration APIs Authentication Authorization Background Jobs Basics Caching Code Organization Code Review Comments Complete App Concerns Controllers Credentials CSS CSV Debugging Deployment Design Patterns Development Docker Emails Ember Errors File Uploading Fixtures Forms Frontend Gems Generators Geocoding Helpers Hotwire Internationalization iOS Javascript JavaScript Maps Messaging Metaprogramming Middleware Mobile Models Multitenancy Notifications OAuth Open Source Pagination Payments Performance Production Rack Rails 4.2 Rails 5.0 Rails 5.1 Rails 5.2 Rails 6 Rails 7 Rails 7.1 Rails 7.2 Rails 8 Rails Engines React Native Refactoring Routes Ruby Search Security Servers Sharing SQL Testing Timezones Turbo Turbolinks Upgrading Views VueJS Webhooks Webpacker