{"id":"a927933d-6ae7-46e3-bd95-c333ea079487","title":"SQL for Analytics: Complete — Foundations and Tools","description":"SQL for Analytics: Complete — Foundations and Tools 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-foundations-and-tools-ee45ab8d-ed6.webp","createdAt":"2026-05-26T07:45:43.400Z","updatedAt":"2026-05-26T07:51:46.252Z","durationSeconds":79200,"authorId":"7ad5a0b9-ccaa-4db4-a813-43a2e920dbd4","rating":4.2,"reviewCount":20,"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 foundations and tools.","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":99,"features":[],"highlighted":true}],"minPricingTierPrice":99,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"f0b51449-15a0-45e2-9f07-f0befb46c59d","title":"SQL for Analytics: Complete — Foundations and Tools — course orientation and outcomes","description":"Lesson 1 of 8 in SQL for Analytics: Complete — Foundations and Tools: 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:45:43.400Z","updatedAt":"2026-05-26T07:45:43.400Z","courseId":"a927933d-6ae7-46e3-bd95-c333ea079487","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"2711dab2-d300-4087-9ef0-3ea7532c2fb6","title":"SQL for Analytics: Complete — Foundations and Tools — core concepts and mental models","description":"Lesson 2 of 8 in SQL for Analytics: Complete — Foundations and Tools: 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:45:43.400Z","updatedAt":"2026-05-26T07:45:43.400Z","courseId":"a927933d-6ae7-46e3-bd95-c333ea079487","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"fe62a250-3caf-47e2-b6fb-6083c8f3a4aa","title":"SQL for Analytics: Complete — Foundations and Tools — queries, models, and structure","description":"Lesson 3 of 8 in SQL for Analytics: Complete — Foundations and Tools: 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:45:43.400Z","updatedAt":"2026-05-26T07:45:43.400Z","courseId":"a927933d-6ae7-46e3-bd95-c333ea079487","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"897c945e-a33d-4310-95e6-4a5ce5fdfa1c","title":"SQL for Analytics: Complete — Foundations and Tools — data handling and preparation","description":"Lesson 4 of 8 in SQL for Analytics: Complete — Foundations and Tools: 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:45:43.400Z","updatedAt":"2026-05-26T07:45:43.400Z","courseId":"a927933d-6ae7-46e3-bd95-c333ea079487","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b6efe7cc-0f81-4a27-8ac0-cfd9904b1649","title":"SQL for Analytics: Complete — Foundations and Tools — real cases and guided practice","description":"Lesson 5 of 8 in SQL for Analytics: Complete — Foundations and Tools: 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:45:43.400Z","updatedAt":"2026-05-26T07:45:43.400Z","courseId":"a927933d-6ae7-46e3-bd95-c333ea079487","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"eb6e2475-977d-45b5-b8df-ee8e5328e4ed","title":"SQL for Analytics: Complete — Foundations and Tools — project build and review","description":"Lesson 6 of 8 in SQL for Analytics: Complete — Foundations and Tools: 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:45:43.400Z","updatedAt":"2026-05-26T07:45:43.400Z","courseId":"a927933d-6ae7-46e3-bd95-c333ea079487","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"fe165b51-3382-4bea-bd16-773d3b7a5786","title":"SQL for Analytics: Complete — Foundations and Tools — troubleshooting and common pitfalls","description":"Lesson 7 of 8 in SQL for Analytics: Complete — Foundations and Tools: 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:45:43.400Z","updatedAt":"2026-05-26T07:45:43.400Z","courseId":"a927933d-6ae7-46e3-bd95-c333ea079487","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"7f6bbafa-aef2-4239-bbe1-ac055ceb6066","title":"SQL for Analytics: Complete — Foundations and Tools — implementation, handoff, and next steps","description":"Lesson 8 of 8 in SQL for Analytics: Complete — Foundations and Tools: 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:45:43.400Z","updatedAt":"2026-05-26T07:45:43.400Z","courseId":"a927933d-6ae7-46e3-bd95-c333ea079487","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"7ad5a0b9-ccaa-4db4-a813-43a2e920dbd4","name":"Gavin Bennett","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/a28315ee-158a-457a-a6a8-2368dfd2db55.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}