Principles of Database Systems

CS-GY 6083 Prof. Frankl, Phyllis

Database System Concepts, 7th Edition, Avi Silberschatz, Henry F. Korth , S. Sudarshan

  • Design databases using the ER model and converting to the relational model

  • Write queries in relational algebra, relational calculus, and SQL

  • Understanding of indexing, including B+ trees and hashing

  • Analyze performance of various query processing algorithms and understanding of the rudiments of query optimization

  • Understanding of transaction management, including the ACID properties, concurrency management goals and protocols and rudiments of recovery

p.22

Last updated