FULL PRACTICAL SQL COURSE for Data Analysts 2024 - Нікіта Тимошенко [ Аналіз даних українською ] - World Latest Movie, Series, Videos and Trailers | fetery.com

FULL PRACTICAL SQL COURSE for Data Analysts 2024

118,295 views

Нікіта Тимошенко [ Аналіз даних українською ]

Published on Jan 5, 2024

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

vidoe Comments

Trend Videos

23:21

Han Hye-jin's Hongcheon Kimchi with Pungja x Um Ji-yoon❤️(I miss Na-rae..^^)｜Kimchi, boiled pork, ramen mukbang, Hongcheon villa, let's be my wife

한혜진 Han Hye Jin

393,212 views 1 day ago

23:38

Mysterious Soviet Taxi Driver and Extreme Road Trip - Tajikistan (2)

곽튜브

723,309 views 7 days ago

22:18

Noh Hong-chul goes to his older brother's house in Japan (glamping, sauna)

노홍철

419,754 views 1 day ago

29:11

Eat 11,111 calories of Pepero in one day!! (w. Baek & Ah Areum)

박씨집안

253,128 views 4 days ago

29:11

Eat 11,111 calories of Pepero in one day!! (w. Baek & Ah Areum)

박씨집안

253,128 views 4 days ago

3:13

[Steph] Choi Ho Jong · Eternal Nightmare Main Character Stage Choice by PUBLIC Mission Solo Cam Stage Voting

The CHOOM (더 춤)

570,094 views 3 days ago

7:12

[Park Soo-hong is happy] Caesarean section recovery Daily life of a postpartum caregiver Changes after giving birth Happiness given by a baby Newborn Beginning of parenting

박수홍 행복해다홍

307,510 views 21 hours ago

9:46

The suffocating college entrance exam results are announced on the day of the exam

빠더너스 BDNS

965,286 views 1 day ago

17:33

How long should we celebrate Kaya Rani's birthday week?

카야라니 [KaiaLani]

93,792 views 19 hours ago

26:41

Reasons for not getting married. No, I can't... No, I won't...

걍밍경

724,876 views 1 day ago

3:13

[Steph] Choi Ho Jong · Eternal Nightmare Main Character Stage Choice by PUBLIC Mission Solo Cam Stage Voting

The CHOOM (더 춤)

570,094 views 3 days ago

10:32

[Rising in popularity] The all-purpose 'ginger juice' is really easy! Don't miss out on fresh ginger✔️ these days and make it~ (+Hemma Hangju gift set)

땅끝마을 임선생

179,546 views 5 days ago

11:49

When I first visited my sister-in-law's newlywed home after she got married in Korea, there were so many new things that I was surprised by.

예나러브 [Jun & Yena]

397,839 views 3 days ago

26:30

🥬8-pack Kimchi🥬Lee Ha-yeon's 2024 Kimchi! All the secret ingredients of the master's kimchi are revealed!

김치쌤 이하연

141,912 views 3 days ago

13:14

Sister, would you really do a kimchi business with me? (with Yangnyeompak Park Junmyeon) [Eng sub]

덱스101

284,779 views 4 days ago

25:19

Every word she says makes me nervous. Joo Byung Jin's second blind date full of excitement~ #highlight #CanILoveNow EP.2

tvN STORY 티비엔 스토리

2,143,866 views 4 days ago

19:04

Mimi Minu's Super-fast Breakup Date Course! (w. Chaeyoung) Tertrip 3 EP.1

LG Uplus

583,965 views 1 day ago

26:41

Reasons for not getting married. No, I can't... No, I won't...

걍밍경

724,876 views 1 day ago

19:57

[VLOG] Tearful Taeyomine Dongdong's Birth Vlog 👼🏻

태요미네

1,206,609 views 1 day ago

14:54

Where will Son Heung-min go if he leaves Tottenham?

김진짜 Real KIM

744,204 views 1 day ago

32:13

Why does that person do that?

[하말넘많] heavytalker

753,833 views 8 days ago

4:30

[I Live Alone Pre-release] The King's Table in Front of Jeon Hyun-moo?! A Hearty Korean Birthday Table Prepared by Chef Jeong Ji-seon🎂, Broadcast on MBC 241115

