Relational AlgebraIntroduces relational query languages, focusing on algebra operators and query optimization.
Database Systems: OverviewIntroduces database systems, covering DBMS ecosystem, relational model, course overview, prerequisites, course outline, grading scheme, projects, and teaching methods.
Introduction to Database SystemsCovers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
File Organization and IndexingExplores file organization, indexing methods, and database storage design, including record formats, page formats, and index classification.
DDL, DML, ViewsCovers SQL data definition, manipulation, and views in databases.
Data Management: OverviewIntroduces fundamental concepts of data management, including data models, databases, and key tasks.