SQL functions, GROUP BY, ORDER BY, DISTINCT --- SQL for data science tutorial EP#2 (for beginners)

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

*****
IMPORTANT!!! I moved the datafile from the original server in the video, to a new one.
From now on, to copy the data into your table, you should use this code instead:
COPY flight_delays
DELIMITER ',' CSV HEADER;
*****

(I updated this in the codebase file, too, unfortunately can't update it in the video.)

In this episode, I’ll show you the most essential SQL functions that you will use for finding the maximums or the minimums (MAX, MIN) in a data set and to calculate aggregates (SUM, AVG, COUNT). Then I’ll show you some intermediate SQL clauses -- like GROUP BY for segmentations or ORDER BY for sorting values in an SQL table.

ARTICLE VERSION (RECOMMENDED):

00:00 Intro
02:03 Import a 7,000,000-row dataset into SQL
08:41 SQL functions
09:40 COUNT
11:48 SUM
13:04 AVG
14:50 MAX, MIN
16:07 GROUP BY (segmentation with SQL)
22:34 ORDER BY (sorting value with SQL)
26:21 DISTINCT (remove duplicates)
29:44 Conclusion

LINKS MENTIONED IN THE EPISODE:

NEXT EPISODE:

--------------------------------------------------------

Рекомендации по теме

Комментарии

I am learning a lot from you.... It is detailed and fast... so much better than other classes. Thank u very much!!

ameneh

Your videos are a HUGE inspiration!! just started out my own youtube (from my experience as a data analyst) All the best!

TobysDataDigest

🔥🔥🔥 That is so great! Thank you, Tomi)

АндрейБузько-си

The dataserver doesnt seem to be reachable anymore :(

brunokrok

IMPORTANT!!! I moved the datafile from the original server in the video, to a new one.
From now on, to copy the data into your table, you should use this code instead:
COPY flight_delays
DELIMITER ', ' CSV HEADER;

(I updated this in the codebase file, too, unfortunately can't update it in the video.)

datatomi

can anyone please let me know how to load exact data into MySQL?

krupalirao

SQL functions, GROUP BY, ORDER BY, DISTINCT --- SQL for data science tutorial EP#2 (for beginners)

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

SQL Group By: An Explanation and How To Use It

GROUP BY Clause (SQL) - Summarize Results into Groups

Lec-61: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System

Group, Sort und Aggregation in SQL - SQL 7

Learn SQL: Query 9: Functions COUNT() GROUP BY

Aggregate Functions, Group by Clause and Having Keyword in SQL ? | SQL Server Interview Questions

SQL | Windows Vs Aggregate Functions

Azure Database for MySQL - Monthly Webinar (Oct 2024)

Group by in sql server - Part 11

SQL Tutorial 7: Group By, Having & ,Order By Clauses in SQL

SQL Window Functions in 10 Minutes

group by clause in sql | Oracle Database

22 -GROUP BY Clause in SQL | Use Of GROUP BY | Interview Questions | Examples | Multiple Column| SQL

Group By And Having Clause In SQL | Group By Clause In SQL | SQL Tutorial For Beginners |Simplilearn

Lec-67: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS

Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Group By and Having Clause in SQL | SQL Tutorial in Hindi 9

SQL Window Functions Basics | Partition By, Order By, Frame | #SQL Course #3

Learn GROUP BY vs PARTITION BY in SQL

GROUP BY & HAVING CLAUSE IN SELECT COMMAMD || SQL COMMANDS || GROUP BY || HAVING || SQL || DBMS

#13 SQL GROUP BY & Having Clause in Telugu | SQL Full Course in Telugu| Group BY & Having Cl...

Intermediate SQL Tutorial | Partition By