{"id":"14e884d2-0a21-4d5b-8caa-9a7e80acf3e5","title":"SQL for Analytics: Applied — System and Results","description":"SQL for Analytics: Applied — System and Results helps learners move from understanding to execution through 7 lessons (~18 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-applied-system-and-results-c02bba30-1f7.webp","createdAt":"2026-05-26T07:46:40.844Z","updatedAt":"2026-05-26T07:51:46.237Z","durationSeconds":64800,"authorId":"86820033-e819-455f-8c8f-320e73b50c1e","rating":4.8,"reviewCount":5,"expectedLessonsCount":7,"trailerUrl":null,"faq":[{"answer":"Basic understanding of tables and metrics is helpful. The course starts with a clear ramp-up and then moves into system and results.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 3–5 hours per week. In total, the course includes 7 lessons and about 18 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":"741ec5ad-857d-4fa7-b6b7-ba1cd24f852f","title":"SQL for Analytics: Applied — System and Results — course orientation and outcomes","description":"Lesson 1 of 7 in SQL for Analytics: Applied — System and Results: 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":9258,"position":0,"createdAt":"2026-05-26T07:46:40.844Z","updatedAt":"2026-05-26T07:46:40.844Z","courseId":"14e884d2-0a21-4d5b-8caa-9a7e80acf3e5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"b013cc4f-fb3a-47a4-95d2-f2fd25d4e933","title":"SQL for Analytics: Applied — System and Results — core concepts and mental models","description":"Lesson 2 of 7 in SQL for Analytics: Applied — System and Results: 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":9257,"position":1,"createdAt":"2026-05-26T07:46:40.844Z","updatedAt":"2026-05-26T07:46:40.844Z","courseId":"14e884d2-0a21-4d5b-8caa-9a7e80acf3e5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"f38b583d-839b-4dba-af94-869632e970ca","title":"SQL for Analytics: Applied — System and Results — queries, models, and structure","description":"Lesson 3 of 7 in SQL for Analytics: Applied — System and Results: 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":9257,"position":2,"createdAt":"2026-05-26T07:46:40.844Z","updatedAt":"2026-05-26T07:46:40.844Z","courseId":"14e884d2-0a21-4d5b-8caa-9a7e80acf3e5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"bc15914c-f1e2-49c4-8789-256e174f3e08","title":"SQL for Analytics: Applied — System and Results — data handling and preparation","description":"Lesson 4 of 7 in SQL for Analytics: Applied — System and Results: 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":9257,"position":3,"createdAt":"2026-05-26T07:46:40.844Z","updatedAt":"2026-05-26T07:46:40.844Z","courseId":"14e884d2-0a21-4d5b-8caa-9a7e80acf3e5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"2f5e9a26-3980-4923-b9da-d6932c302e8c","title":"SQL for Analytics: Applied — System and Results — real cases and guided practice","description":"Lesson 5 of 7 in SQL for Analytics: Applied — System and Results: 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":9257,"position":4,"createdAt":"2026-05-26T07:46:40.844Z","updatedAt":"2026-05-26T07:46:40.844Z","courseId":"14e884d2-0a21-4d5b-8caa-9a7e80acf3e5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"e6ac34f1-41c8-42da-8b40-257f52aafe3b","title":"SQL for Analytics: Applied — System and Results — project build and review","description":"Lesson 6 of 7 in SQL for Analytics: Applied — System and Results: 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":9257,"position":5,"createdAt":"2026-05-26T07:46:40.844Z","updatedAt":"2026-05-26T07:46:40.844Z","courseId":"14e884d2-0a21-4d5b-8caa-9a7e80acf3e5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"afaad1ce-fcd3-4b12-a334-04345c4a5db0","title":"SQL for Analytics: Applied — System and Results — implementation, handoff, and next steps","description":"Lesson 7 of 7 in SQL for Analytics: Applied — System and Results: 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":9257,"position":6,"createdAt":"2026-05-26T07:46:40.844Z","updatedAt":"2026-05-26T07:46:40.844Z","courseId":"14e884d2-0a21-4d5b-8caa-9a7e80acf3e5","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"86820033-e819-455f-8c8f-320e73b50c1e","name":"Christopher Russell","avatarUrl":"https://lernrise.com/public/avatars/teacher-avatars/en/59910a0d-9c01-4979-9804-280d38698f76.webp","bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}