dat415 | undergraduate

Managing The Database Environment II

Explore by:

or call us at

About:

About:

This course is an advanced look at Managing the Database Environment, exposing students to applied concepts to solve high speed and high volume data problems in today's IoT and Big Data environment.

This undergraduate-level course is 5 weeks To enroll, speak with an Enrollment Representative.

Course details:

Credits: 3
Continuing education units: XX
Professional development units: XX
Duration: 5 weeks

topic title goes here

    Data Normalization

    • Define data normalization through use of Boyce-Codd normal form (BCNF).
    • Apply data normalization through BCNF.
    • Explain the value of normalized data for an enterprise level database application.
    • Determine the characteristics of inefficient database schemas.

    Efficient Database Management and Optimized Structured Query Language (SQL) Queries

    • Evaluate why databases become inefficient.
    • Construct optimized SQL queries.
    • Construct SQL queries that use multiple joins to return a data set.
    • Evaluate the performance of SQL queries to limit processor and network resources.

    Complex Queries, Triggers, and Views

    • Construct complex SQL queries.
    • Construct triggers in SQL.
    • Construct views (virtual tables) in SQL.

    Client Server Data Transfer

    • Explain the advantages and disadvantages of transferring data from client to server using Extensible Markup Language (XML) and JavaScript Object Notation (JSON).
    • Create XML and JSON data structures that would move data from client to server.

    Big Data Analytics and Data Management Tools

    • Compare big data analytics: descriptive vs. predictive vs. prescriptive.
    • Evaluate tools and techniques for proactively managing large databases.
    Tuition for individual courses varies. For more information, please call or chat live with an Enrollment Representative.

    Please ask about these special rates:

    Teacher Rate: For some courses, special tuition rates are available for current, certified P-12 teachers and administrators. Please speak with an Enrollment Representative today for more details.

    Military Rate: For some courses, special tuition rates are available for active duty military members and their spouses. Please speak with an Enrollment Representative today for more details.

    The University of Phoenix reserves the right to modify courses.

    While widely available, not all programs are available in all locations or in both online and on-campus formats. Please check with a University Enrollment Representative.

    Transferability of credit is at the discretion of the receiving institution. It is the student’s responsibility to confirm whether or not credits earned at University of Phoenix will be accepted by another institution of the student’s choice.