Building Database Systems


You are here: [Building Database Systems Home]

A course reader developed by the instructor is provided at no additional cost to accompany this course.

This course provides students with an overview of database applications from simple desktop applications to client-server and finally, to Web applications; special emphasis is put on designing forms. Additional class exercises, tests, and projects are assigned to enhance the student's learning experience. Upon successful completion, students will be able to design and develop effective database applications using simple development tools. Students will gain broad knowledge of the different application types and the underlying technologies.

Using free, express versions of databases (Oracle, SQL Server) in conjunction with free-downloadable IDE (Integrated Development Environments) tools, students design and build complex applications. Attention is also given to designing effective user interfaces and elements of human interfaces. Additionally, reporting tools for formatted output and combining the different parts into one integrated application are covered in this course. Designed for increased student hands-on activities, additional class exercises, tests, and projects are assigned to enhance the learning experience.

The course outline is shown below:

  • Overview of Database Applications
  • Application Development Design (System Analysis, Designing Workflow, Databases, Security and Auditing)
  • Database Programming (DQL, DML, T-SQL, Triggers, Stored Procedures)
  • User Interfaces (Interface Design and Architecture, Effective Interfaces)
  • Client-Server Form Applications (C# Programming Language, Windows Forms & Controls)
  • Designing Effective Output (Reporting, Report Bursting, E-mail reports)
  • User Help & HTML
  • Introduction to Web Applications (HTML Forms, JavaScript)
  • Introduction to ASP
  • Building Web Applications (ASP.net, AJAX, JavaScript in ASP.net)

Prerequisites: Introduction to Relational Database Management Systems (X409.1) or basic understanding of databases , prior experience in SQL is helpful but not required.

Click here for more information