Thu, 12 December 2013
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 three types of relationships you can have in SQL, they are:
In this episode we are going to be focusing on the One-to-Many relationship as it’s the most commonly used in my opinion. |
Wed, 4 December 2013
Terminology It's the foundation when learning any new concepts. In this episode of the "How to Program with Java Podcast" we will be talking about some new database terminology. One of the most important aspects of modern databases is the fact that they allow you to define relationships. Relationships between tables allow you to break data up into its individual "areas of interest". But when you break the data up, you'll need to know how to put it back together. This is accomplished using relationships, keys and joins. There's plenty to learn about these concepts and we will start by scratching the surface in this episode.
Exciting Announcement As you'll hear in the first few minutes of this episode, I've recently had an epiphone! I realized that there's no great communities dedicated to programmers. So I took it upon myself to create the very first community dedicated to programmers and the pursuit of knowledge and advancement of our common goals (to excel as programmers). You'll learn lots about this community in the episode, so I won't go in to details here, but if you're interested in checking it out - please visit:
|