Главная
Study mode:
on
1
Database Schema
2
SQL
3
Database Normalisation
4
Hypermedia Systems
5
QBE: Why "Query By Example" Was Developed
6
QBE: A Concrete Example
7
QBE's Design Principles
8
QBE's Relationship To SQL
9
Primary & Foreign Keys
10
Loans Database: Data Redundancy
11
Loans Database: Identifying the Tables
12
Loans Database: Building the Schema
13
Flight Database: Identifying Records
14
Flight Database: SQL Query
Description:
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.

Database Systems

Eddie Woo
Add to list
0:00 / 0:00