This course introduces the fundamental concepts and emerging technologies in database design and modeling, database systems, data storage, and data governance. It presents a balanced theory-practice focus and covers entity relationship model and UML model, relational model, relational databases, Structured Query Language, and two flavors of NoSQL databases in MongoDB and Neo4j graph database. It also includes a brief introduction to big data management including hadoop, MapReduce, and Apache Spark. This course provides the theory and applications of database management to support data analytics, data mining, machine learning, and artificial intelligence.
What you'll learn
understand database design and modeling concepts
differentiate between relational and NoSQL databases
write queries using Structured Query Language (SQL)
gain a basic understanding of big data tools like Hadoop and Apache Spark
Course objectives
to familiarize students with different database systems
to equip students with skills for data analytics integration
to provide practical insights into data governance and storage