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.
Curated Video
Job-Ready SQL in an Afternoon - Running an SQL Script
In this video, you will learn how to run an SQL script. 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 - Inserting Values
In this video, you will learn how to insert values. 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 - 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 - Creating Tables
In this video, you will learn how to create 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 - SQL Editor CLI (Command Line Interface)
In this video, we will explore SQL Editor CLI (Command Line Interface). 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...
Curated Video
Job-Ready SQL in an Afternoon - SQL Editor DataGrip
In this video, we will explore SQL Editor DataGrip. 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 environment.
Curated Video
Job-Ready SQL in an Afternoon - [Mac] SQL Editor Postico
In this video, we will cover SQL Editor Postico for Mac. 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
Snowflake - Build and Architect Data Pipelines Using AWS - What Is Pushdown in UDF?
This video explains Pushdown in UDF. This clip is from the chapter "Snowflake – User-Defined Functions" of the series "Snowflake - Build and Architect Data Pipelines Using AWS".This section focuses on user-defined functions in Snowflake.
Curated Video
Snowflake - Build and Architect Data Pipelines Using AWS - What Is Data-Warehouse?
This video talks about the Data-Warehouse. This clip is from the chapter "Introduction to Snowflake and AWS" of the series "Snowflake - Build and Architect Data Pipelines Using AWS".This section focuses on the introduction to Snowflake...
Curated Video
Snowflake - Build and Architect Data Pipelines Using AWS - Two Aspects of a Data Ecosystem
This video demonstrates the two aspects of a data ecosystem. This clip is from the chapter "Introduction to Snowflake and AWS" of the series "Snowflake - Build and Architect Data Pipelines Using AWS".This section focuses on the...
Curated Video
Snowflake - Build and Architect Data Pipelines Using AWS - Streams - Data Retention and Staleness
This video explains about the data retention and staleness in streams. This clip is from the chapter "Snowflake – Streams and Change Data Capture" of the series "Snowflake - Build and Architect Data Pipelines Using AWS".This section...
Curated Video
Snowflake - Build and Architect Data Pipelines Using AWS - Snowflake Architecture
This video explains the Snowflake architecture. This clip is from the chapter "Introduction to Snowflake and AWS" of the series "Snowflake - Build and Architect Data Pipelines Using AWS".This section focuses on the introduction to...
Curated Video
Snowflake - Build and Architect Data Pipelines Using AWS - Snowflake - Virtual Warehouses
This video explains about virtual warehouses in Snowflake. This clip is from the chapter "Introduction to Snowflake and AWS" of the series "Snowflake - Build and Architect Data Pipelines Using AWS".This section focuses on the...