Mô tả

'Using this Course, you will master Google BigQuery( BigQuery) and you can apply the SQL queries used in this course in any other Database management tool in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, and DB2'.

"Welcome to the most popular Quality complete Course on Google BigQuery(Big Query). This is a complete Google google bigquery training"

  • Master all the important concepts of Google BigQuery

  • Digital Marketers will be able to create their own analysis sheet

  • Students will be expert in arrays, UNNEST, STRUCT, CTE, Derived Tables, etc

  • Master all the concepts of SQL in BigQuery

  • Can write all the commands like Joins, Group by, Order By, Having clause, SubQueries, etc.

  • Create tables with partitioning

  • Can easily connect the Google BigQuery to Google Data Studio

  • Learning based on a real-time project helps students to apply the concepts in his job

  • Helps the students to be Job ready in Google BigQuery

  • Bigquery for Google Analytics

========================================================================

Join this course which is the best "Google BigQuery" course. I will share all the syntax of BigQuery SQL with multiple examples along the way!!!

Want to start learning SQL from scratch with no previous coding experience?

You have come to the right place. Please have a look at the Course content carefully and ask a few questions from yourself?

  • I have shared all the codes which are used in this course

  • Is the Course taught by a real-time expert? I have more than 15 years of experience as an Instructor and more than 10 years of experience in SQL along with Big Query. I firmly believe that if an Instructor does not have a good experience, he/she will flood the course with poor content.

  • Is the Course content clear and Precise? The content is short, crisp, and clear.

  • The course assumes no prior knowledge of Google BigQuery(BigQuery) and teaches you from scratch to an advanced level

  • Once you Enroll for this Course, you get lifetime access to this course and you will get all the future updates.

  • The course does not cover T-SQL directly but it will help you to learn T-SQL also.

  • This will also help you to link Google Data studio with Google Big Query

  • If you aspire to be a data scientist, data analyst, SQL Developer, etc, then it is going to help you a lot.

  • If you plan to work with other databases like Oracle, MySQL, SQLite, PostgreSQL, etc, it will be extremely helpful.

  • If you are a data scientist (Data Analysis role) or willing to become a data scientist, then SQL is a must and this course helps in data analytics.


Do you want to start on Google BigQuery but have no experience with SQL?

If you have some prior knowledge on Google BigQuery or if you are a complete fresher, you are at the right place. The Course teaches you to Google Big Query with SQL right from Scratch. It will be the best course for absolute beginners.


There’s no risk involved in taking this Course!

I am sure that this is the best complete course on Google BigQuery and SQL and it is the perfect starting point to master complete BigQuery and SQL.


What if you are stuck?

I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.


Are you getting updated content?

Yes, I keep updating the content always to make sure, I provide all the information to my students.


Once you enroll for this course-

  1. Google bigquery in analytics

  2. What is google bigquery?

  3. How to use google bigquery

  4. Complete Google bigquery tutorial and course which covers everything step by step

  5.  You can easily analyze the google bigquery public datasets

  6. Master the datasets and tables in BigQuery

  7. Upload files from multiple ways to table

  8. All major SQL Statements in Google Big Query like below -

  9. Different SELECT Statements

  10. SELECT statements with conditions

  11. Filter the Records in Google Big Query

  12. Copy records from one table to another table in Big Query

  13. All the major numerical, Date, and String Functions of SQL with functions which are only present in Big Query

  14. You will master all the special operators

  15. Joins, SubQueries, UNIONs are covered in detail

  16. CTE and Derived tables are explained beautifully with a lot of examples

  17. Find a pattern of records in Google Big Query

  18. I have explained the concepts of Arrays, Struct, UNNEST, etc in detail which you will not find in any other course

  19. All the major functions which are exclusively available in Google BigQuery is covered with easy-going examples which are real-time

  20. Google bigquery data types are shown clearly

  21. Creation of tables and views are covered with real-time examples

  22. Inserting Record into a table is shown.

  23. I am going to cover all google bigquery sql statements.

  24. The course is packed with multiple real-time google bigquery examples.


Note: This course is about Google BigQuery but it will also help you to learn SQL which can be used on Microsoft SQL Server, Oracle, MySql, PostgreSQL, SQLite, DB2, etc.


Certification:

Once you complete the course, you will get a course completion "Google Bigquery Certification" by Udemy


Bạn sẽ học được gì

Yêu cầu

Nội dung khoá học

13 sections

Introduction

7 lectures
Introduction
03:15
What is Google BigQuery and Why it is used?
02:55
Setting up the BigQuery Sandbox account
06:31
Explaining about Datasets and tables
06:21
Uploading files from local to create tables under a dataset
11:12
Overwrite a file
02:15
Executing multiple Queries
04:14

Retrieve the records

14 lectures
SELECT Statement and SELECT DISTINCT
04:16
SQL Code used
00:05
CASE with SELECT Statement
05:16
SQL Code used
00:09
WHERE Clause and Comparison operator in WHERE Clause
06:14
SQL Code used
00:13
Logical Operators in WHERE Clause
05:58
SQL Code used
00:16
Copy Table to another table
03:54
Arithmetic operators
09:42
SQL Code used
00:16
Order of execution with WHERE clause
02:14
COUNT the rows from table
04:49
SQL Code used
00:02

Special Operators

8 lectures
NULL and NOT NULL
03:55
SQL Code used
00:06
BETWEEN and NOT BETWEEN operator
03:19
SQL Code used
00:06
IN and NOT IN Operator
04:21
SQL Code used
00:18
LIKE Operator
08:01
SQL Code used
00:12

