Stephen Smith Gletse

A software developer and a businessman.

[𝕏 Ghana 🇬🇭 @xghana_]

You’re scrolling through LinkedIn and your company posted a vacancy for your position 😅

[ɱҽԃι✨ @Med1_Ai]

Programming languages are difficult to learn, but not impossible.

Learning programming is easier with these notes.

Here are some notes you will get:

✅ Python PDF
✅ Git PDF
✅ Java PDF
✅ SQL PDF
✅ JavaScript PDF
✅ MongoDB PDF
✅ Algorithms PDF
✅ And more...

Just:👇

1. Follow me for DM
2. Like and Repost
3. Comment “ FREE ”

[Rahul Roy @Ai_here202]

𝗣𝗮𝗶𝗱 𝗖𝗼𝘂𝗿𝘀𝗲 𝗙𝗥𝗘𝗘 (PART - 1)

1. Artificial Intelligence + Data Analyst
2. Machine Learning + Data Science
3. Cloud Computing + Web Development
4. Ethical Hacking + Hacking
5. Data Analytics + DSA
6. AWS Certified + IBM COURSE
7. Data Science + Deep Learning
8. BIG DATA + SQL COMPLETE COURSE
9. Python + OTHERS
10 MBA + HANDWRITTEN NOTES

(72 Hours only ) Cost About - $500

To get FREE: -
1. Follow (So I can DM you)
2. Like & retweet
3. Reply " Send "

[Stephen Smith Gletse @GletseSmith]

@SaddickAdams As much as I’m concerned about the prices of coconut I’m more concerned about the guy drinking the coconut in this tweet
Like ahh wtf
Relax erhh😂💔

[Stephen Smith Gletse @GletseSmith]

@kyekyeku_tv 😂😂

[Stephen Smith Gletse @GletseSmith]

@opokubilson_ 😂😂💔

[Massimo @Rainmaker1973]

50 websites to find unlimited content

[Code Geek @codek_tv]

Data Analyst Roadmap

[Dhanian 🗯️ @e_opore]

Free Hosting Sites.

1. General Free Hosting Platforms
1. https://t.co/K4q4Fmkp8i
2. https://t.co/hSGXWM0a38
3. https://t.co/JWNUGnQCgb
4. https://t.co/HWPVS2Rl0h
5. https://t.co/FMgc9Jgu8s
6. https://t.co/twn16i5Sr9
7. https://t.co/0ZAHC5qUP4
8. https://t.co/RQgUvDkluH
9. https://t.co/Zcba2gIfYO
10. https://t.co/P3niIHRfui

2. Free Hosting for Static Websites
11. https://t.co/cT9UtqQC7L
12. https://t.co/DEV4soNlDM
13. https://t.co/GAlqJUkGKX
14. https://t.co/jR4zVoVLDC
15. https://t.co/bRbv9Nmhhr
16. https://t.co/ASXvRBEois
17. https://t.co/mAWJm0v5yJ
18. https://t.co/EHWai0VS2i
19. https://t.co/UF1BjFev3f
20. https://t.co/WrJWmEMwVO

3. Free Hosting for Dynamic Websites
21. https://t.co/Zu5hOedDER
22. https://t.co/elgsz0pYSx
23. https://t.co/0xLUc5C83P
24. https://t.co/pg8ynFNzQb
25. https://t.co/SJfo0Q2HLS
26. https://t.co/SXoWQmRuXa
27. https://t.co/SpAexQ9c1t
28. https://t.co/G5G2B0K7fh
29. https://t.co/GFyjsbnH77
30. https://t.co/FYk6I4Yik6

4. Free Hosting for WordPress
31. https://t.co/s3qRdOfCGi
32. https://t.co/fR4PyWGCFE…
33. https://t.co/BUXBrR55EX
34. https://t.co/TLvqFhQgyj
35. https://t.co/kZ38R1MhHE
36. https://t.co/Qp5F1j5BLU
37. https://t.co/dMlr2PpFHD
38. https://t.co/KTm808AVVs…
39. https://t.co/btyX53Gqsa
40. https://t.co/fyAQQn7kU2

5. Free Hosting for Node.js Apps
41. https://t.co/jR4zVoVLDC
42. https://t.co/FMgc9Jgu8s
43. https://t.co/0xLUc5C83P
44. https://t.co/elgsz0pYSx
45. https://t.co/JWNUGnQCgb
46. https://t.co/SgchHKMBgb
47. https://t.co/SJfo0Q2HLS
48. https://t.co/SpAexQ9c1t
49. https://t.co/ke6OZZbHKi
50. https://t.co/65sVfn4S1G

[Nikki Siapno @NikkiSiapno]

Things Every Developer Should Know — SQL Execution Order.

