Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Mastering SQL with Google BigQuery for Beginners
Rating: 3.9 out of 5(5 ratings)
13 students
Created byBogdan Anghelus
Last updated 5/2024
English

What you'll learn

  • Master the fundamentals of SQL to extract meaningful insights from large datasets
  • Leverage BigQuery to scale data analysis efficiently.
  • Utilize basic and more complex SQL techniques to analyze and solve real-world problems
  • Create and optimize SQL queries to be cost effective and performant

Course content

7 sections • 79 lectures • 4h 50m total length

  • Course Introduction1:12

    General overview about the instructor and the course structure.

  • What is SQL and Why we use it?1:00

    Understand what SQL is and why it's so in demand

  • What is GCP and GBQ?1:51

    General overview of Google Cloud Platform  and Google BigQuery

  • GCP account set-up1:34

    Set-up a free GCP account

  • GCP UI: location of different elements4:03

    Learn how to navigate in the GCP console

  • Understanding BigQuery resource hierarchy0:47

    Get a sense of how the resource hierarchy looks like in GCP

  • Create a project, a dataset, a table and upload data12:08

    Apply the theory from the last lesson and create a new structure: project-dataset-table

  • Create a table from Cloud Storage5:37

    Upload a csv in Cloud Storage and create a table

  • Cost structure in BigQuery3:17

    Understand how the components of the BigQuery billing: compute and storage

Requirements

  • No prior experience is needed. You will learn everything in this course.

Description

Note: This course is indented to teach you the basics of SQL on a cloud environment - GCP BigQuery. Please review this course as you see fit, your feedback is invaluable and helps me keep my standards high.


Hey there, I’m Bogdan, your instructor, and I’ll be your guide in this amazing journey of understanding SQL and BigQuery.

Throughout my experience as a Data Analyst (working in industries like Fintech, Gambling and Wholesale), I've realized that SQL it's not just about querying data; it's about understanding and managing it efficiently.

My journey has been filled with learning, and now, I'm excited to share that knowledge with you.

Whether you're a beginner or you have some domain experience, this course will equip you with the knowledge and skills you need to succeed in the world of data.

In this course, we'll cover everything from the basics of SQL and BigQuery to a bit more advanced techniques for data analysis and manipulation; with a practical focus, trying to mimic real world situations that I, personally, have encountered.

More concrete, we will cover topics like:

  1. Selecting specific data from a table

  2. Filtering and sorting

  3. Aggregating data to summarize information

  4. Joining multiple tables

  5. Creating new tables and many more

By the end of this course, my hope is that you will learn to love SQL! See you at the next lecture!

Who this course is for:

  • Beginner data analysts who want to learn the fundamentals of SQL and BigQuery to start analyzing data and solving business problems.
  • Professionals from various industries who want to gain hands-on experience using SQL and BigQuery to improve their decision-making and data-driven problem-solving abilities.

Report abuse