CPTR2210 - Database Report Generation

Credits
3 (2/1/0)
Description
Students will be introduced to database reporting using commonly used tools. Examples include Microsoft Structured Query Language (SQL) Reporting Services, comma-separated values (CSV), Microsoft Access and Excel, and Crystal Reports. Students will understand ethical and security concerns and challenges of database reporting. This course will cover the best practices of database reporting and help students understand business requirements behind database reporting.
Prerequisites
Competencies
  1. Apply querying techniques to generate reports.
  2. Analyze and contrast leading software packages relating to database reporting.
  3. Publish database reports from relational data sets.
  4. Publish database reports from eXtensible Markup Language (XML) datasets.
  5. Present database reports to the class to demonstrate understanding of problems.
  6. Identify business factors involved in report distribution.
  7. Identify and analyze security and ethical issues related to database reporting.
  8. Demonstrate database optimization techniques for database reporting.
  9. Analyze use cases of database reporting.
  10. Explain current trends in database reporting.
  11. Demonstrate best practices of database reporting.
Degrees that use this course