Top Tweets for #100DaysOfSQL
GitHub scripts → https://t.co/e0StSPaLMm
What’s your biggest headache when hunting data gaps in PostGIS?
→ NULLs in spatial joins?
→ Performance on large layers?
→ Chaining multiple joins?
Drop your thoughts below ⬇️
#GeoAI #DataEngineer #100DaysOfSQL
Working with Multiple Tables in SQL: UNION
Used Pakistan CO emissions data(2024 vs 2025) to show how stacking tables works.
We get the data off Kaggle using Python(script in github)
https://t.co/fiFbAvUuWJ
#SpatialTidbits #100DaysOfSQL #geospatialanalysis #DataEngineer
A GitHub repo to accompany my series on SQL for Geospatial Data
It contains:
SQL scripts:
-Retrieving_Part_1
- Retrieving_Part_2
- Sorting_query_results
Python data pipeline scripts
👉👉https://t.co/PVwjj617r1
#SpatialTidbits #100DaysOfSQL #geospatialanalysis #DataEngineer

A GitHub repo to accompany my series on SQL for Geospatial Data
It contains:
SQL scripts:
-Retrieving_Part_1
- Retrieving_Part_2
- Sorting_query_results
Python data pipeline scripts
👉👉https://t.co/PVwjj617r1
#SpatialTidbits #100DaysOfSQL #geospatialanalysis #DataEngineer

SQL for Geospatial Data:Mastering the Basics Part 4
Sorting Query Results
✅ Sorting by Multiple Fields
✅ Precision Substring Sorting
✅ Default vs. Descending Logic
https://t.co/inVhKNmK0V
#SpatialTidbits #100DaysOfSQL #geospatialanalysis #DataEngineer
SQL for Geospatial Data:Mastering the Basics Part 3 covers the following:
✅ Feature Engineering with CASE
✅ Fixing NULLs with COALESCE
✅ Pattern matching for values
https://t.co/RKLvMbPb5m
#SpatialTidbits #100DaysOfSQL #geospatialanalysis #DataEngineer
Part 2 of the series on SQL for Geospatial Data:Mastering the Basics.
✅ Mastering SELECT vs. WHERE
✅ Subqueries & CTEs
✅ Aliasing
SQL for Geospatial Data:Mastering the Basics
https://t.co/GhOxK3p1Zn
#SpatialTidbits #100DaysOfSQL #geospatialanalysis #DataEngineer
Part 1 of a series on SQL for Geospatial Data:Mastering the Basics.
The basics will cover as much as the SQL cookbook covers thus tag along even for non spatial data
https://t.co/rHIDQS6iCE
#SpatialTidbits #100DaysOfSQL #geospatialanalysis #DataEngineer
🔥100DaysOfSQL Challenge
⭐ Day 2 :
📌 Problem :
Find employees earning more than their department’s average salary.
#100DaysOfSQL

🗄️ Day 1/84: SQL Learning Journey
📊 Topic: Basic SELECT Statement
MySQL:
SELECT * FROM users LIMIT 10;
PostgreSQL:
SELECT * FROM users LIMIT 10;
Oracle:
SELECT * FROM users FETCH FIRST 10 ROWS ONLY;
💡 Key Difference: Oracle uses FETCH instead of LIMIT!
#100DaysOfSql
Day 61 of #100DaysOfSQL
Today I learned about Normalization in SQL the process of organizing data to reduce redundancy and improve integrity.
🔹 1NF
🔹 2NF
🔹 3NF
🔹 BCNF
#SQL #DatabaseDesign #Normalization #DataModeling #LearningInPublic

Day 59/100 of SQL Learning
Today I learnt about Composite Indexes Database indexing helps speed up data retrieval and composite indexes take it further by indexing multiple columns together to boost query performance!
#SQL #100DaysOfSQL

CONCAT() - join strings
UPPER() - convert characters of a string to uppercase
LOWER() - convert characters of a string to lowercase
TRIM() - remove leading & trailing spaces
REPLACE() - swap characters
#SQL #DataEngineering #LearnInPublic #100DaysOfSQL #Christmas
Day 58/100 of learning SQL
Today I focused on understanding Clustered vs Non-Clustered Indexes in MySQL:
- Clustered Index: sorts actual table data
- Non-Clustered Index: stores pointers to data
#100DaysOfSQL #SQLLearning #DataAnalytics

