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
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.8M 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