SQL for Data Analysis

Fill out the form below and proceed to purchase.

Your data is safe.

Learn SQL theory and practice to work with databases and extract strategic insights, with real-world examples from the daily work of a data analyst.

13 modules

Online

About the course

The ESEG SQL for Data Analysis extension course teaches you to master the SQL language — the main tool for querying and manipulating databases — with a direct focus on the daily routine of a data analyst. You will learn everything from the fundamentals of relational databases to complex queries, with practical examples applied to the business environment.

Taught by an electrical engineer from Unicamp with a specialization in Data Science and experience as Head of Data, the course is structured progressively: you will solve problems of increasing complexity throughout the modules. By the end, you will be able to extract, filter, aggregate, and analyze data in relational databases, becoming a much more efficient professional in the data field.

labor market

SQL is the most widely used language in the data field and one of the most in-demand technical skills in the market. Data analysts, data scientists, data engineers, and BI professionals need to master SQL to perform their work efficiently—and this knowledge is required in virtually all data-related jobs.

Beyond the technology field, SQL has become a valued skill in business areas such as finance, marketing, operations, and human resources, where professionals who can extract data directly from information systems make faster and more informed decisions. Mastering SQL is the first concrete step towards a solid career in data analysis and science.

Course modules

What are relational databases, how do they work, and why is SQL the standard language for working with them? Environment setup and first commands: SELECT, FROM, WHERE.

Structure and organization of relational databases. Tables, columns, data types, primary and foreign keys. How to think in terms of relational data.

Fundamental SQL commands: SELECT, INSERT, UPDATE, DELETE. Basic syntax and best practices for writing clear and efficient queries.

Introduction to Google BigQuery as a cloud-based data analytics platform. How to run SQL queries on large volumes of data and integrate BigQuery into your analytical workflow.

In-depth exploration of essential commands: filtering with WHERE, sorting with ORDER BY, limiting results, and using logical and comparison operators.

How to use GROUP BY, HAVING, COUNT, SUM, AVG, MIN, and MAX to consolidate and summarize large volumes of data. Creating aggregate reports for business analysis.

SQL mathematical functions for numerical calculations: rounding, power, modulus, and statistical functions. How to perform mathematical operations directly in queries.

String manipulation with SQL: concatenation, substring extraction, case conversion, and text cleaning. How to handle and standardize text data in queries.

Work with dates and timestamps in SQL: extracting date parts, calculating ranges, formatting, and comparing periods. Essential for time series analysis.

Introduction to the geographic functions available in BigQuery. How to work with coordinates, calculate distances, and perform spatial analysis using SQL.

It explains how to combine data from different tables. It covers INNER JOIN, LEFT JOIN, and other variations.

Using subqueries to solve complex data analysis problems. Correlated and uncorrelated subqueries, within the WHERE, FROM, and SELECT clauses.

Window functions (ROW_NUMBER, RANK, LAG, LEAD, SUM OVER, AVG OVER) for advanced analysis without collapsing rows. Practical applications in rankings, time comparisons, and cumulative data.

Professor of the course

Caio Avelino

Holds a degree in Electrical Engineering from the State University of Campinas (Unicamp) with a specialization in Data Science from the Data Science Academy. Possesses practical experience as Head of Data, leading teams and data analysis projects in companies across various sectors. Combines a solid technical background with a strategic business vision.

Course value

12 installments of R$ 24.95

or R$ 250.00 cash

Frequently Asked Questions

Description

Professional Growth

Advance your career quickly and strategically.

At ESEG College, you can take short online courses focused on the skills most valued by the market.

Learn in a practical way, but with a solid foundation of knowledge, and be ready to seize new opportunities.

Who we are

Education for those who want to evolve with purpose and a vision for the future.

At ESEG College, we train professionals prepared for the real challenges of the market.

We combine a solid academic foundation, applied practice, and connections with companies to transform knowledge into a successful career.

We work from initial training to ongoing professional development, always focusing on innovation, employability, and human growth.

Testimonials

What they say about us

“I’ve been an entrepreneur for years, but I’ve always struggled to communicate the essence of my business. With the practical lessons and inspiring examples from the course, I gained a new perspective on how to tell stories to connect emotionally with my clients.”

Helena Martins

São Paulo

“I am a psychology student and I decided to complement my education with this course. I was impressed by the applicability of the information in both professional and personal contexts. I learned so much about the cognitive processes involved in purchasing decisions and now I can even better understand my own choices.”

Lucas Oliveira

Curitiba

“"Despite it being a complex topic, the professor managed to make it easy to understand. I learned data analysis techniques that I never imagined I could master, and now I feel prepared to face any challenge in the world of statistics."”