How to Actually Get Started with SQL CS16 - A clear (and human) guide to get started without drowning

START LEARNING

𝗦𝗤𝗟

RIGHT NOW!!

www.databites.tech/p/how-to-ac...

Did you like this post?

Then join the DataBites newsletter to get weekly issues about Data Science and more! 🧩

👉🏻 databites.tech

How to Actually Get Started with SQL CS16 - A clear (and human) guide to get started without drowning

If you like this thread, go check the original article‼️

www.databites.tech/p/how-to-ac...

15. 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗦𝗤𝗟 𝗧𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀
For seasoned users, explore sophisticated SQL features:
• Windows Functions, Recursive Queries
• Pivot/Unpivot Operations, Common Table Expressions (CTE)

The two final steps is learning how to craft better and more optimized SQL queries.

14. 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻
Techniques to enhance the efficiency of your queries:
• Query Analysis, Optimizing JOINS, Reducing Subqueries

13. 𝗗𝗮𝘁𝗮 𝗜𝗻𝘁𝗲𝗴𝗿𝗶𝘁𝘆 𝗮𝗻𝗱 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆
Now that you are here, I strongly recommend you get familiar with security best practices. Maintain the security and integrity of your database:
• Using GRANT and REVOKE
• Database Security Best Practices

Now you should focus on crafting better queries by leveraging indexes and following best security practices 💥

12. 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗶𝗻𝗴 𝘄𝗶𝘁𝗵 𝗜𝗻𝗱𝗲𝘅𝗲𝘀
Indexes improve query performance:
• Unique, Clustered, and Non-Clustered Indexes

Once a result is good, you might want to create a view!
11. 𝗪𝗼𝗿𝗸𝗶𝗻𝗴 𝘄𝗶𝘁𝗵 𝗩𝗶𝗲𝘄𝘀
Views can simplify complex queries:
• Creating, Modifying, and Dropping Views

Now you should understand advanced syntax like specific functions and new ways of merging data like UNION.

10. 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗦𝘆𝗻𝘁𝗮𝘅
Explore more complex SQL operations:
• UNION, INTERSECT, EXCEPT
• CASE, COALESCE, and Functions for NULL Handling

Your SQL skills here are already really good!! 🙌🏻
But learning must go on…

9. 𝗟𝗲𝘃𝗲𝗿𝗮𝗴𝗶𝗻𝗴 𝗦𝘂𝗯𝗾𝘂𝗲𝗿𝗶𝗲𝘀
As queries keep getting more complex, you need to create subqueries.
• Nested and Correlated Subqueries
• EXISTS and NOT EXISTS

Our data will usually be spread across many different tables, this is why being able to merge data from different sources is crucial in SQL.

8. 𝗠𝗮𝘀𝘁𝗲𝗿𝗶𝗻𝗴 𝗝𝗢𝗜𝗡𝘀
JOINs are critical for combining data from multiple tables:
• INNER, LEFT, RIGHT, and FULL OUTER JOINs

How to Actually Get Started with SQL CS16 - A clear (and human) guide to get started without drowning

If you like this thread, go check the original article‼️

www.databites.tech/p/how-to-ac...

👉🏻 This will be one of the most important steps when creating KPIs and specific metrics.

7. 𝗘𝗻𝗳𝗼𝗿𝗰𝗶𝗻𝗴 𝗖𝗼𝗻𝘀𝘁𝗿𝗮𝗶𝗻𝘁𝘀
Ensure data integrity through constraints:
• PRIMARY KEY, FOREIGN KEY, UNIQUE
• NOT NULL and CHECK Constraints

Now you should keep getting better with SQL programming language 💥

6. 𝗨𝗻𝗱𝗲𝗿𝘀𝘁𝗮𝗻𝗱𝗶𝗻𝗴 𝗔𝗴𝗴𝗿𝗲𝗴𝗮𝘁𝗶𝗼𝗻
Aggregate functions are powerful tools for summarizing data:
• SUM, AVG, COUNT, MAX, MIN

