Data with Charles

Back to Basics - SQL 06 - WHERE e HAVING

Charles De Barros, Dec 09, 2025, Back to basics Sql

Filtragem SQL com WHERE e HAVING (Com diagramas, ilustrações e desafios adicionais) Índice Visão Geral Entendendo WHERE O que é Agregação? HAVING filtra grupos agregados WHERE vs HAVING Quando Usar...

Back to Basics - SQL 06 - WHERE and HAVING

Charles De Barros, Dec 09, 2025, Back to basics Sql

SQL filtering with WHERE and HAVING (With diagrams, ilustrationsn and practice challenges) Table of Contents SQL Filtering with WHERE and HAVING Understanding WHERE What Is Aggregation? HAVING Filters Aggregated Groups...

Back to Basics - SQL 05 - ORDER BY and GROUP BY

Charles De Barros, Sep 16, 2025, Back to basics Sql

ORDER BY vs GROUP BY in SQL: A Complete Guide with Examples Table of Contents Introduction What is ORDER BY? Basic Syntax Beginner Example Intermediate Example Advanced Example What is...

Back to Basics - SQL 05 - ORDER BY e GROUP BY

Charles De Barros, Sep 02, 2025, Back to basics Sql

ORDER BY vs GROUP BY no SQL: Um Guia Completo com Exemplos Índice Introdução O que é ORDER BY? Sintaxe Básica Exemplo para Iniciantes Exemplo Intermediário Exemplo Avançado O que...

Back to Basics - SQL 04 - The ORDER BY keyword

Charles De Barros, Sep 02, 2025, Back to basics Sql

Photo by Markus Spiske on Unsplash Mastering SQL ORDER BY: Sorting Data Effectively When working with relational databases, retrieving data is only half the battle. Equally important is presenting that...

Back to Basics - SQL 04 - A cláusula ordenadora ORDER BY

Charles De Barros, Sep 02, 2025, Back to basics Sql

Foto cortesia de Markus Spiske no Unsplash Dominando o ORDER BY em SQL: Classificando Dados com Eficácia Ao trabalhar com bancos de dados relacionais, recuperar dados é apenas metade da...

Back to Basics - SQL 03 - The WHERE statement

Charles De Barros, Aug 26, 2025, Back to basics Sql

Photo by Bruno Wolff on Unsplash Mastering the SQL WHERE Statement: From Beginner to Advanced Structured Query Language (SQL) is the foundation of working with relational databases. Among its many...

Back to Basics - SQL 03 - O commando de restrição WHERE

Charles De Barros, Aug 26, 2025, Back to basics Sql

Foto cortesia de Bruno Wolff no Unsplash Dominando o comando de restrição WHERE: Do Básico ao Avançado A Linguagem de Consulta Estruturada (SQL) é a base do trabalho com bancos...

Back to Basics - SQL 02 - The SELECT statement

Charles De Barros, Aug 05, 2025, Back to basics Sql

Photo by Mitchel Lensink on Unsplash Understanding the SQL’s SELECT Statement: A Comprehensive Guide SQL (Structured Query Language) is the cornerstone of managing and querying data in relational databases. Among...

Back to Basics - SQL 02 - O Comando SELECT

Charles De Barros, Aug 05, 2025, Back to basics Sql Portuguese

Foto cortesia de Mitchel Lensink on Unsplash Entendendo o comando SELECT do SQL: Um Guia Abrangente SQL (Structured Query Language) é a base para gerenciar e consultar dados em bancos...

Back to Basics - SQL 01 - SQL Intro

Charles De Barros, Jul 21, 2025, Back to basics Sql

Mastering the Basics of SQL: A Beginner’s Guide to Structured Query Language In today’s data-driven world, understanding how to manage and retrieve data effectively is a highly valuable skill. Whether...

Back to Basics - Python 03

Charles De Barros, Apr 23, 2024, Back to basics Python

Better than sliced bread String slicing allows us to extract specific portions of a string by specifying a start and an end indices. We can even skip characters! How about...

Back to Basics - Pandas 02

Charles De Barros, Apr 16, 2024, Back to basics Pandas

One of the most common tasks we perform with Pandas is data indexing and selection. We do that pretty much daily. Let’s delve into the world of Pandas and explore...

Back to Basics - Python 02

Charles De Barros, Apr 10, 2024, Back to basics Python

The Numeric data type There are eight major data types in Python: Description Type Text str Numeric int, float, complex Sequence list, tuple, range Mapping dict Set set, frozenset Boolean...

Back to Basics - Pandas 01

Charles De Barros, Apr 09, 2024, Back to basics Pandas

Introduction to Pandas Pandas Official Documentation. What is Pandas? As per the Pandas Official Documentation website: Pandas is an open source, BSD-licensed library providing high-performance, easy-to-use data structures and data...

Back to Basics - Python 01

Charles De Barros, Apr 09, 2024, Back to basics Python

Intro It’s March 2024 and I have joined a Level 4 Data Analytics Bootcamp! Hurray! Technically lessons will only start at the beginning of April but I am already very...

Posts are showing from back to basics