Building Database Systems


You are here: [Building Database Systems Syllabus]

Printable Version

Building Database Systems: Course Syllabus Summer 2018

Currently no courses scheduled for this term.

Class 1

  • Application Development Process
    • System Analysis and Design
    • Defining the System Boundaries
    • Defining Workflow Processes
    • Designing the Database
    • Designing the System Architecture
    • Designing Security
    • Designing Auditing
    • Documenting the Design

Class 2

  • Design & Develop Databases
    • Overview of Applications
    • Database Technologies
    • Database Objects
    • Non-Procedural SQL

Class 3

  • Database Programming
    • Database Programming Environment
    • Transact-SQL
    • Creating Functions
    • Creating Triggers
    • Creating Stored Procedures

Class 4

  • Designing User Interfaces: Forms
    • Introduction to Interface Design
    • User Interface Architectures
    • Integrated Development Environments
    • Designing Form Interfaces

Class 5

  • Designing User Interfaces: Controls
    • Form Controls
    • Introduction to C# Programming Language
    • Programming Windows Forms
    • Programming Form Controls

Class 6

  • Designing Effective Output
    • Sorting, Searching, Filtering of Data
    • Producing Standard Reports
    • Ad-hoc Reporting
    • Report Bursting
    • E-mail Reports
    • Dashboard Repors
  • User Help
    • Overview of User Help
    • Passive Help
    • Reactive Help
    • Proactive Help
  • Basic HTML
    • Introduction to HTML
    • Structure of an HTML page
    • HTML Tags

Class 7

  • Introduction to Web Applications
    • Overview of Web Applications
    • Advanced HTML
    • HTML Forms
    • Java Script Basics

Class 8

  • Dynamic Web Applications
    • Introduction to ASP
    • ASP Objects and Components
    • ASP Database Connection
    • Introduction to dot net and ASP.net

Class 9

  • Building Web Applications, Part I
    • ASP.net Web Forms
    • Building a Simple Web Form
    • Web Forms displaying Database Data
    • Web Forms manipulating Database Data

Class 10

  • Building Web Applications, Part II
    • JavaScript in ASP.net
    • ASP.net AJAX
    • Using jQuery
    • Data Access Layer (DAL)
    • Business Access Layer (BAL)