If you are reading this tweet, it means you are alive. Don't take this for granted and live in arrogance. Some wished to be in your position but didn't get that chance. Be grateful and stay humble.
If you're learning SQL, save this.
These are 20 essential SQL commands and functions every Data Analyst should know.
Don't just memorize them practice them on real datasets.
Top 20 SQL Functions
Data Retrieval & Filtering
SELECT – Extract specific data.
WHERE – Filter rows based on conditions.
DISTINCT – Remove duplicate values.
ORDER BY – Sort results.
LIMIT / TOP – Return a set number of rows.
Aggregation & Grouping
COUNT() – Count rows.
SUM() – Add up values.
AVG() – Calculate average.
MIN() – Find the lowest value.
MAX() – Find the highest value.
GROUP BY – Aggregate data by categories.
HAVING – Filter groups after aggregation.
Joins & Relationships
INNER JOIN – Return matching records.
LEFT JOIN – Return all from left + matches.
RIGHT JOIN – Return all from right + matches.
FULL JOIN – Return all from both tables.
String & Date Functions
CONCAT() – Combine strings.
SUBSTRING() – Extract part of a string.
NOW() / GETDATE() – Current date & time.
Readability & Query Optimization
ALIAS (AS) – Rename columns/tables for cleaner queries.
Bookmark this post. You'll use these throughout your SQL journey.
I’m a senior data analyst.
If you’re learning:
• AI
• SQL
• Excel
• Power BI
•Python
• Data Modeling
• Data Visualization
• AI for data analysis
and looking to break into data analytics. This account shares practical insights on SQL, Excel, Python, Power BI, Data Modeling, and Data Visualization, Ai for data analysis - helping you skip the headaches and fast-track your career.
Type Lets Connect
Hermano,
Has ganado el mundial. Has hecho historia. 🥹❤️
Pero más allá del trofeo, gracias por esto: has hecho que millones de inmigrantes como nuestros padres se sientan orgullosos de que sus futuros hijos algun dia puedan vivir lo que tu has vivido y de que millones de españoles empaticen con nuestra historia que no es solo la nuestra sino la de todas las personas que dejan todo atrás por un futuro mejor, porque has tocado el cielo con los dedos y has demostrado que con trabajo y esfuerzo todo es posible.
Hoy el mundo te ha conocido mas si cabe y has puesto nuestro apellido en el infinito, por lo siglos de los siglos.
Te admiro. Te amo. Campeón del mundo ✊🏿🏆🥹
🚨 For Cristiano Ronaldo to equal Messi's achievements, He needs:
• 1 World Cup
• 3 Ballon D'or Award
• 2 French League titles and
• 1 Human Hormone.
🚨 But For Lionel Messi to equal Ronaldo's achievements, He needs:
• 3 Premier League titles
• 2 Champions League titles
• 1 Puskas Award
• 2 FA Cup
• 2 English Super Cup
• 2 Italian League titles
• 2 Italian Cup
• 1 Club World Cup
• 6 Globe Soccer Award
• 1 UCL All Time scorer Award
• 1 Diamond YouTube play button.
• 1 Saudi Pro League title
Any disrespect to Cristiano Ronaldo from all Messi fans will not be tolerated anymore... 🤔