SQL for Data Analysis with Google BigQuery (2024)

Focused View

Caio Avelino

1:40:42

13 View

1. Introduction

1. Instructor Introduction.mp4

01:22

2. Course Dynamics.mp4

01:14

3. Modules.mp4

01:18

4. Tools, Tips, and Contact Information.mp4

02:00

2. Google BigQuery

1. Definition.mp4

02:34

2. Signing up for BigQuery.mp4

04:01

3. Platform Interface.mp4

06:32

4. Explanation of Some Tables Well Use.mp4

02:36

5. Table Upload Hands-On!.mp4

03:16

Files.zip

3. SQL Basics

1. Selection Commands and Operators (Theory).mp4

01:51

2. Selection Commands and Operators (Practical Class).mp4

03:53

3. Limit and Distinct (Practical Class).mp4

02:18

4. Operators Arithmetic, Logical, Comparison, is (Theory).mp4

01:44

5. Operators Arithmetic, Logical, Comparison, is (Practical Class).mp4

05:54

6. Aliases AS (Theory).mp4

01:15

7. Aliases AS (Practical Class).mp4

02:37

8. Restriction Commands WHERE (Theory).mp4

00:56

9. Restriction Commands WHERE (Practical Class).mp4

02:24

10. Conditional Commands IF, CASE, COALESCE (Theory).mp4

01:56

11. Conditional Commands IF, CASE, COALESCE (Practical Class).mp4

03:21

12. Grouping and Sorting Commands GROUP BY, ORDER BY (Theory).mp4

01:54

13. Grouping and Sorting Commands GROUP BY, ORDER BY (Practical Class).mp4

03:11

14. Aggregation Functions COUNT, MAX, MIN, SUM, AVG (Theory).mp4

01:27

15. Aggregation Functions I (Practical Class).mp4

03:59

16. Aggregation Functions II (Practical Class).mp4

03:25

17. Table Relationships Definition (Theory).mp4

01:55

18. Tables Summary and Upload.mp4

03:29

19. Table Relationships INNER JOIN (Theory).mp4

01:59

20. Table Relationships INNER JOIN (Practical Class).mp4

02:27

21. Table Relationships LEFT JOIN (Theory).mp4

02:47

22. Table Relationships LEFT JOIN (Practical Class).mp4

02:43

23. Table Relationships RIGHT JOIN (Theory).mp4

02:45

24. Table Relationships RIGHT JOIN (Practical Class).mp4

02:50

25. Table Relationships FULL JOIN (Theory).mp4

02:34

26. Table Relationships FULL JOIN (Practical Class).mp4

03:34

27. Exercises.mp4

06:41

Files.zip

Description

Learn the most important language for Data Science

What You'll Learn?

Learn DQL (a subset of SQL)
Learn to perform queries in a Relational Database
Learn how a query is structured
Learn, IN PRACTICE, the main Commands and Operators of the Data Query Language
Learn Aggregation Functions
Learn JOINS, with examples for each case
Create an account on BigQuery and run queries on databases with SQL

Who is this for?

Beginners and those curious about Business Intelligence

Data Science students who would like to learn SQL

Employees of a company, from any area, who would like to learn SQL for database queries

BI analysts interested in learning SQL to build custom analyses and dashboards, without the limitations of software that only allow drag and drop charts

Anyone, from any field, who wants to enter the Data World

Marketing professionals who would like to bring more analytical power

What You Need to Know?

You don't need to be from the exact sciences field to take this course

Willingness to learn new languages

Willpower

More details

Description
[100% UPDATED LESSONS IN 2024 WITH THE NEW BIGQUERY INTERFACE]

ABOUT THE COURSE

This is NOT just another complicated course with unclear explanations or impractical examples for the job market.

This course IS a simple way for you to learn SQL (more specifically DQL, Data Query Language).

You don't need to have experience in Data or exact sciences to follow the entire course, which was designed with simple didactics and progressive modules so you can advance with confidence! To help you progress throughout the course, the modules will have exercises and quizzes to reinforce your knowledge.

Start exploring the field of Business Intelligence and Data Science today with ease. Even if you're already in the field, this is your opportunity to improve your skills with a new language.

The job market increasingly demands that various professionals have knowledge in data analysis! Learn to extract information from different databases to relate and create strategic analyses. Be prepared to quickly learn, in another course, how to create complete and customized dashboards without the difficulties and limitations of other tools.

--

ABOUT THE INSTRUCTOR

My name is Caio Avelino, and the knowledge I'll share with you in this course was mainly acquired through my experience in the job market. I have been working in the fields of Business Intelligence, Data Science, and Artificial Intelligence for years and had the opportunity to develop my skills in various startups.

I guarantee that you will leave this course ready to query any Database, without difficulties. I will be online and always available to clarify doubts and enhance your professional experience with SQL learning.

See you soon!
Who this course is for:
Beginners and those curious about Business Intelligence
Data Science students who would like to learn SQL
Employees of a company, from any area, who would like to learn SQL for database queries
BI analysts interested in learning SQL to build custom analyses and dashboards, without the limitations of software that only allow drag and drop charts
Anyone, from any field, who wants to enter the Data World
Marketing professionals who would like to bring more analytical power

User Reviews

Rating

average 0

Total votes0

Focused display

Profissional criativo, inovador, empreendedor e inquieto. Head em diferentes startups com foco em Business Intelligence, Ciência de Dados e Inteligência Artificial e domínio das principais ferramentas, linguagens e processos dessas áreas.Formado em Engenharia Elétrica pela Unicamp e na Monash University-Melbourne/Austrália. Formado em Ciência de Dados pela Data Science Academy.Eu amo me desafiar e aprender todos os dias, sou um típico resolvedor de problemas. Nunca estive em um momento da minha carreira sem me aprofundar em cursos ou me dedicar a projetos e desafios.Hoje coordeno a área de Data Science em um e-commerce de Casa e Decoração.Tenho paixão por dados e extrair insights relevantes para um negócio alavancar com base em análises complexas, construção de dashboards, automatizações e criação de modelos de Machine Learning. Também gosto de participar de competições no Kaggle.Fiquem à vontade para mandar mensagens ou sugestões. Meu objetivo é tornar a vida do aluno interessado em BI, Data e AI mais fácil e produtiva!Caio Avelino

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.