Skip to main content

Search form

Main menu

  • UWinnipeg
  • PT Timetable
  • About Us
  • Contact Us
  • Student Logins
Menu

Secondary Menu

Home
  • Future Students
    • Admissions

      Admissions Menu

      • Admission Requirements
      • Apply Today
      • Tuition & Fees
      • Funding & Financial Aid
      • Internships
      • Student Life
      • FAQ
      • Pathways to UWinnipeg
      • Student Success Stories
      • PACE News

      Programs

      Programs for Domestic Students

      • Full Time
      • Part Time
      • Microcredentials

      Courses

      Courses

      • Part Time Timetable
      • Register for Courses
  • Current Students
    • Part Time

      Part Time

      • Part Time Students Home
      • Part Time Timetable
      • Part Time Students Planning Tool
      • Register for Courses
      • Online Learning for Part Time Students

      All

      All

      • Transfer Credits
      • Student Resources
      • Forms
      • FAQ
      • Graduation Information
      • Student Life
      • PACE News

      Student Logins

      Student Logins

      • Nexus Login
      • WebAdvisor Login
      • Webmail Login
  • International Students
    • International Students

      International Students

      • Programs
      • Admission Requirements
      • Admission Process for Full Time Students
      • Tuition & Fees
      • Study In Canada
      • UWinnipeg English Language Pathways
      • International Student Success Stories
      • Transfer Credits
      • PACE News
      • Join Us for Live Webinar About Studying at PACE
  • About Pace
    • About Pace

      About PACE

      • About Us
      • Contact Us
      • Fact Sheets & Publications
      • Instructors
      • Teach at PACE
      • Policies
      • PACE News
Apply Today!
DIT 21127 36 hours

In a web development environment, predictive tools are essential for helping developers conceptualize and integrate the flow of data through websites. In this hands-on course using MySQL, students will be introduced to the principles of database design and data modeling, the fundamentals of entity relationships, and the diagram database models using Entity Relationship Diagrams (ERD).

Students will learn to normalize database tables to create robust and scalable databases that can handle growth and minimize human error. Students will be introduced to the MySQL Database Management System (DBMS) and to the fundamentals of querying databases using Structured Query Language (SQL) to extract meaningful information, enter new information, and update existing information.

Prerequisites

  • MySQL
  • Computer and Internet access at home
Outcomes

Upon successful completion of this course, students will be able to:

  • Identify and define “entities” and explain their importance in database design
  • Identify and explain the relationship (cardinality) of entities in a database
  • Plan and model a multi-table database
  • Explain and demonstrate the process of normalization, including identification of the major normal forms
  • Normalize and model a multi-table database to (at least) Third Normal Form (3NF)
  • Create a fully functioning database in the MySQL Database Management System

Apply Today
UWinnipeg PACE
  • UWinnipeg
  • About Us
  • Contact Us
  • About Pace
  • Webadvisor
  • Nexus Login
  • Webmail Login
  • Contact Webmaster
COPYRIGHT © 2018 THE UNIVERSITY OF WINNIPEG - PROFESSIONAL, APPLIED AND CONTINUING EDUCATION
Privacy PolicyEmergency Info

Cookies

By clicking "Accept" you allow cookies that improve your experience on our site, help us analyze site performance and usage, and enable us to show relevant marketing content.

Accept