How to Program with Java Podcast

Database Relationships: Many-to-Many and One-to-One

Show Notes available via: http://howtoprogramwithjava.com/session43   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 many-to-many database relationship is used when you are in the situation where the rows in the first table can map to multiple rows in the second table… and those rows in the second table can also map to multiple (different) rows in the first table.   One-to-One Relationship A One-to-One relationship means that you have two tables that have a relationship, but that relationship only exists in such a way that any given row from Table A can have at most one matching row in Table B.

Database Relationships – One to Many

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: One-to-Many One-to-One Many-to-Many 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.

Database Terminology - Relationships, Joins and Keys

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: http://coderscampus.com

CRUD Operations - Syntax for Interacting with your Database

What’s all this CRUD about? Create Read Update Delete This is the 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, I talk about these four database operations in detail and the actual syntax that is used in a flavour of SQL known as MySQL.

Intro to Databases and SQL

Ladies and gentlemen the time has come for you to start learning about Databases and SQL. In this episode I will talk about the very basics of databases and why it is they exist in the first place.  You'll learn things like: What exactly is a Database, and what ulitimate purpose does it serve? Why are modern databases referred to as relational databases? What a database does, day in and day out, it's sole purpose in life is essentially CRUD! How does SQL fit into the database equation Why it was that Trevor failed his first database course in university!  For shame! Learning and understanding databases is more is less a required skill in these modern days of programming, and at the very least, having knowledge about databases will give you a leg up on any competition.  So pay attention boys and girls, and strap on your thinking caps, because this ride is getting started.