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
- DELETE FROM table_name WHERE condition;

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;

Here you can find SQL Interview Resources👇
https://t.iss.one/DataSimplifier

Share with credits: https://t.iss.one/sqlspecialist

Hope it helps :)

Beware of any recruiter who asks for money for interview scheduling, certification, or references etc. This is a clear sign of a scam and a fake hiring process.

- No Payment Required: In the IT industry, you should never have to make any kind of payment to get hired. Legitimate companies and recruiters do not charge candidates for job opportunities.

- Third-Party Agencies: Even when you are working with third-party agencies, these agencies charge the employer (their clients), not you.

Red Flags to Identify Scams:

- Payment Requests: If a recruiter asks for money at any stage, it is likely a scam.

- Unverified Contacts: Be cautious if the recruiter’s contact information or company details cannot be verified.

- Pressure Tactics: Scammers often use urgency or pressure tactics to get you to pay quickly.

Always remember: never pay for a job opportunity. If a recruiter or agency asks for money, it is a scam. Stay away and protect yourself from fraudulent practices.

𝗟𝗲𝗮𝗿𝗻 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 (𝗡𝗼 𝗦𝘁𝗿𝗶𝗻𝗴𝘀 𝗔𝘁𝘁𝗮𝗰𝗵𝗲𝗱)

𝗡𝗼 𝗳𝗮𝗻𝗰𝘆 𝗰𝗼𝘂𝗿𝘀𝗲𝘀, 𝗻𝗼 𝗰𝗼𝗻𝗱𝗶𝘁𝗶𝗼𝗻𝘀, 𝗷𝘂𝘀𝘁 𝗽𝘂𝗿𝗲 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴.

𝗛𝗲𝗿𝗲’𝘀 𝗵𝗼𝘄 𝘁𝗼 𝗯𝗲𝗰𝗼𝗺𝗲 𝗮 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝘁𝗶𝘀𝘁 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘:

1️⃣ Python Programming for Data Science → Harvard’s CS50P
The best intro to Python for absolute beginners:
↬ Covers loops, data structures, and practical exercises.
↬ Designed to help you build foundational coding skills.

Link: https://cs50.harvard.edu/python/

https://t.iss.one/datasciencefun

2️⃣ Statistics & Probability → Khan Academy
Want to master probability, distributions, and hypothesis testing? This is where to start:
↬ Clear, beginner-friendly videos.
↬ Exercises to test your skills.

Link: https://www.khanacademy.org/math/statistics-probability

https://whatsapp.com/channel/0029Vat3Dc4KAwEcfFbNnZ3O

3️⃣ Linear Algebra for Data Science → 3Blue1Brown
↬ Learn about matrices, vectors, and transformations.
↬ Essential for machine learning models.

Link: https://www.youtube.com/playlist?list=PLZHQObOWTQDMsr9KzVk3AjplI5PYPxkUr

4️⃣ SQL Basics → Mode Analytics
SQL is the backbone of data manipulation. This tutorial covers:
↬ Writing queries, joins, and filtering data.
↬ Real-world datasets to practice.

Link: https://mode.com/sql-tutorial

https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v

5️⃣ Data Visualization → freeCodeCamp
Learn to create stunning visualizations using Python libraries:
↬ Covers Matplotlib, Seaborn, and Plotly.
↬ Step-by-step projects included.

Link: https://www.youtube.com/watch?v=JLzTJhC2DZg

https://whatsapp.com/channel/0029VaxaFzoEQIaujB31SO34

6️⃣ Machine Learning Basics → Google’s Machine Learning Crash Course
An in-depth introduction to machine learning for beginners:
↬ Learn supervised and unsupervised learning.
↬ Hands-on coding with TensorFlow.

Link: https://developers.google.com/machine-learning/crash-course

7️⃣ Deep Learning → Fast.ai’s Free Course
Fast.ai makes deep learning easy and accessible:
↬ Build neural networks with PyTorch.
↬ Learn by coding real projects.

Link: https://course.fast.ai/

8️⃣ Data Science Projects → Kaggle
↬ Compete in challenges to practice your skills.
↬ Great way to build your portfolio.

Link: https://www.kaggle.com/

Dear Data Analyst:

If you are learning Excel

Use this: