Course Outlines

You are in the Academics section


CPTR2210 – Database Report Generation pdf

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: CPTR1106
Corequisites: None
  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.
MnTC goal areas: None

« back to course outlines