{"id":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases","description":"SQL for Analytics: Bootcamp — Step-by-Step Cases helps learners move from understanding to execution through 9 lessons (~25 hours). It is aimed at career starters and switchers aged 25–34, with emphasis on core concepts and mental models, queries, models, and structure and data handling and preparation, and ends with a SQL analysis project that can be used in work or in a portfolio.","contentLanguage":"en","coverUrl":"/course-covers/sql-for-analytics-bootcamp-step-by-step-cases-3ad30ff5-651.webp","createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:51:46.245Z","durationSeconds":90000,"authorId":"5173ffc6-c0f4-4be3-8f61-bf8cb8dfbe2f","rating":4.65,"reviewCount":20,"expectedLessonsCount":9,"trailerUrl":null,"faq":[{"answer":"Basic understanding of tables and metrics is helpful. The course starts with a clear ramp-up and then moves into step-by-step cases.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 4–6 hours per week. In total, the course includes 9 lessons and about 25 hours of guided study.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a SQL analysis project plus reusable materials built around SQL, joins and aggregations.","question":"What will I finish the course with?"}],"learningOutcomes":null,"requirements":null,"levels":["advanced"],"firstLessonFreePreviewEnabled":false,"certificateEnabled":true,"isPlatformCourse":false,"pricingTiers":[{"id":"standard","name":"Standard","price":119,"features":[],"highlighted":true}],"minPricingTierPrice":119,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"c989c7de-9964-4828-8aee-89b8b0e58c4c","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases — course orientation and outcomes","description":"Lesson 1 of 9 in SQL for Analytics: Bootcamp — Step-by-Step Cases: work through course orientation and outcomes in the context of SQL for Analytics, and turn the result into a reusable part of the final SQL analysis project using SQL and joins.","videoUrl":null,"videoFileName":null,"duration":10000,"position":0,"createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:45:51.436Z","courseId":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"f9990476-7eaa-4717-8d3a-005baacad687","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases — core concepts and mental models","description":"Lesson 2 of 9 in SQL for Analytics: Bootcamp — Step-by-Step Cases: work through core concepts and mental models in the context of SQL for Analytics, and turn the result into a reusable part of the final SQL analysis project using SQL and joins.","videoUrl":null,"videoFileName":null,"duration":10000,"position":1,"createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:45:51.436Z","courseId":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"1d861b18-8496-4d4e-ae99-7e1ce35a5c42","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases — queries, models, and structure","description":"Lesson 3 of 9 in SQL for Analytics: Bootcamp — Step-by-Step Cases: work through queries, models, and structure in the context of SQL for Analytics, and turn the result into a reusable part of the final SQL analysis project using SQL and joins.","videoUrl":null,"videoFileName":null,"duration":10000,"position":2,"createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:45:51.436Z","courseId":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"4b119a99-cf1a-4eff-9f05-393433cc4ed8","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases — data handling and preparation","description":"Lesson 4 of 9 in SQL for Analytics: Bootcamp — Step-by-Step Cases: work through data handling and preparation in the context of SQL for Analytics, and turn the result into a reusable part of the final SQL analysis project using SQL and joins.","videoUrl":null,"videoFileName":null,"duration":10000,"position":3,"createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:45:51.436Z","courseId":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"503c6051-17cc-4f17-9dfe-b2f71aaa66dc","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases — real cases and guided practice","description":"Lesson 5 of 9 in SQL for Analytics: Bootcamp — Step-by-Step Cases: work through real cases and guided practice in the context of SQL for Analytics, and turn the result into a reusable part of the final SQL analysis project using SQL and joins.","videoUrl":null,"videoFileName":null,"duration":10000,"position":4,"createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:45:51.436Z","courseId":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b3725782-0cce-4c03-b9e7-7b0660193900","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases — project build and review","description":"Lesson 6 of 9 in SQL for Analytics: Bootcamp — Step-by-Step Cases: work through project build and review in the context of SQL for Analytics, and turn the result into a reusable part of the final SQL analysis project using SQL and joins.","videoUrl":null,"videoFileName":null,"duration":10000,"position":5,"createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:45:51.436Z","courseId":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"a876bc54-73d1-4b21-b975-033dec3b78af","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases — troubleshooting and common pitfalls","description":"Lesson 7 of 9 in SQL for Analytics: Bootcamp — Step-by-Step Cases: work through troubleshooting and common pitfalls in the context of SQL for Analytics, and turn the result into a reusable part of the final SQL analysis project using SQL and joins.","videoUrl":null,"videoFileName":null,"duration":10000,"position":6,"createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:45:51.436Z","courseId":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"aaf9bf65-fe97-43e0-9468-5046ab84af72","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases — metrics, quality, and decision criteria","description":"Lesson 8 of 9 in SQL for Analytics: Bootcamp — Step-by-Step Cases: work through metrics, quality, and decision criteria in the context of SQL for Analytics, and turn the result into a reusable part of the final SQL analysis project using SQL and joins.","videoUrl":null,"videoFileName":null,"duration":10000,"position":7,"createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:45:51.436Z","courseId":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"c360000f-b326-4847-9b29-86e0c865c8f9","title":"SQL for Analytics: Bootcamp — Step-by-Step Cases — implementation, handoff, and next steps","description":"Lesson 9 of 9 in SQL for Analytics: Bootcamp — Step-by-Step Cases: work through implementation, handoff, and next steps in the context of SQL for Analytics, and turn the result into a reusable part of the final SQL analysis project using SQL and joins.","videoUrl":null,"videoFileName":null,"duration":10000,"position":8,"createdAt":"2026-05-26T07:45:51.436Z","updatedAt":"2026-05-26T07:45:51.436Z","courseId":"8c1238e8-08cc-48e9-9b8a-70dd33079e00","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"5173ffc6-c0f4-4be3-8f61-bf8cb8dfbe2f","name":"Nicholas Brooks","avatarUrl":null,"bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}