Learn MySQL in 2024: Lesson 3 exploring a entity relationship diagram and the select statement
In the third lesson in this series Dr. Todd Wolfe demonstrates how to review a Enhanced Entity Relationship Diagram followed by creating a SQL select statement to retrieve data from an actor, film_actor, and film tables (entities). The lesson concludes by demonstrating a join condition. At the end of this lesson you should be able to
1) Find how to review a data model in MySQL Workbench (Enhanced Entity Relationship Diagram - EERD)
2) Create a basic select statement
3) Create a select statement with specific fields
4) Create a select statement with a where clause
5) Create a select statement with multiple conditions
6) Use the in clause for a list of values
7) Create sub query
8) Create a 3 table SQL Join using the inner join command
9) Verify your results
Watch video Learn MySQL in 2024: Lesson 3 exploring a entity relationship diagram and the select statement online without registration, duration hours minute second in high quality. This video was added by user Dr. Todd Wolfe Technology Training and Tutorials 28 December 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 448 once and liked it 9 people.