by Derek Jensen
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.Introduction3 lessons, 13:51
3 lessons, 13:51
Free Lesson 1.1Introduction00:40
Free Lesson
1.1
Introduction
00:40
Free Lesson 1.2Prerequisites07:25
Free Lesson
1.2
Prerequisites
07:25
1.3General MySQL Commands05:46
1.3
General MySQL Commands
05:46
2.Working With MySQL Databases and Tables3 lessons, 16:12
3 lessons, 16:12
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 Operations5 lessons, 28:11
5 lessons, 28:11
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 Tables4 lessons, 28:17
4 lessons, 28:17
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.Conclusion1 lesson, 02:50
1 lesson, 02:50
5.1Conclusion02:50
5.1
Conclusion
02:50