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 […]
PostgreSQL Intermediate Skills Test
Hey there, SQL-ites. Time for another (yes, another!) PostgreSQL skills challenge. It’s our last stop before moving into more intermediate and advanced PostgreSQL skills, such as JOINS. If you’re just joining this series on SQL, we previously covered the HAVING statement & GROUP BY. Here’s the home page of our journey in learning PostgreSQL. Today, we […]
Univariate Linear Regression Concepts
Howdy, machine learning compatriots! Welcome back to our foray into getting started with machine learning. Previously, we covered some core machine learning concepts, namely supervised machine learning algorithms and unsupervised / deep learning. (For the full series to date, here’s our Machine Learning for Beginners page.) Today we’re learning the concepts behind supervised machine […]
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 […]
SQL Aggregate Functions: Min, Max, Avg and Sum
Welcome back, SQL nerds! We’re back in action on the journey of learning SQL, after a beginner PostgreSQL skills challenge. We’re reaching the end of basic functions and queries with this article. Based on what we’ve learned so far, we can do basic counting, filtering, sorting and pattern matching against PostgreSQL databases. If you’re just […]
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 […]
The LIKE Statement: SQL Statement Fundamentals
Howdy folks! We are overdue for another installation of SQL learning. I’ve slept a few times since the past couple of articles on how to learn SQL. Previously, we talked about the IN Statement, BETWEEN statement, and ORDER BY clause. In this article, we’ll learn how to execute the LIKE statement in SQL queries. Let’s […]
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), […]