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 […]
The HAVING Clause in PostgreSQL
Howdy SQL-ites! Welcome back to our next step in learning SQL. After a long hiatus, we recently stumbled our way through some intermediate SQL statement challenges, namely on GROUP BY. Today, we’re back in the flow, and learning about the HAVING clause in PostgreSQL. About the HAVING Clause in PostgreSQL The HAVING clause is most […]
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 […]
What is Data Science?
Welcome back, campers! It’s been a minute (read:months) since I’ve last posted, and we’re back! (For now.) Today’s topic, data science: supposedly the latest exploding field, critical to every enterprise. Why is it important and relevant? The rise of big data has created a relatively untapped treasure trove of insight. However, it’s undeveloped! Further, the […]
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 […]
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 […]
Supervised Learning & Its Types: Machine Learning Essentials
Welcome back, machine learning geeks! Let’s delve deeper into our journey of mastering machine learning. In the previous article, we looked at both informal and technical definitions of machine learning. We also looked at the two major types of machine learning algorithms, A) supervised machine learning algorithms, and B) unsupervised machine learning algorithms. We […]
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 […]
An Introduction to Machine Learning
Howdy! This is an abrupt interruption to our regularly scheduled programming of SQL lessons, Amazon Alexa Skill development and Algorithmic trading. For those readers who don’t personally know me, I’m on a quest/streak to level up as a technologist. Getting around to the point, I’ve been taking self-paced courses in varying forms to learn, apply […]