#advancedsql - Twitter Hashtag

3 months ago

Successfully completed the SQL Advanced certification from HackerRank! 🏆 Another step forward in strengthening my SQL & database skills. 📷#HackerRank #SQL #AdvancedSQL #Database #Programming

imvyashh's tweet photo. Successfully completed the SQL Advanced certification from HackerRank! 🏆 Another step forward in strengthening my SQL & database skills. 📷#HackerRank #SQL #AdvancedSQL #Database #Programming https://t.co/CGPYOfFhDI

0

5

0

66

The Data Boy @Fortune_star01

6 months ago

New episode is out — Views in SQL. Learn how to turn complex queries into reusable virtual tables. Watch here: https://t.co/s01WTRAuMN #SQL #MySQL #AdvancedSQL #DataAnalytics #TheDataBoy

0

2

1

0

86

Om Walzade @OMwalzade11

7 months ago

Learned about Transactions and how they keep data safe and consistent. Dived into ACID properties: @ChaiCodeHQ @Hiteshdotcom @piyushgarg_dev #SQL #AdvancedSQL #Database #BackendDevelopment #LearningJourney

OMwalzade11's tweet photo. Learned about Transactions and how they keep data safe and consistent.
Dived into ACID properties:
@ChaiCodeHQ @Hiteshdotcom @piyushgarg_dev
#SQL #AdvancedSQL #Database #BackendDevelopment #LearningJourney https://t.co/EnVEDE1ARr

0

30

0

124

Moses @mrkayodetoyou

8 months ago

LEFT JOIN is common. RIGHT and FULL? Rare — but powerful when needed. #SQL #DataAnalytics #AdvancedSQL

0

2

0

12

Camila

@AiCamila_

9 months ago

📊 LAG() & LEAD() Explained Compare rows without self-join. LAG(sales) OVER(ORDER BY date) Used for: • Growth rate • Trends • Forecasting #SQL #Analytics #AdvancedSQL #DataScience

AiCamila_'s tweet photo. 📊 LAG() & LEAD() Explained

Compare rows without self-join.

LAG(sales) OVER(ORDER BY date)

Used for:
• Growth rate
• Trends
• Forecasting

#SQL #Analytics #AdvancedSQL #DataScience https://t.co/5H7L2d9H5W

0

3

0

21

Camila

@AiCamila_

9 months ago

🧠 ROW_NUMBER() for Deduplication Keeps one row, removes rest — safely. #SQL #WindowFunctions #AdvancedSQL

0

2

0

13

Camila

@AiCamila_

9 months ago

🔄 Pivoting Data in SQL SQL doesn’t always have PIVOT, but CASE + GROUP BY does the job. #SQL #DataTransformation #AdvancedSQL

0

2

0

9

Camila

@AiCamila_

10 months ago

Isolation Levels 🧪 Transaction Isolation Levels • Read Committed • Repeatable Read • Serializable Higher isolation = safer but slower. #SQL #Concurrency #AdvancedSQL

AiCamila_'s tweet photo. Isolation Levels

🧪 Transaction Isolation Levels

• Read Committed
• Repeatable Read
• Serializable

Higher isolation = safer but slower.

#SQL #Concurrency #AdvancedSQL https://t.co/f2TuQOoWvK

0

3

0

10

Camila

@AiCamila_

10 months ago

⚔️ CTE vs Temporary Table CTE → readability Temp Table → reuse + indexing Choose wisely. #SQL #AdvancedSQL #Performance

0

2

0

13

Camila

@AiCamila_

10 months ago

🔬 EXPLAIN ANALYZE = Real Execution Data • Shows actual runtime • Reveals bottlenecks Use this before adding indexes blindly. #SQL #PerformanceTuning #AdvancedSQL

AiCamila_'s tweet photo. 🔬 EXPLAIN ANALYZE = Real Execution Data

• Shows actual runtime
• Reveals bottlenecks

Use this before adding indexes blindly.

#SQL #PerformanceTuning #AdvancedSQL https://t.co/fYAuIpHYS9

0

3

0

1

18

Camila

@AiCamila_

10 months ago

⚔️ CTE vs Subquery CTE → readable & reusable Subquery → quick & inline Choose clarity over shortcuts. #SQLTips #AdvancedSQL #CleanCode

AiCamila_'s tweet photo. ⚔️ CTE vs Subquery

CTE → readable & reusable
Subquery → quick & inline

Choose clarity over shortcuts.

#SQLTips #AdvancedSQL #CleanCode https://t.co/uefik0x4tz

0

4

0

25

PurityTheChemist🔬✨ @PurityVerse

over 1 year ago

✅ Week 6 SQL Challenge done! Dived into advanced queries: pizza pairings, pricing insights, category analysis & more—all with real-world data. #SQL #DataAnalytics #AdvancedSQL #DataSkills #TDI @TDataImmersed @DabereNnamani @JudeRaji_ @SQLServer

PurityVerse's tweet photo. ✅ Week 6 SQL Challenge done!
Dived into advanced queries: pizza pairings, pricing insights, category analysis & more—all with real-world data.
#SQL #DataAnalytics #AdvancedSQL #DataSkills
#TDI
@TDataImmersed @DabereNnamani @JudeRaji_ @SQLServer https://t.co/oyErLG7g4X

1

2

0

33

jashandeep Kaur @jashandeep71777

about 2 years ago

🚀 SQL Learning Journey - Day 36 Update 🚀 Today, I advanced further into Advanced SELECT & JOINs and solved a LeetCode problem 📃The Number of Employees Who Report to Each Employee. #SQL #LeetCode #SQLLearning #Joins #AdvancedSQL

jashandeep71777's tweet photo. 🚀 SQL Learning Journey - Day 36 Update 🚀

Today, I advanced further into Advanced SELECT & JOINs and solved a LeetCode problem

📃The Number of Employees Who Report to Each Employee.

#SQL #LeetCode #SQLLearning #Joins #AdvancedSQL https://t.co/tSqFju9X9N

0

7

0

101

Maho Jase IT @mahojase

about 2 years ago

Use EXISTS to check for related records based on conditions in another table. . . . #MySQL #SQLQuery #EXISTS #AdvancedSQL #DataFiltering

mahojase's tweet photo. Use EXISTS to check for related records based on conditions in another table.
.
.
.
#MySQL #SQLQuery #EXISTS #AdvancedSQL #DataFiltering https://t.co/7ssDvnHLWM

0

2

1

0

14

Palam Solutions @PalamSolutions

about 3 years ago

BigQuery SQL Queries: Basics & Advanced Techniques. #BigQueryGuide #SQLQueries #DataAnalyst #AdvancedSQL #DatabaseTechniques https://t.co/RFfVm0RmDJ

0

3

2

0

29

PenTest Magazine @PenTestMag

about 3 years ago

Advanced SQL Injection and Data Store Attacks Online Course - XPATH Injection | Injection Tutorial https://t.co/tCjGvRc7FD #hakin9media #advancedsql #sql #injection #datastore #attacks #onlinecourse #xpath

0

7

1

612