Data Scientist - SQL for data Analysis 101.1 | Basics Data Extraction and Aggregation

4.0 (3)

32 learners

What you'll learn

This course includes

51.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

data analysis sql sql 101 sql interview questions and answers basic sql basic sql for data analysis sql for data science sql queries example google bigquery GCP BigQuery data analysis interview

Full Transcript

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

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

30-Day Beginner Guitar Challenge for New Players

Master the Guitar in 30 Days: Your Ultimate Beginner Challenge! Unleash your inner guitarist with step-by-step lessons designed to transform you from novice to confident player. Join Your Guitar Academy and kickstart your musical journey today!

⭐ 4.3

36 ratings

7 hours