Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them
PowerBI Data Analyst - Create visualizations and dashboards from scratch
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Dive into a comprehensive 2.5-hour exploration of database systems, covering essential topics such as database schema, SQL, normalization, and hypermedia systems. Learn about Query By Example (QBE), its development rationale, design principles, and relationship to SQL. Understand the concepts of primary and foreign keys, and explore practical examples using loans and flight databases. Gain hands-on experience in identifying data redundancy, building database schemas, and crafting SQL queries to effectively manage and retrieve information from relational databases.
Syllabus
Database Schema.
SQL.
Database Normalisation.
Hypermedia Systems.
QBE: Why "Query By Example" Was Developed.
QBE: A Concrete Example.
QBE's Design Principles.
QBE's Relationship To SQL.
Primary & Foreign Keys.
Loans Database: Data Redundancy.
Loans Database: Identifying the Tables.
Loans Database: Building the Schema.
Flight Database: Identifying Records.
Flight Database: SQL Query.
Taught by
Eddie Woo