Introduction to Database Management
This course will serve as a general introduction to databases including the history of data handling and processing, database approaches, database architecture, data modeling, query language, data security, and emerging trends in data management. This is an application course with assignments and projects where learners will create an entity-relationship data model to represent business data requirements, translate that model into relational schema, and build and use a relational database that implements the schema.
Objectives
- Explain the goals, functions, and models of relational and non-relational database systems.
- Describe the role of data, information and databases in organizations.
- Discuss the importance of database constraints to ensure integrity, accuracy, and reliability.
- Describe tasks commonly performed by database administrators such as migrating databases to new environments, database upgrades, database patching, and design/setup of disaster recovery databases.
- Analyze ways data fragmentation, replication, and allocation affect database performance in an enterprise environment.
Course Content
- Express how the growth of the internet and demands for information changed data handling and transactional and analytical processing and led to the creation of special purpose databases. (ACM)
- Explain the goals, functions, and models of relational and non-relational database systems.
- Describe the components of database systems with examples of their use.
- Describe the role of data, information and databases in organizations.
- Illustrate data quality, accuracy, and timeliness and their impact on business functions.
- Describe mechanisms for data collection, transit, and storage and their implications.
- Discuss regulatory compliance as it relates to data retention, physical storage, backup, and security.
- Compare and contrast data models for different types of data.
- Describe concepts in modeling notation (e.g., Entity-Relation Diagrams) and how they would be used.
- Describe the relationship between a logical model and a physical model.
- Discuss the importance of database constraints to ensure integrity, accuracy, and reliability.
- Compare and contrast online analytical processing (OLAP) and online transaction processing (OLTP).
- Evaluate a physical model for the best performance including impact of normalization and indexes.
- Design and implement a physical model based on appropriate organization rules for a given scenario including the impact of normalization and indexes.
- Create working Structured Query Language (SQL) statements for simple and intermediate queries to create and modify data and database objects to store, manipulate, and analyze enterprise data. (ACM)
- Perform filtering and sorting data using various clauses including where, order by, between, like, group by, and having.
- Perform calculations in a query using calculated fields and aggregate functions.
- Demonstrate select, project, union, intersection, set difference, and natural join relational operations using simple example relations provided.
- Express the relationship between functional dependencies and keys with examples.
- Evaluate data integrity and provide examples of entity and referential integrity.
- Analyze ways data fragmentation, replication, and allocation affect database performance in an enterprise environment.
- Perform major database administration tasks such as creating and managing database users, assigning roles and privileges, performing backups, and restoring database objects to ensure organizational efficiency, continuity, and information security.
- Evaluate the importance of metadata in a database environment.
- Describe tasks commonly performed by database administrators such as migrating databases to new environments, database upgrades, database patching, and design/setup of disaster recovery databases.
- Describe resources for continuous professional development related to data and database management.
$225
Completion Time:
70-75 Hours
Access to course:
3 Months
U of A 10% discount available - view details