Advanced Database Management Systems

Catalog description

Teaches advanced concepts of database management systems, for example, further dependencies and higher normal forms, indexing, transaction and locking, concurrency control, database security, backup and recovery, accessing XML data, query optimization techniques, and databases for web applications. Students expand their SQL programming knowledge through focused database design practice with an increasingly complex problem and solution set using Microsoft SQL Server. Introduces NoSQL for SQL developers and about unstructured 'big data' databases and hands-on experience with MongoDB. Project-driven course builds on the background presented in Software Development for Information Technology. Familiarity with information modeling and software development process is essential.