DEV Community

Cover image for SQL in Minutes: Your Ultimate SQL Cheat Sheet
Just Determined
Just Determined

Posted on

2

SQL in Minutes: Your Ultimate SQL Cheat Sheet

SQL Cheatsheet πŸ“

This SQL cheatsheet is designed to be your quick reference guide for SQL programming. Whether you’re a beginner learning how to query databases or an experienced developer looking for a handy resource, this cheatsheet covers essential SQL topics.

  1. Database Basics

    • CREATE DATABASE db_name;
    • USE db_name;
  2. Tables

    • Create Table: CREATE TABLE table_name (col1 datatype, col2 datatype);
    • Drop Table: DROP TABLE table_name;
    • Alter Table: ALTER TABLE table_name ADD column_name datatype;
  3. Insert Data

    • INSERT INTO table_name (col1, col2) VALUES (val1, val2);
  4. Select Queries

    • Basic Select: SELECT * FROM table_name;
    • Select Specific Columns: SELECT col1, col2 FROM table_name;
    • Select with Condition: SELECT * FROM table_name WHERE condition;
  5. Update Data

    • UPDATE table_name SET col1 = value1 WHERE condition;
  6. Delete Data

  7. Joins

    • Inner Join: SELECT * FROM table1 INNER JOIN table2 ON table1.col = table2.col;
    • Left Join: SELECT * FROM table1 LEFT JOIN table2 ON table1.col = table2.col;
    • Right Join: SELECT * FROM table1 RIGHT JOIN table2 ON table1.col = table2.col;
  8. Aggregations

    • Count: SELECT COUNT(*) FROM table_name;
    • Sum: SELECT SUM(col) FROM table_name;
    • Group By: SELECT col, COUNT(*) FROM table_name GROUP BY col;
  9. Sorting & Limiting

    • Order By: SELECT * FROM table_name ORDER BY col ASC|DESC;
    • Limit Results: SELECT * FROM table_name LIMIT n;
  10. Indexes

    • Create Index: CREATE INDEX idx_name ON table_name (col);
    • Drop Index: DROP INDEX idx_name;
  11. Subqueries

    • SELECT * FROM table_name WHERE col IN (SELECT col FROM other_table);
  12. Views

    • Create View: CREATE VIEW view_name AS SELECT * FROM table_name;
    • Drop View: DROP VIEW view_name;

Checkout this on WhatsApp for More Resources

Heroku

Simplify your DevOps and maximize your time.

Since 2007, Heroku has been the go-to platform for developers as it monitors uptime, performance, and infrastructure concerns, allowing you to focus on writing code.

Learn More

Top comments (0)

Image of AssemblyAI

Automatic Speech Recognition with AssemblyAI

Experience near-human accuracy, low-latency performance, and advanced Speech AI capabilities with AssemblyAI's Speech-to-Text API. Sign up today and get $50 in API credit. No credit card required.

Try the API

πŸ‘‹ Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay