{"id":"22205b08-91c3-48eb-960d-78be473eb015","title":"SQL for Analytics: Office Hours — Projects for Portfolio and Interviews","description":"SQL for Analytics: Office Hours — Projects for Portfolio and Interviews is built for career starters and switchers aged 25–34 who want a concrete, portfolio-ready result rather than abstract theory. Across 6 lessons and about 14 hours, the course focuses on course orientation and outcomes, foundations and working vocabulary, and SQL exploration; the capstone is a SQL project portfolio built with Excel and dbt.","contentLanguage":"en","coverUrl":null,"createdAt":"2026-05-26T07:50:46.853Z","updatedAt":"2026-05-26T07:50:46.899Z","durationSeconds":50400,"authorId":"dd809298-ebec-4217-9076-6175be33e909","rating":4.166666666666667,"reviewCount":6,"expectedLessonsCount":6,"trailerUrl":null,"faq":[{"answer":"A minimal base is recommended, but the opening block still aligns terminology, tools, and expectations before practice.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 3–5 hours per week. In total, the course includes 6 lessons and about 14 hours of guided work.","question":"How much time should I set aside each week?"},{"answer":"You will finish with a SQL project portfolio plus reusable materials built around Excel and dbt.","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":"8eb83ed3-c3a2-4589-bda3-ebcbb53b0855","title":"SQL for Analytics: Office Hours — Projects for Portfolio and Interviews — course orientation and outcomes","description":"Lesson 1 of 6 in SQL for Analytics: Office Hours — Projects for Portfolio and Interviews: work through course orientation and outcomes and convert the result into a reusable part of the final SQL project portfolio using Excel and dbt.","videoUrl":null,"videoFileName":null,"duration":8400,"position":0,"createdAt":"2026-05-26T07:50:46.853Z","updatedAt":"2026-05-26T07:50:46.853Z","courseId":"22205b08-91c3-48eb-960d-78be473eb015","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"e1c8a512-c53f-4ca9-bafb-96ea81498ba5","title":"SQL for Analytics: Office Hours — Projects for Portfolio and Interviews — foundations and working vocabulary","description":"Lesson 2 of 6 in SQL for Analytics: Office Hours — Projects for Portfolio and Interviews: work through foundations and working vocabulary and convert the result into a reusable part of the final SQL project portfolio using Excel and dbt.","videoUrl":null,"videoFileName":null,"duration":8400,"position":1,"createdAt":"2026-05-26T07:50:46.853Z","updatedAt":"2026-05-26T07:50:46.853Z","courseId":"22205b08-91c3-48eb-960d-78be473eb015","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"ffc709b3-e9a5-44f7-a359-92ebc72630bf","title":"SQL for Analytics: Office Hours — Projects for Portfolio and Interviews — SQL exploration","description":"Lesson 3 of 6 in SQL for Analytics: Office Hours — Projects for Portfolio and Interviews: work through SQL exploration and convert the result into a reusable part of the final SQL project portfolio using Excel and dbt.","videoUrl":null,"videoFileName":null,"duration":8400,"position":2,"createdAt":"2026-05-26T07:50:46.853Z","updatedAt":"2026-05-26T07:50:46.853Z","courseId":"22205b08-91c3-48eb-960d-78be473eb015","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8f9edec5-a118-41fb-b645-80933331745c","title":"SQL for Analytics: Office Hours — Projects for Portfolio and Interviews — measurement and optimization","description":"Lesson 4 of 6 in SQL for Analytics: Office Hours — Projects for Portfolio and Interviews: work through measurement and optimization and convert the result into a reusable part of the final SQL project portfolio using Excel and dbt.","videoUrl":null,"videoFileName":null,"duration":8400,"position":3,"createdAt":"2026-05-26T07:50:46.853Z","updatedAt":"2026-05-26T07:50:46.853Z","courseId":"22205b08-91c3-48eb-960d-78be473eb015","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"4f09bd3f-59b1-433a-93c3-041304650fff","title":"SQL for Analytics: Office Hours — Projects for Portfolio and Interviews — handoffs and documentation","description":"Lesson 5 of 6 in SQL for Analytics: Office Hours — Projects for Portfolio and Interviews: work through handoffs and documentation and convert the result into a reusable part of the final SQL project portfolio using Excel and dbt.","videoUrl":null,"videoFileName":null,"duration":8400,"position":4,"createdAt":"2026-05-26T07:50:46.853Z","updatedAt":"2026-05-26T07:50:46.853Z","courseId":"22205b08-91c3-48eb-960d-78be473eb015","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"78935ea2-4d94-49b5-a1b4-f108e7013278","title":"SQL for Analytics: Office Hours — Projects for Portfolio and Interviews — implementation and adoption","description":"Lesson 6 of 6 in SQL for Analytics: Office Hours — Projects for Portfolio and Interviews: work through implementation and adoption and convert the result into a reusable part of the final SQL project portfolio using Excel and dbt.","videoUrl":null,"videoFileName":null,"duration":8400,"position":5,"createdAt":"2026-05-26T07:50:46.853Z","updatedAt":"2026-05-26T07:50:46.853Z","courseId":"22205b08-91c3-48eb-960d-78be473eb015","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"dd809298-ebec-4217-9076-6175be33e909","name":"Marcus Price","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/ce969206-6a83-4733-9a17-a2643428b81e.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}