Skip to content

SQL

sql-in-a-nutshell.jpeg

(try SQLBolt: http://sqlbolt.com)

𝗙𝗼𝗿 𝗳𝗿𝗲𝗲 𝗿𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀:

🔸 freecodecamp.org: https://lnkd.in/duCfNtTW 🔸 Programming with Mosh: https://lnkd.in/dFT8UQ4x 🔸 techTFQ: https://lnkd.in/d_aSwXpJ 🔸 Alex the Analyst: https://lnkd.in/dCXcY82Z

𝗔𝗱𝗱𝗶𝘁𝗶𝗼𝗻𝗮𝗹 𝗳𝗿𝗲𝗲 𝗿𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀:

🔸 SQLBolt: http://sqlbolt.com 🔸 SQLZoo: https://lnkd.in/dCa9Vwgv 🔸 SQLTest: http://sqltest.net 🔸 W3Schools.com: http://w3schools.com/sql/ 🔸 Codecademy: https://lnkd.in/d2J3956R

𝗧𝗼 𝗽𝗿𝗮𝗰𝘁𝗶𝗰𝗲:

🔸 LeetCode: https://leetcode.com 🔸 HackerRank: https://www.hackerrank.com 🔸 DataLemur: https://datalemur.com

𝗙𝗼𝗿 𝗳𝘂𝗻 𝗴𝗮𝗺𝗲𝘀 𝗼𝗻 𝗦𝗤𝗟:

🔸 SQLZOO: https://sqlzoo.net/ 🔸 SQLBOLT: https://sqlbolt.com/ 🔸 SQL Murder Mystery: https://lnkd.in/dbw9JUY5

indexes Pros and cons, tradeoff

Pros: - quick responses, better performance for looking rows

Cons - maintain the index tree when some rows are deleted - maintain the index tree when a row is added

database_indexing.jpeg