CIT 111: Introduction to Databases

Additional Resources (Optional):

• Read the Brother Miles documentation: How to Retrieve Data from Multiple Tables
  • See: "Joins with the Using Clause", "Joins with the On Clause", "Join Multiple Tables with the Using Clause", and "Join Multiple Tables with the On Clause" Sections.
• Watch the O'Reilly Videos. Login with your BYU–Idaho email.
• Watch the following video explaining JOINS:
  • https://learning.oreilly.com/videos/introduction-to-mysql/9781491982334/9781491982334-video298832/ 
• Read the Brother Miles documentation: Working with Summary Queries
  • See: "Aggregate Functions", "Using the Group By Clause", and "Using the Having Clause" Sections.
• Watch the O'Reilly Videos. Login with your BYU–Idaho email.