Lessons:21Length:2.3 hours
- Overview
- Transcript
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.Introduction1 lesson, 01:23
1 lesson, 01:23
Free Lesson 1.1Introduction01:23
Free Lesson
1.1
Introduction
01:23
2.Basic SQL Usage5 lessons, 26:27
5 lessons, 26:27
Free Lesson 2.1Setting Up Our Environment09:59
Free Lesson
2.1
Setting Up Our Environment
09:59
2.2Creating Database03:28
2.2
Creating Database
03:28
2.3Creating Tables03:44
2.3
Creating Tables
03:44
2.4Adding Data to the Database04:31
2.4
Adding Data to the Database
04:31
2.5Selecting Records04:45
2.5
Selecting Records
04:45
3.Intermediate SQL Concepts5 lessons, 30:18
5 lessons, 30:18
3.1Data Types08:46
3.1
Data Types
08:46
3.2Primary Keys07:05
3.2
Primary Keys
07:05
3.3Altering Tables07:12
3.3
Altering Tables
07:12
3.4Deleting Tables and Records02:24
3.4
Deleting Tables and Records
02:24
3.5Updating Records04:51
3.5
Updating Records
04:51
4.Selecting Records4 lessons, 34:55
4 lessons, 34:55
4.1Where Clauses08:57
4.1
Where Clauses
08:57
4.2Choosing a Number of Records04:15
4.2
Choosing a Number of Records
04:15
4.3Ordering and Grouping Records06:44
4.3
Ordering and Grouping Records
06:44
4.4Subqueries and Joins14:59
4.4
Subqueries and Joins
14:59
5.SQL Grab-Bag5 lessons, 42:41
5 lessons, 42:41
5.1Aliases06:07
5.1
Aliases
06:07
5.2Foreign Keys and Relationships07:35
5.2
Foreign Keys and Relationships
07:35
5.3SQL Functions08:46
5.3
SQL Functions
08:46
5.4MySQL and PHP11:02
5.4
MySQL and PHP
11:02
5.5GUIs09:11
5.5
GUIs
09:11
6.Conclusion1 lesson, 02:16
1 lesson, 02:16
6.1Conclusion02:16
6.1
Conclusion
02:16