The thing that's going to make or break [the] next generation of databases is the way they handle unstructured data... because most of the world's data is unstructured. ---Michael Stonebraker

This course presents the database design process practiced when creating a relational database; it also presents the relational database management system’s architecture as well as the fundamental ACID properties of a relational database management system. Extended entity-relationship models will be generated and represented using the Unified Modeling Language (UML) notation. Relational algebra and its relationship to the SQL language will be presented. Advanced topics include triggers, stored procedures, indexing, and fundamentals of transactions, concurrency and recovery. The course will also include an introduction to NoSQL databases and provide students the opportunity to compare SQL to NoSQL. Students will define a database project that includes the design and implementation of a database as well as an application for interacting with the database.

Author: Martin Schedlbauer, PhD ⏎

This course was developed by Martin Schedlbauer. Dr. Schedlbauer is a Teaching Professor at the Khoury College of Computing Sciences at Northeastern University working in their Online Campus. Martin has developed numerous courses for Khoury as well as countless commercial courses for organizations across the world and workshops at leading conferences. Dr. Schedlbauer holds PhD, MSc, and BS degrees in Computer Science from the University of Massachusetts as well as an MEd degree from Northeastern University.

No Outcomes Defined.
No skills Defined.