Lessons:16Length:1.5 hours
4.4 Joining Many Tables Together
Finally, with your newly created many-to-many relationship tables created, it's time to once again revisit our friend the SELECT query. In this lesson, we are going to get back to the concept of the JOIN and start adding in multiple joins as well as introducing the concept of grouping.
Related Links
1.Introduction
1.1Introduction00:40
1.1
Introduction
00:40
1.2Prerequisites07:25
1.2
Prerequisites
07:25
1.3General MySQL Commands05:46
1.3
General MySQL Commands
05:46
2.Working With MySQL Databases and Tables
2.1Creating and Deleting Databases02:06
2.1
Creating and Deleting Databases
02:06
2.2Creating and Deleting Tables07:10
2.2
Creating and Deleting Tables
07:10
2.3Creating Tables With Additional Options06:56
2.3
Creating Tables With Additional Options
06:56
3.Basic Database Read and Write Operations
3.1Inserting Data Into Tables04:59
3.1
Inserting Data Into Tables
04:59
3.2Select Query Basics05:48
3.2
Select Query Basics
05:48
3.3Update Query Basics05:40
3.3
Update Query Basics
05:40
3.4Delete Query Basics03:46
3.4
Delete Query Basics
03:46
3.5Modifying Table Structures07:58
3.5
Modifying Table Structures
07:58
4.Relationships Between Tables
4.1Creating One-to-Many Tables06:29
4.1
Creating One-to-Many Tables
06:29
4.2Joining Tables Together07:20
4.2
Joining Tables Together
07:20
4.3Creating Many-to-Many Tables07:54
4.3
Creating Many-to-Many Tables
07:54
4.4Joining Many Tables Together06:34
4.4
Joining Many Tables Together
06:34
5.Conclusion
5.1Conclusion02:50
5.1
Conclusion
02:50
