SQL Tutorial for beginners | Part - 4 | SQL Queries

This tutorial video is Part -4 of the series on learning SQL from the basics to the intermediate level.

a) Download the file
b) Extract the folder
c) Follow the steps in the video to import the data into the workbench

In this part, we discuss SQL queries that are used to read the data from the SQL database. These include - SELECT, WHERE, HAVING, GROUP BY, ORDER BY, JOINS, ALIAS, LIMIT with OFFSET, AGG_FUNC and expressions in queries. Follow through to learn all the queries.

Timestamps:
0:00 Introduction
0:25 Setup
3:58 SELECT query
7:30 WHERE clause (basic operators)
9:10 WHERE clause (between & not between)
12:13 WHERE clause (in & not in)
13:50 WHERE clause (like & not like)
18:37 DISTINCT clause
19:30 ORDER BY clause
20:56 LIMIT with OFFSET clause
24:01 Aggregate Functions with GROUP BY clause
28:00 HAVING clause
29:47 Task-1
31:03 Task-2
33:32 Task-3
34:32 Task-4
36:35 JOINs
37:34 INNER JOIN
40:30 Task-5
44:30 RIGHT JOIN
45:57 LEFT JOIN (Task-6)
50:48 FULL JOIN/ UNION
53:20 Expressions in queries
54:52 ALIAS in SQL
57:00 Outro

[TheMLMine]

Here you can find the link to the SQL script that is used in the video.

[sushankkadayat]

Your content is really awesome, please share dataset link which is valid, I am not able to download and import provided data set link

[Dreamtiw]

Sir Can you help
How to solve intermediate level of sql query step by step ?

I know the basic and advance but still not able to solve it intermediate level of sql query please help if you can