Intro to Databases and SQL

Intro to Databases and SQL

Author: Trevor Page: Java Guru | Programmer | Teacher November 14, 2013 Duration: 0:00

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.


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
EP26 - IF Statements in JavaScript [not-audio_url] [/not-audio_url]

Duration: 19:23
Show notes for this episode can be found via http://coderscampus.com/26 Also don't forget to check out our lifetime membership to Coders Campus and get access to 130+ hours of video tutorial content on full-stack Java. C…
EP25 - JavaScript Data Types [not-audio_url] [/not-audio_url]

Duration: 27:45
Checkout the show notes of today's episode via http://coderscampus.com/25 Also, I've started a brand new "lifetime membership" deal for Coders Campus, you can check out the details of this new offer via http://coderscamp…
EP23 - JavaScript Variables [not-audio_url] [/not-audio_url]

Duration: 15:00
Show notes for this episode are available via http://coderscampus.com/23 Also, don't forget about the sweet deal I have over at http://coderscampus.com/deal - you help support the show when you join our community of code…
Coders Campus EP21 - Dynamic Typing in JavaScript [not-audio_url] [/not-audio_url]

Duration: 21:01
Don't forget to check out this sweet deal on a Coders Campus via http://coderscampus.com/deal You'll get access to over 128 hours of video tutorial content that will teach you how to become a full-stack programmer (inclu…
What is JavaScript? [not-audio_url] [/not-audio_url]

Duration: 22:54
Don't forget to check out the special deal that we're putting on for our podcast listeners via http://coderscampus.com/deal
EP68 - Subscribe to my new show called the "Coders Campus Podcast" [not-audio_url] [/not-audio_url]

Duration: 2:59
You can subscribe to the new show via this link: http://coderscampus.com/itunes There will be no more episodes of the How to Program with Java podcast (this podcast), all new episodes will be shared via the Coders Campus…
Episode 66 - Summer is here and something new is in the air [not-audio_url] [/not-audio_url]

Duration: 5:36
I'm happy to announce that dropping on July 1st, 2016 - a brand new podcast will be hitting the digital shelves! Although the How to Program with Java podcast will be coming to an end, I'll be launching a brand new serie…
EP65: HTML Design & Layout [not-audio_url] [/not-audio_url]

Duration: 47:01
Okay so you know how to add some styles and CSS to your webpage, that's a great start, but what about deciding where all your text should go? What if you wanted to setup your website so that you have some text on the lef…
EP 64: CSS 101 Tutorial [not-audio_url] [/not-audio_url]

Duration: 44:57
Cascading Style Sheets are a bit of a tricky beast in HTML. Given this fact, I wanted to dedicate an entire section to just this topic. Let's start with the basics, shall we? What are Cascading Style Sheets (CSS)? Well,…