나혼자산다 STUDIO

84,395 views 21 hours ago

16:46

Sold out in 10 minutes. Samsung Galaxy Z Fold SE... What are your thoughts after using it for a week?

ITSub잇섭

890,379 views 1 day ago

26:37

19 Hour Silk Road Taxi Journey - Tajikistan (1)

곽튜브

1,047,016 views 11 days ago

19:04

Mimi Minu's Super-fast Breakup Date Course! (w. Chaeyoung) Tertrip 3 EP.1

LG Uplus

583,965 views 1 day ago

3:12

JAESSBEE - 'All Now with You' @JAESSBEE 1st Fan Concert 20241115

MMTG 문명특급

312,773 views 16 hours ago

22:18

Noh Hong-chul goes to his older brother's house in Japan (glamping, sauna)

노홍철

419,754 views 1 day ago

16:46

Sold out in 10 minutes. Samsung Galaxy Z Fold SE... What are your thoughts after using it for a week?

ITSub잇섭

890,379 views 1 day ago

23:21

Han Hye-jin's Hongcheon Kimchi with Pungja x Um Ji-yoon❤️(I miss Na-rae..^^)｜Kimchi, boiled pork, ramen mukbang, Hongcheon villa, let's be my wife

한혜진 Han Hye Jin

393,212 views 1 day ago

11:49

When I first visited my sister-in-law's newlywed home after she got married in Korea, there were so many new things that I was surprised by.

예나러브 [Jun & Yena]

397,839 views 3 days ago

3:31

JAESSBEE - 'All Now with You' Official MV

MMTG 문명특급

1,592,226 views 5 days ago

54:46

Seoul Mukbang VLOG + One bite Hyeyoung 😋 Episode 3) Samgyeopsal + chicken feet + Mul Naengmyeon Life Kkwabarow + Cheese Bomb Nurungji Chicken + Yogurt World Buldak Bokkeummyeon Cheongwaok Ginger Bear Dore Dore Lotte Hotel X Bomnal Encollaboration 2 nights 3 days Seoul trip❤️MUKBANG

여수언니 정혜영 [Yeosu Unnie]

225,072 views 3 days ago

Google AdSense
336 x 280

Up Next

40:19

13 Pirekuas of the sons Of St. Peter of Ocumicho

Jesus Magana

8,685 views
3 years ago

28:00

Mix of Pirekuas to remember

Tsamé Sapichu

119,062 views
10 years ago

2:02:47

35 Pirekuas of group Andapiti conqueror of Ocumicho michoacan

Jesus Magana

119,965 views
3 years ago

1:22:26

JOAN SEBASTIAN and MARCO ANTONIO SOLIS 30 GREATEST HITS JOAN SEBASTIAN and SOLIS THEIR BEST

MM Instrumental

3,182,132 views
2 months ago

20:44

INTER PRETENDING TO BE BEAUTIFUL SKIN DUET THE BROTHERS LOPEZ

ORQUESTA SENTIMIENTO PUREPECHA

348 views
7 days ago

40:02

#Mix By Los Galleros De Nurio - Jucheeti Mintsitarhuri Irekaska (You Live In My Heart) FULL ALBUM

Dilan Alcantar

23,890 views
2 years ago

47:46

The Merry Men of Teran Pure Rancheras

CORRIDOS

27,060 views
1 year ago

44:31

Click Download to save Los Rayos Del Sol - Jacinto Rita mp3 youtube com

Kike Ruiz

91,581 views
6 years ago

1:18:31

The Goldfinches, Las Palomas Duet 20 Immortal Hits ~ Old Corridos and Rancheras 2024

Corridos Y Rancheras

3,945 views
16 hours ago

12:58

The Galleros of Nurio 3 pirekuas

Diego Tomas

86,612 views
7 years ago

54:09

The sparrow of Tarecuato Michoacán - hits #pirekuas #musicalmemories #tributes

El Gorrión de Tarecuato Mich.Pag. oficial

1,700 views
2 weeks ago

1:07:51

16 beautiful Pirekuas of musical mystery of Ocumicho michoacan

Jesus Magana

33,461 views
3 years ago

15:18

05 SUNRAY PIREKUAS OF ANGAHUAN MICH.

