Cs 3306 Databases 2

CS 3306: Databases 2

Course Description:

This course will cover server database management, configuration and administration, security mechanisms, backup and recovery; transact SQL Programming, and an introduction to database web-application development and security.

Required Textbook and Materials:

The main required textbooks for this course are listed below, and can be readily accessed using the provided links. There may be additional required/recommended readings, supplemental materials, or other resources and websites necessary for lessons; these will be provided for you in the course’s General Information and Forums area, and throughout the term via the weekly course Unit areas and the Learning Guides.

• Sharma, N., Perniu, L., Chong, R.F., Iyer, A., Nandan, C., Mitea, A.C., Nonvinkere, M., & Danubianu, M. (2010). Database Fundamentals (1st ed.). Markham, ON: IBM Corporation.
• Silberschatz, A., Korth, H.F., & Sudarshan, S. (2001). Database System Concepts (4th ed.). New York, NY: McGraw-Hill.
• Din, A.I. (1994). Structured Query Language (SQL): A Practical Introduction. Manchester, UK: NCC Blackwell.
• Simpson, B. & Toussi, F. (Eds.). (2013). HyperSQL User Guide. The HSQL Development Group.
• HyperSQL website by The HSQL Development Group.

Software Requirements/Installation:

In this course, we will be learning about database systems and will be conducting database lab exercises. The course has been designed so that it can be completed using freely available open source tools including:

OpenOffice Base Version 3.3.0 (or current version) – The database included in the OpenOffice suite. OpenOffice Base uses the HSQLDB database engine, which is compliant with the ANSI SQL-92 and the ANSI SQL-2008 specifications. The open office suite can be downloaded at the following url: http://www.openoffice.org/download/

Dia version 0.97.2 – The Dia (diagram editor) application provides a free open source tool that can be used to create diagrams including flowcharts and the Entity Relationship diagrams required in this course. Dia can be downloaded from the following url: http://dia-installer.de/download/index.html.en

You also have a choice to use any other relational database system that supports ANSI SQL such as DB2-Express-c, which is the database developed by IBM and used in examples within the book. You can also use MySQL. HyperSQL will be available for users of the Virtual Computing Lab as an alternative to OpenOffice if desired. The Clifton International University will not provide an instance of DB2-Express, MySQL or Oracle in the virtual computing lab.

Learning Objectives and Outcomes:

By the end of this course students will be able to:

1. Examine server database management and its attributes
2. Distinguish between configuration and administration of database systems
3. Describe database security mechanisms used to protect data
4. Understand backup and recovery procedures and apply to an active database
5. Apply transact SQL Programming to solve applied business problems
6. Describe database web-application development.
7. Apply Hyper Structured Query Language (SQL) statements to manipulate both data structures and data within a database system

Course Schedule and Topics:

This course will cover the following topics in eight learning sessions, with one Unit per week. The Final Exam will take place during Week/Unit 9.

Week 1: Unit 1 – Introduction to Data models

Week 2: Unit 2 – Transaction Management

Week 3: Unit 3 – Application Development and Admin

Week 4: Unit 4 – Security Mechanisms

Week 5: Unit 5 – Backup and Recovery

Week 6: Unit 6 – Transact SQL Programming

Week 7: Unit 7 – Database Web-Application Development

Week 8: Unit 8 – Technology trends and databases

Week 9: Unit 9 – Course Review and Final Exam