|
My Contact Info |
|
Office: BAS S137D
Phone: 615-898-2359
Fax: 615-898-2359
Email: ccoronel@mtsu.edu |
|
Course Objective: To
provide a solid and practical foundation for the design, implementation and
management of database systems. Coverage of database design, current
database technologies, and database management issues. Our focus is
on database concepts, database modeling using the E-R model
(MS-Visio), design
of production databases, the relational model, SQL, Procedural SQL
(triggers and stored procedures), transaction management and query
optimization.
Required Textbooks and materials:
Database Systems: Design, Implementation and Management, by Peter
Rob and Carlos Coronel, published by Course Technologies.
|
|
|
Normalization Resources
SQL Tutorials
|
ERD Resources
DBMS Software/Tools
Publications & Web Sites
|
|
Videos
|
Resources:
|
|
|