Till now, we were solving all the problems using PostgreSQL but going forward we will be also using MySQL. So here we will be setting up our system for the same. As part of Data Engineering Suite, we have already installed and configured MySQL. (If you have not use below video or follow blog) https://youtu.be/FT2lM7d3EQI... Continue Reading →
Data Engineering Problem 5 (City names starting with vowels)
Please find earlier blogs to have understanding of our Data Engineering Learning plan and system setup for Data Engineering. Today we are solving and learning one more Data Engineering problem and learning new concepts. For earlier problem solution and key learning points follow below. https://developershome.blog/category/data-engineering/problem-solving/ Problem Statement Query the list of CITY names starting with... Continue Reading →
Data Engineering Problem 4 (Get Shortest and Longest City Name)
Please find earlier blogs to have understanding of our Data Engineering Learning plan and system setup for Data Engineering. Today we are solving and learning one more Data engineering problem and learning new concepts. Problem Statement Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths... Continue Reading →