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 […]
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 […]
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 […]
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 […]
The IN Statement: SQL Fundamentals
Howdy, budding SQL masters! It’s been a minute since the last SQL post! I’ve taken some time to devote to Alexa Skills, some other personal housekeeping, and adopting a dog with my wife!! Last time we talked SQL, we learned the BETWEEN statement to hone in on the exact values we wanted for a SQL […]
The BETWEEN Statement: SQL Statement Fundamentals
Hey there, folks! Welcome back to our journey in learning SQL. Our last few of posts covered the ORDER BY clause, LIMIT statement and the COUNT function. (See full list of SQL tutorials here.) Today, we’re going to cover the BETWEEN statement. This is the start of some deeper material. In addition to the BETWEEN […]
ORDER BY Clause: SQL Statement Fundamentals
Welcome back to our SQL learning journey! It’s been a week and a half since my last post on using LIMIT. Work got crazy and I got the flu! 🙁 But we’re back in action. Today, we’ll delving deeper into SQL statements in PostgreSQL: ORDER BY. Let’s jump in. Why would you need a statement […]