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.
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
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
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
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
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
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.
Today
Today's C170 plan
What a Fennie Daily Plan looks like for C170. Yours is built from your own syllabus and adapts every day to your deadlines and progress.
First plan free, no card required. Fennie is independent and unaffiliated with your school.
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.
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.