CIS 244: Database Design and Implementation

Course Description

Provides students with hands-on experience designing and implementing databases using a currently popular relational database management system (DBMS). Includes logical design, physical design, database creation, data import/export, views, stored procedures, triggers, transactions, performance and security. Recommended preparation: CIS 143 or equivalent experience.

Course OutlineSQL Server 2000 Programming Step by Step

  1. The SQL Server 2000 Environment and Administering SQL Server
  2. SQL Server 2000 Security and Creating a Database
  3. Creating Tables and Creating Indexes
  4. Creating Relationships and Creating Check Constraints
  5. Creating Table Objects and Creating Database Diagrams
  6. Retrieving Rows and the SELECT Statement
  7. Sorting and Selecting Rows and Joining Tables
  8. Summarizing Data and Views
  9. Adding Rows and Updating Rows
  10. Deleting Rows and Copying and Moving Data
  11. The Query Analyzer and Data Definition Language
  12. Analyzing Queries and Transact-SQL Language Components
  13. Programming Objects and Controlling Execution
  14. Transact-SQL Cursors and Stored Procedures
  15. Triggers and User-Defined Functions

Required Materials

  • Microsoft® SQL Server™ 2000 Programming Step by Step  – Microsoft Press –
    ISBN-10: 0-7356-1142-4   ISBN-13: 9780735611429

    Note: The Harper Bookstore is unable to order this book.  Be sure to obtain a copy of the textbook on your own before registering for this course.
  • Internet access and a Harper Blackboard account.
  • Access to a computer running a licensed or free trial version of Microsoft SQL Server 2000. Harper lab I 205 has computers and software that may be configured as necessary for this course.

Faculty Contact

For questions about this course contact the department coordinator:

Dave Braunschweig
dbraunsc@harpercollege.edu
847.925.6817