- Which types of table joins exist?
- What does an INNER JOIN do?
- What is a table alias, and how do you use it?
- Which types of OUTER JOIN exist in MySQL?
- What does a right excluding join do?
- What is a natural join?
- What is a CROSS JOIN?
- What is the difference between UNION and UNION ALL?
- How do you accomplish an intersection query in MySQL?
- How can you improve multiple table query performance?
- Tech Categories
- Best Sellers
- New Releases
- Books
- Videos
- Audiobooks
Tech Categories Popular Audiobooks
- Articles
- Newsletters
- Free Learning
You're reading from Learn SQL Database Programming
Josephine Bush has over 10 years experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using MySQL, SQL Server, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics.
Read more about Josephine Bush
Unlock this book and the full library FREE for 7 days
Author (1)
Josephine Bush has over 10 years experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using MySQL, SQL Server, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics.
Read more about Josephine Bush