Filter
Exclude
Time range
-
Near
The UPDATE & DELETE Statements tutorial is officially out now πŸ”₯ πŸŽ₯ Watch here: youtu.be/rPHhklUiuBA πŸ‘ Like πŸ’¬ Comment πŸ” Share πŸ”” Subscribe for more SQL tutorials #SQL #LearnSQL #SQLTutorial #DataAnalytics #DataScience #Database #Programming #Coding #Tech #SQLForBeginners
12
BigQuery Sandbox: Google’s Free SQL Playground (No Credit Card Needed) πŸš€ Stop worrying about bills and start practicing enterprise-grade SQL today. My new tutorial shows you how to: - Spin up a full BigQuery environment instantly - Query terabytes of public data - Upload your own files - Create beautiful dashboards Perfect for beginners and career switchers. Watch here: youtu.be/bSTzu4Rzprk?si=KUTQ… Blog on @DataCamp : datacamp.com/tutorial/bigque… #BigQuery #GoogleCloud #SQLTutorial @googlecloud
2
2
144
If you’re learning SQL, start here. The SELECT statement is the foundation of everything you’ll do with data and most people overthink it. What SQL topic should we cover next? Drop it in the comments πŸ‘‡ #DataCommunityAfrica #SQL #DataAnalytics #SQLTutorial #LearnSQL
4
13
465
28 May 2025
When you use ABS with percentages in Oracle, do they magically become more positive? Source: devhubby.com/thread/how-to-u… #DataScience #TechTutorials #DataEngineering #SQLTutorial #oracle #function
6
9
πŸš€ SQL DATA TYPES SQL data types define the type of data that can be stored in a column. They vary slightly between different database systems like MySQL, PostgreSQL, SQL Server, and Oracle, but here are the common categories: A thread πŸ§΅πŸ‘‡πŸ»πŸ‘‡πŸ» #SQL #SQLTutorial #LearnSQL #SQLQuery #SQLForBeginners #Database #SQLDatabase #SQLQueries #SQLServer #MySQL #PostgreSQL #DataScience #DataAnalytics #SQLTips #SQLInterview #pushpendratips
31
8
40
1,229
πŸ”₯ SQL Command Types Explained (With Examples) SQL commands are divided into 5 Main Categories based on their functionality. A thread πŸ§΅πŸ‘‡πŸ» #SQL #LearnSQL #SQLTips #SQLTutorial #DatabaseManagement #SQLQueries #SQLDeveloper #SQLForBeginners
36
12
69
3,005
πŸ“œ SQL Cheat Sheet πŸ” Fetching Data (SELECT) SELECT * FROM table_name; SELECT column1, column2 FROM table_name; SELECT DISTINCT column FROM table_name; _____________________________________________________ 🎯 Filtering Data (WHERE) SELECT * FROM users WHERE age > 25; SELECT * FROM orders WHERE status = 'delivered'; _____________________________________________________ 🧩 Multiple Conditions (AND, OR, NOT) SELECT * FROM users WHERE age > 25 AND city = 'Delhi'; SELECT * FROM products WHERE price < 500 OR stock > 50; SELECT * FROM employees WHERE NOT department = 'HR'; _____________________________________________________ πŸ”’ Sorting Results (ORDER BY) SELECT * FROM employees ORDER BY salary DESC; SELECT * FROM products ORDER BY price ASC, name DESC; _____________________________________________________ πŸŽ› Limiting & Skipping (LIMIT, OFFSET) SELECT * FROM products LIMIT 5; SELECT * FROM orders LIMIT 10 OFFSET 5; _________________________________________________________ πŸ— Grouping Data (GROUP BY, HAVING) SELECT department, COUNT(*) FROM employees GROUP BY department; SELECT category, AVG(price) FROM products GROUP BY category HAVING AVG(price) > 100; _________________________________________________________ πŸ† Aggregations (COUNT, SUM, AVG, MIN, MAX) SELECT COUNT(*) FROM users; SELECT SUM(price) FROM orders; SELECT AVG(salary) FROM employees; SELECT MIN(age), MAX(age) FROM users; _____________________________________________________ πŸ”„ Joining Tables (JOIN) πŸ‘« Inner Join SELECT users.name, orders.amount FROM users INNER JOIN orders ON users.id = orders.user_id; _____________________________________________________ πŸ“Œ Left Join SELECT users.name, orders.amount FROM users LEFT JOIN orders ON users.id = orders.user_id; _________________________________________________________ πŸ“Œ Right Join SELECT users.name, orders.amount FROM users RIGHT JOIN orders ON users.id = orders.user_id; _____________________________________________________ πŸ”— Full Join SELECT users.name, orders.amount FROM users FULL JOIN orders ON users.id = orders.user_id; _____________________________________________________ πŸ— Creating & Modifying Tables πŸ†• Creating a Table CREATE TABLE users ( id INT PRIMARY KEY, name VARCHAR(100), age INT, city VARCHAR(50) ); _____________________________________________________ πŸ”§ Altering a Table ALTER TABLE users ADD COLUMN email VARCHAR(100); ALTER TABLE users DROP COLUMN city; _____________________________________________________ πŸ“ Modifying Data βž• Inserting Data INSERT INTO users (id, name, age) VALUES (1, 'Amit', 30); _____________________________________________________ πŸ›  Updating Data UPDATE users SET age = 31 WHERE id = 1; _____________________________________________________ ❌ Deleting Data DELETE FROM users WHERE id = 1; DELETE FROM users; -- Delete all rows _____________________________________________________ πŸ› Indexes & Keys πŸ”‘ Primary Key CREATE TABLE users ( id INT PRIMARY KEY, name VARCHAR(100) ); _____________________________________________________ πŸ”‘ Foreign Key CREATE TABLE orders ( id INT PRIMARY KEY, user_id INT, FOREIGN KEY (user_id) REFERENCES users(id) ); _____________________________________________________ πŸš€ Creating Index CREATE INDEX idx_name ON users(name); _____________________________________________________ πŸ“œ Subqueries & Unions πŸ”„ Subquery SELECT name FROM users WHERE id IN (SELECT user_id FROM orders); _____________________________________________________ πŸ”— Union (Combine Results) SELECT name FROM customers UNION SELECT name FROM suppliers; SELECT name FROM customers UNION ALL SELECT name FROM suppliers; -- Includes duplicates _____________________________________________________ πŸ”₯ Transactions BEGIN TRANSACTION; UPDATE accounts SET balance = balance - 500 WHERE id = 1; UPDATE accounts SET balance = balance 500 WHERE id = 2; COMMIT; -- Save changes ROLLBACK; -- Undo changes #SQL #SQLTutorial #LearnSQL #SQLQueries #SQLCheatSheet #Database #DataScience #Programming #Tech #Code #SQLForBeginners #SQLBasics #SQLTraining #LearnToCode #CodingForBeginners #AdvancedSQL #SQLPerformance #SQLOptimization #SQLBestPractices #SQLDatabase #MySQL #PostgreSQL #SQLServer #OracleSQL #NoSQL #DataAnalytics #SQLForDataScience #BusinessIntelligence #BigData #DataVisualization
28
19
66
8,752
Does converting midnight to a number in Oracle SQL make it less spooky? πŸ‘»0️⃣ Source: devhubby.com/thread/how-to-c… #TechDiscussion #DeveloperCommunity #OracleSQL #SQLTutorial #number #oraclesql
3
8
33
Save these sites FOREVER!!! ❯ C ➟ learn-c ❯ C ➟ fluentcpp ❯ Java ➟ baeldung ❯ JavaScript ➟ javascript .info ❯ Python ➟ planetpython ❯ SQL ➟ sqlbolt ❯ HTML ➟ learn-html ❯ CSS ➟ css-tricks ❯ Go ➟ learn-golang ❯ Kotlin ➟ studytonight ❯ Swift ➟ codewithchris ❯ C# ➟ learncs ❯ PHP ➟ learn-php ❯ DSA ➟ techdevguide .withgoogle ❯ Java ➟ dzone ❯ C ➟ learncpp ❯ JavaScript ➟ MDN ❯ Go ➟ gobyexample ❯ Go ➟ golangbot ❯ Ruby ➟ rubyguides ❯ Swift ➟ hackingwithswift ❯ React ➟ scrimba ❯ React ➟ react-tutorial ❯ Vue ➟ vuemastery ❯ Vue ➟ learnvue ❯ Vue ➟ scrimba ❯ Ruby on Rails ➟ railstutorial ❯ Spring ➟ baeldung ❯ Spring ➟ journaldev ❯ Spring ➟ dzone ❯ Laravel ➟ laracasts ❯ SQL ➟ sqlzap ❯ SQL ➟ codecademy ❯ SQL ➟ sqltutorial ❯ MySQL ➟ mysqltutorial ❯ PostgreSQL ➟ postgresqltutorial ❯ SQL Server ➟ sqlservertutorial ❯ Oracle ➟ oracletutorial ❯ MongoDB ➟ mongodbtutorial ❯ REST ➟ restfulapi ❯ GraphQL ➟ apollographql ❯ Full Stack ➟ theodinproject ❯ Backend ➟ theserverside ❯ Microservices ➟ dzone ❯ DevOps ➟ theserverside ❯ Cloud ➟ dzone ❯ Azure ➟ learn. microsoft -- Most Useful Sites -- ❯ w3schools ❯ tutorialspoint ❯ programiz ❯ geeksforgeeks ❯ freecodecamp ❯ towardsdatascience ❯ dzone ❯ theserverside P.S: Follow the official docs first. Those are always the best places to learn.
17
212
1,316
83,483
Currently using sqltutorial org for learning SQL What are your go-to resources for learning and practising SQL? Books, courses, websites, challengesβ€”drop your recommendations below! πŸ™ŒπŸΌ
2
3
434
Save these sites FOREVER!!! ❯ HTML ➟ learn-html ❯ CSS ➟ css-tricks ❯ JavaScript ➟ javascript .info ❯ Python ➟ kaggle ❯ Java ➟ baeldung ❯ SQL ➟ sqlbolt ❯ Go ➟ learn-golang ❯ Kotlin ➟ studytonight ❯ Swift ➟ codewithchris ❯ C# ➟ learncs ❯ C ➟ learn-c ❯ C ➟ fluentcpp ❯ PHP ➟ learn-php ❯ DSA ➟ techdevguide .withgoogle ❯ Java ➟ dzone ❯ C ➟ learncpp ❯ JavaScript ➟ MDN ❯ Go ➟ gobyexample ❯ Go ➟ golangbot ❯ Ruby ➟ rubyguides ❯ Swift ➟ hackingwithswift ❯ React ➟ scrimba ❯ React ➟ react-tutorial ❯ Vue ➟ vuemastery ❯ Vue ➟ learnvue ❯ Vue ➟ scrimba ❯ Ruby on Rails ➟ railstutorial ❯ Spring ➟ baeldung ❯ Spring ➟ journaldev ❯ Spring ➟ dzone ❯ Laravel ➟ laracasts ❯ SQL ➟ sqlzap ❯ SQL ➟ codecademy ❯ SQL ➟ sqltutorial ❯ MySQL ➟ mysqltutorial ❯ PostgreSQL ➟ postgresqltutorial ❯ SQL Server ➟ sqlservertutorial ❯ Oracle ➟ oracletutorial ❯ MongoDB ➟ mongodbtutorial ❯ REST ➟ restfulapi ❯ GraphQL ➟ apollographql ❯ Full Stack ➟ theodinproject ❯ Backend ➟ theserverside ❯ Microservices ➟ dzone ❯ DevOps ➟ theserverside ❯ Cloud ➟ dzone ❯ Azure ➟ learn. microsoft πŸ’‘ Never forget below sites. They provide content for multiple skills: ❯ w3schools ❯ tutorialspoint ❯ programiz ❯ geeksforgeeks ❯ freecodecamp ❯ studytonight ❯ dzone ❯ theserverside P.S: Follow the official docs first. Those are always the best places to learn.
5
94
521
33,851