INFO 579 Database Design in SQL

This course provides an overview of modern database systems at the time. Both relational databases (SQL) and a few non-relational databases (NoSQL) are covered, including topics on data warehouses. The focus of the course is on the practical skills of the design and implementation of data storage and access for data and information sciences. Topics covered include ER-diagrams, database normalization, data modeling in NoSQL databases, SQL and other query languages, and data warehousing. The course will selectively cover one or two types of NoSQL databases, for example, document-oriented, key-value pair, column-oriented, or graph databases. Database platforms used in this course could change with time, some examples include MySQL, PostgreSQL, Apache HBASE, Apache Cassandra, MongoDB, and Neo4J.