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 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.