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 5,000 students around the world have been trained by our experts atArtefact. You will benefit from immersion training with one of the world leaders in Data & AI, who will share their expertise with you. Every day, you'll learn from real-life cases you've worked on with some of the world's biggest companies.
How do I apply for our courses?
The registration process is very simple: you apply directly for the course of your choice, explaining your motivation and describing your career path. You can also download our full programme and make an appointment with our team.
How can I finance my training?
There are a number of funding solutions available to you: personal funding (in one or more instalments), use of your Personal Training Account (CPF), assistance from Pôle emploi, funding via your company's OPCO if you are in post, Professional Transition Project (PTP), Agefiph, etc. As each professional project and each funding application is unique, we offer you a personalised meeting to answer all your questions and help you through the process. You can also watch a video showing all the financing options available.
Are the courses face-to-face or distance learning?
We recommend taking the course face-to-face, in order to take full advantage of the learning environment within a leading player in Data and Artificial Intelligence, and to benefit from direct exchanges with the trainers and other participants.
However, for greater flexibility, our courses can also be taken at a distance or in a hybrid format. Every effort is made to ensure that you can participate in the best possible conditions, either from our classroom or from home, depending on your preference. This flexible format has been designed to optimise your learning throughout the course.
Who are the speakers at Artefact School of Data?
The lecturers at Artefact School of Data are senior Data Scientists, Data Analysts and Data Engineers. They all work forArtefactone of the world leaders in data. Thanks to their day-to-day work with Artefact's customers, they are confronted with the real and current issues faced by companies. This proximity to the field means that we can offer training that is rooted in the reality of data projects, built on their experience and the challenges they face every day.
Are our training courses Qualiopi certified?
Our training courses are certified "Qualiopi pour l'action de formation".
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 the data industry. This means that every day, they meet Data Scientists, Data Analysts, Data Engineers and Data Marketing experts, who make up their team. professional network and increase their chances of securing a future position with Artefact or from one of our partners.