SQL FOR BEGINNERS. Everything you need to know in SQL for analytics (basic SQL queries)
127,453 views
About :
Start a career in analytics with a starting salary of 70,000 rubles: https://u.to/DeSnHA. Use the promo code NOUKASH10 to get a 10,000 ruble discount on the Data Analyst program and a free consultation on the profession! (Erid: Pb3XmBtzt8xovqdw5bXmaFhvJfCYkqK4jwspQJi) This is a video cheat sheet on SQL for beginners. I have collected all the SQL commands that a data analyst or product analyst should know and be able to use in their work. We will analyze how all the main SQL queries work: sql join, window functions in sql, select, order by, having, where, group by, count, nested queries and other sql functions. Subscribe: Telegram channel: https://t.me/noukashblog Channel chat for communication: https://t.me/noukash_it Intensive course on working abroad: https://noukash.com/intensive Other useful videos about SQL: How and where to learn SQL from scratch: • How and where to learn SQL for beginners? S... How SQL and Python are used in data analytics: • How SQL and PYTHON are used in data analytics... Analysis of SQL tasks from Silicon Valley: Part 1: • SQL. Solving TEST TASKS from AMAZO... Part 2: • Full analysis of SQL tasks from Silicon... Part 3: • Full analysis of SQL tasks from Silicon... Materials from the video: List of all aggregate functions in Postgre https://www.postgresql.org/docs/9.5/f... Examples of using WHERE IN: https://www.dofactory.com/sql/where-in Examples of using WHERE LIKE: https://www.w3schools.com/sql/sql_lik... Timestamps: 00:00 - Intro 00:22 - SELECT 01:01 - WHERE (IN) 02:46 - WHERE LIKE 03:57 - How to exclude NULL values? 04:26 - Advertisement. Data Analytics Course from Changellenge Education 06:33 - Aggregation Functions (COUNT, SUM, MIN, MAX, AVEREGE) 06:53 - GROUP BY 08:57 - HAVING 10:06 - SQL JOIN 12:48 - ORDER BY 13:41 - SQL Window Functions (LEAD, LAG, ROW NUMBER, RANK) 16:49 - Nested Queries _____________________ My name is Andrey - I work as a product analyst in a German IT startup and on this channel (Noukash) I talk about a career in IT and product analytics. There will be career analyses, training tips, stories and much more. Subscribe and leave comments) Sign up for my intensive course on finding a job abroad: https://noukash.com/ 🇺🇸 Learn English with a native speaker (with a $10 discount): https://www.italki.com/affshare?ref=a... Instagram*: / noukash Telegram: https://t.me/noukashblog Chat for communication: https://t.me/noukash_it *Meta is recognized as an extremist organization and is banned in Russia...
752,310 views 2 days ago
934,492 views 1 day ago
127,411 views 3 days ago
273,207 views 2 days ago
273,207 views 2 days ago
182,847 views 3 days ago
1,589,373 views 6 days ago
1,084,259 views 3 days ago
Google AdSense
336 x 280
336 x 280
Up Next
Александр Скрипченко
705,791 views
9 years ago
9 years ago
Автоэлектрика ВЧ
1,561,134 views
3 years ago
3 years ago
AkoevRB
28,700 views
5 years ago
5 years ago
avto 1000
310,901 views
3 years ago
3 years ago
BILPRIME / АВТОСЕРВИС марки ВОЛЬВО и GEELY
56,438 views
3 years ago
3 years ago
Авторемонт от Сани и Вани.
30,018 views
2 years ago
2 years ago
Александр Скрипченко
86,920 views
2 years ago
2 years ago
Ходос Авто
87,300 views
2 weeks ago
2 weeks ago
Viktor-Smirnov
62,513 views
3 years ago
3 years ago
ЛЁША МАСТЕР
51,733 views
4 years ago
4 years ago
Юрий и Лариса Ивановы LIVE
104,317 views
8 years ago
8 years ago
Автоелектрик Сергій Зайцев
125,870 views
6 years ago
6 years ago
Konstantin Zhegalin (RUS)
290,229 views
7 years ago
7 years ago
Zapolin Life
8,127 views
2 years ago
2 years ago
Гараж Автоэлектрика
819,267 views
3 years ago
3 years ago
Rauf.Mechanic
11,402 views
2 years ago
2 years ago
В гостях у моториста
4,677,145 views
2 years ago
2 years ago
Андрей Александрович Гараж-108
15,851 views
3 years ago
3 years ago
AUTODOK YUR_OK
28,537 views
2 years ago
2 years ago
Александр Байрамов
83,449 views
4 years ago
4 years ago
Большие Ямы
14,227 views
5 years ago
5 years ago
Google AdSense
336 x 280
336 x 280