10-152-332 - Database Design and SQL

Syllabus


Instructor and Class Information

Instructor NameClay Hess
Emailhess@ntc.edu
Phone715-803-1731
Office LocationNTC Wausau Campus, Room A113

Instructor Office Hours

Monday1:00 to 3:00 p.m.
Wednesday1:00 to 3:00 p.m.
Thursday1:00 to 3:00 p.m.

Course Information

Course Number10-152-332
Course TitleDatabase Design and SQL
Start Date8/27/2013
End Date12/17/2013
Meeting Time(s)Tuesday, 4:00 to 7:50 p.m.
Meeting LocationWausau Campus, Room A168 and regional campuses
Total Hours72
Type of InstructionLecture (2 credits, 36 hours); Lab (1 credit, 36 hours)
Mode of DeliveryIn Person

Course Description

This course builds upon the basic database principles learned in Database Concepts (10-152-331), further exploring database design/normalization and introducing more complex and varied SQL statements. Learners will create ERDs, create/modify tables and populate/retrieve data using SQL scripts with Microsoft SQL Server. Additional topics include: many-to-many relationships, composite primary keys, referential integrity, stored procedures, triggers and database security.

Pre/Corequisites

Textbooks

Learner Supplies:

Core Abilities

Compentencies

Course Grading Information

Letter GradeRequirements
A>= 92% and meet all course compentencies
A->= 90% and meet all course compentencies
B+>= 87% and meet all course compentencies
B>= 83% and meet all course compentencies
B->= 80% and meet all course compentencies
C+>= 77% and meet all course compentencies
C>= 70% and meet all course compentencies
D>= 60% and meet all course compentencies