Sean ZhangHow to pass Google Certified Professional Data Engineer ExamI obtained my certifications of GCP Associate Cloud Engineer and Professional Data Engineer with 3 years of work experience and 1 year of…Mar 30, 20231Mar 30, 20231
Sean ZhangPython Tips OLD Pythoners Don’t KnowPlease follow and star as this page will be updated in the future.Jan 28, 2023Jan 28, 2023
Sean ZhangCreate your First SSIS Project Step by StepSSIS as an “outdated” ETL tool, is still massively used by organizations. Today we are going to install SSIS and build the first SSIS…Sep 14, 2022Sep 14, 2022
Sean ZhangBigQuery 102-Practical Use CasesIf you find this article useful, please follow me. I write articles about skills you use in your daily work.Aug 5, 2022Aug 5, 2022
Sean ZhangAdvanced SQL Performance TuningI post articles that are related to daily work and not commonly shown in textbooks. Please follow me or throw me a thumb if you find this…Jul 25, 2022Jul 25, 2022
Sean ZhangSQL Performance TuningSQL Textbooks teach us how to get the results by writing queries. In the production environment, query execution time matters just as much…Jul 18, 20221Jul 18, 20221
Sean ZhangCrack A/B Testing InterviewsAs a data science enthusiast, A/B Testing has always been in my interview questions. In this job-hunting process, I interviewed with TikTok…Jun 28, 20211Jun 28, 20211
Sean ZhangAdvanced SQL— — Stored Function, Stored Procedure, Trigger, CTE, and Recursive CTE.Nov 3, 2020Nov 3, 2020
Sean ZhangH2O AutoML in Python Comprehensive TutorialWhat is AutoML and Why AutoML?Oct 30, 2020Oct 30, 2020
Sean ZhangPractical Applications of Machine Learning Models-When and where to use which modelIn 2014 there was an article “Do we Need Hundreds of Classifiers to Solve Real World Classification Problems?” showing the practical…Oct 25, 2020Oct 25, 2020