We may earn an affiliate commission when you visit our partners.
Google Cloud Training
"O terceiro curso desta série é ""Achieving Advanced Insights with BigQuery"". Para continuar desenvolvendo seus conhecimentos sobre SQL, vamos aprender a usar funções avançadas e dividir uma consulta completa em etapas gerenciáveis.
Você também vai conhecer a arquitetura interna do BigQuery (armazenamento fragmentado com base em colunas) e tópicos avançados do SQL, como campos aninhados e repetidos usando matrizes e structs. Por fim, vamos aprender a otimizar consultas para melhorar o desempenho e a proteger seus dados com visualizações autorizadas.
Read more
"O terceiro curso desta série é ""Achieving Advanced Insights with BigQuery"". Para continuar desenvolvendo seus conhecimentos sobre SQL, vamos aprender a usar funções avançadas e dividir uma consulta completa em etapas gerenciáveis.
Você também vai conhecer a arquitetura interna do BigQuery (armazenamento fragmentado com base em colunas) e tópicos avançados do SQL, como campos aninhados e repetidos usando matrizes e structs. Por fim, vamos aprender a otimizar consultas para melhorar o desempenho e a proteger seus dados com visualizações autorizadas.
Read more
"O terceiro curso desta série é ""Achieving Advanced Insights with BigQuery"". Para continuar desenvolvendo seus conhecimentos sobre SQL, vamos aprender a usar funções avançadas e dividir uma consulta completa em etapas gerenciáveis.
Você também vai conhecer a arquitetura interna do BigQuery (armazenamento fragmentado com base em colunas) e tópicos avançados do SQL, como campos aninhados e repetidos usando matrizes e structs. Por fim, vamos aprender a otimizar consultas para melhorar o desempenho e a proteger seus dados com visualizações autorizadas.
Depois de concluir este curso, inscreva-se no ""Applying Machine Learning to Your Data with Google Cloud""."
Register for this course and see more details by visiting:
OpenCourser.com/course/ejlmw4/achieving
What's inside
Syllabus
Introdução
Entender os objetivos do curso
Funções e cláusulas avançadas
Aprofunde seus conhecimentos sobre o SQL no BigQuery aprendendo funções mais avançadas, como aproximações estatísticas, consultas de janela analítica, funções definidas pelo usuário e cláusulas WITH.
Read more
Syllabus
Introdução
Entender os objetivos do curso
Funções e cláusulas avançadas
Aprofunde seus conhecimentos sobre o SQL no BigQuery aprendendo funções mais avançadas, como aproximações estatísticas, consultas de janela analítica, funções definidas pelo usuário e cláusulas WITH.
Read more
Criação de esquemas e estruturas de dados aninhados
Confira a evolução da forma como os bancos de dados tradicionais lidam com a escala e compare como o BigQuery foi criado para solucionar as limitações de escalonamento. Conheça em detalhes os campos aninhados e repetidos, que são uma parte importante das estruturas de dados desnormalizadas do BigQuery.
Como otimizar para desempenho
Conheça as tarefas fundamentais que afetam o desempenho do BigQuery e como otimizar suas consultas para que fiquem mais rápidas.
Insights avançados com o Vertex AI Workbench
Apresentamos o Vertex AI Workbench, uma ferramenta essencial para cientistas de dados que permite a colaboração entre analistas usando notebooks escalonáveis na nuvem.
Acesso aos dados
Proteger e compartilhar seus bancos de dados do BigQuery é essencial para qualquer organização. Saiba quais ferramentas do Google Cloud e do BigQuery estão disponíveis para você controlar as permissões e compartilhar seus dados.
Resumo do curso
Resumo dos principais pontos de aprendizado do curso
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Ensina funções e cláusulas avançadas do SQL, indispensáveis para aprofundar o conhecimento em SQL no BigQuery
Destina-se a cientistas de dados, pois aborda o Vertex AI Workbench, ferramenta essencial que viabiliza a colaboração entre analistas com o auxílio de notebooks escalonáveis na nuvem
Ensina a otimizar consultas para melhorar o desempenho do BigQuery, uma habilidade essencial para profissionais que trabalham com grandes conjuntos de dados
Save this course
Save Achieving Advanced Insights with BigQuery - Português 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 Achieving Advanced Insights with BigQuery - Português with these
activities:
Review SQL syntax
Show steps
Refresh your memory on the basic syntax and commands used in SQL, which will form the backbone of the queries you will build in this course.
Browse courses on
SQL
Show steps
-
Go through your notes or a SQL tutorial.
-
Practice writing simple queries.
Complete the BigQuery Quickstart
Show steps
Set up your development environment and familiarize yourself with the basics of BigQuery by completing the official Quickstart, providing a solid foundation for your journey in this course.
Browse courses on
BigQuery
Show steps
-
Follow the steps outlined in the BigQuery Quickstart guide
-
Create a BigQuery dataset and table.
-
Load sample data into the table.
Discussion Forum on BigQuery Best Practices
Show steps
Engage with fellow learners to share experiences, discuss challenges, and learn from each other's insights on best practices for using BigQuery.
Show steps
-
Join the discussion forum and introduce yourself.
-
Ask questions and share your experiences with BigQuery.
-
Participate in discussions and provide feedback to others.
11 other activities
Expand to see all activities and additional details
Show all 14 activities
Tutorial: How to Create your First Matrix in BigQuery
Show steps
Prepare for this topic by watching this comprehensive tutorial on how to use BigQuery to create and use matrices.
Browse courses on
Structured Data
Show steps
-
Watch the tutorial video.
-
Create a new BigQuery dataset and table.
-
Load data into your table using a matrix format.
-
Write a query to retrieve data from your matrix table.
-
Optional: Explore additional resources on BigQuery matrices.
Connect with BigQuery experts
Show steps
Expand your professional network by attending industry events or joining online communities where you can connect with individuals who have expertise in BigQuery.
Browse courses on
BigQuery
Show steps
-
Identify industry events or online communities focused on BigQuery.
-
Attend events or join the communities.
-
Introduce yourself to others and share your interests in BigQuery.
Use BigQuery's UDFs to Enhance Data Analysis
Show steps
Familiarize yourself with User Defined Functions in BigQuery. They help extend SQL capabilities, making it easier to analyze and process data.
Browse courses on
User Defined Functions
Show steps
-
Learn the syntax and usage of UDFs in BigQuery.
-
Explore examples of UDFs for common data manipulation tasks.
-
Practice creating and using UDFs in your own BigQuery queries.
Complete the BigQuery sandbox tutorial
Show steps
Get hands-on experience using BigQuery through Google's interactive sandbox tutorial, which will provide a solid foundation for the practical components of this course.
Browse courses on
BigQuery
Show steps
-
Sign up for a free trial of Google Cloud Platform.
-
Follow the steps in the BigQuery sandbox tutorial.
-
Experiment with different queries and data visualizations.
Visualize Insights Using BigQuery and Data Studio
Show steps
Gain hands-on experience in creating compelling data visualizations. This helps you effectively communicate insights and trends derived from BigQuery analysis.
Browse courses on
Data Visualization
Show steps
-
Explore different types of charts and graphs suitable for various data types.
-
Connect BigQuery to Data Studio and create interactive dashboards.
-
Share your visualizations with stakeholders and gather feedback.
Form a study group
Show steps
Enhance your learning experience by collaborating with peers, discussing course concepts, and working together on assignments.
Show steps
-
Identify fellow students who are taking the same course.
-
Schedule regular meetings to discuss course material.
-
Work together on assignments and projects.
Solve SQL practice problems
Show steps
Reinforce your understanding of SQL by working through practice problems that challenge you to write efficient and effective queries.
Browse courses on
SQL
Show steps
-
Find online SQL practice problems or use a resource like HackerRank.
-
Attempt to solve the problems on your own.
-
Review your solutions and identify areas for improvement.
Attend a BigQuery workshop
Show steps
Deepen your knowledge of BigQuery by attending a workshop led by experienced practitioners, providing opportunities for hands-on learning and expert guidance.
Browse courses on
BigQuery
Show steps
-
Research and find a BigQuery workshop that aligns with your interests.
-
Register and attend the workshop.
-
Actively participate and engage with the instructors and other attendees.
SQL Challenges for Data Wrangling in BigQuery
Show steps
Develop your SQL proficiency by tackling data wrangling challenges. This will enhance your ability to transform, clean, and prepare data for analysis.
Show steps
-
Solve a series of SQL puzzles involving data cleaning, aggregation, and transformation.
-
Optimize your SQL queries for better performance.
-
Discuss your solutions with peers to gain alternative perspectives.
Data Analysis Project Using BigQuery
Show steps
Work on a comprehensive data analysis project. This allows you to apply the skills you've learned to solve real-world business problems.
Browse courses on
Data-Driven Decision Making
Show steps
-
Define a clear problem statement and research relevant data sources.
-
Use BigQuery to extract, transform, and analyze the data.
-
Develop insights and recommendations based on your findings.
-
Present your project to a group of stakeholders.
Develop a case study using BigQuery
Show steps
Demonstrate your proficiency by developing a case study that leverages BigQuery to solve a real-world data analysis problem.
Browse courses on
BigQuery
Show steps
-
Identify a problem or question that can be addressed using data.
-
Gather and prepare the necessary data using BigQuery.
-
Write SQL queries to analyze the data and draw insights.
-
Present your findings in a clear and concise manner.
Review SQL syntax
Show steps
Refresh your memory on the basic syntax and commands used in SQL, which will form the backbone of the queries you will build in this course.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Go through your notes or a SQL tutorial.
- Practice writing simple queries.
Complete the BigQuery Quickstart
Show steps
Set up your development environment and familiarize yourself with the basics of BigQuery by completing the official Quickstart, providing a solid foundation for your journey in this course.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Follow the steps outlined in the BigQuery Quickstart guide
- Create a BigQuery dataset and table.
- Load sample data into the table.
Discussion Forum on BigQuery Best Practices
Show steps
Engage with fellow learners to share experiences, discuss challenges, and learn from each other's insights on best practices for using BigQuery.
Show steps
Show steps
Show steps
- Join the discussion forum and introduce yourself.
- Ask questions and share your experiences with BigQuery.
- Participate in discussions and provide feedback to others.
11 other activities
Expand to see all activities and additional details
Show all 14 activities
Tutorial: How to Create your First Matrix in BigQuery
Show steps
Prepare for this topic by watching this comprehensive tutorial on how to use BigQuery to create and use matrices.
Browse courses on
Structured Data
Show steps
Show steps
Show steps
- Watch the tutorial video.
- Create a new BigQuery dataset and table.
- Load data into your table using a matrix format.
- Write a query to retrieve data from your matrix table.
- Optional: Explore additional resources on BigQuery matrices.
Connect with BigQuery experts
Show steps
Expand your professional network by attending industry events or joining online communities where you can connect with individuals who have expertise in BigQuery.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Identify industry events or online communities focused on BigQuery.
- Attend events or join the communities.
- Introduce yourself to others and share your interests in BigQuery.
Use BigQuery's UDFs to Enhance Data Analysis
Show steps
Familiarize yourself with User Defined Functions in BigQuery. They help extend SQL capabilities, making it easier to analyze and process data.
Browse courses on
User Defined Functions
Show steps
Show steps
Show steps
- Learn the syntax and usage of UDFs in BigQuery.
- Explore examples of UDFs for common data manipulation tasks.
- Practice creating and using UDFs in your own BigQuery queries.
Complete the BigQuery sandbox tutorial
Show steps
Get hands-on experience using BigQuery through Google's interactive sandbox tutorial, which will provide a solid foundation for the practical components of this course.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Sign up for a free trial of Google Cloud Platform.
- Follow the steps in the BigQuery sandbox tutorial.
- Experiment with different queries and data visualizations.
Visualize Insights Using BigQuery and Data Studio
Show steps
Gain hands-on experience in creating compelling data visualizations. This helps you effectively communicate insights and trends derived from BigQuery analysis.
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Explore different types of charts and graphs suitable for various data types.
- Connect BigQuery to Data Studio and create interactive dashboards.
- Share your visualizations with stakeholders and gather feedback.
Form a study group
Show steps
Enhance your learning experience by collaborating with peers, discussing course concepts, and working together on assignments.
Show steps
Show steps
Show steps
- Identify fellow students who are taking the same course.
- Schedule regular meetings to discuss course material.
- Work together on assignments and projects.
Solve SQL practice problems
Show steps
Reinforce your understanding of SQL by working through practice problems that challenge you to write efficient and effective queries.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Find online SQL practice problems or use a resource like HackerRank.
- Attempt to solve the problems on your own.
- Review your solutions and identify areas for improvement.
Attend a BigQuery workshop
Show steps
Deepen your knowledge of BigQuery by attending a workshop led by experienced practitioners, providing opportunities for hands-on learning and expert guidance.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Research and find a BigQuery workshop that aligns with your interests.
- Register and attend the workshop.
- Actively participate and engage with the instructors and other attendees.
SQL Challenges for Data Wrangling in BigQuery
Show steps
Develop your SQL proficiency by tackling data wrangling challenges. This will enhance your ability to transform, clean, and prepare data for analysis.
Show steps
Show steps
Show steps
- Solve a series of SQL puzzles involving data cleaning, aggregation, and transformation.
- Optimize your SQL queries for better performance.
- Discuss your solutions with peers to gain alternative perspectives.
Data Analysis Project Using BigQuery
Show steps
Work on a comprehensive data analysis project. This allows you to apply the skills you've learned to solve real-world business problems.
Browse courses on
Data-Driven Decision Making
Show steps
Show steps
Show steps
- Define a clear problem statement and research relevant data sources.
- Use BigQuery to extract, transform, and analyze the data.
- Develop insights and recommendations based on your findings.
- Present your project to a group of stakeholders.
Develop a case study using BigQuery
Show steps
Demonstrate your proficiency by developing a case study that leverages BigQuery to solve a real-world data analysis problem.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Identify a problem or question that can be addressed using data.
- Gather and prepare the necessary data using BigQuery.
- Write SQL queries to analyze the data and draw insights.
- Present your findings in a clear and concise manner.
Career center
Learners who complete Achieving Advanced Insights with BigQuery - Português will develop knowledge and skills
that may be useful to these careers:
Data Scientist
Data Scientist
Data Scientists use data to solve business problems. They use a variety of techniques, including data analysis, machine learning, and artificial intelligence. This course can help you develop the skills you need to succeed as a Data Scientist by teaching you how to use BigQuery to perform data analysis tasks. You will learn how to use advanced SQL functions and clauses, how to create nested and repeated data structures, and how to optimize your queries for performance.
Machine Learning Engineer
Machine Learning Engineer
Machine Learning Engineers build and maintain machine learning models that can be used to automate tasks and make predictions. This course can help you develop the skills you need to succeed as a Machine Learning Engineer by teaching you how to use BigQuery to train and deploy machine learning models. You will learn how to use Vertex AI Workbench, a tool that makes it easy to collaborate on machine learning projects.
Data Analyst
Data Analyst
Data Analysts use data to identify trends, patterns, and insights that can help businesses make better decisions. This course can help you develop the skills you need to succeed as a Data Analyst by teaching you how to use BigQuery to perform data analysis tasks. You will learn how to use advanced SQL functions and clauses, how to create nested and repeated data structures, and how to optimize your queries for performance.
Data Engineer
Data Engineer
Data Engineers are responsible for designing, building, and maintaining data pipelines that collect, transform, and store data for analysis. This course can help you develop the skills you need to succeed as a Data Engineer by teaching you how to use BigQuery to perform data analysis and machine learning tasks. You will learn how to optimize your queries for performance and how to protect your data with authorized views.
Database Administrator
Database Administrator
Database Administrators are responsible for managing and maintaining databases. They ensure that databases are available, secure, and performant. This course can help you develop the skills you need to succeed as a Database Administrator by teaching you how to use BigQuery to manage and maintain data. You will learn how to create and manage tables, indexes, and views. You will also learn how to monitor and troubleshoot database performance.
Business Analyst
Business Analyst
Business Analysts use data to help businesses make better decisions. They use a variety of techniques, including data analysis, financial analysis, and market research. This course can help you develop the skills you need to succeed as a Business Analyst by teaching you how to use BigQuery to perform data analysis tasks. You will learn how to use advanced SQL functions and clauses, how to create nested and repeated data structures, and how to optimize your queries for performance.
Data Architect
Data Architect
Data Architects design and build data systems that meet the needs of businesses. They work with stakeholders to understand business requirements and then design systems that can meet those requirements. This course can help you develop the skills you need to succeed as a Data Architect by teaching you about the architecture of BigQuery. You will learn how BigQuery stores and processes data, and how to design data systems that can take advantage of BigQuery's features.
Data Integration Engineer
Data Integration Engineer
Data Integration Engineers design and build systems that integrate data from different sources. They work with stakeholders to understand business requirements and then design systems that can meet those requirements. This course can help you develop the skills you need to succeed as a Data Integration Engineer by teaching you how to use BigQuery to integrate data from different sources. You will learn how to use BigQuery's connectors to connect to different data sources, and how to use BigQuery's data blending features to combine data from different sources.
Database Developer
Database Developer
Database Developers design and build databases. They work with stakeholders to understand business requirements and then design databases that can meet those requirements. This course can help you develop the skills you need to succeed as a Database Developer by teaching you how to use BigQuery to design and build databases. You will learn how to create and manage tables, indexes, and views. You will also learn how to monitor and troubleshoot database performance.
Statistician
Statistician
Statisticians use data to understand the world around us. They use a variety of techniques, including data analysis, probability, and inference. This course can help you develop the skills you need to succeed as a Statistician by teaching you how to use BigQuery to perform data analysis tasks. You will learn how to use advanced SQL functions and clauses, how to create nested and repeated data structures, and how to optimize your queries for performance.
Software Engineer
Software Engineer
Software Engineers design, build, and maintain software applications. They work on a variety of projects, from small to large, and from simple to complex. This course can help you develop the skills you need to succeed as a Software Engineer by teaching you how to use BigQuery to store and process data. You will learn how to use SQL to query data, and how to use BigQuery's machine learning features to build predictive models.
Data Warehouse Architect
Data Warehouse Architect
Data Warehouse Architects design and build data warehouses that store and process data for analysis. They work with stakeholders to understand business requirements and then design systems that can meet those requirements. This course can help you develop the skills you need to succeed as a Data Warehouse Architect by teaching you about the architecture of BigQuery. You will learn how BigQuery stores and processes data, and how to design data warehouses that can take advantage of BigQuery's features.
For more career information including salaries, visit:
OpenCourser.com/course/ejlmw4/achieving
Reading list
We've selected ten 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
Achieving Advanced Insights with BigQuery - Português.
Provides a comprehensive overview of data science techniques, including data wrangling, exploratory data analysis, machine learning, and visualization techniques. It covers both fundamental principles and advanced topics, making it a valuable resource for both beginners and experienced practitioners.
Provides a comprehensive overview of Gaussian processes, including data wrangling, exploratory data analysis, machine learning, and visualization techniques. It covers both fundamental principles and advanced topics, making it a valuable resource for both beginners and experienced practitioners.
Provides a comprehensive overview of statistical learning techniques, including data wrangling, exploratory data analysis, machine learning, and visualization techniques. It covers both fundamental principles and advanced topics, making it a valuable resource for both beginners and experienced practitioners.
Provides a comprehensive overview of machine learning techniques, including data wrangling, exploratory data analysis, machine learning, and visualization techniques. It covers both fundamental principles and advanced topics, making it a valuable resource for both beginners and experienced practitioners.
Save
Provides a comprehensive overview of data mining techniques, including data wrangling, exploratory data analysis, machine learning, and visualization techniques. It covers both fundamental principles and advanced topics, making it a valuable resource for both beginners and experienced practitioners.
Save
Provides a comprehensive overview of deep learning techniques, including data wrangling, exploratory data analysis, machine learning, and visualization techniques. It covers both fundamental principles and advanced topics, making it a valuable resource for both beginners and experienced practitioners.
Provides a comprehensive overview of probabilistic graphical models, including data wrangling, exploratory data analysis, machine learning, and visualization techniques. It covers both fundamental principles and advanced topics, making it a valuable resource for both beginners and experienced practitioners.
Provides a comprehensive introduction to Hadoop, the open-source framework for distributed computing. It covers both fundamental principles and advanced topics, making it a valuable resource for both beginners and experienced practitioners.
Provides a comprehensive introduction to Spark, the open-source framework for distributed computing. It covers both fundamental principles and advanced topics, making it a valuable resource for both beginners and experienced practitioners.
Provides a practical introduction to data science for business professionals. It covers data wrangling, exploratory data analysis, machine learning, and visualization techniques, and shows how to use these techniques to solve real-world business problems.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/ejlmw4/achieving
Share
Similar courses
Here are nine courses similar to
Achieving Advanced Insights with BigQuery - Português.
Next.js e React - Curso Completo - Aprenda com Projetos
OpenCourser.com/course/0ftj1l/next
Next.js e React - Curso Completo - Aprenda com Projetos
Most relevant
Creating BigQuery Datasets, Visualizing Insights - Português
OpenCourser.com/course/fvltzl/creating
Creating BigQuery Datasets, Visualizing Insights -...
Most relevant
ML Pipelines on Google Cloud - Português
OpenCourser.com/course/i0amm9/ml
ML Pipelines on Google Cloud - Português
Most relevant
Exploring and Preparing Your Data with BigQuery - Português
OpenCourser.com/course/fm6vvt/exploring
Exploring and Preparing Your Data with BigQuery -...
Most relevant
Applying Machine Learning to Your Data with GC - Português
OpenCourser.com/course/ucjnhb/applying
Applying Machine Learning to Your Data with GC - Português
Most relevant
Aprendendo a aprender: ferramentas mentais poderosas para ajudá-lo a dominar assuntos difíceis (em Português) [Learning How to Learn]
OpenCourser.com/course/p52osc/aprendendo
Aprendendo a aprender: ferramentas mentais poderosas para...
Most relevant
Machine Learning in the Enterprise - Português Brasileiro
OpenCourser.com/course/td51cf/machine
Machine Learning in the Enterprise - Português Brasileiro
Most relevant
Managing Google Workspace - Português Brasileiro
OpenCourser.com/course/4wqdyn/managing
Managing Google Workspace - Português Brasileiro
Most relevant
Curso Tempero é Para Todo Mundo!
OpenCourser.com/course/w8igr8/curso
Curso Tempero é Para Todo Mundo!
Most relevant
Effort
1 週間の学習（5～7 時間/週）
Level
Introductory
Via
Coursera
Institution
Google Cloud
Instructor
Google Cloud Training
Language
Português
Transcript
English
Good to know
Ensina funções e cláusulas avançadas do SQL, indispensáveis para aprofundar o conhecimento em SQL no BigQuery
Destina-se a cientistas de dados, pois aborda o Vertex AI Workbench, ferramenta essencial que viabiliza a colaboração entre analistas com o auxílio de notebooks escalonáveis na nuvem
Ensina a otimizar consultas para melhorar o desempenho do BigQuery, uma habilidade essencial para profissionais que trabalham com grandes conjuntos de dados
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