Open in app

Sign In

Write

Sign In

Sean Zhang
Sean Zhang

134 Followers

Home

Lists

About

Mar 30

How to pass Google Certified Professional Data Engineer Exam

I obtained my certifications of GCP Associate Cloud Engineer and Professional Data Engineer with 3 years of work experience and 1 year of cloud experience. Here are some thoughts on the preparation for them: Pick the exam that you are specialized in. I am a data engineer so I find…

Gcp

3 min read

How to pass Google Certified Professional Data Engineer Exam
How to pass Google Certified Professional Data Engineer Exam
Gcp

3 min read


Jan 28

Python Tips OLD Pythoners Don’t Know

Please follow and star as this page will be updated in the future. No small talk:

Python

1 min read

Python

1 min read


Sep 14, 2022

Create your First SSIS Project Step by Step

SSIS as an “outdated” ETL tool, is still massively used by organizations. Today we are going to install SSIS and build the first SSIS project to bring any text file in a folder into our MSSQL database. First of all, please leave a thumb and follow me for more “straight…

Ssis Training

3 min read

Create your First SSIS Project Step by Step
Create your First SSIS Project Step by Step
Ssis Training

3 min read


Aug 5, 2022

BigQuery 102-Practical Use Cases

If you find this article useful, please follow me. I write articles about skills you use in your daily work. 102.1 — I want my table back To retrieve a table at a timestamp, use SYSTEM_TIME: To restore a table:

Bigquery

3 min read

BigQuery 102-Practical Use Cases
BigQuery 102-Practical Use Cases
Bigquery

3 min read


Jul 25, 2022

Advanced SQL Performance Tuning

I 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 article useful. If you are looking for quick tips to tune the SQL performance, please check my first article: SQL Performance Tuning. Effectiveness: …

Data Science

3 min read

Advanced SQL Performance Tuning
Advanced SQL Performance Tuning
Data Science

3 min read


Jul 18, 2022

SQL Performance Tuning

SQL Textbooks teach us how to get the results by writing queries. In the production environment, query execution time matters just as much since it influences user experience or even leads to a production incident of “Runtime Out” due to platform threshold setup. …

Database

3 min read

SQL Performance Tuning
SQL Performance Tuning
Database

3 min read


Jun 28, 2021

Crack A/B Testing Interviews

As a data science enthusiast, A/B Testing has always been in my interview questions. In this job-hunting process, I interviewed with TikTok (Product Marketing Analyst), Whole Food (Digital Marketing Campaign Result Analyst), and Sega of America (Data Analyst). …

A B Testing

8 min read

Crack A/B Testing Interviews
Crack A/B Testing Interviews
A B Testing

8 min read


Nov 3, 2020

Advanced SQL

— — Stored Function, Stored Procedure, Trigger, CTE, and Recursive CTE. Except for the basic SELECT-FROM-WHERE and common INSERT, UPDATE and DELETE, there are some other useful SQL queries including Stored Functions, Stored Procedures, Triggers, Common Table Expressions(CTE), and Recursive CTE. I will use MySQL for the classicmodels, which you…

Sql

4 min read

Advanced SQL
Advanced SQL
Sql

4 min read


Oct 30, 2020

H2O AutoML in Python Comprehensive Tutorial

What is AutoML and Why AutoML? AutoML automates methods for model selection, hyperparameter tuning, and model ensemble. It does not help feature engineering. AutoML works best for common cases including tabular data(66% of data used at work are tabular), time series, and text data. It does not work as good in deep learning because deep learning…

Machine Learning

4 min read

H2O AutoML in Python Comprehensive Tutorial
H2O AutoML in Python Comprehensive Tutorial
Machine Learning

4 min read


Oct 25, 2020

Practical Applications of Machine Learning Models-When and where to use which model

In 2014, an article “Do We Need Hundreds of Classifiers to Solve Real World Classification Problems?” shows the practical results from179 classifiers’ performance on 121 datasets. The answer is: there is no best classifier, but there is a most proper one for that dataset. Overall, Random Forest shows the best…

Machine Learning

4 min read

Practical Applications of Machine Learning Models-When and where to use which model
Practical Applications of Machine Learning Models-When and where to use which model
Machine Learning

4 min read

Sean Zhang

Sean Zhang

134 Followers

Data Science | Machine Learning| Data Engineer

Following
  • Gencay I.

    Gencay I.

  • Bar Dadon

    Bar Dadon

  • Byron Allen

    Byron Allen

  • Frank Zickert | Quantum Machine Learning

    Frank Zickert | Quantum Machine Learning

  • Rafay Aleem

    Rafay Aleem

See all (11)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams