10-152-333 - Advanced 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-333
Course NameAdvanced SQL
Start Date8/29/2014
End Date12/19/2014
Meeting Time(s)Friday 8:00 to 11:50 a.m.
Meeting LocationWausau Campus, Room A168
Total Hours72
Type of InstructionLecture (2 credits, 36 hours); Lab (1 credit, 36 hours)
Mode of DeliveryIn Person

Course Description

Builds upon the database concepts taught in earlier courses, introducing advanced SQL syntax, database design and data transformation. Learners will write advanced SQL statements, design robust databases and write Extract, Transfer, Load (ETL) processes. Additional topics include alternate database technologies, emerging database trends and database administration and 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-333 Advanced SQL Class Schedule

Fall 2014 - Jamie Chavez

Friday 8:00 to 11:50 a.m. (Section 01)

DescriptionPoints (860)Due DateLocation
1.1 Class Lab109/4/2014Learning Plan 1
1.1 Project Assignment309/4/2014Learning Plan 1
Discussion Board Post 1109/4/2014Learning Plan 1
1.2 Class Lab109/11/2014Learning Plan 1
1.2 Project Assignment309/11/2014Learning Plan 1
1.2 Quiz109/11/2014Learning Plan 1
1.3 Class Lab109/18/2014Learning Plan 1
1.3 Project Assignment309/18/2014Learning Plan 1
Discussion Board Post 2109/18/2014Learning Plan 1
2.1 Class Lab109/25/2014Learning Plan 2
2.1 Project Assignment309/25/2014Learning Plan 2
2.1 Quiz109/25/2014Learning Plan 2
2.2 Class Lab1010/2/2014Learning Plan 2
2.2 Project Assignment3010/2/2014Learning Plan 2
2.2 Evaluation Assignment5010/2/2014Learning Plan 2
3.1 Class Lab1010/9/2014Learning Plan 3
3.1 Project Assignment3010/9/2014Learning Plan 3
Discussion Board Post 31010/9/2014Learning Plan 3
3.2 Class Lab1010/16/2014Learning Plan 3
3.2 Project Assignment3010/16/2014Learning Plan 3
3.2 Quiz1010/16/2014Learning Plan 3
3.3 Class Lab1010/23/2014Learning Plan 3
3.3 Project Assignment3010/23/2014Learning Plan 3
Discussion Board Post 41010/23/2014Learning Plan 3
3.4 Class Lab1010/30/2014Learning Plan 3
3.4 Project Assignment3010/30/2014Learning Plan 3
3.4 Quiz1010/30/2014Learning Plan 3
3.5 Class Lab1011/6/2014Learning Plan 3
3.5 Project Assignment3011/6/2014Learning Plan 3
3.5 Evaluation Assignment5011/6/2014Learning Plan 3
4.1 Class Lab1011/13/2014Learning Plan 4
4.1 Project Assignment3011/13/2014Learning Plan 4
Discussion Board Post 51011/13/2014Learning Plan 4
4.2 Class Lab1011/20/2014Learning Plan 4
4.2 Project Assignment3011/20/2014Learning Plan 4
4.2 Quiz1011/20/2014Learning Plan 4
5.1 Class Lab1012/4/2014Learning Plan 5
5.1 Project Assignment3012/4/2014Learning Plan 5
Discussion Board Post 61012/4/2014Learning Plan 5
5.2 Class Lab1012/11/2014Learning Plan 5
5.2 Project Assignment3012/11/2014Learning Plan 5
5.2 Quiz1012/11/2014Learning Plan 5
5.3 Project Assignment3012/18/2014Learning Plan 5
5.3 Evaluation Assignment5012/18/2014Learning Plan 5