Coursera

BigQuery Fundamentals for Oracle Professionals (Coursera)

Offered by 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. 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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

What You Will Learn

Describe BigQuery’s architecture, resource provisioning, and data definition model.
Create, secure, and share BigQuery data assets using best practices.
Implement common patterns and best practices for designing schemas, ingesting data, and querying data - in BigQuery.

Compare and contrast the differences and commonalities between Oracle and BigQuery.

Syllabus

WEEK 1
Module 1: BigQuery Architecture and Resource Provisioning
This introductory module summarizes the key details of BigQuery architecture and resource provisioning including how BigQuery utilizes slots to execute SQL queries and workload management in BigQuery. Drawing upon your knowledge of Oracle, this module also provides a high-level overview of the similarities and differences between Oracle and BigQuery architecture and resource provisioning to help you get started with BigQuery.
Module 2: BigQuery Data Definition Model
This module summarizes the key details of BigQuery’s resource hierarchy and data definition model, including how to create datasets and tables in BigQuery. Drawing upon your knowledge of Oracle, this module also provides a high-level overview of the similarities and differences between the Oracle and BigQuery resource hierarchies and primary data types to help you start working with data in BigQuery.
Module 3: BigQuery and Google Cloud IAM
This module summarizes the key details of the Google Cloud Identity and Access Management (IAM) model, including how roles and permissions are applied to datasets and tables in BigQuery. Drawing upon your knowledge of Oracle, this module also provides a high-level overview of the similarities and differences in roles and permissions between Oracle and BigQuery to help you start securing and sharing your data in BigQuery.

WEEK 2
Module 4: BigQuery Data Ingestion
This module summarizes the primary options and best practices for ingesting data into BigQuery, including batch data loading, streaming ingestion, and queries to external data sources. Drawing upon your knowledge of Oracle, this module also provides a high-level overview of the similarities and differences in data ingestion options between Oracle and BigQuery to help you start reading and loading your data into BigQuery.
Module 5: BigQuery Schema Design and Optimization
This module summarizes common patterns and best practices for designing and optimizing table schemas in BigQuery, including the use of nested and repeated fields, partitioning, and clustering. Drawing upon your knowledge of Oracle, this module also provides a high-level overview of the similarities and differences in schema usage and design between Oracle and BigQuery to help you start structuring and optimizing your data in BigQuery.
Module 6: SQL in BigQuery
This module summarizes the key features and operations of the Google Standard SQL dialect used in BigQuery and best practices for optimizing query performance and controlling costs in BigQuery. Drawing upon your knowledge of Oracle, this module also provides a high-level o

Go to Class

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Coursera

SkillUp EdTech

Power BI Data Analyst Associate Prep (Coursera)

CS: Information & Technology

This short course will guide you on preparing for the PL-300: Microsoft Power BI Data Analyst exam. This exam is the requirement for Microsoft Certified: Power BI Data Analyst Associate certification. The course provides you with a detailed understanding of the Power BI concepts, its features, and capabilities.

Nov 2nd 2026

3 Weeks

SQL Data Analysis Data Cleaning

Coursera

Illinois Tech

Introduction to Relational Databases (Coursera)

Statistics & Data Analysis Data Science

Database management systems are a crucial part of most large-scale industry and open-source systems. This course will introduce you to important concepts of database systems and design. We will learn what relational databases are, what they are used for, the theory underlying their design, and how to query and modify a database using the declarative SQL language.

Nov 9th 2026

4 Weeks

SQL Relational Databases Relational Algebra

Coursera

University of Colorado System

Relational Database Support for Data Warehouses (Coursera)

Statistics & Data Analysis Data Science

Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.

Oct 26th 2026

5-12 Weeks

Databases SQL Big Data

Coursera

University of Illinois at Urbana-Champaign

Accounting Data Analytics with Python (Coursera)

Statistics & Data Analysis Data Science

