SQL and Data Visualization - The Complete Bootcamp
What you'll learn
- SQL
- Business Intelligence
- Data Analysis
- Data Visualization
- PostgreSQL
- SQL Language
- sql
- Metabase
Course content
Introduction to this SQL & Data Viz course1 lecture • 2min
- Who am I and what will you learn in this cours?Preview02:11
Create Your First Database & Data Set11 lectures • 1hr 13min
Learn SQL Basics From Scratch12 lectures • 47min
Improve your SQL skills & start doing Data Visualization9 lectures • 46min
Advanced SQL - From newbie to expert10 lectures • 1hr 4min
SQL, Level Expert!9 lectures • 55min
BONUS - Cohort Analysis & World Map2 lectures • 38min
Requirements
- Have a computer
Description
In this course you will learn how to write and execute SQL queries on your own database. Starting with basic SQL, we will learn how to use PostgreSQL to make advanced data analysis, graphs, reports and tables.
Who should attend this SQL and Data Viz course?
You who are dependent on Business Analysts to create Reports
You who are limited to Excel or Spreadsheet for your data analyses
You who would like to do some in-depth analysis and blow your boss or client away
You're the one who always said, "I need to learn SQL!"
You who find your business analysis dull and graphless.
Why learn SQL?
Whether you are a Marketer, Product Marketer, Developer, Sales or Manager, SQL is one of the most sought-after skills in the job market. This extraordinary skill takes your CV into another world, the world of autonomy and rigor in your reporting.
To learn SQL and Data Viz, you don't need to have a "Business Analyst" career plan. This skill will serve you in all areas, just like some tools such as Excel or Google Spreadsheet have served you well. The only difference? SQL is much more advanced than these!
Become an expert in data visualization
You'll learn how to become a business analyst and produce reports that are as visual as they are effective. In just a few clicks, create your own PostgreSQL database and connect the best tools to make your analyses dynamic, attractive and orderly. You can then create your own charts, histograms, curves and world maps for specific business situations.
Learn SQL from A to Z
SQL will have no secrets from you. Of course, we'll go over the basics. Then, you'll even become an expert as you get more and more powerful as you watch the videos.
CASE
WHEN 'become better in analysis' THEN 'join this course'
ELSE 'keep working on Excel'
END AS expert_sql_and_data_viz
The tools you will master
- Metabase, the perfect data visualization tool to run your data analysis
- Heroku, to host your database
- PGAdmin, to create your database and data set
Why is this course different from the others?
1- You will apply SQL in real business cases that you will be able to reuse
2- You will work on your own database
3- You will create your own graphs in a few minutes
4- You will progress step by step in the SQL language
5- I will answer all your questions in a few minutes
Anyway, I just wanted to tell you that I'm not from the Data world. I'm a Marketing Manager who got tired of doing his reports in Excel and wanted to take it to the next level by learning SQL! So, if I did it, you can do it.
So, join me in this course "SQL & Data Visualization: the complete guide", and don't hesitate to leave a note if you like this course ✌️
Raffi
Who this course is for:
- People who want to improve their reporting and analysis
- People who want to learn SQL
- Marketing Manager who wants to improve business analysis
- Product Marketer who wants to learn SQL to improve a Product
- Anyone who wants to get rid of Excel or Spreadsheet to do an analysis
Instructor
![Raffi Sarkissian | SQL | PostgreSQL | Metabase](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.7 Instructor Rating
- 42 Reviews
- 197 Students
- 2 Courses
Bonjour,
Je suis Raffi Sarkissian, Head of Monetization & Business Intelligence chez Qonto, une fintech de 200 personnes ayant réalisé 104 Millions d'euros de levée de fonds.
Je manage une équipe de data analysts. Cela m'a permis d'installer ou d'utiliser des outils de data visualisation puissants comme Metabase ou Tableau et de travailler sur des bases Postgresql ou des Warehouses comme Snowflake.
Mon expertise me permet d'enseigner aux débutants l'art du SQL et de la data analyse de manière simple, ludique et en plusieurs étapes :
1- L'installation d'une base de données sur PGAdmin, d'un outil de data visualisation avec Metabase et d'un serveur avec Heroku.
2- Les bases du SQL
3- La construction de graphs et de dashboards BI pour un premier pas dans le monde de la data visualisation
4- Du SQL avancé pour répondre à des besoins business (cohorts, mediane, quartiles, génération de séries etc...)
Avec tous mes remerciements
Bien à vous
Raffi