Watch The Complete Sql Bootcamp 2020: Go From Zero To Hero Course

Once the basics are down, the course ramps up. This is where the data manipulation happens. You dive into:

SELECT c.first_name, c.last_name, SUM(p.amount) AS total_spent FROM customer c JOIN payment p ON c.customer_id = p.customer_id GROUP BY c.customer_id HAVING COUNT(p.rental_id) > 30 ORDER BY total_spent DESC; Once the basics are down, the course ramps up

| Aspect | Evaluation | |--------|-------------| | | Excellent for beginners – slow, clear explanations. | | Hands-on | Every concept includes a practice exercise. | | Real-world examples | Uses DVD rental database (realistic business scenario). | | Instructor style | Jose Portilla is known for clear, engaging delivery. | | Resources | Downloadable SQL scripts, exercise solutions, and notes. | | Time efficiency | ~9 hours of video (can be completed in 1-2 weeks part-time). | | | Hands-on | Every concept includes a practice exercise

The course is divided into several sections: | | Resources | Downloadable SQL scripts, exercise