Achieving Advanced Insights with BigQuery 日本語版 from Coursera

このコースシリーズの 3 番目のコースは、「Achieving Advanced Insights with BigQuery」です。ここでは、高度な関数と、複雑なクエリを管理可能なステップに分割する方法を学びながら、SQL に関する知識を深めます。

BigQuery の内部アーキテクチャ（列ベースのシャーディングストレージ）についてや、ARRAY と STRUCT を使用した、ネストされたフィールドと繰り返しフィールドなどの高度な SQL トピックについて説明します。最後に、クエリのパフォーマンスを最適化する方法と、承認済みビューを使用してデータを保護する方法について説明します。

このコースを修了したら、「Applying Machine Learning to Your Data with Google」コースに登録してください。

What's inside

Syllabus

はじめに

本コースで学習する大まかな内容

高度な関数と句

統計的近似、分析ウィンドウクエリ、ユーザー定義関数、WITH 句などの高度なファンクションについて学ぶことで、BigQuery での SQL について理解を深めます。

スキーマの設計とネストされたデータ構造

従来のデータベースがデータセットのスケールを処理する方法の進化について説明し、スケールの制約に対処するために BigQuery がどのように開発されたかを比較します。非正規化 BigQuery データ構造の重要な部分である、ネストされたフィールドと繰り返しフィールドについて詳しく説明します。

パフォーマンスの最適化

BigQuery のパフォーマンスに影響を与える基本的な作業と、クエリを最適化してスピードを向上させる方法について学びます。

Vertex AI Workbench による高度な分析

Vertex AI Workbench の概要 -- データサイエンティストツールキットの主なツール -- アナリストはスケーラブルなクラウドノートブックを使用して共同作業ができるようになります。

データアクセス

BigQuery データセットの保護と共有は、どの組織にとっても重要です。Google Cloud と BigQuery ツールのうち、権限の管理とデータの共有に利用できるものについて学びます。

コースのまとめ

コースの主な学習ポイントのまとめ

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

ビッグデータについての高度な知識を学ぶことができます。

ビッグクエリに関するSQLの知識を深めることができます。

ネストされたフィールドや繰り返しフィールドなどの高度なSQLトピックについて学ぶことができます。

クエリのパフォーマンスを最適化する方法について学ぶことができます。

承認済みビューを使用してデータを保護する方法について学ぶことができます。

業界標準の関数を使用します。

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Achieving Advanced Insights with BigQuery 日本語版 with these activities:

リフレッシュ SQL 演算と関数の知識

Show steps

この活動は、基本的な SQL 演算と関数の知識をリフレッシュし、高度な SQL トピックの理解を向上させます。

Browse courses on SQL

Show steps

オンラインチュートリアルやドキュメントを参照する。
練習問題やサンプルクエリを実行する。

BigQuery のアーキテクチャとデータ構造に関するチュートリアルを完了する

Show steps

この活動では、BigQuery の内部アーキテクチャと、ARRAY と STRUCT を使用したネストされたフィールドや繰り返しフィールドなどの高度なデータ構造について理解を深めます。

Browse courses on Array

Show steps

Google Cloud Training または Coursera のチュートリアルを見つける。
チュートリアル内の手順に従って、自分の BigQuery アカウントで演習を行う。

Show all two activities

Career center

Learners who complete Achieving Advanced Insights with BigQuery 日本語版 will develop knowledge and skills that may be useful to these careers:

Data Scientist

Data Scientists build, deploy, and evaluate machine learning models to address complex business problems. They're responsible for the entire lifecycle of a machine learning project, from data collection and preparation to model development and deployment. This course can help you learn the SQL skills needed to query and analyze large datasets, which is essential for building and evaluating machine learning models.

See salaries and explore the career path for Data Scientist

Data Analyst

Data Analysts collect, clean, and analyze data to help organizations make better decisions. They use SQL to query and analyze large datasets, and they develop visualizations to communicate their findings. This course can help you learn the SQL skills needed to perform data analysis, which is essential for identifying trends and patterns in data.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts help organizations identify and solve business problems using data. They work with stakeholders to understand their needs and develop data-driven solutions. This course can help you learn the SQL skills needed to analyze data and identify trends, which is essential for developing data-driven business solutions.

See salaries and explore the career path for Business Analyst

Data Engineer

Data Engineers design, build, and maintain data pipelines. They work with data scientists and business analysts to understand their needs and develop data solutions. This course can help you learn the SQL skills needed to design and build data pipelines, which is essential for ensuring that data is available to those who need it.

See salaries and explore the career path for Data Engineer

Machine Learning Engineer

Machine Learning Engineers build, deploy, and evaluate machine learning models. They work with data scientists and business analysts to understand their needs and develop data-driven solutions. This course can help you learn the SQL skills needed to query and analyze large datasets, which is essential for building and evaluating machine learning models.

See salaries and explore the career path for Machine Learning Engineer

Web Developer

Web Developers design, build, and maintain websites. They work with users to understand their needs and develop web solutions. This course can help you learn the SQL skills needed to develop websites that interact with databases.

See salaries and explore the career path for Web Developer

Software Engineer

Software Engineers design, build, and maintain software applications. They work with users to understand their needs and develop software solutions. This course can help you learn the SQL skills needed to develop software applications that interact with databases.

See salaries and explore the career path for Software Engineer

Database Administrator

Database Administrators maintain and optimize databases. They work with database users to ensure that data is available and secure. This course can help you learn the SQL skills needed to administer databases, which is essential for ensuring that data is available to those who need it.

See salaries and explore the career path for Database Administrator

Information Security Analyst

Information Security Analysts are responsible for protecting data from unauthorized access, use, disclosure, disruption, modification, or destruction. They work with stakeholders to understand their needs and develop security solutions. This course can help you learn the SQL skills needed to protect data from unauthorized access.

See salaries and explore the career path for Information Security Analyst

Risk Analyst

Risk Analysts are responsible for identifying, assessing, and mitigating risks. They work with stakeholders to understand their needs and develop risk management solutions. This course can help you learn the SQL skills needed to identify and mitigate risks.

See salaries and explore the career path for Risk Analyst

Data Architect

Data Architects design and build data systems. They work with stakeholders to understand their needs and develop data solutions. This course can help you learn the SQL skills needed to design and build data systems.

See salaries and explore the career path for Data Architect

Data Governance Specialist

Data Governance Specialists develop and implement data governance policies and procedures. They work with stakeholders to understand their needs and develop data solutions. This course can help you learn the SQL skills needed to develop and implement data governance policies and procedures.

See salaries and explore the career path for Data Governance Specialist

Privacy Analyst

Privacy Analysts are responsible for protecting data from unauthorized access, use, disclosure, disruption, modification, or destruction. They work with stakeholders to understand their needs and develop privacy solutions. This course can help you learn the SQL skills needed to protect data from unauthorized access.

See salaries and explore the career path for Privacy Analyst

Compliance Analyst

Compliance Analysts are responsible for ensuring that organizations comply with laws and regulations. They work with stakeholders to understand their needs and develop compliance solutions. This course can help you learn the SQL skills needed to ensure that organizations comply with laws and regulations.

See salaries and explore the career path for Compliance Analyst

Data Steward

Data Stewards are responsible for managing and protecting data. They work with stakeholders to understand their needs and develop data solutions. This course can help you learn the SQL skills needed to manage and protect data.

See salaries and explore the career path for Data Steward