Curated Video
Job-Ready SQL in an Afternoon - Inner Joins
In this video, we will cover inner joins. This clip is from the chapter "Joins, Unions, and Subqueries" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover joins, unions, and subqueries.
Curated Video
Job-Ready SQL in an Afternoon - String Subsets and Concatenations
In this video, we will cover string subsets and concatenations. This clip is from the chapter "Dates, Times, and Manipulating Data" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover dates, times, and...
Curated Video
Job-Ready SQL in an Afternoon - Joining Conditionals
In this video, we will cover joining conditionals. This clip is from the chapter "Conditionals and Arithmetic" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover conditionals and arithmetic.
Curated Video
Job-Ready SQL in an Afternoon - Comments
In this video, we will cover comments. This clip is from the chapter "Dates, Times, and Manipulating Data" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover dates, times, and manipulating data.
Curated Video
Job-Ready SQL in an Afternoon - Negating Conditionals
In this video, we will cover negating conditionals. This clip is from the chapter "Conditionals and Arithmetic" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover conditionals and arithmetic.
Curated Video
Job-Ready SQL in an Afternoon - Conditional Filtering Direct Comparisons
In this video, we will cover conditional filtering direct comparisons. This clip is from the chapter "Conditionals and Arithmetic" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover conditionals and arithmetic.
Curated Video
Job-Ready SQL in an Afternoon - Creating Tables Using Query Results
In this video, you will learn how to create tables using query results. This clip is from the chapter "Databases, Tables, and Basic Queries" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover databases, tables,...
Curated Video
Job-Ready SQL in an Afternoon - Enumerated Types
In this video, you will learn about Enumerated types. This clip is from the chapter "Databases, Tables, and Basic Queries" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover databases, tables, and basic queries.
Curated Video
Job-Ready SQL in an Afternoon - Creating Schemas
In this video, you will learn how to create schemas. This clip is from the chapter "Databases, Tables, and Basic Queries" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover databases, tables, and basic queries.
Curated Video
Job-Ready SQL in an Afternoon - Creating and Removing a Database
In this video, you will learn how to create and remove a database. This clip is from the chapter "Fundamentals and Setup" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover fundamentals and work on setting up...
Curated Video
Job-Ready SQL in an Afternoon - Data Types and Schemas
In this video, you will learn about data types and schemas. This clip is from the chapter "Fundamentals and Setup" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover fundamentals and work on setting up our...
Curated Video
Job-Ready SQL in an Afternoon - Altering Tables
In this video, you will learn how to alter tables. This clip is from the chapter "Databases, Tables, and Basic Queries" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover databases, tables, and basic queries.
Curated Video
Job-Ready SQL in an Afternoon - Grouping and Filtering Aggregations
In this video, you will learn how to group and filter aggregations. This clip is from the chapter "Dates, Times, and Manipulating Data" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover dates, times, and...
Curated Video
Job-Ready SQL in an Afternoon - Exercise 5
In this exercise video, we will find out how much people from each country spent on tracks in total. This clip is from the chapter "Exercises" of the series "Job-Ready SQL in an Afternoon".In this section, we will work on different...
Curated Video
Job-Ready SQL in an Afternoon - Window Functions and Aliases
In this video, we will cover Window functions and aliases. This clip is from the chapter "Window Functions" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover Window functions.
Curated Video
Job-Ready SQL in an Afternoon - CTEs
In this video, we will cover CTEs (Common Table Expressions). This clip is from the chapter "Joins, Unions, and Subqueries" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover joins, unions, and subqueries.
Curated Video
Job-Ready SQL in an Afternoon - Manipulating Strings
In this video, we will cover manipulating strings. This clip is from the chapter "Dates, Times, and Manipulating Data" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover dates, times, and manipulating data.
Curated Video
Job-Ready SQL in an Afternoon - Aliases and Ordering
In this video, you will learn about aliases and ordering. This clip is from the chapter "Databases, Tables, and Basic Queries" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover databases, tables, and basic...
Curated Video
Job-Ready SQL in an Afternoon - Intro to Relational Databases
In this video, we will have a quick introduction to Relational databases. This clip is from the chapter "Fundamentals and Setup" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover fundamentals and work on...
Curated Video
Job-Ready SQL in an Afternoon - Row Numbers and Ranks
In this video, we will cover row numbers and ranks. This clip is from the chapter "Window Functions" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover Window functions.
Curated Video
Job-Ready SQL in an Afternoon - String Positional Information
In this video, we will cover string positional information. This clip is from the chapter "Dates, Times, and Manipulating Data" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover dates, times, and manipulating...
Curated Video
Job-Ready SQL in an Afternoon - Datatype Conversions
In this video, we will cover datatype conversions. This clip is from the chapter "Conditionals and Arithmetic" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover conditionals and arithmetic.
Curated Video
Job-Ready SQL in an Afternoon - Creating New Columns and Arithmetic
In this video, you will learn how to create new columns and arithmetic. This clip is from the chapter "Conditionals and Arithmetic" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover conditionals and arithmetic.
Curated Video
Job-Ready SQL in an Afternoon - Reading Data
In this video, you will learn how to read data. This clip is from the chapter "Databases, Tables, and Basic Queries" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover databases, tables, and basic queries.