Stop Skipping SQL Fundamentals: One Hands-On Guide from Basics to Advanced

Hey everyone!
Just brushed up on my SQL fundamentals again while sitting through 8-hour-LONG!!!! tutorials. 😭
I’ve noticed that even some paid courses don’t cover very basic concepts despite having 6+ hours of content.
So, I decided to create a single ".ipynb" file that covers SQL from fundamentals to advanced concepts, with hands-on examples throughout.
Here’s the link: https://lnkd.in/gsHP_wx9
Let me know what you think And if you ever have doubts while learning, feel free to irritate me with DMs. 😂
Hope it helps someone!

What checks out

• The GitHub repository exists and is public: LShreeChaithanya/Solid_fundamentals_SQL.
• It contains a main Jupyter notebook named sql_learning.ipynb, along with Python/MySQL code, a regex cheat sheet, diagrams, and project configuration files.
• The notebook genuinely covers a broad range of MySQL topics, including:
  • SQL syntax and DDL
  • Filtering and aggregation
  • Joins
  • Date/string operations
  • NULL handling
  • Set operations
  • Subqueries
  • Transactions
  • GRANT / REVOKE
  • Window functions
  • Partitioning
• The LinkedIn post itself is verifiable: a LinkedIn profile for Shree Chaithanya contains the same SQL-learning post and references this repository.

⚠️ Claims that need qualification

“covers SQL from fundamentals to advanced concepts”
➡️ Mostly true, but specifically it's a MySQL-focused learning notebook, not a comprehensive guide to every SQL dialect. The repository explicitly describes itself as a MySQL Learning Notebook.

“all the fundamental and certain advanced concepts of SQL”
➡️ This is the author's description, not an objectively verifiable claim that all SQL fundamentals/advanced concepts are included. The repo does cover many important areas, but SQL is much broader.

“prominently skipped in many courses”
➡️ Not independently verifiable. That's an opinion/generalization unless supported by a systematic comparison of courses.

“single .ipynb file”
➡️ Slightly misleading. There is a central sql_learning.ipynb, but the repository also contains other files such as mysql_python.py, regex.html, diagrams, and configuration files.

🚨 One important issue

The repository's own README says the notebook and Python example contain example local credentials root/root and recommends replacing them with environment variables or proper secret management.

That's not necessarily a security breach if they're dummy/local credentials, but it's something I'd flag before recommending people blindly run the code.

Verdict

The post is genuine, but some wording is promotional rather than objectively proven.