SQL for data Analysis 101.1 | Basics Data Extraction and Aggregation

Hey there! In this video, I'm going to start with the basics of SQL for Data Analytics.
You may be struggling now choosing between learning Python or R for your Data Science role, but there is a less fancy and less known, but definitely most commonly used programming language for data analysis - SQL.
For many roles, you will be required to know it and it pops up in a lot of tech interviews for Analytics.
It's step 0 in cleaning, extracting, and manipulating data, it can be very powerful and efficient, and a lot of DSes use it daily, sometimes more than any other programming language.

00:00 Intro
00:48 SQL interview questions?
01:39 The value of SQL in data analysis
03:11 Exercise explanation
08:46 Google BigQuery on GCP

[aninditamitra]

Hi Anastasia, This is brilliant! Could you please also make a video like how data analyst uses Python apart from SQL, Tableau in day to day work

[astronemir]

Have you thought of running a short boot camp or online skill boosting class in Sweden? Because you are a great lecturer, not wasting time on BS, speak clearly and simply, and you are really good at communicating information. This video was really valuable as a short refresher. Thanks for sharing!

[ibrahimbadr]

this is the beautifulest thing I've seen for a while

[rban]

this is so intersting to me as a software engineer who works a lot with databases but from a very different perspective. mostly i work on the IaaC stuff and backend to keep the databases up and running and i spent a lot of time working on designing the database schemas in SQL and deployment pipelines surrounding them and I thought I was pretty good at SQL but from watching your video I realize I am not so good at writing queries haha

[bonzolijo]

Hi, just found you channel, its great and at the moment underrated...

[anuprai]

I like the way you are sharing useful knowledge. I hope you will share some more videos like this.

[glstnlev]

Please keep doing videos like this! It’s priceless

[Huss]

Hi Anastasia, your videos are top notch 👌 Hoping that you will please do more if possible in the future 🙏

[digigoliath]

Nice! TQVM!! I am not new to SQL but you have a new subscriber!

[SuperBookMonkey]

Very useful! I look forward to more videos.

[mzhr]

Very soothing music in the background, it's a thumbs up for this video!!

[ashenwizardtx]

This is very helpful Anastasia. I genuinely appreciate your content.

[cristinaaguilar]

Wooow! I love your videos, I’m BI Developer and I want to be a Data Scientis 🤘🏻👩🏻‍💻

[medeirov]

This is a very nice video. Enjoyed the pacing of it and the "examples" of those basic notions. Great stuff!

[ronaldagamaescobedo]

I love the way you explain. Could you please make more videos like this maybe explaining how to get the new users?
Greetings from Perú 🇵🇪

[himanshumishra]

Great practical stuff that will help anyone who is preparing for an SQL related interview with real time basic as well as important queries for a product based organisation 👍.

[alfredopr]

Great video. Thank you so much for the dedication you put into each video. I am currently a student in Data Science and your videos are really helpful. Wish you the best.

[priyankjetani]

yes, this is very help full video... I am Data Science Student and also I have that type of quotation in my mind about SQL and Database. it's good for me.. thanks for making that type video... Great practical stuff.. thank to you.

[Nicephore]

Cool video, I like your way of breaking things down. I just hope you'll be able to do more in-depth tutorials soon.

[Avinashkumar-]

Nice and informative video and bring more stuff like this, I am preparing for Data Science, your this video of SQL helped me a lot today. Thank you! Stay safe!