A SQL query executes its statements in the following order:

1) FROM / JOIN
2) WHERE
3) GROUP BY
4) HAVING
5) SELECT
6) DISTINCT
7) ORDER BY
8) LIMIT / OFFSET

𝗧𝗵𝗲 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀 𝘆𝗼𝘂 𝗶𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁 𝗮𝘁 𝗲𝗮𝗰𝗵 𝘀𝘁𝗲𝗽 𝗵𝗲𝗹𝗽 𝘀𝗽𝗲𝗲𝗱 𝘂𝗽 𝘁𝗵𝗲 𝗳𝗼𝗹𝗹𝗼𝘄𝗶𝗻𝗴 𝘀𝘁𝗲𝗽𝘀. This is why it's important to know their execution order. 𝗧𝗼 𝗺𝗮𝘅𝗶𝗺𝗶𝘇𝗲 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝗰𝘆, 𝗳𝗼𝗰𝘂𝘀 𝗼𝗻 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗶𝗻𝗴 𝘁𝗵𝗲 𝘀𝘁𝗲𝗽𝘀 𝗲𝗮𝗿𝗹𝗶𝗲𝗿 𝗶𝗻 𝘁𝗵𝗲 𝗾𝘂𝗲𝗿𝘆.

With that in mind, let's take a look at some 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗶𝗽𝘀:

𝟭) 𝗠𝗮𝘅𝗶𝗺𝗶𝘇𝗲 𝘁𝗵𝗲 𝗪𝗛𝗘𝗥𝗘 𝗰𝗹𝗮𝘂𝘀𝗲

This clause is executed early, so it's a good opportunity to reduce the size of your data set before the rest of the query is processed.

𝟮) 𝗙𝗶𝗹𝘁𝗲𝗿 𝘆𝗼𝘂𝗿 𝗿𝗼𝘄𝘀 𝗯𝗲𝗳𝗼𝗿𝗲 𝗮 𝗝𝗢𝗜𝗡

Although the FROM/JOIN occurs first, you can still limit the rows. To limit the number of rows you are joining, use a subquery in the FROM statement instead of a table.

𝟯) 𝗨𝘀𝗲 𝗪𝗛𝗘𝗥𝗘 𝗼𝘃𝗲𝗿 𝗛𝗔𝗩𝗜𝗡𝗚

The HAVING clause is executed after WHERE & GROUP BY. This means you're better off moving any appropriate conditions to the WHERE clause when you can.

𝟰) 𝗗𝗼𝗻'𝘁 𝗰𝗼𝗻𝗳𝘂𝘀𝗲 𝗟𝗜𝗠𝗜𝗧, 𝗢𝗙𝗙𝗦𝗘𝗧, 𝗮𝗻𝗱 𝗗𝗜𝗦𝗧𝗜𝗡𝗖𝗧 𝗳𝗼𝗿 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀

It's easy to assume that these would boost performance by minimizing the data set, but this isn’t the case. Because they occur at the end of the query, they make little to no impact on its performance.

If you want to create efficient queries, it's a good idea to understand how things work under the hood otherwise your efforts may be wasted. While these tips work best in most cases, you should consider your unique use case when choosing the best course of action.

~~
Thanks to our partner CodeRabbit who keeps our content free to the community.

𝗗𝗶𝗱 𝘆𝗼𝘂 𝗵𝗲𝗮𝗿 about CodeRabbit releasing their CLI and providing 𝗳𝗿𝗲𝗲 𝗰𝗼𝗱𝗲 𝗿𝗲𝘃𝗶𝗲𝘄𝘀 𝗶𝗻 𝘁𝗵𝗲 𝗖𝗟𝗜?

Check it out: https://t.co/2HlvbMoSQF

[Code Geek @codek_tv]

Types of Databases!!!

[Stephen Smith Gletse @GletseSmith]

@the_marcoli_boy Matters dey😂💔

[Alif Hossain @alifcoder]

The iPhone 16 is launching soon.

It's gonna be Apple's biggest upgrade yet.

Here are 7 mind-blowing features you won't believe 🤯

[Stephen Smith Gletse @GletseSmith]

@DAMIADENUGA 😂😂

[Stephen Smith Gletse @GletseSmith]

@CFC_Clement 😂😂💔

[Stephen Smith Gletse @GletseSmith]

@dawgdeyfool @The_Chamoo 😂😂💔

[Stephen Smith Gletse @GletseSmith]

@theapplehub @theapplehub check Dm

[Stephen Smith Gletse @GletseSmith]

@Yumvita3 @eddie_wrt We plenty bro😂💔

[Stephen Smith Gletse @GletseSmith]

@NtimBarima This biker deserve an award 🔥

[Stephen Smith Gletse @GletseSmith]

@tv3_ghana Committee