This is an introductory course on database systems that teaches practical skills appropriate for database administrators, database specialists, database users, and application developers. The course provides a comprehensive coverage of data modeling, including entity-relationship and relational models, logical database design, and the implementation and manipulation of databases.
The emphasis is on the pitfalls, techniques, theory, and practice of data modeling and logical database design. Through several programming assignments and a project using Oracle 10g, you will also become familiar with practical aspects of database development, including data definition and data manipulation in SQL. Other contemporary languages for defining and querying persistent data, QBE (Query-By-Example) and XML (Extensible Markup Language), are also discussed. The course concludes with a survey of recent trends in database and information systems, including data warehousing and data mining.
