Database Terminology - Relationships, Joins and Keys

Database Terminology - Relationships, Joins and Keys

Author: Trevor Page: Java Guru | Programmer | Teacher December 4, 2013 Duration: 0:00

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

 


The How to Program with Java Podcast is a practical guide for anyone wanting to build software, from curious beginners to those looking to solidify their professional skills. Host Trevor Page, a seasoned Java guru and teacher, breaks down complex programming concepts into clear, manageable lessons you can apply immediately. You'll hear detailed walkthroughs on building applications, understanding core principles like object-oriented design, and navigating the tools of the trade. The discussions move beyond dry theory, focusing on the real-world logic and problem-solving that defines a career in software development. Whether you're aiming for a new job, tackling a personal project, or helping a child explore technology, this podcast provides a structured, conversational path forward. Each episode is crafted to demystify the process, translating technical jargon into plain English so you can focus on creating functional code. The tone is direct and encouraging, rooted in Trevor's experience as both a programmer and an educator. It’s a resource for building a tangible skill set, episode by episode, where consistent listening translates directly to growing competency. You’ll find the content naturally bridges the categories of technology education and career development, making it a useful companion for your learning journey.
Author: Language: English Episodes: 113

How to Program with Java Podcast
Podcast Episodes
Mocking in Java [not-audio_url] [/not-audio_url]

Duration: 45:54
In this episode you'll hear what mocking is all about and how it can be used to help you in your unit testing journey. Mocking is all about testing chunks of code in solutide, without having any dependecies on other Obje…
Unit Testing in Java [not-audio_url] [/not-audio_url]

Duration: 38:50
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…
Casting in Java [not-audio_url] [/not-audio_url]

Duration: 30:42
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…
Custom Sorting Algorithms in Java [not-audio_url] [/not-audio_url]

Duration: 42:47
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…
Constructors in Java [not-audio_url] [/not-audio_url]

Duration: 25:04
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…
Packages in Java [not-audio_url] [/not-audio_url]

Duration: 28:34
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…
Regular Expressions in Java [not-audio_url] [/not-audio_url]

Duration: 39:27
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…
Collections in Java [not-audio_url] [/not-audio_url]

Duration: 44:04
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…
Finally and StackTrace in Java [not-audio_url] [/not-audio_url]

Duration: 45:06
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…
Exceptions in Java [not-audio_url] [/not-audio_url]

Duration: 33:40
Interested in starting your coding career? I'm now accepting students into an immersive programming Bootcamp where I guarantee you a job offer upon graduation. It is a 6 month, part-time, online Bootcamp that teaches you…