Databases and Applications

Introduction to the basic concepts of database and information storage systems. Topics include data models, database design theory, database performance, transaction processing, web-database interaction, techniques for handling large volumes of data, and contemporary database issues. Hands-on projects emphasize basic database and information storage and retrieval techniques. Final Project.

Course Outcomes

Upon completion of this course, you will be able to do the following:

  1. Analyze particular data storage needs and determine appropriate database approaches, tools, and techniques to meet those needs
  2. Design, develop, and test a data-driven application that addresses a real-world need
  3. Articulate the need for a data-driven application and how it addresses a real-world problem
  4. Analyze social and ethical implications of various database applications with a particular emphasis on privacy issues
  5. Function effectively as a member of a small software development team
  6. Apply database theory to the implementation of an information management system
    1. Create an abstract data model for an information system

    2. Normalize a relational database to at least 3rd Normal Form (3NF)

    3. Use SQL to query a database

    4. Analyze the factors affecting database performance

  7. Prevent attacks against data-driven applications by using defensive programming techniques, such as input validation and prepared statements

Announcements

subscribe via RSS