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.1Introduction01:23
1.1
Introduction
01:23
2.Basic SQL Usage
2.1Setting Up Our Environment09:59
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 Concepts
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 Records
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-Bag
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.Conclusion
6.1Conclusion02:16
6.1
Conclusion
02:16
