BigQuery for Data Analysts
Data Modeling, SQL Functions, Access Controls, Performance Tips, and Controlling Costs
Lo que serás capaz de hacer
Analyze data in BigQuery using both basic SQL statements as well as specialized functions to help you gain insight into your data. If you need to analyze data in BigQuery and have some familiarity with using BigQuery, then this course will help you expand your skills with lectures, quizzes, and assignments. ( If you are new to BigQuery, consider taking the Introduction to BigQuery course first.) The course begins with data definition language statements for creating and altering tables and views followed by a review of data manipulation statements, including SELECT, INSERT, UPDATE, DELETE, and MERGE. Learn how to use common table expressions (CTEs) effectively to modularize your SQL and make even complex logic easy to understand. Note: There are several basic videos reviewing SELECT statements which you can skip if you have taken Introduction to BigQuery or are comfortable writing SELECT statements. Working with BigQuery has some differences from working with relational databases like Postgres and SQL Server. We often use arrays and structures in BigQuery and this course will teach you how to work with arrays, querying and unnesting arrays, using array functions as well as working with structures and arrays of structures . SQL functions are foundational building blocks for data analytics work and it is important to know the functions available in BigQuery to rapidly and effectively analyze data. In this course, we will learn about a range of SQL functions for: Math and statistics Aggregate functions Data type casting Dates and times String manipulation Regular expressions Approximate functions for working with large datasets Analytical and window functions Data analysts need to be familiar with BigQuery operations so the course also covers BigQuery security, including access controls, column security, and row-level security , as well as performance and cost management . Test your understanding of BigQuery concepts with 8 assignments and 10 quizzes. In this course, you will learn a wide range of topics that data analysts need to understand and you will know how to apply that knowledge effectively in BigQuery while working cost-effectively. After completing this course you will know a wide range of functions and techniques for analyzing and transforming data in BigQuery, understand how access to data is controlled using IAM, row-level, and column security, and how to control the cost of your BigQuery operations.
- Learn how to work with SQL functions for math, strings, datetimes, and more
- Use structured and repeated fields for efficient data modeling
- Apply access controls to columns, rows, tables, and datasets
- Cost controls and performance optimizations
Temario
UNIDAD 1 - Introduction · 1 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Introduction
UNIDAD 2 - Creating Tables and Views in BigQuery · 9 leccionesUNIDAD 2 - Creating Tables and Views in BigQuery
UNIDAD 2 - Creating Tables and Views in BigQuery
- Creating Tables using the BigQuery Console
- Creating Tables using the bq Command
- Creating Tables using SQL Statements
- Creating Views using the BigQuery Console
- Creating Views using SQL Statements
- Altering a Table
- Creating a Table in BigQuery
- Altering a Table in BigQuery
- Creating Tables and Views Quiz
UNIDAD 3 - Review of Querying with SELECT Statements · 15 leccionesUNIDAD 3 - Review of Querying with SELECT Statements
UNIDAD 3 - Review of Querying with SELECT Statements
- Working with a 1 Table Public Data Set
- Working with a 2 Table Public Data Set
- Basic Select Statements
- WHERE Clauses
- ORDER BY Clauses
- GROUP BY Clauses
- WHERE, GROUP BY, and ORDER BY Clauses
- HAVING Clauses
- Aggregate Functions
- Simple Math Expressions
- CASE Statements and Error Checking
- Joining Two Tables
- Common Table Expressions
- Find the name of the station with the smallest station_id
- Find the name of the station that was the start of the longest trip duration.
UNIDAD 4 - Data Manipulation Language Statements · 7 leccionesUNIDAD 4 - Data Manipulation Language Statements
UNIDAD 4 - Data Manipulation Language Statements
- Inserting Data
- Updating Data
- Deleting and Truncating Data
- Merging and Upserting Data
- Create a SELECT Statement Using Aggregate Functions
- Filter Aggregated Results
- Data Manipulation Language Quiz
UNIDAD 5 - Arrays and Structs · 5 leccionesUNIDAD 5 - Arrays and Structs
UNIDAD 5 - Arrays and Structs
- Querying and Unnesting Arrays
- Array Functions
- Querying Structs
- Querying Arrays of Structs
- Arrays and Structs Quiz
UNIDAD 6 - SQL Math and Cast Functions · 9 leccionesUNIDAD 6 - SQL Math and Cast Functions
UNIDAD 6 - SQL Math and Cast Functions
- Basic Math Functions
- Sample Data for Numeric Functions
- ABS and SIGN Functions
- SQRT and POWER Functions
- RAND and MOD Functions
- Safe Operations
- Casting Data Types
- SQL Math and Casting Functions Quiz
- Randomly select rows from a table.
UNIDAD 7 - Date and Time Functions · 5 leccionesUNIDAD 7 - Date and Time Functions
UNIDAD 7 - Date and Time Functions
- Date Functions
- Datetime Functions
- Time Functions
- Timestamp Functions
- Date and Time Function Quiz
UNIDAD 8 - Statistical Aggregate Functions · 4 leccionesUNIDAD 8 - Statistical Aggregate Functions
UNIDAD 8 - Statistical Aggregate Functions
- Pearson Correlation with the CORR Function
- Calculating Covariance with COVAR Function
- Calculating Standard Deviation with STDDEV Functions
- Statistical Aggregation Functions
UNIDAD 9 - String Functions · 7 leccionesUNIDAD 9 - String Functions
UNIDAD 9 - String Functions
- Basic String Functions
- Trimming and Padding
- Splitting Delimited Strings
- Working with Substrings
- Matching with Regular Expressions
- Write a SQL statement to split a string on a delimeter.
- Working with Strings Quiz
UNIDAD 10 - Window Functions · 6 leccionesUNIDAD 10 - Window Functions
UNIDAD 10 - Window Functions
- Introduction to Window Functions
- Lead and Lag Functions
- First Values Functions
- Numbering Functions
- Moving Average Functions
- Window Functions Quiz
UNIDAD 11 - Access Controls in BigQuery · 4 leccionesUNIDAD 11 - Access Controls in BigQuery
UNIDAD 11 - Access Controls in BigQuery
- BigQuery and Identity and Access Management (IAM)
- Column Level Access Contols
- Row Level Security
- Access Controls in BigQuery Quiz
UNIDAD 12 - Cost Control and Query Performance Tips · 3 leccionesUNIDAD 12 - Cost Control and Query Performance Tips
UNIDAD 12 - Cost Control and Query Performance Tips
- Query Performance Tips
- Cost Control Options
- Cost Control and Query Performance Tips
UNIDAD 13 - Conclusion · 1 leccionesUNIDAD 13 - Conclusion
UNIDAD 13 - Conclusion
- Next Steps
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
13 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
18 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Dan Sullivan.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 13 unidades · 76 lecciones · 60 h
- 12 meses de acceso
- 18 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Dan Sullivan; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
