Video Lessons
Learn at your own pace with high-quality, in-depth video tutorials. Each lesson is designed to guide you step-by-step through the concepts, ensuring you gain clarity and confidence.
- • Covers foundational to advanced topics in a logical sequence.
- • Accessible anytime, so you can re-watch and review as needed.
- • Clear explanations from an experienced instructor.
Slides Deck
Complement your learning with detailed written guides and resources. Perfect for revisiting key points or studying in-depth concepts anytime, anywhere.
- • Easy-to-follow breakdowns of key concepts.
- • Perfect for note-taking and offline study.
- • Includes bonus insights and examples not covered in videos.
Practical exercises
Put your skills to the test with hands-on exercises tailored to reinforce what you’ve learned. These real-world scenarios will help you build confidence and mastery.
- • Real-world scenarios to build practical expertise.
- • Step-by-step instructions to ensure you're never stuck.
- • Challenge yourself and track your progress.
Private discord access
Join a vibrant, supportive community of learners and experts. Get your questions answered, share ideas, and stay motivated as part of an exclusive network.
- • Connect with like-minded individuals to share ideas and collaborate.
- • Get instant answers to your questions from peers and mentors.
- • Stay updated with exclusive news, tips, and live Q&A sessions.
⭐⭐⭐⭐⭐
Pablo is the best of the best. He helped me with technical elements of Tableau, while still supporting my desire to learn. He is so helpful!
—Rachel, United States
- • Basic concepts are not explained
- • Master 47 SQL dialects you'll never use
- • Memorize SQL syntax to impress your interviewer
- • Read documentation longer than The Lord of the Rings
- • Write complex code when a simple AI prompt would do
- • Learn the fundamentals first
- • Use AI to code for you
- • Keep learning on the fly
- • Ask questions in case of doubt
⭐⭐⭐⭐⭐
A great communicator, very patient and greatly exceeded my expectations. Highly recommend.
—Mikey, United Kingdom
- 1. Introduction to SQL and Relational Databases
- 2. Setting Up Your Environment (Installations and Tools)
- 3. Basic SQL Syntax and Queries
- 4. Understanding Data Types in SQL
- 5. SELECT, FROM, and WHERE Clauses
- 6. Sorting Data with ORDER BY
- 7. Filtering Data with Comparison and Logical Operators
- 8. INSERT, UPDATE, and DELETE Statements
- 9. Understanding NULL Values and Handling Them
- 10. Using Aggregate Functions (SUM, AVG, COUNT, MIN, MAX)
- 11. Grouping Data with GROUP BY and HAVING Clauses
- 12. Aliases for Columns and Tables
- 13. Introduction to Database Normalization and Keys
- 14. INNER JOIN: Combining Data Across Tables
- 15. LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
- 16. CROSS JOIN and Self-Joins
- 17. Understanding and Using Subqueries
- 18. Window Functions (ROW_NUMBER, RANK, PARTITION BY)
- 19. Common Table Expressions (CTEs) and Recursive CTEs
- 20. Using CASE Statements for Conditional Logic
- 21. Understanding and Using UNION, INTERSECT, and EXCEPT
- 22. Introduction to Database Design and Schema Creation
- 23. Creating and Modifying Tables (CREATE, ALTER, DROP)
- 24. Understanding and Creating Indexes for Optimization
- 25. Transactions and Rollbacks: Ensuring Data Integrity
- 26. Using Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE)
⭐⭐⭐⭐⭐
Very professional. He knows the material and is very educated. Great customer service, will go above and beyond
—Hamza, United States
crack your interview
⭐⭐⭐⭐⭐
Good knowledge
—Reareath, India