CIS 303 - Introduction to Database

1. Analyze the purpose and benefit of databases
   1. Define common database terminology
   2. Identify popular databases
   3. Review the concept of changing data into useful information
   4. Understand the use of information systems in business and industry
   5. Discuss the benefit of reducing data redundancy
   6. Compare traditional file systems to databases
   7. Describe data organization, storage, and access in a database
2. Examine relational database technology
   1. Identify common database objects
   2. Describe the structure of a relational database
   3. Distinguish between primary and foreign keys and describe the relationship between them
   4. Explain the purpose and importance of referential integrity
   5. Determine common constraints used in relational databases and their importance
   6. Understand the purpose of data dictionaries and identify common characteristics
3. Design a relational database
   1. Summarize the process of database development including conceptual, logical and physical design
   2. Differentiate between logical and physical database design
   3. Identify business rules and user information requirements and how they influence database design
   4. Outline the benefits of data modeling
   5. Develop a data model using an Entity-Relationship Diagram (ERD)
4. Create a relational database
   1. Implement a physical database based on logical design
   2. Create tables
   3. Modify tables
   4. Enter and edit data in a table
   5. Enforce relationships between tables in the database
   6. Implement constraints
   7. Formulate a data dictionary with all appropriate components
5. Retrieve data stored in a relational database
   1. Identify SQL as a non-procedural query language
   2. Differentiate between data definition, data manipulation, and data control commands
   3. Apply criteria to limit results
   4. Perform calculations
   5. Join multiple tables
   6. Apply aggregate functions
   7. Produce sorted results
6. Perform Extract-Transform-Load (ETL) tasks
   1. Import data from an external source
   2. Export data into an external file
   3. Transfer data between databases
   4. Retrieve data using a web service
7. Normalize tables in a relational database
   1. Define each of the five normal forms
   2. Maximize application maintainability by applying the principles of normalization
   3. Recognize Unnormalized Data
   4. Convert to first, second, and third normal Form
   5. Discuss normalizing during Data Modeling
8. Explore additional topics
   1. Review the role of a database administrator
   2. Recognize database security concerns
   3. Understand transaction management and concurrency control
   4. Discuss business intelligence and data warehousing
   5. Determine unique properties of object-oriented databases
   6. Examine the use of big data in analytics