by Andrew Burgess16 Oct 2012

Lessons:21Length:2.3 hours

4.4 Subqueries and Joins

Sometimes, to get the right data out of the database, you need to work with several tables. In this screencast, we’re going to look at several ways to do it.

1.Introduction
1 lesson, 01:23

Free Lesson

1.1
Introduction
01:23

2.Basic SQL Usage
5 lessons, 26:27

Free Lesson

2.1
Setting Up Our Environment
09:59

2.2
Creating Database
03:28

2.3
Creating Tables
03:44

2.4
Adding Data to the Database
04:31

2.5
Selecting Records
04:45

3.Intermediate SQL Concepts
5 lessons, 30:18

3.1
Data Types
08:46

3.2
Primary Keys
07:05

3.3
Altering Tables
07:12

3.4
Deleting Tables and Records
02:24

3.5
Updating Records
04:51

4.Selecting Records
4 lessons, 34:55

4.1
Where Clauses
08:57

4.2
Choosing a Number of Records
04:15

4.3
Ordering and Grouping Records
06:44

4.4
Subqueries and Joins
14:59

5.SQL Grab-Bag
5 lessons, 42:41

5.1
Aliases
06:07

5.2
Foreign Keys and Relationships
07:35

5.3
SQL Functions
08:46

5.4
MySQL and PHP
11:02

5.5
GUIs
09:11

6.Conclusion
1 lesson, 02:16

6.1
Conclusion
02:16

Andrew Burgess

Hi! I'm Andrew Burgess, and I'm a connoisseur of all things programming. I'm from near Toronto, Canada, and I've been fooling around with computers for nearly my whole life, both hardware and software. Right now, I'm finishing up a computer science degree. For almost a decade now, I've been playing around with over a dozen programming languages on several different platforms, from JavaScript to Java, from Ruby to Befunge. My favourite has always been JavaScript. I've always enjoyed writing, so when I discovered Tuts+ in 2009, I was excited to start writing tutorials. Since then, I've been writing tutorials and producing screencasts for Tuts+. Right now, I'm a course instructor and I produce mostly JavaScript-related courses. Maybe you've seen Building a Web App from Scratch with Angular.js or Node.js from Scratch; that's me! I've also written a few ebooks, like Getting Good with Git, Getting Good with JavaScript, and, more recently, Backbone.js Blueprints.

andrew8088

4.4 Subqueries and Joins

1.Introduction1 lesson, 01:23

2.Basic SQL Usage5 lessons, 26:27

3.Intermediate SQL Concepts5 lessons, 30:18

4.Selecting Records4 lessons, 34:55

5.SQL Grab-Bag5 lessons, 42:41

6.Conclusion1 lesson, 02:16

1.Introduction
1 lesson, 01:23

2.Basic SQL Usage
5 lessons, 26:27

3.Intermediate SQL Concepts
5 lessons, 30:18

4.Selecting Records
4 lessons, 34:55

5.SQL Grab-Bag
5 lessons, 42:41

6.Conclusion
1 lesson, 02:16