From the course: Data Engineering: dbt for SQL
Join today to access over 24,200 courses taught by industry experts.
Construction planning: Query complexity
From the course: Data Engineering: dbt for SQL
Construction planning: Query complexity
- One of the most powerful tools in the software engineering world lies in the use of code libraries. Libraries are like having a team of developers at your fingertips all for free. These libraries let developers share code efficiently and supercharge the development process. Now, think about SQLs built-in functions like SUM or AVERAGE. They're like libraries too. External pieces of code that speed up writing SQL code. But what if you need custom logic specific to a unique set of transformations? SQL does have ways to specify external functions, but sometimes the logic you need is so specialized, it lives in a single SQL file. Let me illustrate this with a real-life story from my own experience. I was working with a construction company that stored equipment information in a relational database. They managed various construction jobs and manually assigned equipment to each job. In the world of construction, different…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.