The 5 hardest things Josh Berry, a 15 year analytics professional, experienced while switching from Python to SQL. Offering examples, SQL code, and a resource to customize the SQL to your own project.

KDnuggets is a leading resource for data scientists, machine learning engineers, and AI practitioners, offering news, tutorials, and insights on data science, machine learning, and artificial intelligence. With a focus on practical applications and real-world use cases, KDnuggets provides resources for learning data science techniques, exploring machine learning algorithms, and staying updated on the latest trends and advancements in the field.

KDnuggets

The Cloud Data Warehouse offers the power of centralizing compute within the cloud. However, this comes with its own set of downsides. One of the primary drawbacks is that you must learn and execute queries in different languages, specifically SQL. The switch over to cloud data warehouses increases the utility of complex SQL versus python.

The 5 Hardest Things to do in SQL

The hardest to learn in SQL for programmers is SET BASE QUERIES. Programmers like iterations and accessing the data over and over again. SQL doesn’t perform well this way in SQL.
The code access the base take for each time frame. You should have use case-when if you want to do that on the fly, or use temp table. Depends on the amount of data. In the example you read the the data for 14 days 3 times and the data for quarter twice. This practice is blocking on transactional system or resources consuming on can be really resources consuming on data warehouse.

yep, haven’t done all of those but can definitely say that trying to figure out time series reporting super sucks