Day 93 of #100DaysofSQL
P4ocessing, Storing, and Organizing Data
Covered OLTP vs OLAP, ordering ETL tasks for proper data flow, and databases design, decide fact vs dimension tables and classified data models
#DataAnalytics
#100DaysofCode

Day 92 of #100DaysofSQL
Introduction to relational databases
Learned how attribute constraints ensure data consistency, how key constraints uniquely identify records, and how foreign keys kink tables together.
##DataAnalytics
#100DaysofCode

Day 92 of #100DaysofSQL
Introduction to relational databases
Learned how attribute constraints ensure data consistency, how key constraints uniquely identify records, and how foreign keys kink tables together.
##DataAnalytics
#100DaysofCode

Day 91 of #100DaysofSQL
Project work
Analyzed a motorcycle parts company's data to explore revenue streams. Built SQL queries to calculate net revenue by product line, month, and warehouse.
#100DaysofCode
##DataAnalytics

Day 91 of #100DaysofSQL
Project work
Analyzed a motorcycle parts company's data to explore revenue streams. Built SQL queries to calculate net revenue by product line, month, and warehouse.
#100DaysofCode
##DataAnalytics

Day 90 of #100DaysofSQL
Structuring Written Reports
Studied report types, reproducibility + proper referencing, writing clear/precise analyses, and drafted a sample report on credit risk.
#DataAnalytics
#100DaysofCode

Solved today in SQL: Combine Two Tables
Every query executed is a step closer to cleaner data and stronger logic.
#SQL #Database #100DaysOfSQL #DataSkills #LeetCode

Day 52/100 of my SQL learning journey
Today, I focused on date formatting
I learnt how to change how dates appear using the DATE_FORMAT() function.
I can easily convert 2025-11-21 to formats like 21/11/2025 or November 21, 2025. #100DaysOfSQL #DataAnalytics #LearningJourney

Day 90 of #100DaysofSQL
Structuring Written Reports
Studied report types, reproducibility + proper referencing, writing clear/precise analyses, and drafted a sample report on credit risk.
#DataAnalytics
#100DaysofCode

Day 89 of #100DaysofSQL
Communicating Data clearly
Learned how to pick the right data, highlight key stats, tailor visuals to each audience, and choose the best format for delivery.
#DataAnalytics
#100DaysofCode

Day 89 of #100DaysofSQL
Communicating Data clearly
Learned how to pick the right data, highlight key stats, tailor visuals to each audience, and choose the best format for delivery.
#DataAnalytics
#100DaysofCode

Day 88 of #100DaysofSQL
Storytelling with Data
Covered Storytelling basics: turning technical insights into clear narratives and showing how data drives decisions.
#DataAnalytics
#100DaysofCode

Last Seen Hashtags on Sotwe
Trends for you
Most Popular Users

Elon Musk 
@elonmusk
240.1M followers

Barack Obama 
@barackobama
119.3M followers

Donald J. Trump 
@realdonaldtrump
111.6M followers

Cristiano Ronaldo 
@cristiano
108.7M followers

Narendra Modi 
@narendramodi
106.9M followers

Rihanna 
@rihanna
97.2M followers

NASA 
@nasa
92.1M followers

Justin Bieber 
@justinbieber
90.5M followers

KATY PERRY 
@katyperry
86.7M followers

Taylor Swift 
@taylorswift13
80.5M followers

Lady Gaga 
@ladygaga
72.1M followers

Kim Kardashian 
@kimkardashian
69.3M followers

YouTube 
@youtube
68.6M followers

Virat Kohli 
@imvkohli
68.4M followers

Bill Gates 
@billgates
63.4M followers

The Ellen Show
@theellenshow
62.5M followers

CNN 
@cnn
61.9M followers

Neymar Jr 
@neymarjr
60.9M followers

X 
@x
60.9M followers

CNN Breaking News 
@cnnbrk
59.9M followers







