SQL Tutorial for Beginners

Показать описание

In this tutorial, you'll learn how to use SQL using mySQL.

📌 What you’ll learn:
How to upload files into MySQL
How to use the SELECT statement
Filtering results with WHERE
Combining conditions using AND and OR
Handling missing data with NULL and IS NULL
Searching with LIKE, % and _
Working with ranges
Using aggregate functions like AVG(), ROUND(), SUM(), MAX(), MIN(), COUNT(), and COUNT(DISTINCT)
Renaming columns for better readability

----------------------
Timestamps:
----------------------
00:00 Intro
00:52 Dataset used
01:17 Upload files into MySQL
03:22 SELECT statement
06:18 WHERE statement
08:25 AND, OR keywords
10:50 IS NULL
11:30 LIKE
15:58 Ranges
16:19 BETWEEN
18:08 ORDER BY
20:15 AVG, SUM, MAX, MIN
22:06 COUNT, COOUNT DISTINCT

----------------------
Social Media:
----------------------

#sql #sqltutorial #dataanalysis