{"id":"99c68b79-3ee8-40b0-97bf-f5eab923c140","title":"Foundations: Blueprint — Portfolio and Practice","description":"Foundations: Blueprint — Portfolio and Practice is aimed at working specialists and managers aged 25–44 who need a structured upgrade they can deploy at work quickly. The program includes 8 lessons and about 22 hours, with emphasis on course orientation and outcomes, core concepts and mental models, and tools, setup, and learning environment; the capstone is a SQL query pack produced with Excel, pandas and Python.","contentLanguage":"en","coverUrl":"/course-covers/foundations-blueprint-portfolio-and-practice-cc5a7994-f43.webp","createdAt":"2026-05-26T07:47:23.275Z","updatedAt":"2026-05-26T07:51:43.544Z","durationSeconds":79200,"authorId":"8af8e188-0076-48fe-881e-7269657a79e9","rating":4.506849315068493,"reviewCount":73,"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 Excel and pandas.","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":109,"features":[],"highlighted":true}],"minPricingTierPrice":109,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8426e212-0e70-4365-981a-f375e42464f6","lessons":[{"id":"aa44d0aa-8b62-4d82-a185-aab74d667f14","title":"Foundations: Blueprint — Portfolio and Practice — course orientation and outcomes","description":"Lesson 1 of 8 in Foundations: Blueprint — Portfolio and Practice: work through course orientation and outcomes and turn the result into a reusable part of the final SQL query pack using Excel and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":0,"createdAt":"2026-05-26T07:47:23.275Z","updatedAt":"2026-05-26T07:47:23.275Z","courseId":"99c68b79-3ee8-40b0-97bf-f5eab923c140","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"a878c88d-5753-4cf8-9a21-9e49b4e81fc8","title":"Foundations: Blueprint — Portfolio and Practice — core concepts and mental models","description":"Lesson 2 of 8 in Foundations: Blueprint — Portfolio and Practice: work through core concepts and mental models and turn the result into a reusable part of the final SQL query pack using Excel and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":1,"createdAt":"2026-05-26T07:47:23.275Z","updatedAt":"2026-05-26T07:47:23.275Z","courseId":"99c68b79-3ee8-40b0-97bf-f5eab923c140","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"bf5ee717-5729-4517-8911-bafbb18f0efe","title":"Foundations: Blueprint — Portfolio and Practice — tools, setup, and learning environment","description":"Lesson 3 of 8 in Foundations: Blueprint — Portfolio and Practice: work through tools, setup, and learning environment and turn the result into a reusable part of the final SQL query pack using Excel and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":2,"createdAt":"2026-05-26T07:47:23.275Z","updatedAt":"2026-05-26T07:47:23.275Z","courseId":"99c68b79-3ee8-40b0-97bf-f5eab923c140","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"2e320652-2a61-44b2-bec2-996f3fa802c9","title":"Foundations: Blueprint — Portfolio and Practice — practical workflows and process design","description":"Lesson 4 of 8 in Foundations: Blueprint — Portfolio and Practice: work through practical workflows and process design and turn the result into a reusable part of the final SQL query pack using Excel and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":3,"createdAt":"2026-05-26T07:47:23.275Z","updatedAt":"2026-05-26T07:47:23.275Z","courseId":"99c68b79-3ee8-40b0-97bf-f5eab923c140","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"45c4ec87-ce6b-4c9f-990c-9e20c37b1ea1","title":"Foundations: Blueprint — Portfolio and Practice — real cases and guided practice","description":"Lesson 5 of 8 in Foundations: Blueprint — Portfolio and Practice: work through real cases and guided practice and turn the result into a reusable part of the final SQL query pack using Excel and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":4,"createdAt":"2026-05-26T07:47:23.275Z","updatedAt":"2026-05-26T07:47:23.275Z","courseId":"99c68b79-3ee8-40b0-97bf-f5eab923c140","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"4f1f9950-a7c7-442c-baac-5b593f9de6ba","title":"Foundations: Blueprint — Portfolio and Practice — project build and review","description":"Lesson 6 of 8 in Foundations: Blueprint — Portfolio and Practice: work through project build and review and turn the result into a reusable part of the final SQL query pack using Excel and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":5,"createdAt":"2026-05-26T07:47:23.275Z","updatedAt":"2026-05-26T07:47:23.275Z","courseId":"99c68b79-3ee8-40b0-97bf-f5eab923c140","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"908a1499-926f-45e6-a936-e927be44f233","title":"Foundations: Blueprint — Portfolio and Practice — implementation, handoff, and next steps","description":"Lesson 7 of 8 in Foundations: Blueprint — Portfolio and Practice: work through implementation, handoff, and next steps and turn the result into a reusable part of the final SQL query pack using Excel and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":6,"createdAt":"2026-05-26T07:47:23.275Z","updatedAt":"2026-05-26T07:47:23.275Z","courseId":"99c68b79-3ee8-40b0-97bf-f5eab923c140","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"10ce64b7-2d03-406b-8794-1b2b87aa8b16","title":"Foundations: Blueprint — Portfolio and Practice — metrics, quality, and decision criteria","description":"Lesson 8 of 8 in Foundations: Blueprint — Portfolio and Practice: work through metrics, quality, and decision criteria and turn the result into a reusable part of the final SQL query pack using Excel and pandas.","videoUrl":null,"videoFileName":null,"duration":9900,"position":7,"createdAt":"2026-05-26T07:47:23.275Z","updatedAt":"2026-05-26T07:47:23.275Z","courseId":"99c68b79-3ee8-40b0-97bf-f5eab923c140","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"8af8e188-0076-48fe-881e-7269657a79e9","name":"Charles Griffin","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/f8cd0611-bec6-4a2d-8ae0-7eaa90b4f901.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}