5. 𝗗𝗮𝘁𝗮 𝗠𝗮𝗻𝗶𝗽𝘂𝗹𝗮𝘁𝗶𝗼𝗻
Get hands-on with inserting, updating, and deleting data:
• INSERT, UPDATE, DELETE Commands

Already proficient with basic commands?

Now it’s turn to understand how to manage databases with the following two steps:

4. 𝗗𝗮𝘁𝗮 𝗗𝗲𝗳𝗶𝗻𝗶𝘁𝗶𝗼𝗻
Learn how to structure and manage your databases with:
• CREATE, ALTER, DROP Statements

3. 𝗠𝗮𝘀𝘁𝗲𝗿𝗶𝗻𝗴 𝗕𝗮𝘀𝗶𝗰 𝗞𝗲𝘆𝘄𝗼𝗿𝗱𝘀
The first real step is to familiarize yourself with the commands that form the backbone of SQL querying:

• SELECT, FROM, WHERE
• ORDER BY and LIMIT Clauses

2. 𝗘𝘅𝗽𝗹𝗼𝗿𝗶𝗻𝗴 𝗗𝗮𝘁𝗮 𝗧𝘆𝗽𝗲𝘀
Once you have a clear image of SQL, you should understand the core data types you will be working with 👇🏻

• Integers, Decimals, and Booleans
• Character Types: CHAR and VARCHAR
• Dates and Binary Data

How to Actually Get Started with SQL CS16 - A clear (and human) guide to get started without drowning

If you like this thread, go check the original article‼️

www.databites.tech/p/how-to-ac...

1. 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝘁𝗵𝗲 𝗕𝗮𝘀𝗶𝗰𝘀
Before diving deep, it's essential to grasp what is SQL.

Begin with:
• What is a Relational Database?
• Comparing SQL and NoSQL Databases
• Understanding SQL Syntax and Basic Commands

🚀 New to SQL?

Then here’s a roadmap to get you started in 2025, step-by-step! 🧵👇

(Don't forget to bookmark for later!! 😉 )

Did you like this post?

Then join the DataBites newsletter to get weekly issues about Data Science and more! 🧩

👉🏻 databites.tech

This roadmap covers everything you need to go from a beginner to an advanced Python programmer! 🌱

17. 𝗗𝗲𝘃𝗢𝗽𝘀 𝗮𝗻𝗱 𝗗𝗲𝗽𝗹𝗼𝘆𝗺𝗲𝗻𝘁
Integrate Python into DevOps practices to deploy and scale your applications. Understanding CI/CD, Docker, and cloud deployment will make your skills industry-ready.

16. 𝗧𝗲𝘀𝘁𝗶𝗻𝗴
Testing is essential for reliable software! Learn the basics of Doctest, Nose, Pytest, and Unittest. These tools help ensure that your code works as expected.

15. 𝗖𝗼𝗺𝗺𝗼𝗻 𝗣𝗮𝗰𝗸𝗮𝗴𝗲𝘀
Familiarize yourself with essential packages like typing for type hints and tox for testing multiple environments. These are invaluable for robust, maintainable code.

14. 𝗗𝗼𝗰𝘂𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻
Documenting your code is crucial for clarity and collaboration. Learn to use Sphinx to generate beautiful, automated documentation that helps others understand your code.

13. 𝗖𝗼𝗱𝗲 𝗙𝗼𝗿𝗺𝗮𝘁𝘁𝗶𝗻𝗴
Clean, readable code is a must! Use tools like Black, YAPF, and Ruff to maintain consistent formatting across your projects. It’s a small habit that makes a big difference.

12. 𝗦𝘁𝗮𝘁𝗶𝗰 𝗧𝘆𝗽𝗶𝗻𝗴
Enhance readability and reduce errors with static typing! Libraries like Pydantic, Mypy, Pyright, and Pyre bring optional type hints to Python, making your code safer and easier to understand.

11. 𝗠𝗮𝗻𝗮𝗴𝗲 𝗘𝗻𝘃𝗶𝗿𝗼𝗻𝗺𝗲𝗻𝘁𝘀
Keep your projects organized! Use tools like Virtualenv, Pyenv, and Pipenv to manage different Python environments and dependencies for each project.