In this video, we will understand query performance.<br<br/>/>

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.

In this video, you will learn how to use other rows with Window functions.<br<br/>/>

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.

In this video, we will cover left, right, and outer joins.<br<br/>/>

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.

In this video, we will cover the logic statements.<br<br/>/>

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.

In this video, we will cover JPQL - using joins.
r/>
This clip is from the chapter "Queries with Entities using JPQL" of the series "Master Hibernate and JPA with Spring Boot in 100 Steps".In this section, the author discusses...

In this exercise video, we will work on data preparation so that we have clean data to work with.
<
br/>
This clip is from the chapter "Exercises" of the series "Job-Ready SQL in an Afternoon".In this section, we will work on...

In this video, we will cover date and time intervals.
<
br/>
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...

In this video, we will cover string replacements.
<
br/>
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...

In this video, we will cover unions.<br<br/>/>

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.

In this video, we will work on setting up a local PostgreSQL server for Windows systems.
<
br/>
This clip is from the chapter "Fundamentals and Setup" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover...

In this exercise video, we will find out if there are any customers who purchased a track more than once.
<
br/>
This clip is from the chapter "Exercises" of the series "Job-Ready SQL in an Afternoon".In this section, we will work...

In this exercise video, we will practice understanding a new database, as we may not always be the creator of the database.
<
br/>
This clip is from the chapter "Exercises" of the series "Job-Ready SQL in an Afternoon".In this...

In this video, we will cover subqueries.<br<br/>/>

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.

In this video, we will cover conditional filtering grouped comparisons.
<
br/>
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...

In this video, we will cover aggregation functions.
<
br/>
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...

In this video, we will cover filtering null values.<br<br/>/>

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.

In this video, we will cover inner joins.<br<br/>/>

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.

In this video, we will cover string subsets and concatenations.
<
br/>
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,...

In this video, we will cover joining conditionals.<br<br/>/>

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.

In this video, you will learn about data types and schemas.
<
br/>
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...

In this video, we will cover comments.<br<br/>/>

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.

In this video, we will cover negating conditionals.<br<br/>/>

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.

In this video, we will cover conditional filtering direct comparisons.
<
br/>
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...

In this video, you will learn how to create tables using query results.
<
br/>
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...