CMPE351 [Database Systems ]
About Course
| Almost all large data processing systems rely on a generalized database to store and retrieve data. This course looks at the theoretical and technical issues involved in the implementation of such generalized databases. Course contents include introduction to databases, entity relationship model, physical database design and access strategies, relational data model, SQL data manipulation language, theoretical data manipulation language, normal forms and logical database design, query processing, concurrency control and recovery in databases, implementation of a simple storage manager and design of a relational database. |
Course Content
ch1,ch2
-
ch1,ch2
28:00
Chapter 3 The Relational Data Model and SQL
Chapter 3: Introduction to SQL part1
Chapter 3: Introduction to SQL part2
SQL practice
Chapter 4 : Intermediate SQL(join)
HW4
HW5
Homework: School database (variation)
Student Ratings & Reviews
No Review Yet