School of Continuing EducationRegistration InformationContact UsUWM HomeShopping Cart
UWM logo

SCE HomepageDean's WelcomeCourses & ProgramsCertificate ProgramsDistance EducationCalendarSpecial EventsDepartments & CentersCommunity ResearchInternationalCenter for the Study of the WorkplaceFaculty & StaffCustomized TrainingKeep Me Posted
 

Connect With Us

 
HomeCourses & ProgramsCertificate ProgramsFaculty & Staff
 

Database Programming for the Web

 

In this hands-on course, you'll make use of open-source web development tools to learn best practices that make front-end web pages interact with a back-end database.

This course can be taken individually or as part of the Web Deelopment certificate program.

Who Should Attend

Those interested in utilizing a database back-end to help build a dynamic web site or further interact with their web site visitors.

Close ▲

Benefits and Learning Outcomes

Upon completion of the course you will be able to:

  • Create a basic database
  • Write information to and query information from the database
  • Properly accept user submitted data as well as display data taken from the database to a web page

Close ▲

Course Outline/Topics

Topics Covered:

  • SQL basics including how to query a database using the SELECT statement and how to modify data with INSERT, UPDATE, and DELETE
  • Database design concepts including database normalization and the use of primary and foreign keys to relate two tables
  • The use of a database abstraction layer to make your code more portable between database back-ends
  • Security principles to properly validate user data that is input through a web page
  • Learn common database field data types and when to use them

Close ▲

 

This program can be applied toward the:

Prerequisites
Web Development core courses or equivalent experience. Knowledge of SQL, PHP and Web Design courses that include creating forms are helpful but not required.

"Great class! The instructor was very helpful with the questions I had. I'm glad he related some of his own work experiences to what we had learned today. Well done."
student, 2013

  Sessions  
Mon., June 23
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Dominic Schanen, Director of Technology, Zoological Society of Milwaukee
Fee: $324
CEUs: 0.7
Program No. 5071-6259
Register Now
 
  Related Courses  
.NET - Practical Application Programming with .NET and Visual Studio 2010
JavaScript Programming
Building Dynamic Websites: AJAX - Web Services
Fundamentals of Web Security
 
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

IT Spring 2014 Brochure

Spring 2014 IT Brochure

Or download the pdf


Center for the Study of the Workplace
Learn about the real-world impact of workplace changes. Hear what leaders in both business and academia have to say and help propel yourself or your company into the future.
Learn more>>