jason's honest review, SQL with a Silicon Valley Engineer course
Reviews 34
Average rating 5
I've been working as a junior data engineer and have been receiving a lot of help from your lectures to improve my lacking areas. Currently, there are no lectures on Inflearn about multidimensional modeling (dimensions, measures) architecture. I'm curious if you're planning to include this content in the advanced SQL course in the future. While searching for a book called "The Data Warehouse Toolkit," I noticed some similarities with your lecture "Data Architecture Essentials You Must Know for Promotion." I'm wondering if this lecture can help me understand the overall structure of OLAP.
2
Hello Taegyeong Hong, Thank you so much for listening to the course so attentively and taking the time to leave your questions. The concepts of Dimension/Measure-centered multidimensional modeling that you mentioned will be covered in the upcoming 'Advanced SQL' course. However, rather than focusing on theoretical explanations, the Advanced SQL course is planned to be structured around the SQL patterns that data engineers encounter most frequently in real-world work. It will cover from a practical perspective how to implement Fact/Dimension structures in actual queries, which queries are performance-advantageous, and which designs create bottlenecks. Regarding your question about the relationship between "Data Architecture Essentials You Must Know for Promotion" and "The Data Warehouse Toolkit," there are certainly similar aspects. However, rather than being limited to specific OLAP modeling techniques, the course focuses on the most fundamental principles you must know when designing and building data pipelines. It covers not only OLAP but also the differences and roles between OLTP and OLAP, and is structured to help you understand the background and context of why such structures and designs are necessary. I believe that through the "Data Architecture Essentials You Must Know for Promotion" course, you'll be able to understand data warehouse-related books and design documents much more easily in the future.
1