Explore tweets tagged as #100DaysOfSQL
Day 34 of SQL Learning Today was all about understanding the difference between Derived Tables and CTEs.They both help you build temporary tables in a query but CTEs? Cleaner, reusable, and easier to read. Derived tables? Quick and sometimes messy.#SQL #100DaysOfSQL
0
2
3
🚀 Desafio iniciado: 100 dias de MySQL 📅 Dia 51/100 📚Triggers (CREATE TRIGGER) São gatilhos que executam ações automáticas no BD quando ocorre um evento (INSERT, UPDATE, DELETE). 💡100DaysOfSQL #MySQL
0
0
11
Day 42 of 100 days SQL learning Today, I did a mini SQL project and applied everything I’ve learned so far from Self Joins to Triggers, Views, CTEs, UDFs, and more. I also explored Pivoting & Unpivoting to transform and analyze my dataset better #DataAnalytics #100DaysOfSQL
0
3
5
Day 92 of #100daysofsql NTILE & PERCENT RANK in SQL NTILE The NTILE function divides the rows into a result set into a specified number of groups and assigns each row a unique rank based on its group belongs.
1
1
2
Day 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
3
4
11
🚀 Desafio iniciado: 100 dias de MySQL 📅 Dia 43/100 📚 Views (CREATE VIEW) Ela não armazena dados, apenas a lógica da consulta. ✅ Usos: • Simplificar consultas complexas • Criar relatórios e dashboards • Garantir segurança (mostrar só o necessário) 💡100DaysOfSQL #MySQL
0
0
1
0
0
0
If you sign up for this SQL newsletter today, 22nd Dec will be the last day. You will close the year with better SQL skills and you won’t be starting from scratch come 2025! Onboarding is on Friday #100DaysOfSQL
1
7
11
Today we kicked off #100DaysOfSQL with onboarding and the setting up the free version of bigquery. Recorded a mini tutorial as well. You can still sign up for the newsletter.
0
3
10
Day 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql
0
1
2
It’s been 100 days of consistently posting SQL content. Hello everyone, I sincerely thank you all for joining me on this journey. Sharing this platform has been both exciting and full of learning. Day 100 of #100daysofsql
2
1
4
Day 36 of SQL Learning Today I explored Views, basically saved SQL queries that act like virtual tables. ✅ Simplify complex queries ✅ Reuse code easily #SQL #100DaysOfSQL #DataJourney #LearnSQL
0
1
5
🚀 Desafio iniciado: 100 dias de MySQL 📅 Dia 46/100 📚 Otimização com índices ⚡Índices aceleram buscas no banco — em vez de varrer tudo, o BD vai direto ao ponto 💪Equilíbrio é a chave: rapidez nas consultas sem sobrecarregar as escritas 💡100DaysOfSQL #MySQL
0
0
7
🚀 Desafio iniciado: 100 dias de MySQL 📅 Dia 39/100 📚 Hoje foi dia de aprender sobre SELF JOIN É quando uma tabela se junta com ela mesma! 🔁 Usado em estruturas hierárquicas como: 👔 Funcionário 📂 Categoria 👫 Usuário 💡100DaysOfSQL #MySQL
0
0
33
🚀 How to find the second-highest salary in a table using SQL? 🚀 💡 Here's a quick solution using a table named "Emp" with employee details such as id, name, and salary. 👉 Check out for raw code snippets. Let's code together! 🚀🔍 #SQLQueries #100DaysOfSQL
1
0
0
#Day29 of #100daysofSQL To use a subquery in an INSERT statement, it must be included in the values clause.
0
1
1
Yesterday, I was skeptical about choosing BigQuery for the #100DaysOfSQL challenge. I chose it because I wanted people to participate despite their laptop size. I’m glad I stuck with it—the response has been amazing!
0
2
3
#Day30 of #100daysofSQL A subquery is used in a DELETE statement with a logical operator to remove data from a table.
0
1
1
🚀 Desafio iniciado: 100 dias de MySQL 📅 Dia 52/100 📚Procedures (CREATE PROCEDURE) ✅Use CREATE PROCEDURE + CALL nome() para reutilizar consultas complexas. ✅Parâmetros: IN (entrada), OUT (saída), INOUT (ambos). 💡100DaysOfSQL #MySQL
0
0
10
Day 18 of #100DaysOfSQL ✅ Today, I explored CTEs (Common Table Expressions) by working on a practical challenge: 💡 Used concepts like: - WITH clause (CTE) - AVG()function #SQL #LearningJourney #DataAnalytics #100DaysOfCode
3
2
11