EN 
FR 
Powered by ARTEFACT
SQL & BigQuery Beginner
Make the most of your data
Dive into the world of databases with SQL and BigQuery. At the end of the course, you'll be able to build analyses and reports, and extract and calculate KPIs from your customers' databases.
SQL & BigQuery Beginner
On request
Choose your session
Course description
This course gives you a complete introduction to SQL and the use of BigQuery, an essential data management tool for data warehousing. You will learn how to structure an SQL query, manipulate and analyse data to extract relevant insights, while respecting the best practices in the field.Objectives
On completion of this course, you will be able to :
Use SQL to extract and analyse data.
Understand and apply the main concepts of databases and data modelling.
Run queries in BigQuery to build your analyses and reports.
Public
This course is aimed at all audiences: Analytics, IT, Management, Business.Prerequisites
No prerequisites.Evaluation
–SQL & BigQuery Beginner
1. INTRODUCTION TO SQL & BIGQUERY
30 minutes
Key concepts of SQL and BigQuery
Introduction to the BigQuery interface and technologies
Discussion on data warehouses and the difference between structured and unstructured data
Relational models and entity-association relationship diagrams
A brief history of BigQuery, the language used by databases
2. SQL BASICS
1 hour
Understand what a query is and the fundamental concepts of the SQL language
Primary keywords and SQL language functions
Basic syntax for creating queries (SELECT, FROM, WHERE)
3. ADVANCED SQL QUERIES
2 hours
More in-depth knowledge of SQL queries with practical examples
Using ORDER BY, LIMIT and CASE statements
Techniques for applying SELECT & LIMIT to list the necessary data
Using DISTINCT to understand unique values
Filtering users by age using WHERE
Segmenting customers by age with CASE WHEN
4. SQL JOINTS
2 hours
Explanation of relational models and the importance of primary and foreign keys
Learn about the different types of JOIN (inner, outer, left, right) and their uses
Applying joins to combine data tables
Important considerations concerning joins to avoid common errors
5. SQL AGGREGATIONS
2 hours 30 minutes
Aggregating data with SQL functions
Grouping results with the GROUP BY query
Conditional filtering of groups using the HAVING query
Best formatting practices for indentation, comments, shortcuts, column order and joins
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.