Lab #03 (Database Normalization + SQL)
SGHG 4653 (Advance Database)
Lab #03 (Database Normalization + SQL)
Video Chapters
00:00 Intro
00:29 Table Sekolah
01:17 Table Alamat
01:28 Table SejarahSekolah
01:51 Perform SQL for querying the database and retrieve all schools
03:41 Join tables (table Sekolah with table SejarahSekolah)
04:44 Apply single and multiple columns ordering by City and Mukim
07:45 Find schools that were built over 50 years ago
10:19 SQL to count the total number of schools (that were built over 50 years ago) in each Mukim
13:13 Adding the SQL GROUP BY (for Mukim)
14:41 Perform SQL to detect data duplication in Mukim field
On this page of the site you can watch the video online Lab #03 (Database Normalization + SQL) with a duration of hours minute second in good quality, which was uploaded by the user ivinamri 20 December 2020, share the link with friends and acquaintances, this video has already been watched 284 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
