IST 659: Data Administration Concepts and Database Administration

This course provides a foundation for database administration, exploring the fundamental models of database management systems. It covers the definition, development and management of databases for information systems. Students learn data analysis techniques, data modeling, schema design, query languages and search specifications, including Structured Query Language (SQL), data structures, file organizations, principles of data management systems, and hierarchical, network and relational data models. Students gain hands-on experience using Microsoft’s Access and SQL Server database management systems (DBMS) as implementation vehicles. This course provides hands-on experience in database design and implementation through assignments, lab exercises and course projects. This course also introduces advanced database concepts such as transaction management and concurrency control, distributed databases, multitier client/server architectures, web-based database applications, data warehousing and NoSQL.

Learning Objectives:

  • Understand fundamental data and database concepts
  • Explain and use the database development life cycle
  • Solve problems by constructing database queries using SQL
  • Design databases using data modeling and data normalization techniques
  • Develop insights into future data management tools and technique trends
  • Recommend and justify strategies for managing data security, privacy, audit/control, fraud detection, backup and recovery
  • Critique the effectiveness of DBMS in computer information systems

Tools & Concepts

  • SQL
  • Microsoft SQL Server
  • Microsoft Access
  • Visio
  • NoSQL
  • Data warehousing
  • Database design, management and implementation
  • Network and hierarchical data models
  • Multitier client/server architectures
  • Web-based database applications

BACK TO CURRICULUM

Learn More

Now is the time to earn your master’s in data science online.