{"id":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","title":"SQL for Analytics: Bootcamp — Confident Applied Level","description":"SQL for Analytics: Bootcamp — Confident Applied Level 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-confident-applied-level-80c52569-def.webp","createdAt":"2026-05-26T07:46:33.678Z","updatedAt":"2026-05-26T07:51:46.241Z","durationSeconds":90000,"authorId":"0b6fe73f-1a5c-42e2-9112-c5781288e3ed","rating":4.555555555555555,"reviewCount":9,"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 confident applied level.","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":149,"features":[],"highlighted":true}],"minPricingTierPrice":149,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"7f785069-fd0f-4dce-aad9-9655314851d8","title":"SQL for Analytics: Bootcamp — Confident Applied Level — course orientation and outcomes","description":"Lesson 1 of 9 in SQL for Analytics: Bootcamp — Confident Applied Level: 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:46:33.678Z","updatedAt":"2026-05-26T07:46:33.678Z","courseId":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"ea5b68a1-ff0f-45be-a3c8-d28732f5c713","title":"SQL for Analytics: Bootcamp — Confident Applied Level — core concepts and mental models","description":"Lesson 2 of 9 in SQL for Analytics: Bootcamp — Confident Applied Level: 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:46:33.678Z","updatedAt":"2026-05-26T07:46:33.678Z","courseId":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"bda46dae-2243-40cd-b54d-cebaa57c4b34","title":"SQL for Analytics: Bootcamp — Confident Applied Level — queries, models, and structure","description":"Lesson 3 of 9 in SQL for Analytics: Bootcamp — Confident Applied Level: 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:46:33.678Z","updatedAt":"2026-05-26T07:46:33.678Z","courseId":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"0de80b62-7648-4e1f-8748-4f2f997c55a2","title":"SQL for Analytics: Bootcamp — Confident Applied Level — data handling and preparation","description":"Lesson 4 of 9 in SQL for Analytics: Bootcamp — Confident Applied Level: 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:46:33.678Z","updatedAt":"2026-05-26T07:46:33.678Z","courseId":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"380105cd-92e6-4558-9776-20af53e057db","title":"SQL for Analytics: Bootcamp — Confident Applied Level — real cases and guided practice","description":"Lesson 5 of 9 in SQL for Analytics: Bootcamp — Confident Applied Level: 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:46:33.678Z","updatedAt":"2026-05-26T07:46:33.678Z","courseId":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8640330b-cd59-4d66-be01-616e67a65579","title":"SQL for Analytics: Bootcamp — Confident Applied Level — project build and review","description":"Lesson 6 of 9 in SQL for Analytics: Bootcamp — Confident Applied Level: 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:46:33.678Z","updatedAt":"2026-05-26T07:46:33.678Z","courseId":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"ba9d0bec-79b9-4ca4-996e-4677239a962e","title":"SQL for Analytics: Bootcamp — Confident Applied Level — troubleshooting and common pitfalls","description":"Lesson 7 of 9 in SQL for Analytics: Bootcamp — Confident Applied Level: 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:46:33.678Z","updatedAt":"2026-05-26T07:46:33.678Z","courseId":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"f10dbe86-ec6b-4c31-aa69-17f3ce4801f0","title":"SQL for Analytics: Bootcamp — Confident Applied Level — metrics, quality, and decision criteria","description":"Lesson 8 of 9 in SQL for Analytics: Bootcamp — Confident Applied Level: 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:46:33.678Z","updatedAt":"2026-05-26T07:46:33.678Z","courseId":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"e94e4969-ff6e-4e8e-9e02-706d6d5a8a30","title":"SQL for Analytics: Bootcamp — Confident Applied Level — implementation, handoff, and next steps","description":"Lesson 9 of 9 in SQL for Analytics: Bootcamp — Confident Applied Level: 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:46:33.678Z","updatedAt":"2026-05-26T07:46:33.678Z","courseId":"1f79ad7a-7e24-431c-9e6e-267289c32e9d","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"0b6fe73f-1a5c-42e2-9112-c5781288e3ed","name":"Oliver Porter","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/974b0d8e-1453-47df-aa0c-2d558e05a0c3.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}