This course will teach you about current relational database systems and how important they are. The course will teach students how to use relational databases, as well as their advantages and disadvantages, and how to apply them to decision-making. The focus of the course will be on a real-world orientation through case studies and hands-on exercises that emphasize the need of a comprehensive database strategy. 


Topics

  • Introduction
  • Introduction to the Relational Model
  • Introduction to SQL
  • Intermediate SQL
  • Advanced SQL
  • Other Relational Languages
    • Relational Algebra, Tuple Relational Calculus
  • Entity-Relationship Model
  • Relational Database Design
  • Advanced Relational Database Design
  • Application Design and Development
  • Data Analysis and Mining (may be omitted if desired)