This course addresses the analysis, design and implementation of relational and non-relational databases. Structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, data security, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, web data extraction, Big Data, MapReduce framework and key-value stores.
