• Health Home

• Programs
• Courses
  • Certificate Program in Environmental and Occupational Health
  • Current Concepts in Dentistry
  • Health and Helping Professionals
  • General Health Courses
• Registration / Admission
  • Environmental and Occupational Health
  • Current Concepts in Dentistry
  • Canadian Falls Prevention
  • Wound Management for Health Professionals
• FAQ
  • Helping Professionals and General Health courses
  • Environmental & Occupational Health
• Contact

•  

COURSE INFORMATION

Database Application Development

CBIS Technology & Analysis Elective, by Distance

Program Options: CBIS TRU

This course builds upon the database design skills taught in Database Concepts (DBC) and the SQL skills obtained in Relational Database Management Systems (RDBMS). You will find this course provides a valuable and natural follow-up to the database design and data access skills by completing the lifecycle with the creation of a sophisticated web-based application interface. 

Using Open Source and/or free software editions, you will learn to install and configure the Vaadin, Eclipse and Apache Tomcat products as well as your choice of the following database products; MySQL, MS SQL Express or Oracle Express. You will build a web-based Graphical User Interface (GUI) application that incorporates multiple forms (pages), GUI controls like buttons and lists of values, as well as, generate dynamic reports. You will deploy and test your web-based application to the open source Apache Tomcat Web Server. The course incorporates extensive hands-on work.

Prerequisites: Computing Concepts, Database Concepts, and Relational Database Management Systems or equivalent experience 

Objective

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

• work with some of the latest technologies for database and interface development environments;
• build a web-based Graphical User Interface (GUI) front end using an existing relational database;
• leverage the power of SQL and Java in an Integrated Development Environment (IDE);
• create user entry forms (pages);
• implement basic data validation techniques in their application;
• incorporate basic programming to enhance functionality when interacting with GUI controls;
• deploy and test their application application web server.

Format

By Distance

CBIS courses are 13 weeks in duration. Students login to the course and communicate with the instructor and fellow students via the course management system Moodle. For further information about Moodle, visit the Moodle Startup Kit at http://distance.uvic.ca/onlinehelp/tutorials/moodle/.

Requisites

• Technical Requirements

  Students must have the following:

  Students will install the most recent versions of a number of different software applications including Eclipse/Vaadin (IDE), either Oracle Express, SQL Server Express or MySQL Community Server database software. As well to test the web-based database applications students will install the Apache Tomcat Application Server. 

  To participate in this course, students must have the following:

  Hardware Computer:

  • Personal Computer (PC), Intel or compatible Pentium III 2.6 GHz or faster

  Memory (RAM):

  • 2 GB or more is recommended

  Hard disk space:

  • 2 GB or more is recommended

  Communications:

  • Cable or ADSL service is recommended

  Software Operating system:

  • Windows 2000 Service Pack 4 or later
  • Windows XP with Service Pack 3 or later
  • Vista and Windows 7 (installs must be set to Windows XP compatibility)
  • Windows Server 2003 Standard, Enterprise, or Datacenter with Service Pack 1 or later
  • Windows Server 2003 Web Edition SP1
  • Windows Small Business Server 2003 with Service Pack 1 or later
  • Vista Home Basic and above (SQL Express SP1 and SQL Express Advanced SP2)
  • Windows XP Embedded SP2 Feature Pack 2007
  • Windows Embedded for Point of Service SP2

  Important Note: All supporting software must be downloaded by students. A high-speed, stable connection is required. You can download but do not install the software before the course starts. Various Units provide both download and installation instructions and the Moodle site may have forum posts about installation issues if any.

  Browser:

  • Microsoft Internet Explorer 6.0 or later
  • Firefox 1.5 or later
    *with cookies enabled

  Text Editor:

  • Microsoft Notepad or other text editor and Microsoft Word

  Course Text

  • This course utilizes online Unit notes. No course text is required.

  If you have any questions, please contact the Program Coordinator:

  Email: cbis@uvcs.uvic.ca
  Phone: 250-721-8779

---

Go Back

•  

Messages