cristobal mateo ventura

42,896 views
4 years ago

1:31:42

VICENTE FERNANDEZ, ANTONIO AGUILAR, JOSE ALFREDO JIMENEZ, EZEQUIEL PEÑA ~ THE BEST RANCHERAS

Musica Mexicana Clásicos

19,329 views
18 hours ago

26:04

MIX OF SKINS

Nueva Cuponera En USA 🇺🇸

213,839 views
12 years ago

54:45

Trio Tradicion Serrana - This is how I Jalpan (Full Album)

Musica de Arranque (Suscribete)

28,292 views
6 years ago

29:12

Kenda Male Trinita Group Mix

Pirekuas Viejitas

16,749 views
3 years ago

37:53

TANIMU MINTZITEECHA - ALBUM: JUCHITI MINTSITA (2015)

PIREKUAS DE MI PUEBLO

29,146 views
8 years ago

42:32

BASIC FRENCH Learn French Verb Tenses Easy and Fast Course 1

Aprender francés con Judy

2,526 views
1 day ago

31:28

FRENCH CONVERSATION YOU WILL EASILY LEARN THE SKILL OF COMMUNICATING IN FRENCH COURSE 1

Aprender francés con Judy

10,194 views
1 month ago

58:33

FRENCH LANGUAGE LISTENING 150 CONVERSATIONAL PHRASES PHRASES FOR EVERY DAY

ФРАНЦУЗСКИЙ ЯЗЫК🗼С КРИСТИНОЙ ФРАНЦ

9,100 views
12 days ago

31:55

LEARN BASIC FRENCH FOR BEGINNERS MASTER EASY FRENCH CONVERSATION Course 54

Aprender francés con Judy

9,070 views
1 month ago

22:06

🇫🇷 The 80 most used verbs in French - Pronunciation and translation

Francés Método Fácil

1,739 views
1 month ago

25:53

50 (very) important phrases in French for beginners

Francés Con Olivier

1,248,447 views
3 years ago

23:00

FRENCH CONVERSATION LEARN THE SKILL OF COMMUNICATING IN FRENCH EASILY COURSE 2

Aprender francés con Judy

5,385 views
3 weeks ago

15:26

🇨🇵The basics of French in 15 minutes✅

Claudia En Francia

773,938 views
2 years ago

1:14:05

LEARN FRENCH EASY & FAST - 49-53 Your first step to learn French from scratch to advanced

Aprender italiano & inglés con Judy

5,801 views
2 months ago

1:28:18

📚If you MEMORIZE these PHRASES you will be able to SPEAK FRENCH EVERY DAY 🏅 Complete French Course ✔️

Hablo Francés | 'Aprende Francés Rápido y Fácil' |

2,007 views
11 days ago

56:07

150 EASY PHRASES IN FRENCH SO YOU CAN SPEAK WITHOUT FEAR Complete French Course

Cindy Go

227,205 views
3 years ago

30:01

FRENCH VOCABULARY N°10 LEARN FRENCH easily & quickly from scratch Form sentences in French

Aprender francés con Judy

31,790 views
7 months ago

44:48

FRENCH FROM SCRATCH 🇫🇷 IN A WEEK ALL 7 LESSONS COURSE A1 100 PHRASES BASED ON GRAMMAR FOR BEGINNERS

ФРАНЦУЗСКИЙ ЯЗЫК🗼С КРИСТИНОЙ ФРАНЦ

156,238 views
8 months ago

1:18:14

🧠 Memorize these 200 French phrases for conversation

Ernst's Language School

62,543 views
1 year ago

37:47

French by ear Everyday phrases in French Conversational practice in French 🇫🇷

Французский с нуля! Французский на слух!

7,470 views
4 days ago

1:06:33

Vocabulary review 6-8 Learn French easily & quickly from scratch Form sentences in French

Aprender francés con Judy

38,096 views
11 months ago

1:50:06

Basic French Conversation - Slow and Easy

Kendra's Language School

3,233,443 views
6 years ago

1:12:20

LEARN FRENCH EASY French vocabulary Your first step to learn French from scratch

Aprender italiano & inglés con Judy

14,427 views
5 months ago

Google AdSense
336 x 280