Dakai ZhouSQL - Condition In WHERE and JOIN ONAs SQL beginners and even SQL users for couple years, you might sometimes still confused with where you should put your conditions when you…Apr 3Apr 3
Dakai ZhouinDev GeniusDatabase System Tables And INFORMATION_SCHEMA Tricks Data Engineers And Data Scientists Should KnowThe tasks for data engineers does not only restrict to data manipulation in table level by using select, update, delete, etc. in database…May 9, 2023May 9, 2023
Dakai ZhouAn Introduction To Data Vault 2.0If you are from data engineering background, you may have heard about the term Data Vault. Data Vault is a methodology of designing…Mar 29, 2023Mar 29, 2023
Dakai ZhouBuilding Data Pipeline Step 3: Store Data in Target DatabaseIn the last two posts, connection to the data source and raw data cleansing/transformation are discussed. In this post, two different…Jul 8, 2022Jul 8, 2022
Dakai ZhouBuilding Data Pipeline Step 2: Clean and Transfer Raw DataIn the last blog, we discussed a scalable way to get raw data from data platforms. In this blog, I am going to share my perspective on raw…May 31, 2022May 31, 2022
Dakai ZhouBuilding Data Pipeline Step 1: A Stable Connection To Data SourceData pipeline development is a common task that is always required to be implemented by people who work as a Data Engineer, an ETL…Apr 24, 20221Apr 24, 20221
Dakai ZhouinTowards DevPython and Plotly: From Static Plot To Progression VideoNowadays, data visualization is required in almost every industry. Not every data visualization tool satisfies the needs, in which case you…Mar 29, 2022Mar 29, 2022
Dakai ZhouinTowards DevUseful Database/SQL Tricks for Data EngineeringWriting SQL statements is part of the daily routine for data analysts, data engineers, and many data scientists. Here are some SQL tricks…Feb 22, 20223Feb 22, 20223
Dakai ZhouGenerate Random Location Coordinates Within Given Area With PythonSome time ago, I was doing a side project. One step in the project was to generate random location coordinates, latitude, and longitude…Nov 25, 2021Nov 25, 2021