image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

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!

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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
8
1.1-Introduction
1.2-Setting up your Sandbox Account
1.3-EXERCISE - Sandbox Account
1.4-Add your first Dataset
1.5-EXERCISE - Your First Data Set
1.6-Explore Tables & Column Data Types
1.7-EXERCISE - Data Types
1.8-Exploring Tables
2-Retrieve the data you need with the SELECT Statement
6
2.1-SELECT with single & multiple columns
2.2-EXERCISE - Selecting Single & Multiple Columns
2.3-SELECT with EXCEPT
2.4-EXCERCISE - SELECT with EXCEPT
2.5-Query History & Saving Queries - Find your queries again
2.6-EXERCISE - Query History & Saving Queries
3-Filter the data you need with the WHERE Statement
24
3.1-WHERE statement with Integers
3.2-EXERCISE - Where statement with integers
3.3-ORDER BY to order your results
3.4-EXERCISE - ORDER BY
3.5-WHERE statement with Dates
3.6-EXERCISE - WHERE statement with Dates
3.7-WHERE statement with boolean values (True/False)
3.8-EXERCISE - WHERE with boolean values
3.9-AND - to combine your filters
3.10-EXERCISE - using AND
3.11-OR - to combine your filters
3.12-EXERCISE - OR
3.13-BETWEEN - to combine your filters
3.14-EXERCISE - BETWEEN
3.15-IN - to filter on multiple values
3.16-EXERCISE - IN
3.17-WHERE statement with strings (text)
3.18-EXERCISE - WHERE with text
3.19-LIKE - filter for strings
3.20-EXERCISE - LIKE
3.21-WHERE statement with strings - handling case sensitivity
3.22-NULL
3.23-NOT - filter
3.24-WHERE - Summary
4-Calculate more metrics with Aggregate Analytical Functions
5
4.1-COUNT() - to count number or rows or values
4.2-COUNT() with DISTINCT
4.3-SUM() AND AVG() - To calculate the sum and average
4.4-MIN() and MAX()
4.5-VAR() & STD_DEV()
5-GROUP BY
5
5.1-GROUP BY statement
5.2-GROUP BY & ORDER BY
5.3-GROUP BY multiple columns
5.4-GROUP BY & ORDER BY 1,2,3
5.5-HAVING & GROUP BY
6-JOIN tables together
3
6.1-JOINING tables
6.2-Aliasing Tables
6.3-LEFT JOIN
7-Create new Columns with Single Line Functions
2
7.1-IF() Function
7.2-CASE function
8-EXPORT your data
2
8.1-Exporting to Google Drive or .csv
8.2-Export to Google Data Studio