Introdução ao SQL: O que é SQL e como ele funciona SQL (Structured Query Language - Linguagem de Consulta Estruturada) é a linguagem padrão usada para interagir com bancos de...
read more
SQL Introduction: What SQL is and how it works SQL (Structured Query Language) is the standard language used to interact with relational databases. If you work with data, applications, analytics,...
read more
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...
read more
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...
read more
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...
read more
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...
read more
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...
read more
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...
read more
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...
read more
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...
read more
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...
read more
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...
read more
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...
read more
Note: All the project’s Jupyter Notebook files, including images and my notes, can be seen here. Sources InsideAirBnb London data About the source Inside Airbnb is an independent, non-commercial set...
read more
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...
read more
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...
read more
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...
read more
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...
read more
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...
read more
I’m happy to share that I’ve obtained a new certification: SQL for Data Analysis: Beginner MySQL Business Intelligence from Udemy (Maven Analytics). See the certificate on Udemy here. COURSE OUTLINE: SQL Intro...
read more
Have you ever needed to quickly generate mock data to exercise your data analytics skills or test your app? Try Mockaroo. It is an easy and quick way to create...
read more
If you, like me, use Jupyter Notebook for Data Analysis, these Jupyter Notebook shortcuts might come in very handy. #jupyterNotebook #dataanalsys #python #numpy #pandas #shortcuts Jupyter Notebook tips and shortcuts...
read more
I have based my research on the UK’s Department for Transport data. I investigated and found patterns and trends in Road Safety in various Local Authorities across the country. Analysing...
read more
If you are learning Data Analysis and have just started with Python Pandas, check this Pandas playlist from Corey M Schafer. It is truly excellent, very comprehensive, and a very...
read more
It is finally here! My Level 3 - Data Citizen Skills Bootcamp Certificate of Completion. Level 3 - Data Citizen Skills Bootcamp I cannot express enough how much this certificate...
read more
It is Week 10, our last week, at the Cambridge Spark Data Citizen Bootcamp. It is also project week. We are putting to practice all the new skills we have...
read more
This week, Week 9 of our Data Citizen Bootcamp at Cambridge Spark, was a gentle intro to Python for Data Analysis, including an intro to the Pandas data analysis library....
read more
A very thorough guide on Markdown markup language. Very useful if one needs to add some markdown structure to their blog posts.
Markdown Cheatsheet
read more
Confused by the difference between ETL and ELT when dealing with data? Which one is the most appropriate? Is one better than the other? Take a look at this nice...
read more
Today we started Week 8 of our Data Citizen Bootcamp at Cambridge Spark and it was all about Data Storytelling. Finally, we are wrapping up all the last 7 weeks...
read more
Today was a Visualisation/Building Power BI dashboards on our Cambridge Spark Data Citizen Bootcamp lesson. Really good fun, by the way! I am from a “less is more” school when...
read more
A very instructive Microsoft article on “Top ten ways to clean your data” found by my colleague Bryan, from our Cambridge Spark Data Citizen Bootcamp. We have just finished Week...
read more
