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.

Normalizing a Relational Database

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

Extended Entity Relationship Diagram (ERD)

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

Advanced Tables

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

Designing Advanced Queries

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

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.

Using Reports to Create Business Intelligence

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

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

Continue
or call us at866.766.0766

Contact us