EN 
FR Powered by ARTEFACT
SQL & BigQuery Advanced
Improve your skills
Deepen your SQL skills with this advanced training course on BigQuery. Optimise the performance and cost of your queries while improving your data manipulation and cleansing techniques.
SQL & BigQuery Advanced
On request
Choose your session
Course description
This intensive one-day course is designed for users with a basic understanding of SQL and BigQuery who want to take their skills to the next level. You will learn advanced techniques for joins, aggregation and query optimisation to maximise performance and minimise costs.
Objectives
On completion of this course, you will be able to :
Develop your mastery of SQL applied to BigQuery
Improve your data handling and cleansing skills
Optimise the performance and profitability of your SQL queries
Public
This course is designed for a group of 15 participants, ideal for professionals with basic knowledge of SQL who want to deepen their expertise in BigQuery.
Prerequisites
A recent computer (less than 5 years old).
An active Google Account.
Evaluation
–
SQL & BigQuery Advanced
1. ADVANCED ENRICHMENT AND AGGREGATION
1 hour 30 minutes
Key concepts of SQL and BigQuery
Various data aggregation methods such as GROUP BY and window functions
Calculate moving averages, lagged values, rankings and other business KPIs using the window functions
2. DATA CLEANSING AND MANIPULATION
2 hours
Using CASE WHEN for data filtering
Management of NULL values and NORMALIZE function for normalising character strings
Using regexes and string functions for pattern matching
Simplify data cleansing with BigQuery's user-defined functions
3. DATE AND TIME MANAGEMENT
1 hour 30 minutes
Using the PARSE_DATE and PARSE_DATETIME functions to analyse dates
Formatting dates with FORMAT_DATE and FORMAT_DATETIME
Extraction of date components using the EXTRACT function
Calculation of the time difference between dates and common operators for filtering on dates
4. OPTIMISING SQL QUERIES
2 hours
Understanding the basics of pricing in BigQuery
Reduce the amount of data queried with the EXCEPT instruction
Configuration of billing limits per request and quotas per project/user
Optimising queries with partitioned and clustered tables
Judicious use of views and materialized views, CTE and sub-queries
Like them, train your teams in data
Choose Artefact School of Data
to train your teams
Receive all the latest news from the School of Data.
Other training courses on the same theme
Up-skill your teams
FAQ
Do you have any other questions about Artefact School of Data? We'd love to hear from you.
What is the difference between Artefact School of Data and other courses?
World-renowned learning and a unique educational experience. More than 4,000 students worldwide have been trained by our Artefact business experts. You benefit from immersion training with one of the world leaders in Data, who will share his expertise with you. Every day, you will learn from real-life case studies carried out with some of the world's leading companies.
What is the training format?
You choose the format! Training can be face-to-face, distance learning or hybrid! Everything is designed so that you can follow the course from our classroom or from home, as you wish. We've made this choice to optimise your learning during the course.
What support is there to help you find a job?
Every day, our students have the opportunity to work alongside Artefact employeesone of the leaders in Data. This means that every day, they meet Data Scientists, Analysts and Engineers who make up their professional network and increase their chances of securing a future position with Artefact or with a partner.
Who are the teachers?
Your teachers are Data Scientists, Analysts or Senior Engineers by trade. This is very important to us, because they work at the very heart of one of the leaders in Data: Artefact. This means that the tutors are in daily contact with Artefact customers and are responding to real, topical issues in the field. Our training courses are therefore designed around what they experience on a daily basis.
How do I apply for the course?
The registration process is very simple: you apply directly for a course, explaining your choice and describing your career path. You can also download our full programme and then make an appointment with us.