Course Overview
In the Data to Insights course series, this is the second course. Here, we'll go over how to add fresh external datasets to BigQuery and use Google Data Studio to display them. We'll also go over advanced SQL techniques like multi-table JOINs and UNIONS, which let you evaluate data from several sources.
Even if you have experience with SQL, you might not be familiar with BigQuery nuances (such managing query cache and table wildcards).
Enroll in the Achieving Advanced Insights with BigQuery course after finishing this one.
The emblem that is shown above can be yours if you've finished this course! Visit your profile page to see all the badges you have earned. By showcasing your acquired talents to the world, you can advance your cloud career.
Prerequisites
To get the most advantage out of this specialization, we recommend participants have some experience with ANSI SQL.
Audience Profile
- Data Analysts
- Business Analysts
- Business Intelligence professionals and Cloud Data Engineers will partner with Data Analysts to build scalable data solutions on Google Cloud.
Learning Objectives
- Build new permanent and temporary tables from your query results
- Load and create new datasets inside BigQuery
- Differentiate between SQL JOINs and UNIONs and when to use each
- Create dashboards and visualizations with Google Data Studio
Content Outline
Overview of what you will learn in this course
Create new permanent and temporary tables from your query results
Load and create new datasets inside BigQuery
Understand the differences between SQL JOINs and UNIONs and when to use each
Understand the differences between SQL JOINs and UNIONs and when to use each
Create dashboards and visualizations with Google Data Studio
Summary of the course ley learning points
FAQs
A: You may analyse your data using a variety of analytics and business intelligence tools that interface with BigQuery, such as Looker Studio, in addition to performing queries in BigQuery. You may start Looker Studio right away from BigQuery in the Google Cloud dashboard after you've done a query.
A: A BigQuery table contains individual records organized in rows. Each paper is composed of columns (also called fields). Every table is defined by a schema that describes the column names, data types, and other information.
A: Google Standard SQL dialect
In addition to supporting Google Standard SQL, BigQuery also offers support for ancient SQL. Google Standard SQL should be used if you are new to BigQuery as it covers the most capabilities. For instance, only Google Standard SQL can implement capabilities like DDL and DML commands.
A: Radiant has highly intensive selection criteria for Technology Trainers & Consultants who deliver training programs. Our trainers & consultants undergo a rigorous technical and behavioral interview and assessment process before they are onboarded in the company.
Our Technology experts/trainers & consultants carry deep-dive knowledge in the technical subject & are certified by the OEM.
Our training programs are practically oriented with 70% – 80% hands-on training technology tools. Our training program focuses on one-on-one interaction with each participant, the latest content in the curriculum, real-time projects, and case studies during the training program.
Our faculty will quickly provide you with the knowledge of each course from the fundamental level, and you are free to ask your doubts at any time from your respective faculty.
Our trainers have the patience and ability to explain complex concepts simplistically with depth and width of knowledge.
To ensure quality learning, we provide support sessions even after the training program.
A: To attend the training session, you should have operational Desktops or Laptops with the required specification and a good internet connection to access the labs.
A: We recommend you attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, if, due to some contingency, you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.
A: Radiant Techlearning has a data center containing a Virtual Training environment for participants’ hand-on-practice.
Participants can easily access these labs over Cloud with the help of a remote desktop connection.
Radiant virtual labs allow you to learn from anywhere and in any time zone.
A: The learners will be enthralled as we engage them in the natural world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and give you a better experience. These real-time projects will help you a lot in your future tasks and assignments.