Solomon AyanlakinWhat is the difference between a Subquery, Common Table Expression (CTE), and Temporary table?This is a frequently asked interview question. Learn how to answer it when asked.Sep 8, 2023Sep 8, 2023
Solomon AyanlakinExploring Various Date/Time-Related Functions in SQL.Find a cheatsheet for date and time manipulations in SQL.Jun 19, 2023Jun 19, 2023
Solomon AyanlakinData Analytics Challenge using SQL: Danny’s DinnerThe aim of this write-up is to offer a great thought process for solving SQL problems and to answer the first case study of an 8-week-long…Apr 19, 20231Apr 19, 20231
Solomon AyanlakinData Cleaning in SQL— Dealing with Duplicate Data Records.As data analysts, one of the most frustrating and time-consuming problems faced when cleaning data is the presence of duplicate records…Mar 22, 20232Mar 22, 20232
Solomon AyanlakinProduct Management Metrics — Measuring the Right Metrics as a Product LeaderDear Product Managers/Owners, never build a product without clear product metrics and tools to track them.Aug 5, 20222Aug 5, 20222
Solomon AyanlakinAddressing Gender Inequality in the Workplace Using Data Analysis.Introduction — XYZ, the Manufacturing Patriarchy.Mar 1, 2022Mar 1, 2022
Solomon AyanlakinStored Procedures — Building Efficient Product Databases.Creating and Implementing SQL Stored procedures to build efficient databases with tiered security access.Oct 25, 2021Oct 25, 2021
Solomon AyanlakinMy Google Data Analytics Capstone ProjectCyclistic Bicycle Sharing Company — Leveraging data to Convert Casual Users To Annual Subscribers.Aug 4, 20211Aug 4, 20211