This course focuses on developing Python skills for assembling business data. It will cover some of the same material from Introduction to Accounting Data Analytics and Visualization, but in a more general purpose programming environment (Jupyter Notebook for Python), rather than in Excel and the Visual Basic Editor. These concepts are taught within the context of one or more accounting data domains (e.g., financial statement data from EDGAR, stock data, loan data, point-of-sale data).

Nov 9th 2026

5-12 Weeks

Python SQL Linear Regression

Coursera

University of Colorado Boulder

Introduction to Data Analytics for Business (Coursera)

Statistics & Data Analysis Data Science

This course will expose you to the data analytics practices executed in the business. We will explore such key areas of data analytics as the analytical process, how data is created, stored, and accessed, and how the organization works with data and creates the environment in which analytics can flourish.

Oct 26th 2026

4 Weeks

Business SQL Data Modeling

Coursera

Edureka

MySQL for Data Analytics and Business Intelligence (Coursera)

CS: Software Engineering

Embark on a thorough educational expedition through the "Fundamentals of Database Management with MySQL" module. This foundational program aims to impart a robust comprehension of MySQL, a prominent Relational Database Management System (RDBMS). Participants will delve into crucial concepts, ranging from the fundamentals of SQL to more advanced topics like data retrieval, relationships, business intelligence, and data visualization.

Nov 2nd 2026

1 Week

SQL Spreadsheets MySQL

Coursera

Cloudera

Foundations for Big Data Analysis with SQL (Coursera)

Statistics & Data Analysis Data Science

In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database systems, and the common querying language (SQL). Then you'll learn the characteristics of big data and SQL tools for working on big data platforms. You'll also install an exercise environment (virtual machine) to be used through the specialization courses, and you'll have an opportunity to do some initial exploration of databases and tables in that environment.

Oct 26th 2026

5-12 Weeks

Databases SQL Big Data

Coursera

Cloudera

Managing Big Data in Clusters and Cloud Storage (Coursera)

Statistics & Data Analysis Data Science

In this course, you'll learn how to manage big datasets, how to load them into clusters and cloud storage, and how to apply structure to the data so that you can run queries on it using distributed SQL engines like Apache Hive and Apache Impala. You’ll learn how to choose the right data types, storage systems, and file formats based on which tools you’ll use and what performance you need.

Oct 26th 2026

5-12 Weeks

SQL Big Data Data Management

Coursera

LearnQuest

Oracle SQL Proficiency (Coursera)

CS: Software Engineering

This course is designed to help you continue learning about Oracle SQL and database management. We will look more closely at the Create, Alter, and Update commands, explore database relationships, and demonstrate how to use database views and SQL functions. It is recommended that you complete the first three courses of this specialization prior to this one.

Oct 26th 2026

2 Weeks

SQL Database Management Oracle SQL

Coursera

Duke University

Managing Big Data with MySQL (Coursera)

Statistics & Data Analysis Data Science

This course is an introduction to how to use relational databases in business analysis. You will learn how relational databases work, and how to use entity-relationship diagrams to display the structure of the data held within them. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts.

Oct 26th 2026

5-12 Weeks

Databases SQL Big Data

Coursera

University of Washington

Data Manipulation at Scale: Systems and Algorithms (Coursera)

Statistics & Data Analysis Data Science

Data analysis has replaced data acquisition as the bottleneck to evidence-based decision making --- we are drowning in it. Extracting knowledge from large, heterogeneous, and noisy datasets requires not only powerful computing resources, but the programming abstractions to use them effectively. The abstractions that emerged in the last decade blend ideas from parallel databases, distributed systems, and programming languages to create a new class of scalable data analytics platforms that form the foundation for data science at realistic scales.

Oct 26th 2026

4 Weeks

Algebra Algorithms Databases

Coursera

IBM

SQL for Data Science with R (Coursera)

Statistics & Data Analysis Data Science

Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL and R languages. It is also intended to get you started with performing SQL access in a data science environment.

Oct 26th 2026

5-12 Weeks

SQL Data Science R Programming