COMPE 561
Database and Web Programming

Catalog Description:  

Programming computer applications that involve representation, storage, access and communication of data.  File systems.  File formats: text files, binary files and serialization.  Extensible markup language (XML). Unicode, Relational databases.  Structured Query language (SQL). Web servers and web browsers.  Hypertext Markup Language (HTML and XHTML).  Web services. Microsoft Windows development environment: Visual Studio; C# language; NET Framework; Language Integrated Query (LINQ); ASP.NET; ADO.NET.

Credits: 3.0

Class Schedule: 3 hours lecture

Prerequisite by topic:   Fundamentals of object-oriented programming, C# language, .NET framework and Visual Studio development environment.

Prerequisite by course: CompE361

Course Objectives          

  1. Understand  the various tools and technologies related to the representation, storage, access and communication of data.
  2. Be able to design and develop computer applications involving these technologies.

Textbook: 

Deitel et al, C# 2008 for Programmers, 3E, Prentice Hall, 2009
                                           
References:  Various online sites, including The Code Project, Microsoft Developer Network (MSDN) and Wikipedia

Topics Covered  

Data Representation

  1. data structures in memory
  2. .NET collection classes
  3. file systems
  4. relational databases
  5. markup languages
  6. Unicode

File Systems

  1. text files
  2. binary files
  3. sequential access
  4. random access
  5. memory-resident vs file-resident processing
  6. serialization
  7. .NET File System classes

Extensible Markup Language (XML)

  1. XML syntax
  2. XML Namespaces
  3. LINQ to XML
  4. Document Type Definitions (DTDs) (optional)
  5. XML Schema Documents (optional)

Relational Databases

  1. relational database model: tables, attributes (columns), tuples (rows), primary keys, foreign keys, relationships, constraints
  2. database design principles
  3. Structured Query Language (SQL)
  4. Datagrid control and data binding
  5. LINQ to SQL

Internet and World Wide Web Architecture

  1. Internet Protocol (IP) Addresses
  2. client-server architecture
  3. Web servers (e.g., Internet Information Server)
  4. Web browsers (e.g., Internet Explorer)
  5. Web Pages and Uniform Resource Locators (URLs)
  6. Hypertext Transfer Protocol (HTTP)
  7. HyperText Markup Language (HTML and XHTML)
  8. XHTML programming: headers, lists, images, links, tables, forms

Web Programming with ASP.NET

  1. Web Forms
  2. code-behind file
  3. Web Controls
  4. session tracking
  5. connecting to a database
  6. web services
  7. Simple Object Access Protocol (SOAP)

Socket Programming (optional)

  1. Multithreading
  2. Clients and Servers

Prepared by: Dr. Leonard R. Marino
Date of Preparation: 01/30/2009