SQL & BigQuery Essentials in Less Than 2 Hours

Focused View

Pierre Sarkis

1:12:41

387 View

1. Introduction

1. Welcome to the course!.mp4

01:18

2. What you will learn in this course.mp4

01:03

3. What are your expecting out of this course.html

2. Introduction to BigQuery - Part I

1. Introduction to BigQuery.mp4

03:07

2. Set Up a BigQuery Account and Create a Project.mp4

01:25

3. Create a Project and Import Data from Google Sheets.mp4

06:28

4. Interact with Tables Naming, Saving Queries, Views, and Permissions.mp4

05:10

5. Understand Billing in BigQuery and Monitor Costs.mp4

02:24

6. Create a BigQuery Table Using Google Sheet.html

3. Introduction to SQL - Part I

1. Introduction to SQL.mp4

05:29

2. Create Your First SQL Query.html

3. Master Basic SQL Syntax.mp4

03:46

4. Dive into SQL Conditions.mp4

06:06

5. Exercice Leverage WHERE clause.html

6. Sort Data with ORDER BY.mp4

02:30

7. Exercise Leverage ORDER BY clause.html

8. Use Aggregate Functions and GROUP BY.mp4

05:25

9. Exercise Leverage Functions.html

4. Introduction to SQL - Part II

1. Introduction to SQL JOINS.mp4

04:13

2. LEFT JOIN Example.mp4

05:47

3. Exercise Create Second Table and Leverage LEFT JOIN.html

4. Explore Subqueries using WITH.mp4

04:38

5. Exercise Leverage SubQueries.html

6. Leverage ChatGPT as SQL Assistant.mp4

05:40

5. Introduction to SQL - Part II

1. Compare Query Versions.mp4

02:55

2. Schedule Queries.mp4

04:29

3. Exercise Schedule your First Query.html

6. Conclusion

1. Congrats and Thank you!.mp4

00:48

Description

Unlock the power of data analysis with a condensed introductory course to SQL & BigQuery

What You'll Learn?

Boost your analytical capabilities leveraging the power of SQL and a data warehouse
Understand the fundamentals of BigQuery and SQL in today's data-driven landscape
Master the process of creating projects, datasets, and importing data from Google Sheets into BigQuery
Learn how to schedule and automate queries in BigQuery for increased productivity
Comprehend SQL essentials such as syntax, SELECT statements, and the use of basic functions like DISTINCT and LIMIT
Practice SQL operations through exercises focused on WHERE clauses, logical operators, and conditional statements
Understand advanced SQL concepts like aggregate functions, GROUP BY clauses, and data summarization techniques for deeper analysis

Who is this for?

Data-savvy learners eager to up their analytical game in Google Workspace environment

Non-technical professionals seeking to stand out in their roles by acquiring advanced analytics skills

Entrepreneurs or freelancers wishing to autonomously automate data analysis

What You Need to Know?

You will need a Google Workspace account (Free)

More details

Description
Hello everyone ! I'm Pierre, a product manager and data analyst with a mission to make tech more accessible. Like many of you, I don't come from a technical background. I've had to upskill myself on various tools and techniques on my own and I've found these skills to be immensely useful in my career. That's why I've created this course focused on data analytics, specifically SQL and BigQuery.
In today's data-centric world, mastering SQL and data warehouses is essential for professionals across various industries. Surprisingly, these skills are highly approachable even for individuals without a technical background. This course is designed to demystify the fundamentals of SQL and BigQuery, empowering learners to harness the power of data analysis.

Throughout this course, learners embark on a journey to unlock the potential of data analysis. With an exploration of SQL essentials, participants grasp foundational concepts such as querying databases, manipulating data, and extracting valuable insights. Hands-on exercises and practical examples build confidence in executing SQL commands and navigating data warehouses.

This course also offers an introduction of BigQuery, Google's powerful cloud-based data warehouse. Participants learn to set up BigQuery accounts, create projects, import data, and interact with tables effectively. Understanding the billing structure and monitoring costs ensures efficient resource usage.

With Google Workspace and BigQuery being freely available, participants can seamlessly dive into SQL implementation without any upfront costs. This accessibility enables individuals to begin analyzing their own datasets immediately, without relying on external resources or incurring expenses.

By the course's conclusion, learners emerge equipped with the knowledge and skills needed to confidently embark on their data analysis journey. Whether entrepreneurs, freelancers, or aspiring data enthusiasts, this course offers a comprehensive foundation in SQL and BigQuery, enabling the leverage of data-driven insights for informed decision-making and professional advancement.
Who this course is for:
Data-savvy learners eager to up their analytical game in Google Workspace environment
Non-technical professionals seeking to stand out in their roles by acquiring advanced analytics skills
Entrepreneurs or freelancers wishing to autonomously automate data analysis

User Reviews

Rating

average 0

Total votes0

Focused display

Hi everyone!I'm a Data Product Manager who loves bringing ideas to life and discovering new tools along the way. My journey has taken me through big names like Amazon and countless personal projects.Despite my lack of technical background, I've always been drawn to the world of technological tools and data. Through trial and error, I've learned the ropes and experienced the power of technology firsthand. Beyond my professional journey, I find a great joy in sharing my knowledge as I aim to empower others, especially non-techies, to embrace tech products!As a big fan of the Pareto principle (80/20 rule), my goal is provide with as much knowledge as possible into the shortest time frame. Your time is precious, and I want to make sure to get you into action sooner rather than later. Ready to dive in?

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.