Database Programming (ITEC224)
This course is the second database course in the curriculum. Information Management Concepts such as data quality, accuracy, timeliness, backup/recover, business rules, reengineering, data integration and data organization architecture, replication, data are introduced. Details of the conceptual and logical database design procedure for an enterprise level database, advanced concepts in database design and implementation from the programming perspective are studied in detail in the lectures. Common problems and their solutions, security and access considerations in database design are covered. Tasks related to managing the database environment are also discussed. Object Based and XML databases and related query languages are introduced. The labs cover efficient use of SQL for complicated tasks and teach a 3GL database language. The main topics of the laboratory applications are: use of triggers, stored procedures and functions for efficient and more secure implementations of database applications.