INF 385M - Database Management

Fall 2015
Unique ID: 27765
Syllabus:   Syllabus
Prof:  Gunn, Stan
Room: UTA 1.210A
Days:  Wed
Time: 6:30 pm - 9:30 pm
 

Prerequisites:
Restricted to graduate-level degree seekers at the School of Information.

Description:
Principles and practices of database management and database design. Discussion and implementation of a database. Application life cycle, data dictionaries, relational database design, SQL queries, reports and other interfaces to database data, and documentation. Students work on individual and group projects.

Three lecture hours a week for one semester.

Enrollment is restricted to iSchool degree seekers as of Summer 2017.

Notes:
The primary goal of this class is to learn principles and
practices of database management and database design. Over the
course of the semester we will discuss the database application
lifecycle, relational database design, SQL queries, reports and
other interfaces to database data, and documentation. Lectures
will also cover ethical and privacy issues associated with
database systems. In-class instruction and exercises will focus
on the fundamentals for creating sophisticated, interactive
web-based applications.

Objectives
Learn the fundamentals of how data is stored in computer
systems.

Learn basic principles of programming that can be used to store
and extract data in a database.

Learn the fundamentals of Structured Query Language (SQL) and how
it can be used to store and retrieve data from a MySQL database.

Apply the principles used in class to build a web-based database
application from the ground up.

Learn about the software development cycle.

You will not leave this class as a programmer or a database
administrator, but you'll have the groundwork to learn those
skills, and, perhaps more importantly, you will know how to talk
to people who do those jobs.



Textbooks



Stephenson, Neal, In the Beginning was the Command Line, 1999.
This book is available as a paperback or can be downloaded from
the course documents page.

PHP for the World Wide Web: Visual QuickStart Guide, 4th Edition
Larry Ullman
Peachpit Press
ISBN: 0321245652
January 23, 2004

MySQL Crash Course, Ben Forta, Sams, ISBN: 0672327120, 2005
Old Syllabus URL: e.g.
https://utexas.instructure.com/courses/1060901/assignments/syllabus
Old Syllabus File:

View all classes with this course number

glqxz9283 sfy39587stf02 mnesdcuix8
sfy39587stf03
sfy39587stp14