Solomon Ayanlakin·Sep 8, 2023What 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.
Solomon Ayanlakin·Jun 19, 2023Exploring Various Date/Time-Related Functions in SQL.Find a cheatsheet for date and time manipulations in SQL.
Solomon Ayanlakin·Apr 19, 2023Data 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…A response icon1A response icon1
Solomon Ayanlakin·Mar 22, 2023Data 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…A response icon2A response icon2
Solomon Ayanlakin·Aug 5, 2022Product 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.A response icon2A response icon2
Solomon Ayanlakin·Mar 1, 2022Addressing Gender Inequality in the Workplace Using Data Analysis.Introduction — XYZ, the Manufacturing Patriarchy.
Solomon Ayanlakin·Oct 25, 2021Stored Procedures — Building Efficient Product Databases.Creating and Implementing SQL Stored procedures to build efficient databases with tiered security access.
Solomon Ayanlakin·Aug 4, 2021My Google Data Analytics Capstone ProjectCyclistic Bicycle Sharing Company — Leveraging data to Convert Casual Users To Annual Subscribers.A response icon1A response icon1