SQL and Data Visualization - The Complete Bootcamp

Overview

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.

Syllabus

• Introduction to SQL and Databases
Overview of databases
Understanding relational database management systems (RDBMS)
Introduction to PostgreSQL
• Basics of SQL
Writing simple SELECT statements
Using WHERE clauses for filtering
Sorting results with ORDER BY
Eliminating duplicates with DISTINCT
• Querying Multiple Tables
Understanding JOIN operations
INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
Using UNION and UNION ALL
• Advanced SQL Queries
Aggregate functions: COUNT, SUM, AVG, MAX, MIN
GROUP BY and HAVING clauses
Subqueries and nested queries
• Data Manipulation and Management
INSERT, UPDATE, DELETE operations
Managing data integrity with constraints
Transactions and error handling
• Data Cleaning and Preparation
Identifying and fixing data errors
Using SQL functions for data transformation
Common table expressions (CTEs)
• Data Visualization with SQL
Basic data visualization principles
Using SQL to generate charts and graphs
Utilizing available visualization tools with PostgreSQL
• Reporting and Dashboards
Creating reports with SQL
Automating data reports generation
Integrating SQL with popular dashboard tools
• Performance Tuning in SQL
Indexing and optimizing queries
Understanding query plans and execution statistics
Best practices for writing efficient SQL queries
• Final Project
Designing and building a complete analysis workflow
Creating visualizations and reports from complex datasets
Presenting findings and insights using PostgreSQL and visualization tools
• Course Wrap-Up
Review of key concepts and skills
Additional resources and next steps in learning

Taught by

Raffi Sarkissian | SQL | PostgreSQL | Metabase

Subjects

Programming