Data

LIMIT / OFFSET Clauses

LIMIT and OFFSET are SQL query clauses that allows you to limit and offset result records by the amount provided.

Data

HAVING Clause

The HAVING clause in SQL acts as a filtering mechanism similar to the WHERE clause, but for grouped columns and aggregate functions.

Data

GROUP BY Clause

GROUP BY is the first non-relational layer SQL query clause. It creates unique data groupings and allows for aggregations to be used.

Data

WHERE Clause

WHERE is a SQL query clause that allows you to filter raw data by various combinations of data attributes.

Data

FROM Clause

The FROM clause opens up your search query to accessing data tables within your database.

Data

SELECT Clause

SELECT is a foundational SQL clause that is mandatory to run queries. Learn more about SELECT with the start to my series on basic SQL queries.

Technology

Web 3.0 and the Promise of a Privacy-First Future

The evolution of the internet with web 3.0 and the privacy-first technologies leading new ways of identification

The Enjoyment of Working on Passion Projects
Founder Story

The Enjoyment of Working on Passion Projects

Coming to the realization that side projects need to be passion driven. Otherwise you run the risk of burn out.

The Losers in Apple's Privacy Battle - Small E-Commerce Businesses
Business

The Losers in Apple's Privacy Battle - Small E-Commerce Businesses

The move by Apple to regulate third party data sharing and advertising cornered publishers like Facebook and Google and will accelerate the centralization of commerce within these platforms adversely impacting e-commerce businesses.

Combating Marketing Analytics Measurement Paralysis
Data

Combating Marketing Analytics Measurement Paralysis

Handling organizational questioning and debate by understanding the topics of deterministic vs probabilistic modeling and attribution