zyBooks
Labs
Videos:
|
1.7 LAB MySQL Sakila Database Installation
2.6 LAB Create Movie table
2.7 LAB Alter Movie table
3.4 LAB Select horses with logical operators
3.5 LAB Insert rows into Horse table
3.6 LAB Update rows in Horse table
3.7 LAB Delete rows from Horse table
4.5 LAB Create LessonSchedule table with FK constraints
4.6 LAB Create Student table with constraints
4.7 LAB Create Horse table with constraints
5.4 LAB Boyce-Codd normal form
6.4 LAB Select number of movies grouped by year
6.5 LAB Nested aggregates (Sakila)
7.3 LAB Select movie ratings with left join
7.4 LAB Select lesson schedule with inner join
7.5 LAB Select lesson schedule with multiple joins
7.6 LAB Select employees and managers with self join
7.7 LAB Multiple joins with aggregate (Sakila)
8.5 LAB Select tall horses with subquery
10.6 LAB Rollback and savepoint (Sakila) (Not Available)
11.8 LAB Create index and explain (Sakila) (Not Available)
12.21 LAB Message board (PHP PDO)
14.4 LAB Implement strong entity (Sakila) (Not Available)
14.5 LAB Implement supertype and subtype entities (Sakila) (Not Available)
15.7 LAB Create Vehicle and EventVehicle tables (Not Available)
|