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:
- Analyze particular data storage needs and determine appropriate database approaches, tools, and techniques to meet those needs
- Design, develop, and test a data-driven application that addresses a real-world need
- Articulate the need for a data-driven application and how it addresses a real-world problem
- Analyze social and ethical implications of various database applications with a particular emphasis on privacy issues
- Function effectively as a member of a small software development team
- Apply database theory to the implementation of an information management system
-
Create an abstract data model for an information system
-
Normalize a relational database to at least 3rd Normal Form (3NF)
-
Use SQL to query a database
-
Analyze the factors affecting database performance
-
- Prevent attacks against data-driven applications by using defensive programming techniques, such as input validation and prepared statements
Announcements
Final Grades Posted in Blackboard
Wrap Up
Final Week!
Grades Posted for B+ Tree Assignment
Feedback on B+ Tree assignment
Extension for B+ Tree assignment
Addendum for B+ Tree Pseudocode
Grades and Feedback
B+ Tree assignment posted
Alternative Site Theme
Peer Evaluation
Discussions Graded
Web Development PEX
Schedule Changes
Discussion Posts
Resuming Class
Grades Posted in Blackboard
Operation Graduation
Web Development with Apache
Resiliency Day: Part Deux
Office Hours
Resiliency Day
What I've Been Working On
Welcome to Online Learning!
"Soft-start" comms check
Path Forward
Project Teams and Peer Evaluations
User Inyerface
SQL PEX extension
ER diagrams for SQL PEX
Empty Mondial database
Classes Canceled 18 February
Lesson 15 preparation
Lesson 12: SQL Data Definition
Software Installation in VM
Project Proposal Due
Graded Review II moved
Textbook
Extra Credit
Welcome to Comp Sci 364!
subscribe via RSS