{"id":"27f79752-eb67-41c7-ae66-ae58b89248ad","title":"SQL for Analytics: Blueprint — Systems and Routines","description":"SQL for Analytics: Blueprint — Systems and Routines is designed for career starters and switchers aged 25–34 who need a concrete, portfolio-ready result instead of abstract theory. Across 8 lessons and about 22 hours, the curriculum focuses on course orientation and outcomes, core concepts and mental models, and tools, setup, and learning environment; the final deliverable is a SQL query pack assembled with Tableau, pandas and data warehouses.","contentLanguage":"en","coverUrl":null,"createdAt":"2026-05-26T07:47:28.594Z","updatedAt":"2026-05-26T07:47:28.654Z","durationSeconds":79200,"authorId":"eb8c7ab1-7c7e-450c-b8c8-d3c79f81fb0f","rating":4.333333333333333,"reviewCount":9,"expectedLessonsCount":8,"trailerUrl":null,"faq":[{"answer":"Some familiarity helps, but the course still aligns the basics before moving into applied work.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 3–5 hours per week. In total, the course includes 8 lessons and about 22 hours of guided work.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a SQL query pack plus reusable materials built around Tableau and pandas.","question":"What will I finish the course with?"}],"learningOutcomes":null,"requirements":null,"levels":["intermediate"],"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":"d3562a4f-43d1-45fd-90b8-41fec9a6cb0c","title":"SQL for Analytics: Blueprint — Systems and Routines — course orientation and outcomes","description":"Lesson 1 of 8 in SQL for Analytics: Blueprint — Systems and Routines: work through course orientation and outcomes and turn the result into a reusable part of the final SQL query pack using Tableau and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":0,"createdAt":"2026-05-26T07:47:28.594Z","updatedAt":"2026-05-26T07:47:28.594Z","courseId":"27f79752-eb67-41c7-ae66-ae58b89248ad","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"7d34a6ef-9e65-4623-935b-e13e9efab88d","title":"SQL for Analytics: Blueprint — Systems and Routines — core concepts and mental models","description":"Lesson 2 of 8 in SQL for Analytics: Blueprint — Systems and Routines: work through core concepts and mental models and turn the result into a reusable part of the final SQL query pack using Tableau and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":1,"createdAt":"2026-05-26T07:47:28.594Z","updatedAt":"2026-05-26T07:47:28.594Z","courseId":"27f79752-eb67-41c7-ae66-ae58b89248ad","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"0c9b242d-9fe0-4b3d-b783-848a26e1d45b","title":"SQL for Analytics: Blueprint — Systems and Routines — tools, setup, and learning environment","description":"Lesson 3 of 8 in SQL for Analytics: Blueprint — Systems and Routines: work through tools, setup, and learning environment and turn the result into a reusable part of the final SQL query pack using Tableau and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":2,"createdAt":"2026-05-26T07:47:28.594Z","updatedAt":"2026-05-26T07:47:28.594Z","courseId":"27f79752-eb67-41c7-ae66-ae58b89248ad","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"d1cd72bb-0ecb-4441-a481-dcb063600071","title":"SQL for Analytics: Blueprint — Systems and Routines — practical workflows and process design","description":"Lesson 4 of 8 in SQL for Analytics: Blueprint — Systems and Routines: work through practical workflows and process design and turn the result into a reusable part of the final SQL query pack using Tableau and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":3,"createdAt":"2026-05-26T07:47:28.594Z","updatedAt":"2026-05-26T07:47:28.594Z","courseId":"27f79752-eb67-41c7-ae66-ae58b89248ad","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"4bfb9b19-ad4a-4f66-95a6-2caa60af1b95","title":"SQL for Analytics: Blueprint — Systems and Routines — real cases and guided practice","description":"Lesson 5 of 8 in SQL for Analytics: Blueprint — Systems and Routines: work through real cases and guided practice and turn the result into a reusable part of the final SQL query pack using Tableau and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":4,"createdAt":"2026-05-26T07:47:28.594Z","updatedAt":"2026-05-26T07:47:28.594Z","courseId":"27f79752-eb67-41c7-ae66-ae58b89248ad","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"94793917-55aa-4c94-8597-d09e5e312d6e","title":"SQL for Analytics: Blueprint — Systems and Routines — project build and review","description":"Lesson 6 of 8 in SQL for Analytics: Blueprint — Systems and Routines: work through project build and review and turn the result into a reusable part of the final SQL query pack using Tableau and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":5,"createdAt":"2026-05-26T07:47:28.594Z","updatedAt":"2026-05-26T07:47:28.594Z","courseId":"27f79752-eb67-41c7-ae66-ae58b89248ad","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"7e9a131d-7124-43cc-8420-f88e2d8db357","title":"SQL for Analytics: Blueprint — Systems and Routines — implementation, handoff, and next steps","description":"Lesson 7 of 8 in SQL for Analytics: Blueprint — Systems and Routines: work through implementation, handoff, and next steps and turn the result into a reusable part of the final SQL query pack using Tableau and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":6,"createdAt":"2026-05-26T07:47:28.594Z","updatedAt":"2026-05-26T07:47:28.594Z","courseId":"27f79752-eb67-41c7-ae66-ae58b89248ad","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"3d105755-9e80-4603-b49b-adaae2e7e853","title":"SQL for Analytics: Blueprint — Systems and Routines — queries, models, and structure","description":"Lesson 8 of 8 in SQL for Analytics: Blueprint — Systems and Routines: work through queries, models, and structure and turn the result into a reusable part of the final SQL query pack using Tableau and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":7,"createdAt":"2026-05-26T07:47:28.594Z","updatedAt":"2026-05-26T07:47:28.594Z","courseId":"27f79752-eb67-41c7-ae66-ae58b89248ad","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"eb8c7ab1-7c7e-450c-b8c8-d3c79f81fb0f","name":"Edward Hughes","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/02d9ccd6-e816-46b3-a1cf-44baf4d9f0ae.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}