JOINS in PostgreSQL
Welcome back, SQL-ites! Today, we’re going to take a significant leap forward in our journey of learning PostgreSQL. A quick recap on where we’ve been recently: The AS PostgreSQL statement An Intermediate PostgreSQL Skills Challenge, and, The HAVING clause in PostgreSQL In more broad terms, most of our PostgreSQL training so far has focused on […]
JOINS Foundations: The AS PostgreSQL Statement
Intro to JOINS: the AS PostgreSQL Statement What’s up SQL people? We’re back, and better than ever, in our foray to learn PostgreSQL. Since we’ve completed some intermediate skills challenges & learned GROUP BY, it’s time to examine JOINS. Before we examine JOINS, there’s a key foundation piece we must cover first: the AS statement […]
Intermediate SQL Skills Challenge: GROUP BY
Hey there SQL-ites! Wow, it’s been awhile since I’ve last posted. Work has been crazy busy again, and just life in general. Sure feels good to be back, learning again! I’m daringly dropping straight back into my learnings from where we left off…in April!? Crazy. Anyway, let’s get back to brass tacks. Before life and […]
GROUP BY SQL Statement
Introducing the GROUP BY SQL Statement in PostgreSQL ‘Ello SQL geeks! Welcome back to our SQL learning journey. We left off with a beginner SQL skills challenge and the aggregate SQL functions: MIN, MAX, AVG and SUM. Today we’re looking at the GROUP BY statement. We’ll learn about this function in PostgreSQL and walk through […]
Beginner SQL Skills Challenge!
Howdy, SQL geeks. Hope this post finds you swell! Over the past few months, we’ve gained a ton of ground in learning SQL, or at least I have. 🙂 Let’s take a moment to: Test our knowledge of SQL skills learned thus far Start seeing SQL queries less as statements of code, and more as […]
Unsupervised Learning Introduction: Machine Learning Essentials
Howdy, machine learning students! Today we’re going to introduce the concept of unsupervised machine learning algorithms. Quick Recap: Supervised Learning Before we jump in, let’s quickly recap our last article introducing supervised machine learning algorithms. This will give us the appropriate context for unsupervised learning. In supervised machine learning problems, we supply pre-labeled data to […]
What is Machine Learning?
Hello there, fellow Machine Learning (ML) students! Welcome back to our crash course in starting machine learning from an absolute beginner’s perspective. In our previous article, we covered an introduction to Machine Learning, answering several key questions: Where is machine learning used in our lives? Where did machine learning come from? Where is machine learning […]
SQL Query Fundamentals: SELECT WHERE
Welcome back, travelers! The journey continues in learning SQL. In case you missed it, the past couple of posts were learning to use SELECT DISTINCT and Restoring an SQL database with table schema only. Today we’re going to learn about using the SELECT clause with the WHERE statement for essential SQL queries. A Quick Recap, […]
4 Simple Marketing Career Paths Your Professor Never Told You About
Several months ago, I sat in a warm conference room in the University of Houston Bauer business school. The wind gusted outside;  professors and a couple of brave students shuffled papers on a conference table between presentations. I was privileged to be an advisory board member and mentor at this Enactus UH event. Unexpectedly (to me), […]
How to Explain SEO in 5 Minutes
Today, you’re going to learn how to explain SEO to anyone in five minutes! Is it a comprehensive, end-all, be-all example? No. Will it help someone quickly understand the basics of a complex practice? Yes. Let’s jump in. This is, after all, a five minute guide! Starting Point: SEO is not a black box. For […]