Course Outlines
University of Winnipeg Continuing Education
DIT 31003 Web Development Level 6: MySQL (Advanced)
|
Course: |
DIT 31003 Web Development Level 6: MySQL (Advanced) The advanced MySQL course expands on basic concepts by giving the student more practical experience to complement the theory already gained. Students will focus on more technical aspects of MySQL as well as analyzing and designing more complex database solutions for common RDBMS applications and creating Web pages that interact with the database via PHP |
|---|---|
|
Dates: |
To be announced. |
|
Time: |
To be announced. |
|
Cost: |
$500 |
|
Instructor: |
The instructor has not been announced. |
|
Materials: |
To be announced.
Optional book resources are here. |
|
Related Program(s): |
|
|
Related Jobs: |
Monster.ca job search. |
|
Additional Information: |
|
|
Register Now: |
Seating is limited. Call The University of Winnipeg Continuing Education Front Desk to register: (204) 982-6633. |
|
Location and Hours: |
Classes for Information Technology are at Main Campus, 480 Ellice Avenue on the 2nd floor of Lockhart Hall (rooms 2L13A & 2L13B) and the 3rd floor of Manitoba Hall (room 3M58). Proceed to room 2L13 in Lockhart Hall to find out which room your class will be in. Stevi Dram's office is on the 2nd floor, Lockhart Hall: 2L13C The DCE Registration Office is located at 275 Portage Avenue on the 14th floor. Their phone number is (204) 982-6633. Registration Office Hours:
Lost? Here is a map of Main Campus showing Lockhart Hall and Manitoba Hall. |
|
DCE IT Twitter Updates |
Follow uwinnipegDCE_IT on Twitter... |
|
DCE Delicious Bookmarks |
|
|
DCE Facebook Page |
Follow University of Winnipeg Division of Continuing Education on Facebook... |
Learning Outcomes
- Integrate and create practical applications of MySQL with PHP
- Sanitize user-submitted data
- Implement full-text searching of data
- Perform database transactions, triggers, views & stored routines
- Describe database driver abstraction with PHP
- Implement database Security
- Decribe common MySQL problems and solutions
- Increase MySQL's performance
Prerequisites
The following or equivalent is required before taking this course:
Web Design Certificate
- 31000 Web Design Level 4: XHTML (Advanced)
-
This course will build on the basics already introduced by teaching how to use XHTML 1.0 Strict markup with Cascading Style Sheets to create Web pages that are faster and easier to create, maintain, and implement across a wider variety of user agents. CSS for layout and XHTML for markup will be explored.
- Learn more about the Web Design Level 4: XHTML (Advanced) course.
Web Development Diploma
- 31001 Web Development Level 1: Apache (Introduction)
-
Apache is a free open-source HTTP server software package developed and provided by the Apache Software Foundation. Apache has been the most popular web server on the Internet since April 1996 and runs on nearly every operating system available, including Linux, Windows, Mac OS X and many more. Apache's robustness, features, stability and freely-available source code has shaped the Internet and the World Wide Web into how we know it today. Students will learn how to utilize the Apache server technology to implement and maintain enterprise-class web sites.
- Learn more about the Web Development Level 1: Apache (Introduction) course.
- 15528 Web Development Level 2: Perl (Introduction)
-
Perl is a robust programming language frequently used for creating CGI (Common Gateway Interface) programs on Web servers. It is fast, can read and write binary and text files, and can process very large files quickly. It is used extensively on Web servers all over the world.
- Learn more about the 15528 Web Development Level 2: Perl (Introduction) course.
- 15529 Web Development Level 3: PHP (Introduction)
-
PHP is a free, open-source, server-side scripting language that can be embedded in Web pages for developing Web based software applications, often with MySQL or other databases. This is the first step in creating feature rich sites that include shopping carts or other e-commerce abilities.
- Learn more about the 15529 Web Development Level 3: PHP (Introduction) course.
- 31002 Web Development Level 5: PHP (Advanced)
-
The advanced PHP course builds on the basics from the introduction to PHP material by more deeply exploring the abilities of PHP and making Web pages become more functional and secure.
- Learn more about the Web Development Level 5: PHP (Advanced) course.
- 15530 Web Development Level 4: MySQL (Introduction)
-
MySQL (pronounced "my ess cue el") is a popular cross-platform, free, open source relational database management system that uses Structured Query Language (SQL). MySQL is noted for its speed, reliability, and flexibility and is used for content management (CMS) systems, shopping carts, product databases, and other applications all over the Web.
- Learn more about the Web Development Level 4: MySQL (Introduction) course.
Course Format
The course format is to be announced.
Student Deliverables and Pace
The student deliverables are to be announced.
Evaluation
The evaluation is to be announced.
Topic Outline
The topic outline is to be announced.
Grades:
Letter Graded Courses:
A+ = 96 - 100% Outstanding A = 91 - 95% A- = 83 - 90% Very Good B+ = 75 - 82% B = 70 - 74% Average C+ = 66 - 69% C = 57 - 65% Pass D = 50 - 56% F = Failure VW = Voluntary Withdrawal
Pass/Fail Courses:
P = Pass F = Failure I = Incomplete VW = Voluntary Withdrawal
Audited Courses:
CP = Certificate of Participation (based on >75% attendance) NCP = No Certificate of Participation (based on <75% attendance)
Note: Final percentages containing a half-point will be rounded up to the next full point (e.g., 69.5 would be rounded up to 70), and then converted to the letter grade (i.e., from C+ to B).
Late Assignments
Unless otherwise stated, late assignments are penalized 10% per calendar day. No assignments will be accepted more than 2 days late without permission.
Quizzes
Quizzes may be given during classes and could be time limited. They may be fill in the blank, short answer, code, or multiple choice and may be given online, verbally, or on paper. Missed quizzes cannot be made up if absent or if you are late for class.
Attendance
While class attendance may not be taken for marks, your attendance is required for each class to participate in quizzes, homework, and assignments.
Considerations
Please consider turning off any cell phones and pagers while in lectures or seminars. If you need to be available (on call for work, for example) please set your cell/pager to vibrate. Also, please remember that checking email, typing instant messages, or surfing the Web may be distracting to others.
A Statement on Plagiarism and Cheating
The Modern Language Association Handbook for Writers of Research Papers defines plagiarism as:
the act of using another person's ideas or expressions in your writing without acknowledging the source.
Copying words or ideas from any source, including another student, constitutes academic 'theft', and may result in loss of marks for the assignment, loss of marks for the entire course, or even expulsion. The same penalties will result if a student is found guilty of cheating or contributing to cheating on any test, exam or assignment.
Students should familiarize themselves with University of Winnipeg policy concerning plagiarism and academic honesty.
Other Plagiarism Resources
More Information
Here are links to more information that you may find helpful:
- Winnipeg Transit
- The Winnipeg Transit site includes links for fares, the free Downtown Spirit service, schedules and more.
- Exchange District BIZ
- The Winnipeg Exchange District BIZ site has maps and information about the area around our campus.
- Downtown Winnipeg BIZ
- The Downtown Winnipeg BIZ site includes links for parking, restaurants, and the BIZ Patrol.
Notice
The contents of this page are given as a guideline only and are subject to change.
Course Outlines - University of Winnipeg Continuing Education - Web Development Diploma - [ DIT 31003 Web Development Level 6: MySQL (Advanced) ] -
Description - Outcomes - Prerequisites -
