Advanced Desktop Databases – it261 (3 credits)

This course is a continuation in the study of desktop database software. Emphasis is placed on database design, reporting, queries and data analysis using desktop database software.

This undergraduate-level course is 9 weeks. This course is available to take individually or as part of a degree or certificate program. To enroll, speak with an Enrollment Representative.

Using Reports to Create Business Intelligence

  • Create advanced reports using the Design view.
  • Create reports using the Report Wizard.
  • Sort and filter data within a report.

Designing Advanced Queries

  • Explain when to use crosstab and action queries.
  • Create a subquery.
  • Create a query using multiple tables.

Normalizing a Relational Database

  • Normalize a database through the fifth normal form.
  • Explain the purpose of normalization.
  • Describe the stages of the normalization process.

Extended Entity Relationship Diagram (ERD)

  • Provide rationale in selecting primary keys.
  • Create an Extended Entity Relationship Diagram (ERD).

Advanced Tables

  • Create advanced tables.
  • Use the Table Analyzer to improve the efficiency of a table.

Introduction to SQL

  • Explain when to use each SQL data definition command.
  • Use SQL data manipulation commands to create queries.
  • Use aggregate functions in an SQL query.

Data and Business Intelligence

  • Explain the need for data analysis.
  • Define business intelligence.
  • Differentiate between operational data and decision support data.

Advanced Reports

  • Organize data in a report using group headers.
  • Create aggregate fields in a report.
  • Use print layout to improve the appearance of a report.

Data Warehousing

  • Define a data warehouse.
  • Compare and contrast the different decision support architectural styles.
  • Explain how a data warehouse is implemented.

Start your journey now

or call us at866.766.0766

Contact us