Тёмный

Data Analyst Project: Step-by-Step Analysis with SQL 

Database Star
Подписаться 56 тыс.
Просмотров 2,8 тыс.
50% 1

📝 Get this Data Analysis Project Guide: www.databasestar.com/project-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
If you want to improve your SQL, you'll need to practice your skills.
A great way to do this is to download a sample data set and run some SQL on it.
In this video, you will learn how to:
- download a sample CSV data set
- import this CSV into a database
- adjust the table to resolve some issues we find
- answer a range of questions we have about the data
⏱ TIMESTAMPS:
00:00 - Our project
00:37 - Download and import the data
05:17 - Initial analysis
12:46 - Question 1
14:24 - Question 2
21:45 - Question 3
22:46 - Question 4
26:17 - Question 5
27:18 - Question 6
29:20 - Question 7
30:30 - Question 8
🔗 VIDEO LINKS:
Script for Alter Table: github.com/bbrumm/databasesta...

Наука

Опубликовано:

 

23 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 10   
@PaulRhee-gp8zu
@PaulRhee-gp8zu 2 месяца назад
The projects are so great to put the information together and so much more fun. Thanks!!!
@DatabaseStar
@DatabaseStar 2 месяца назад
That’s great to hear! Glad you like the video and the project.
@BlackSwan912
@BlackSwan912 Месяц назад
Your trainings are always spot on.
@DatabaseStar
@DatabaseStar Месяц назад
Thanks!
@Danishkhan-rh2nf
@Danishkhan-rh2nf 2 месяца назад
Hello sir How to download and install oracle on MacBook m3
@DatabaseStar
@DatabaseStar 2 месяца назад
Hi, I have a video coming out later this week on this very topic :)
@mrbartuss1
@mrbartuss1 2 месяца назад
@@DatabaseStar Thank you very much! Could you please do that also for PostgreSQL, MySQL and MS SQL Server?
@DatabaseStar
@DatabaseStar 2 месяца назад
Sure - MySQL and Postgres can be installed natively or using Docker, and SQL Server can only be installed using Docker. I have videos for all of these on my channel already.
@maxyudin
@maxyudin 2 месяца назад
Thanks for the detalization. but Import, not impOrt.
@DatabaseStar
@DatabaseStar 2 месяца назад
Thanks! Yeah the emphasis is on the first syllable.
Далее
How to Design a Database
10:57
Просмотров 50 тыс.
SQL Data Analyst Project: Car Sales Data
34:28
Просмотров 1,7 тыс.
Stop Complex SQL Date Logic and Use This Instead
13:32
`const` was a mistake
31:50
Просмотров 131 тыс.
The unfair way I got good at Data Analysis
15:16
Просмотров 10 тыс.
Movie Theatre Database Design: Step-by-Step
27:50
Просмотров 2,2 тыс.