SQL Go to guide - meta level insights
We cover the following topics. A quick read will suffice to revise and ramp up. pdf Link
SQL Principles
Proper use of Aliases
Filtering Data
Filtering data - Detailed Sections
- Using the WHERE Clause
- Using the FROM Clause (specifically in Joins with the ON Clause)
- Using the HAVING Clause
- Additional Points
- WHERE Versus HAVING – CAUTION AND TAKEAWAYS
Filtering data – Concise Summary with Sample codes
Recursive CTEs – Food for thought
- Basic Structure
- How It Works
- Use Cases
- Example
- Key Points to Remember
Solved Problems
- HackerRank Problem: Challenges Source
- HackerRank Problem: Contest Leaderboard Source
MySQL from the Command Line interface
- Accessing MySQL from terminal in MacOS
- Commonly used MySQL commands in terminal
Resources to follow
For Markdown preview, visit the link.