SQL Subquery

June 25, 2014

Podcast: Play in new window | Download The SQL Subquery Now that you’ve learned about SQL Joins, aggregate functions and the group by keyword, it’s time we moved on to our final topic in our SQL tutorial series. Today you’ll be learning all about SQL Subqueries, how to use them and when you should use […]

Read the full article →

SQL Group By

June 16, 2014

Podcast: Play in new window | Download SQL Group By After having talked about all the SQL Aggregate functions, there’s one more topic that goes hand in hand with what we’ve already learned… The group by keyword. This particular keyword allows us to take a bunch of data and mash it all together into matching […]

Read the full article →

SQL Aggregate Functions

June 5, 2014

Podcast: Play in new window | Download SQL Aggregate Functions In today’s podcast episode (which can be played by clicking the PLAY button above) you’ll be learning all about the aggregate functions that exist in SQL. What the heck is an aggregate function? Well that’s what I’m going to try and teach you today, and […]

Read the full article →

SQL Join

May 28, 2014

Podcast: Play in new window | Download The SQL Join There are three categories of joins that you can make use of in SQL: Inner Join Outer Join Cross Join But before we dive into the categories of joins, we first need to have an understanding of what a join really is. Joins are used […]

Read the full article →

SQL Tutorial

May 23, 2014

Podcast: Play in new window | Download Learn SQL – Enforce Relationships Part II Be sure to listen to the embedded podcast episode that goes along with this blog post. You can click the PLAY button on the player above. In this SQL tutorial episode/post we’re going to learn how to enforce our SQL relationships […]

Read the full article →

How to Create a Table in Mysql

May 13, 2014

Podcast: Play in new window | Download SQL Queries You’ve learned all about how to create sql queries to read, write, update and delete data… but you haven’t yet learned how to create the tables where you’ll be doing the reading, writing, updating and deleting. So that’s what today’s podcast is all about, be sure […]

Read the full article →

Database Relationships – Many to Many / One to One

January 7, 2014

Podcast: Play in new window | Download In a previous post we learned a whole bunch about the most common database relationship that exists, the one-to-many relationship. In this post we will be expanding on the topic of database relationships and touch on two that are less common but just as useful. Many-to-Many Relationship The […]

Read the full article →

Database Relationships – One to Many

December 12, 2013

Podcast: Play in new window | Download We’ve talked about relational databases already, and we’ve learned why this type of database management really dovetails with the object oriented programming model. So now I want to dive into the specifics when it comes to relationships. What are the different types of relationships in SQL? There are […]

Read the full article →

Database Joins, Keys and Relationships

December 4, 2013

Podcast: Play in new window | Download Coders’ Campus Before we get into the show notes for this podcast episode, I want to spend some time talking about a brand new community. I’m a BIG believer in online communities. Masterminds and communities are the main reason why I’ve come as far as I have in […]

Read the full article →

Intro to SQL and Databases

November 28, 2013

Podcast: Play in new window | Download What’s all this CRUD about? Create Read Update Delete This is the stuff at the heart of all databases and SQL. A database essentially carries out these four operations over and over again for the duration of its existence. In this podcast (which you can play above), I […]

Read the full article →