We may earn an affiliate commission when you visit our partners.
Google Cloud
This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Oracle and want to begin working in BigQuery.
Read more
This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Oracle and want to begin working in BigQuery.
Read more
This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Oracle and want to begin working in BigQuery.
This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Oracle and want to begin working in BigQuery. Through interactive lecture content and hands-on labs, you learn how to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery. Drawing upon your knowledge of Oracle, you also learn about similarities and differences between Oracle and BigQuery to help you get started with data warehouses in BigQuery. After this course, you can continue your BigQuery journey by completing the skill badge quest titled https://www.cloudskillsboost.google/quests/147">Build and Optimize Data Warehouses with BigQuery.
Register for this course and see more details by visiting:
OpenCourser.com/course/3hcmfl/bigquery
What's inside
Syllabus
BigQuery Architecture and Resource Provisioning
BigQuery Data Definition Model
BigQuery and Google Cloud IAM
BigQuery Data Ingestion
Read more
Syllabus
BigQuery Architecture and Resource Provisioning
BigQuery Data Definition Model
BigQuery and Google Cloud IAM
BigQuery Data Ingestion
Read more
BigQuery Schema Design and Optimization
SQL in BigQuery
Course Resources
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Designed for professionals familiar with Oracle cloud data warehouses who seek to migrate to BigQuery
Provides a strong foundation for professionals transitioning from Oracle to BigQuery
Interactive lecture content and hands-on labs enhance practical understanding of BigQuery
Helps learners optimize query performance, a critical aspect of data warehousing
Covers essential aspects of BigQuery architecture, such as resource provisioning and data ingestion
Provides insights into similarities and differences between Oracle and BigQuery, easing the transition
Save this course
Save BigQuery Fundamentals for Oracle Professionals to your list so you can find it easily later:
Save
Save
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 BigQuery Fundamentals for Oracle Professionals with these
activities:
Review BigQuery architecture
Show steps
Review the fundamental concepts and architecture of BigQuery to ensure a solid foundation for this course.
Browse courses on
BigQuery Architecture
Show steps
-
Read the Google Cloud documentation on BigQuery architecture
-
Create a diagram of the BigQuery architecture
Follow BigQuery tutorials
Show steps
Follow step-by-step tutorials to gain hands-on experience with BigQuery and reinforce your understanding of key concepts.
Show steps
-
Complete the BigQuery quickstart tutorial
-
Follow the BigQuery SQL tutorial
-
Practice loading data into BigQuery using the BigQuery console
Review BigQuery documentation
Show steps
Reading the BigQuery documentation will help you understand the basic concepts and terminology used in BigQuery.
Browse courses on
BigQuery Architecture
Show steps
-
Visit the BigQuery documentation website.
-
Read through the Getting Started guide.
-
Review the BigQuery tutorials.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Complete the BigQuery Fundamentals tutorial
Show steps
Completing the BigQuery Fundamentals tutorial will give you hands-on experience with BigQuery, and help you understand how to use BigQuery to query and analyze data.
Browse courses on
BigQuery Architecture
Show steps
-
Visit the BigQuery Fundamentals tutorial page.
-
Follow the instructions in the tutorial.
-
Complete the exercises in the tutorial.
SQL exercises in BigQuery
Show steps
Complete SQL exercises in BigQuery to enhance your proficiency in querying and manipulating data in BigQuery.
Show steps
-
Find the top 10 most profitable customers
-
Calculate the average order value for each product category
-
Create a dashboard to visualize your results
Practice writing SQL queries in BigQuery
Show steps
Practicing writing SQL queries in BigQuery will help you develop your skills in data analysis and querying.
Show steps
-
Create a BigQuery dataset.
-
Load some data into the dataset.
-
Write some SQL queries to query the data.
Migration to BigQuery
Show steps
Initiate a project to migrate data from Oracle to BigQuery, implementing the concepts you've learned in this course.
Browse courses on
Data Migration
Show steps
-
Identify the data sources to be migrated
-
Plan the data migration strategy
-
Execute the data migration using BigQuery tools
-
Validate the migrated data and ensure data integrity
Review BigQuery architecture
Show steps
Review the fundamental concepts and architecture of BigQuery to ensure a solid foundation for this course.
Browse courses on
BigQuery Architecture
Show steps
Show steps
Show steps
- Read the Google Cloud documentation on BigQuery architecture
- Create a diagram of the BigQuery architecture
Follow BigQuery tutorials
Show steps
Follow step-by-step tutorials to gain hands-on experience with BigQuery and reinforce your understanding of key concepts.
Show steps
Show steps
Show steps
- Complete the BigQuery quickstart tutorial
- Follow the BigQuery SQL tutorial
- Practice loading data into BigQuery using the BigQuery console
Review BigQuery documentation
Show steps
Reading the BigQuery documentation will help you understand the basic concepts and terminology used in BigQuery.
Browse courses on
BigQuery Architecture
Show steps
Show steps
Show steps
- Visit the BigQuery documentation website.
- Read through the Getting Started guide.
- Review the BigQuery tutorials.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Complete the BigQuery Fundamentals tutorial
Show steps
Completing the BigQuery Fundamentals tutorial will give you hands-on experience with BigQuery, and help you understand how to use BigQuery to query and analyze data.
Browse courses on
BigQuery Architecture
Show steps
Show steps
Show steps
- Visit the BigQuery Fundamentals tutorial page.
- Follow the instructions in the tutorial.
- Complete the exercises in the tutorial.
SQL exercises in BigQuery
Show steps
Complete SQL exercises in BigQuery to enhance your proficiency in querying and manipulating data in BigQuery.
Show steps
Show steps
Show steps
- Find the top 10 most profitable customers
- Calculate the average order value for each product category
- Create a dashboard to visualize your results
Practice writing SQL queries in BigQuery
Show steps
Practicing writing SQL queries in BigQuery will help you develop your skills in data analysis and querying.
Show steps
Show steps
Show steps
- Create a BigQuery dataset.
- Load some data into the dataset.
- Write some SQL queries to query the data.
Migration to BigQuery
Show steps
Initiate a project to migrate data from Oracle to BigQuery, implementing the concepts you've learned in this course.
Browse courses on
Data Migration
Show steps
Show steps
Show steps
- Identify the data sources to be migrated
- Plan the data migration strategy
- Execute the data migration using BigQuery tools
- Validate the migrated data and ensure data integrity
Career center
Learners who complete BigQuery Fundamentals for Oracle Professionals will develop knowledge and skills
that may be useful to these careers:
Data Scientist
Data Scientist
A Data Scientist who has taken this course will be able to leverage their knowledge of SQL-based cloud data warehouses in Oracle as they begin working in BigQuery. You will be able to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery.
Data Engineer
Data Engineer
A Data Engineer, aided by this course, can get started with data warehouses in BigQuery by leveraging their knowledge of Oracle. You will be able to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery.
Data Analyst
Data Analyst
A Data Analyst gathers, analyzes, interprets, and presents data. In this role, you will apply SQL in BigQuery. You will also learn BigQuery Architecture and Resource Provisioning in order to use data to make informed decisions.
Database Administrator
Database Administrator
This course may help a Database Administrator get started with data warehouses in BigQuery. You will learn BigQuery Architecture and Resource Provisioning.
Software Engineer
Software Engineer
A Software Engineer with a background in SQL-based cloud data warehouses may find this course useful in learning about BigQuery. You will learn BigQuery Architecture and Resource Provisioning, and will be able to create and share data assets.
Analyst
Analyst
This course may be useful to an Analyst who is transitioning to a data analysis or engineering role. You will learn the fundamentals of BigQuery, including its architecture and resource provisioning.
Business Analyst
Business Analyst
A Business Analyst who has taken this course will be able to leverage their knowledge of SQL-based cloud data warehouses in Oracle as they begin working in BigQuery. You will be able to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery.
Database Manager
Database Manager
A Database Manager responsible for working with BigQuery may find this course useful. You will learn to provision resources, create and share data assets, and ingest data in BigQuery.
Data Architect
Data Architect
This course may be useful in helping a Data Architect build a foundation in BigQuery. You will learn to provision resources, create and share data assets, and ingest data in BigQuery.
Information Architect
Information Architect
An Information Architect who has taken this course will be able to leverage their knowledge of SQL-based cloud data warehouses in Oracle as they begin working in BigQuery. You will be able to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery.
Project Manager
Project Manager
A Project Manager may find this course useful in gaining a basic understanding of BigQuery. You will learn BigQuery Architecture and Resource Provisioning, and will be able to create and share data assets.
Information Systems Manager
Information Systems Manager
An Information Systems Manager may find this course useful in learning about BigQuery. You will learn BigQuery Architecture and Resource Provisioning, and will be able to create and share data assets.
IT Manager
IT Manager
This course may be useful to an IT Manager who is responsible for overseeing the implementation of BigQuery. You will gain a basic understanding of BigQuery fundamentals, such as BigQuery Architecture and Resource Provisioning.
Research Analyst
Research Analyst
A Research Analyst may find this course useful for gaining a basic understanding of how to use BigQuery to manage and analyze data.
Risk Manager
Risk Manager
This course may be useful to a Risk Manager to gain a basic understanding of BigQuery fundamentals, such as BigQuery Architecture and Resource Provisioning.
For more career information including salaries, visit:
OpenCourser.com/course/3hcmfl/bigquery
Reading list
We've selected 12 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
BigQuery Fundamentals for Oracle Professionals.
Provides a comprehensive guide to administering Oracle Database 12c. It valuable reference for anyone who is responsible for managing Oracle databases.
Save
Provides a comprehensive guide to using SQL and PL/SQL in Oracle databases. It valuable reference for anyone who wants to develop applications using Oracle databases.
Provides a comprehensive guide to Oracle Database security. It covers topics such as user authentication, authorization, and auditing.
Provides a comprehensive guide to optimizing Oracle performance. It covers topics such as database design, indexing, and query tuning.
Provides a comprehensive overview of data warehousing. It covers topics such as data modeling, data integration, and data quality.
Provides a practical guide to writing SQL queries. It covers topics such as data selection, data manipulation, and data aggregation.
Provides a comprehensive overview of the internal workings of Oracle Database. It covers topics such as memory management, I/O operations, and concurrency control.
Provides a comprehensive guide to dimensional modeling. It valuable reference for anyone who wants to learn more about how to design and build data warehouses using dimensional modeling.
Save
Provides a comprehensive overview of machine learning. It valuable reference for anyone who wants to learn more about how to use machine learning for business and analytics.
Save
Provides a comprehensive overview of deep learning. It valuable reference for anyone who wants to learn more about how to use deep learning for business and analytics.
Provides a comprehensive overview of natural language processing. It valuable reference for anyone who wants to learn more about how to use natural language processing for business and analytics.
Provides a comprehensive overview of reinforcement learning. It valuable reference for anyone who wants to learn more about how to use reinforcement learning for business and analytics.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/3hcmfl/bigquery
Share
Similar courses
Here are nine courses similar to
BigQuery Fundamentals for Oracle Professionals.
BigQuery Fundamentals for Oracle Professionals
OpenCourser.com/course/g2usbu/bigquery
BigQuery Fundamentals for Oracle Professionals
Most relevant
BigQuery Fundamentals for Snowflake Professionals
OpenCourser.com/course/skqo05/bigquery
BigQuery Fundamentals for Snowflake Professionals
Most relevant
BigQuery Fundamentals for Redshift Professionals
OpenCourser.com/course/0m7yaq/bigquery
BigQuery Fundamentals for Redshift Professionals
Most relevant
BigQuery Fundamentals for Teradata Professionals
OpenCourser.com/course/feenj4/bigquery
BigQuery Fundamentals for Teradata Professionals
Most relevant
BigQuery Fundamentals for Teradata Professionals
OpenCourser.com/course/5apo2o/bigquery
BigQuery Fundamentals for Teradata Professionals
Most relevant
BigQuery Fundamentals for Snowflake Professionals
OpenCourser.com/course/5sysqx/bigquery
BigQuery Fundamentals for Snowflake Professionals
Most relevant
BigQuery Fundamentals for Redshift Professionals
OpenCourser.com/course/qlraqs/bigquery
BigQuery Fundamentals for Redshift Professionals
Most relevant
Build a Data Warehouse Using BigQuery
OpenCourser.com/course/exulvz/build
Build a Data Warehouse Using BigQuery
Most relevant
Oracle SQL Performance Tuning
OpenCourser.com/course/pc1xx2/oracle
Oracle SQL Performance Tuning
Most relevant
Time
1 hours
Level
Introductory
Via
Pluralsight
Instructor
Google Cloud
Language
English
Good to know
Designed for professionals familiar with Oracle cloud data warehouses who seek to migrate to BigQuery
Provides a strong foundation for professionals transitioning from Oracle to BigQuery
Interactive lecture content and hands-on labs enhance practical understanding of BigQuery
Helps learners optimize query performance, a critical aspect of data warehousing
Covers essential aspects of BigQuery architecture, such as resource provisioning and data ingestion
Provides insights into similarities and differences between Oracle and BigQuery, easing the transition
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser