| 9a. Catalog Description: |
This course is designed for the student who needs knowledge and skills about advanced database systems that use the SQL language such as IBM's DB2, Oracle, Sybase and Microsoft's SQL Server. This course is designed for the end user, the database designer and the database administrator. Microsoft SQL Server 2000 is the database system currently used for this course.
|
| 9b. Other Catalog information: |
|
| |
| 10. Student Performance Objectives: |
Upon successful completion of this course, a student will be able to:
1. Describe SQL DBMS architecture.
2. Retrieve data using the SQL language.
3. Insert, update, and delete data using the SQL language.
4. Design a databse using normal form techniques.
5. Create and maintain tables,databases, and files.
6. Back up databases.
7. Restore databases.
8. Use advance skills such as stored procedures, transactions, and locks.
9. Create views.
9. Import, export and transform data.
10. Plan and implement database permissions. |
| |
| 11. Methods of Evaluating Student Achievement: |
1. Written examinations requiring the student to demonstrate knowledge of and ability to administer a SQL server database.
2. Lab assignments requiring the student to demonstrate proficiency in administering a SQL server database.
3. Class discussions
|
| |
| 12. Student Assignments (Homework): |
| |
| a. Required Reading Assignments: |
| Approximately one chapter per week (approx. 40 pages). |
| |
| b. Required Writing Assignments: |
| Approximately one homework assignment per week. |
| |
| c. Other (Terms projects, research papers, portfolios, etc.) |
| Team and individual projects. |
| |
| 13. Course Content Outline: |
Students will be required to analyze, evaluate, compare and contrast the following characteristics, techniques and procedures:
I. An introduction to SQL
A An introduction to relational databases and SQL
B How to work with a SQL Server database
II The essential SQL skills
A How to retrieve data from a single table
B How to retrieve data from two or more tables
C How to code summary queries
D How to code subqueries
E How to insert, update, and delete data
F How to work with data types and functions
III Database design and implementation
A How to design a database
B How to create and maintain databases and tables
C How to use the Enterprise Manager
D How to Backup and Restore databases
IV Advanced SQL skills
A How to work with views
B How to code scripts
C How to code stored procedures, functions, and triggers
D How to work with cursors
E How to manage transactions and locking
F How to manage database security
V How to install SQL Server
VI Coding and syntax conventions
VII Miscellaneous topics
|
| |
| 14a. All textbooks, resources and other materials used in this course are: |
| College level
|
| |
| 14b. EXAMPLE texts, reading and resources:
|
Bryan Syverson. Murach's SQL for SQL Server. first
Mike Murach and Associates, Inc., 2002
|
Microsoft. SQL Server 2000 System Administration. first
Microsoft Press, 2001
|
Microsoft. SQL Server 2000 Design and Implementation. first
Microsoft Press, 2001
|
