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…3 min read·Mar 30, 2023--1--1
Sean ZhangPython Tips OLD Pythoners Don’t KnowPlease follow and star as this page will be updated in the future.1 min read·Jan 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…3 min read·Sep 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.3 min read·Aug 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…3 min read·Jul 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…3 min read·Jul 18, 2022--1--1
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…8 min read·Jun 28, 2021--1--1
Sean ZhangAdvanced SQL— — Stored Function, Stored Procedure, Trigger, CTE, and Recursive CTE.4 min read·Nov 3, 2020----
Sean ZhangH2O AutoML in Python Comprehensive TutorialWhat is AutoML and Why AutoML?4 min read·Oct 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…4 min read·Oct 25, 2020----