Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 2 hours on-demand video
  • 16 articles
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence Google BigQuery

Learn SQL for Data Analysis with Google Big Query

Learn SQL using Google's scalable analytics data warehouse. Super charge your data analysis skills with BigQuery
Rating: 4.2 out of 54.2 (762 ratings)
2,735 students
Created by Annabel Lyle
Last updated 9/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Use SQL for Data Analysis
  • Navigate the BigQuery User Interface & Key Features
  • Export Data in a range of formats
  • Range of SQL statement e.g SELECT, WHERE, ORDER BY, GROUP BY and more
  • Join multiple tables together with JOIN and LEFT JOIN
  • Range of SQL Analytics Functions e.g MIN(), MAX(), AVG(), SUM(), COUNT() and more
  • All hosted online. Access Google BigQuery with google account
Curated for the Udemy for Business collection

Requirements

  • No prior SQL or database knowledge required!

Description

Learn how to use SQL with BigQuery quickly and effectively with this course!

You'll learn how to read and write complex queries to a database using one of the most in demand skills and one of the most powerful databases: Google BigQuery.

In this course you will learn:

  • How to Navigate the BigQuery User Interface and its key features

  • How to write SQL syntax including a range of statements and functions to query your data sets.

  • Transferable SQL Skills that can be used with any SQL database (Whether you’ll be using Bigquery or another database such as MySQL or Postgresql)

  • How to export your data for a varied range of use cases after you have completed your analysis.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills and one of the most important skills as a Data Analyst.

Check out the free preview videos for more information!

Who this course is for:

  • Data Analysts

  • Data Scientists

  • Engineers

  • Anyone interested in learning more about SQL, BigQuery or data analysis

As a Data Scientist with over 6 years of experience in Data Analytics, I look forward to introducing you to the world of analytics and SQL with Google BigQuery.

Who this course is for:

  • Data Analysis
  • Data Scientist
  • Engineer
  • Anyone who wants to learn SQL or Data Analysis!

Course content

8 sections • 55 lectures • 2h 1m total length

  • Preview02:24
  • Preview03:40
  • EXERCISE - Sandbox Account
    00:25
  • Preview01:58
  • EXERCISE - Your First Data Set
    00:47
  • Explore Tables & Column Data Types
    06:02
  • EXERCISE - Data Types
    00:22
  • Exploring Tables
    03:41

  • SELECT with single & multiple columns
    04:57
  • EXERCISE - Selecting Single & Multiple Columns
    00:50
  • SELECT with EXCEPT
    01:43
  • EXCERCISE - SELECT with EXCEPT
    00:19
  • Query History & Saving Queries - Find your queries again
    02:55
  • EXERCISE - Query History & Saving Queries
    00:46

  • WHERE statement with Integers
    03:42
  • EXERCISE - Where statement with integers
    00:31
  • ORDER BY to order your results
    03:36
  • EXERCISE - ORDER BY
    00:30
  • WHERE statement with Dates
    02:32
  • EXERCISE - WHERE statement with Dates
    00:26
  • WHERE statement with boolean values (True/False)
    01:43
  • EXERCISE - WHERE with boolean values
    00:41
  • AND - to combine your filters
    02:49
  • EXERCISE - using AND
    00:11
  • OR - to combine your filters
    02:10
  • EXERCISE - OR
    00:19
  • BETWEEN - to combine your filters
    03:03
  • EXERCISE - BETWEEN
    00:23
  • Preview03:19
  • EXERCISE - IN
    00:20
  • WHERE statement with strings (text)
    04:02
  • EXERCISE - WHERE with text
    00:10
  • LIKE - filter for strings
    02:39
  • EXERCISE - LIKE
    00:21
  • WHERE statement with strings - handling case sensitivity
    02:02
  • NULL
    03:03
  • NOT - filter
    02:32
  • WHERE - Summary
    00:46

  • COUNT() - to count number or rows or values
    03:44
  • COUNT() with DISTINCT
    03:11
  • SUM() AND AVG() - To calculate the sum and average
    02:36
  • MIN() and MAX()
    03:50
  • VAR() & STD_DEV()
    01:45

  • GROUP BY statement
    03:32
  • GROUP BY & ORDER BY
    02:12
  • GROUP BY multiple columns
    03:20
  • GROUP BY & ORDER BY 1,2,3
    03:34
  • HAVING & GROUP BY
    02:44

  • JOINING tables
    04:03
  • Aliasing Tables
    01:54
  • LEFT JOIN
    02:30

  • IF() Function
    03:09
  • CASE function
    03:05

  • Exporting to Google Drive or .csv
    02:22
  • Export to Google Data Studio
    01:12

Instructor

Annabel Lyle
Data Analyst - Data Studio & Google Analytics
Annabel Lyle
  • 4.2 Instructor Rating
  • 1,988 Reviews
  • 8,111 Students
  • 4 Courses

My name is Annabel and I have over 5 years of experience as a Data Analyst within Marketing and Product Teams. I have also mentored and taught individuals  and teams how to get the most out of a range of data visualisation tools, to ensure they have the greatest impact. My expertise is in storytelling with data, data visualisation and data analysis. Key tools that I teach and work with include Data Studio, Google Analytics, Google Tag Manager and R Studio.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.