Sorting and grouping records

8 lectures
ORDER BY Clause
07:33
SQL Code used
00:13
ORDER BY column position
01:44
SQL Code used
00:11
GROUP BY clause
09:58
SQL Code used
00:22
ORDER OF execution with GROUP BY and ORDER BY
02:27
SQL Code used
00:03

Google BigQuery SQL Functions

16 lectures
Other Numerical functions
06:23
SQL Code used
00:10
String Functions
06:47
SQL Code used
00:17
Ltrim, rtrim, trim and strpos string functions
05:08
SQL Code used
00:09
replace, repeat, reverse and substr functions
05:17
SQL Code used
00:08
Date Functions in Google BigQuery
09:02
SQL Code used
00:21
Date Functions in Google BigQuery continued
06:02
SQL Code used
00:07
Strange behavior of BigQuery parser with GROUP BY and column Alias
03:49
SQL Code used
00:07
HAVING Clause
05:57
SQL Code used
00:20

Joins and Subqueries

23 lectures
Subquery
05:54
SQL Code used
00:12
Subqueries as column expressions
05:45
SQL Code used
00:04
UNION ALL operator
08:32
SQL Code used
00:08
INTERSECT DISTINCT operator
02:56
SQL Code used
00:06
EXCEPT DISTINCT operator
03:05
SQL Code used
00:05
INNER JOIN - Theory
03:11
INNER JOINs
05:29
SQL Code used
00:09
LEFT Join - Theory
03:45
Note about next Lecture
00:10
LEFT JOIN Example
10:03
SQL Code used
00:12
RIGHT JOIN
03:37
SQL Code used
00:10
FULL JOIN
05:23
SQL Code used
00:03
CROSS JOIN
04:39
SQL Code used
00:05

Derived Tables and CTE

22 lectures
Derived Tables - Part 1
05:27
SQL Code used
00:05
Derived Tables - Part 2
03:02
SQL Code used
00:10
Creating 2 tables using CSV for Project 1
05:53
Get productid, Total Qty and profit using INNER JOIN and GROUP BY
05:25
SQL Code used
00:11
Getting the same result using derived tables
07:14
SQL Code used
00:14
Apply HAVING Clause on derived tables
03:32
SQL Code used
00:16
Derived Table with CASE with SELECT statement - Task and Solution
09:06
SQL Code used
00:28
Project 2 - Load 3 tables
02:02
CTE - Theory
02:31
Write SQL Query to get businessentityid and full name
01:07
Solution and CTE Example
04:26
SQL Code used
00:07
CTE Example with 2 Tables
11:38
SQL Code used
00:16
CTE Example with 3 Tables
05:45
SQL Code used
00:15

Arrays, UNNEST, Struct, etc.

36 lectures
Project 3 - Arrays
00:56
Arrays in BigQuery
10:10
SQL Code used
00:11
Write the same query using CTE
01:28
SQL Code used
00:11
UNNEST in Arrays
03:39
SQL Code used
00:03
UNNEST() with CROSS JOIN
04:59
SQL Code used
00:12
GENERATE_ARRAY() function
02:54
SQL Code used
00:02
GENERATE_DATE_ARRAY() Function
03:28
SQL Code used
00:09
ARRAY_LENGTH() function
01:18
SQL Code used
00:02
STRUCT() Function
04:12
SQL Code used
00:11
Multiple Struct Statements
02:52
SQL Code used
00:07
Multiple Struct statements as arrays
07:48
SQL Code used
00:07
Joining multiple rows in Struct statements which has arrays
04:21
SQL Code used
00:18
Save Results of the Query
04:05
Save the Result and get the output as flat tables
04:04
SQL Code used
00:14
Assignment - Using Multiple UNNEST functions
09:36
SQL Code used
00:11
Using Multiple UNNEST functions using CTE
04:08
SQL Code used
00:09
Assignment - UNNEST Function with SUM function
05:14
SQL Code used
00:28
ARRAY_AGG() Function
11:15
SQL Code used
00:24
Assignment - ARRAY_AGG() Function multiple times
08:52
SQL Code used
00:31

Final Project and Queries

11 lectures
Project using bigquery-public-datasets
07:31
Assignment - Analyzing the GA data using SELECT statement, group by, etc.
08:42
SQL Code used
00:07
Selecting Records for all the dates - not by partition.
02:18
SQL Code used
00:07
UNNEST multiple levels - Contains Assignment
15:17
SQL Code used
00:34
Exporting the BigQuery Data to Google Data Studio
06:20
Keyboard Shortcuts in BigQuery
02:18
SQL Dialects in BigQuery
03:41
Optional - Identity and Access Management
05:32

Create Tables

7 lectures
Available Data types in BigQuery
07:34
CREATE Table Statement
09:56
SQL Code used
00:05
CREATE IF NOT EXISTS and CREATE OR REPLACE TABLE
03:30
SQL Code used
00:12
CREATE TABLE with NOT NULL and Partition
07:38
SQL Code used
00:10

Views

6 lectures
CREATE VIEWS
05:33
SQL Code used
00:24
CREATE or REPLACE VIEW or CREATE VIEW IF NOT EXISTS
01:39
SQL Code used
00:47
Dropping a view
00:58
SQL Code used
00:00

Insert Records

3 lectures
CREATE TABLE with columns manually
03:11
INSERT Statement
10:37
SQL Code used
00:15

Bonus Section - Thank You

1 lectures
Bonus Lesson : Let us stay connected
00:51

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.