Get in Touch
 Duration 28 hours

Course Outline

Overview

  • Introduction to the Google BigQuery Platform

Initial Configuration

  • Establishing a Google Cloud account
  • Navigating the BigQuery Web interface
  • Provisioning and administering datasets and tables
  • Ingesting data into the BigQuery environment
  • Executing fundamental SQL queries within BigQuery

SQL Querying in BigQuery

  • Advanced methods for constructing SQL queries
  • Data aggregation using GROUP BY clauses
  • Data filtering and sorting procedures
  • Utilizing date and time functional operations
  • Joining multiple data tables
  • Implementing subqueries and window functions

Advanced BigQuery Capabilities

  • Exporting data from the BigQuery repository
  • Application of user-defined functions (UDFs)
  • Administration and scheduling of query execution
  • Foundations of BigQuery scripting
  • Processing arrays and structural data types
  • Handling JSON-formatted data

BigQuery Performance Optimization

  • Strategies for enhancing query performance
  • Table partitioning and clustering methodologies
  • Interpreting the Query Execution Plan
  • Diagnostic troubleshooting and query debugging
  • Cost management and billing compliance practices
  • Security protocols and access control mechanisms in BigQuery

Advanced Topics and System Integration

  • Real-time analysis via streaming data ingestion
  • Integration of BigQuery with Google Data Studio
  • Introduction to BigQuery ML for machine learning applications
  • Development and deployment of machine learning models using BigQuery ML
  • Integration with data lake architectures

Summary and Forward Planning

Requirements

  • Familiarity with fundamental database architecture and SQL syntax

Target Audience

  • Data analysts
  • Database administrators

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories