10-152-332 - Database Design and SQL

Syllabus


Instructor Information

NameJamie Chavez
Emailchavez@ntc.edu
Skypejamiecchavez
Phone715.803.1732
Office LocationNTC Wausau Campus, Room A113

Office Hours

Mon 12:00 PM - 1:00 PM, Tues 3:00 PM -5:00 PM, Wednesday 8:00 AM - 10:00 AM

Course Information

Course Number10-152-332
Course NameDatabase Design and SQL
Start Date8/26/2014
End Date12/16/2014
Meeting Time(s)Tuesday 5:00 PM-8:50PM
Meeting LocationWausau Campus, Room A108
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:

Soft Skills

Compentencies

Course Grading Information

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

10-152-332 Database Design and SQL Class Schedule

Fall 2014 - Jamie Chavez

Tuesday 5:00 PM-8:50PM (Section 01)

DescriptionPoints (0)Due DateLocation