{"id":"72c7b64b-b25b-457c-bec5-56c3b54ddc61","title":"SQL for Analytics: Complete — Confident Applied Level","description":"SQL for Analytics: Complete — Confident Applied Level helps learners move from understanding to execution through 8 lessons (~22 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-complete-confident-applied-level-e9d94b33-210.webp","createdAt":"2026-05-26T07:46:35.438Z","updatedAt":"2026-05-26T07:51:46.251Z","durationSeconds":79200,"authorId":"88c46dc8-83e6-4ea2-b37b-4b559547faa9","rating":4.308510638297872,"reviewCount":94,"expectedLessonsCount":8,"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 8 lessons and about 22 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":"a98fd479-161d-412d-a7b0-ded8937decdf","title":"SQL for Analytics: Complete — Confident Applied Level — course orientation and outcomes","description":"Lesson 1 of 8 in SQL for Analytics: Complete — 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":9900,"position":0,"createdAt":"2026-05-26T07:46:35.438Z","updatedAt":"2026-05-26T07:46:35.438Z","courseId":"72c7b64b-b25b-457c-bec5-56c3b54ddc61","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"f86c0b34-4dbf-4c48-a83b-447c3ce6c18f","title":"SQL for Analytics: Complete — Confident Applied Level — core concepts and mental models","description":"Lesson 2 of 8 in SQL for Analytics: Complete — 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":9900,"position":1,"createdAt":"2026-05-26T07:46:35.438Z","updatedAt":"2026-05-26T07:46:35.438Z","courseId":"72c7b64b-b25b-457c-bec5-56c3b54ddc61","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"d094371b-a98a-426e-861c-ef7e8d98f8e5","title":"SQL for Analytics: Complete — Confident Applied Level — queries, models, and structure","description":"Lesson 3 of 8 in SQL for Analytics: Complete — 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":9900,"position":2,"createdAt":"2026-05-26T07:46:35.438Z","updatedAt":"2026-05-26T07:46:35.438Z","courseId":"72c7b64b-b25b-457c-bec5-56c3b54ddc61","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"c70102c5-1243-4e7f-8606-2a66bf2e4db7","title":"SQL for Analytics: Complete — Confident Applied Level — data handling and preparation","description":"Lesson 4 of 8 in SQL for Analytics: Complete — 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":9900,"position":3,"createdAt":"2026-05-26T07:46:35.438Z","updatedAt":"2026-05-26T07:46:35.438Z","courseId":"72c7b64b-b25b-457c-bec5-56c3b54ddc61","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"fcbcb175-8bb6-43c9-905b-1f2b9af4efb5","title":"SQL for Analytics: Complete — Confident Applied Level — real cases and guided practice","description":"Lesson 5 of 8 in SQL for Analytics: Complete — 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":9900,"position":4,"createdAt":"2026-05-26T07:46:35.438Z","updatedAt":"2026-05-26T07:46:35.438Z","courseId":"72c7b64b-b25b-457c-bec5-56c3b54ddc61","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b37aaa99-2566-4f86-bec7-ded07a24593c","title":"SQL for Analytics: Complete — Confident Applied Level — project build and review","description":"Lesson 6 of 8 in SQL for Analytics: Complete — 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":9900,"position":5,"createdAt":"2026-05-26T07:46:35.438Z","updatedAt":"2026-05-26T07:46:35.438Z","courseId":"72c7b64b-b25b-457c-bec5-56c3b54ddc61","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"c1f0ece8-98e0-4a2f-be41-8122870e10e9","title":"SQL for Analytics: Complete — Confident Applied Level — troubleshooting and common pitfalls","description":"Lesson 7 of 8 in SQL for Analytics: Complete — 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":9900,"position":6,"createdAt":"2026-05-26T07:46:35.438Z","updatedAt":"2026-05-26T07:46:35.438Z","courseId":"72c7b64b-b25b-457c-bec5-56c3b54ddc61","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"1cbd1620-61df-47ab-8248-28bf065356a0","title":"SQL for Analytics: Complete — Confident Applied Level — implementation, handoff, and next steps","description":"Lesson 8 of 8 in SQL for Analytics: Complete — 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":9900,"position":7,"createdAt":"2026-05-26T07:46:35.438Z","updatedAt":"2026-05-26T07:46:35.438Z","courseId":"72c7b64b-b25b-457c-bec5-56c3b54ddc61","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"88c46dc8-83e6-4ea2-b37b-4b559547faa9","name":"Andrew Ramsey","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/6b4ca94f-5f0a-471a-8552-7b14bf8f70d6.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}