Skip to main content
Fennie
HomeGet Started
WGU
Information Technology
4 credits

WGU C170: Data Management - Applications

C170 is the older-generation applied database course still active in several WGU degree plans: SQL queries, database design, normalization, and indexing, built in MySQL. It's assessed with an objective assessment plus a hands-on component, and was the predecessor pattern for the D426/D427 split.

Fennie is independent and not affiliated with Western Governors University. This is an unofficial study guide.

Build my C170 study plan

What makes it hard

The normalization-and-build work is where students stall — taking unnormalized data through 1NF to 3NF and creating the corresponding tables rewards method over intuition. Students who only read about SQL get caught the same way D427 catches them: the queries have to actually run.

What you'll cover

  • • SQL queries and DDL
  • • Database design and ER modeling
  • • Normalization (1NF–3NF)
  • • Indexes and query efficiency
  • • MySQL in practice

The C170 study guide

How to study for WGU C170, step by step.

  1. 1

    Take the pre-assessment to split your gaps

    C170 mixes conceptual questions with applied SQL, and the PA shows which side needs you more. Most students' gap is the normalization workflow.

  2. 2

    Practice the normalization pipeline end to end

    Take messy, unnormalized data through 1NF, 2NF, and 3NF and then write the CREATE TABLE statements for the result. That full pipeline is the course's signature skill.

  3. 3

    Write SQL in MySQL daily

    Queries, joins, and DDL need to come out of your fingers, not your notes. A daily practice block in an actual MySQL environment is the only preparation that transfers.

  4. 4

    Drill the design vocabulary

    Keys, constraints, ER conventions, and index concepts appear as direct recall. Short flashcard passes cover them without stealing time from hands-on work.

  5. 5

    Retake the PA, then finish strong

    When the pre-assessment passes comfortably and your practice SQL runs clean on the first attempt, complete the assessment while the syntax is fresh.

  6. 6

    Put the practice cadence on Fennie

    Upload the C170 unit list to Fennie and Daily Plans schedules daily SQL practice and normalization reps toward your assessment date, with quizzes generated from the actual units. Free to start.

    Start my C170 plan free

How Fennie helps with C170

Daily Plans schedule C170 as daily hands-on SQL plus normalization reps, the two skills the assessment actually measures. Fennie chat untangles why a join or a normal form went wrong, and quizzes keep the design vocabulary warm.

FAQ

Is WGU C170 hard?

Moderate — the concepts are introductory but the assessment expects working SQL and a clean normalization method. Daily hands-on practice is what separates one-attempt passes from retakes.

Is C170 the same as D426 and D427?

C170 is the older combined course; newer degree plans split the material into D426 (concepts) and D427 (applied SQL). If your plan lists C170, the content covers both halves.

How long does C170 take?

Commonly 3–5 weeks. Students who practice the full normalize-then-build pipeline early finish near the front of that range.

Pass C170 with a plan, not a cram

Upload your C170 materials and Fennie generates a Daily Plan paced to your deadline — plus chat, flashcards, and quizzes built from the actual course content.

Get started free

More WGU courses

C182 — Introduction to IT

C182 is the foundational survey course for WGU's IT degrees, covering computing history, hardware, software, networking basics, and the role of IT in organizations. It's usually one of the first courses new IT students hit, and it ends in an objective assessment (OA).

C172 — Network and Security Foundations

C172 covers networking models, common protocols, network devices, and baseline security concepts — essentially a lighter cousin of Network+ material. It's a core early course across WGU's IT and cybersecurity programs and ends in an OA.

C779 — Web Development Foundations

C779 introduces HTML, CSS, and the basics of how websites are structured, styled, and published. It sits early in several WGU IT degree plans and is assessed with a proctored exam rather than a build-a-site project.

D426 — Data Management - Foundations

D426 covers relational database fundamentals: the relational model, ER diagrams, normalization, and introductory SQL concepts, delivered through zyBooks. It ends in an OA and is the prerequisite for the hands-on D427.