- 提示:
- 透過本站連結購買Udemy課程，本站將獲得推廣佣金，有助未來提供更多實用進修課程資訊給讀者。
課程資料
報名日期*
全年招生
課程級別
學習模式
修業期
2 小時 1 分鐘
教學語言
英語
授課導師
Annabel Lyle
評分
*提示: 以上時間表僅供參考，以機構網站為準。
課程簡介
Learn SQL using Google's scalable analytics data warehouse. Super charge your data analysis skills with BigQuery
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.
課程章節
- 8 個章節
- 55 堂課
- 第 1 章 Introduction
- 第 2 章 Retrieve the data you need with the SELECT Statement
- 第 3 章 Filter the data you need with the WHERE Statement
- 第 4 章 Calculate more metrics with Aggregate Analytical Functions
- 第 5 章 GROUP BY
- 第 6 章 JOIN tables together
- 第 7 章 Create new Columns with Single Line Functions
- 第 8 章 EXPORT your data
課程內容
- 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
此課程所涵蓋的技能
評價
-
AAbdeljalil BOUNAJI
Good one.
-
SSukshith P
Class was very good and intresting
-
MMthokozisi Nyoni
Very straight forward, great course overall.
-
MMargarita Rangel
so far so good...
