Back to Home

Max Pekarsky

Coding 102: Writing code other people can readThat bootcamp may have taught you to write code that works. But the next level is to write code that works with other people.

guide

project-management

Yogesh Chavan

How to Use JavaScript Promises Callbacks, Async/Await, and Promise Methods Explained

guide

Brandon Southern - AnalyticsMentor.io

The Problem with SQL Sub-queries & Better OptionsWhile sub-queries are very helpful and aren’t inherently bad, they tend to be overused and many times a more optimal and preferable solutions exists in the form of a common table expressions (CTE) or a temporary (temp) table. By using a CTE or a temp table, your code become easier to read, more modular, reduces duplicated code (which reduces bugs), and can even increase performance.

sql

guide

Ritesh Gupta

Master Data Science with This Comprehensive Cheat SheetComprehensive Cheat Sheet for Data Science: Numpy, Pandas, Python, R, ML, DL, NLP, Stats, SQL, PySpark, Plotly, Seaborn, git, Excel, Tableau, and PowerBI

sql

python

excel

guide

Sam Corcos

Here are all the Git commands I used last week, and what they do.Like most newbies, I started out searching StackOverflow for Git commands, then copy-pasting answers, without really understanding what they did.

guide

Jérémy Dessalines

Create a simple Approval process via Email with Google Form and Google Apps Script (Web Apps Deployment)At the end of this article, you will know how to create a workflow app, based on a Google Form that send an email to be approved or deny including logging of who is approving or denying with Apps Script.

apps-script

guide

DHH

Conceptual compression means beginners don’t need to know SQL — hallelujah!It used to be a fundamental requirement that you learned an extensive amount of SQL before you were able to start working on database-backed applications.

sql

guide

Taylor Brownlow

Why people don’t trust your numbers and what you can do about it“Those numbers aren’t right.” This phrase is a signal that something is wrong, or likely many things are wrong. Fundamentally, this question speaks to a lack of trust. Maybe this business user doesn’t trust anything that comes from the data team because they’ve been wrong in the past. Maybe they don’t trust you because they haven’t worked with you yet. Maybe they don’t trust data at all and prefer to rely on anecdotal evidence, or maybe the numbers are actually wrong.

project-management

guide

Luisprooc

Top 29 SQL Query Optimization Techniques You Must Know! 🚀By the end of this article, you’ll have the tools and knowledge you need to make your database applications run faster and more efficiently than ever before.

sql

guide

Debbie Widjaja

How Senior Product Managers Think DifferentlyThis article isn’t about how to get promoted to senior PM, but about how to advance your thinking and become a better PM. Anyone can think like a senior PM regardless of their title — and just because one has the senior PM title, doesn’t mean they truly deserve it.

project-management

guide

Aryan Irani

Integrating AI in Google Sheets with Google Apps Script: How to Pass Prompts to ChatGPT and Get a ResponseIn this blog, we’ll be exploring how to bring AI to your spreadsheets using the Open AI API and Google Apps Script.

apps-script

google-sheets

guide