467
AZPART 1/2
The Ultimate SQL Commands Cheatsheet! 💡 SQL is the foundation of database management, and knowing the right commands can make you a pro at handling data efficiently! Here’s a quick reference guide to essential SQL commands:
🔹 𝐃𝐚𝐭𝐚 𝐐𝐮𝐞𝐫𝐲 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞 (𝐃𝐐𝐋) – Retrieving Data ✅ SELECT – Extract data from tables ✅ WHERE – Apply conditions to filter data ✅ ORDER BY – Sort query results ✅ LIMIT – Restrict the number of rows returned
🔹 𝐃𝐚𝐭𝐚 𝐃𝐞𝐟𝐢𝐧𝐢𝐭𝐢𝐨𝐧 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞 (𝐃𝐃𝐋) – Managing Table Structure ✅ CREATE TABLE – Define a new table ✅ ALTER TABLE – Modify an existing table ✅ DROP TABLE – Remove a table completely ✅ TRUNCATE TABLE – Delete all records but keep the structure
🔹 𝐃𝐚𝐭𝐚 𝐌𝐚𝐧𝐢𝐩𝐮𝐥𝐚𝐭𝐢𝐨𝐧 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞 (𝐃𝐌𝐋) – Modifying Data ✅ INSERT INTO – Add new records ✅ UPDATE – Modify existing records ✅ DELETE – Remove specific records
🔹 𝐃𝐚𝐭𝐚 𝐂𝐨𝐧𝐭𝐫𝐨𝐥 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞 (𝐃𝐂𝐋) – Managing User Access ✅ GRANT – Provide specific permissions ✅ REVOKE – Remove granted permissions
🔹 𝐓𝐫𝐚𝐧𝐬𝐚𝐜𝐭𝐢𝐨𝐧 𝐂𝐨𝐧𝐭𝐫𝐨𝐥 𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞 (𝐓𝐂𝐋) – Handling Transactions ✅ COMMIT – Save all changes made during the session ✅ ROLLBACK – Undo changes if needed ✅ SAVEPOINT – Set checkpoints within a transaction
🔹 𝐒𝐐𝐋 𝐉𝐨𝐢𝐧𝐬 – Combining Data from Multiple Tables ✅ INNER JOIN – Fetch only matching records ✅ LEFT JOIN – Get all records from the left table and matching ones from the right ✅ RIGHT JOIN – Get all records from the right table and matching ones from the left ✅ FULL JOIN – Get all records from both tables #databricks #pyspark #python #premium #datafactory
@azure_data_engineer
