A SQL complete tutorial, from beginner to advanced, covering MySQL database fundamentals and advanced topics. It's created by Mosh Hamedani.
It covers the following topics:
- Complex SQL queries
- Joins (inner, outer, natural, cross)
- Views
- Stored procedures
- Functions
- Events
- Triggers
- Transactions
- Concurrency
- Use indexing for performance
- Design relational databases
- Secure databases
The '15_Additional SQL' section refers to the comprehensive SQL tutorial (from basic to advanced) on mode.com.
The last one '16_Intuitive SQL for Analytics' documents all the examples covered by the same course mentored by Vlad Gheorghe. More information is available on this link. Don't skip this gem! 🚀