FULL PRACTICAL SQL COURSE for Data Analysts 2024

118,295 views

About :

???? If such materials are useful for you and you want to support my activity - use the buymeacoffee service: https://www.buymeacoffee.com/timoshtopn ---------- The course is focused on data analytics and does not require previous experience in programming. The necessary theoretical minimum for solving real problems from interviews and projects is covered. We write code and enjoy using the most popular data analyst tool - SQL!!! ???? GitHub (Code from the course and practical exercises for independent work): https://github.com/NickTimosh/sql_pra... ✉️ My contacts: [email protected] / nicktimosh Download ???? PostgreSQL: https://www.postgresql .org/download/ ????DBeaver with test database: • Installing DBeaver to work with all... ???? Data science salary data for analysis: https://www.kaggle.com/datasets/arnab... - --- Additional Materials ???? Rating of data skills and tools: https://datanerd.tech ???? A little about SQL: https://kiev.itstep.org/blog/where-sq... ???? Compact SQL reference: https ://learnsql.com/blog/sql-basics-... ???? W3school Ukrainian adaptation: https://w3schoolsua.github.io/sql/ind... ???? Cheatsheet tips from datacamp https://www.datacamp. com/cheat-sheet/... ---- Course Contents 00:00:00 Introduction 00:02:51 SQL and Databases 00:15:58 PostgreSQL and pgAdmin 00:18:25 Data Import for Work 00:27 :34 Data Types 00:34:39 First Code 00:44:48 SELECT Block 00:52:19 Practice Exercises 01:08:15 Data Filtering 01:18:07 Data Grouping 01:25:11 Practice - Nested Queries 01: 43:45 Data Exploration 01:52:32 Installing DBeaver 01:57:23 First Join 02:07:11 All Types of Joins 02:18:06 Union 02:24:36 Practice 02:30:36 Keys in the Data Model 02: 35:50 CTEs 02:42:36 Window Functions 03:16:31 Database Administration 03:22:01 Project Presentation on GitHub 03:25:17 Bonus: Overview of SQL Trainers

Trend Videos
8:43
7:20
1,619,894 views   9 days ago
10:00
Google AdSense
336 x 280
Up Next
8:02
Компания "Antidark"
112,420 views
2 years ago
7:38
Правильный выбор!
31,444 views
3 months ago
6:26
Компания "Antidark"
758,289 views
2 years ago
22:48
ДОРОЖНЫЙ КОНТРОЛЬ Вадим Серов
1,269,037 views
6 years ago
11:17
Автосвет от CarsLED
374,819 views
1 year ago
19:27
6:05
LEDUNION
63,017 views
1 month ago
18:47
AMD SOUND
31,566 views
1 year ago
26:37
Автодом и Дом на колесах 🚐
494,724 views
6 days ago
8:41
26:37
Автомастерская Авангард
90,825 views
3 years ago
4:40
Вместе к совершенству
40,298 views
4 years ago
30:37
48:29
30:18
6:12
Вместе к совершенству
26,748 views
1 year ago
5:54
6:39
Михаил Клочан
43,409 views
5 years ago
7:04
Легендарные автомобили
292,363 views
3 years ago
18:52
Андрей Александрович Гараж-108
253,006 views
3 years ago
Google AdSense
336 x 280

fetery.com. Copyright 2024