Computer Technology and Information Management

A to Z Course Index

Information Sessions

Certificate Programs

Transcripts

Course Locations

Concurrent Enrollment

Order a Catalog

Courses begin every month. A new edition of our catalog is published three times a year in early April, July and December.


Quick Enroll

Search

Building Database Systems

X478 (2 semester units in EECS)

A requirement in the Professional Sequence in Database Management

Get an overview of database applications from simple desktop applications to client-server and finally, to Web applications. You pay special attention to designing forms and reports. You do additional class exercises, tests, and projects to enhance your learning experience. Upon successful completion, you are able to design and develop effective database applications using simple development tools. You gain broad knowledge of the different application types and the underlying technologies.

Using main-stream desktop applications as well as 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.

Course content outline

Introduction and overview of database applications
  • Overview of applications
  • Database technologies and objects (back-end)
  • Application technologies (front-end)

    • Application Development Design process
  • System analysis and design (goals and scope)
  • Analyzing user requirements
  • Determining technologies

    • Introduction to form design and human interfaces
  • Effective interfaces and interface models
  • User interface architectures
  • Usability considerations

    • Designing effective user interfaces
  • Representing entities in form design
  • One-to-One, One-to-Many, Many-to-Many relationships
  • Representing hierarchies
  • Using specific window controls

    • Building simple desktop form applications
  • Using specification documents, design and create a simple application
  • Database design
  • Application design
  • Automation processes

    • Building complex form applications (client-server)
  • Understanding client-server concepts
  • Converting desktop, file-server based systems into client-server

    • Designing effective output (forms(online) and reports)
  • Basics of sorting, searching, and filtering data
  • Producing standard reports
  • Ad-hoc query interfaces
  • Report bursting
  • E-mail reports

    • Introduction to web applications
  • Overview of basic web application architectures
  • Presentation-oriented vs. Service-oriented
  • Understanding server-side processing
  • The state-less web

    • Overview of web technologies for dynamic web applications
  • Windows-based web technologies
  • Unix-based web technologies
  • Introduction to HTML and ASP Classic/ASP.net
  • Building a simple ASP classic application

    • Building a complex web application
  • Introduction to Visual Studio
  • Setting up an web application project
  • Connecting to the database
  • Designing and building forms
  • Enhancing the web application
  • Navigation and security
  • Introduction to AJAX and Javascript


    • Prerequisite: Introduction to Relational Database Management Systems X409.1, or basic understanding of databases and Introduction to SQL.

    There are currently no sections open for enrollment.




    Sections closed for enrollment

    Thurs. June 25, San Francisco

    Quick Enroll

    Search