Day 9. Joins and Indexes
In yesterday's lesson you saw how to retrieve data using the SELECT statement. Today you will learn how to select data from several tables at once using a join. Joining tables is a fundamental operation of relational databases.
Another key concept you'll learn today is indexes. Indexes can be applied to tables to make retrieving data from them more efficient, especially when performing joins between tables.
Today you will learn:
How to perform the various kinds of joins in MySQL
The benefits of using indexes, when to use them, and when not to
What kinds of indexes are available and how to apply indexes to tables in a database
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
