152-172 Systems Implementation SQL for DB2

Discusses the importance of and need for Database Management Systems(DBMS). Students design and implement relational databases and learn SQL.

• Syllabus



• Schedule

"Struggle is good, I want to fly. No, struggle is bad, I want to die."

• Unit 1 ERD and Normalization
• Chapter 4 Presentation
• Chapter 5 Presentation
• Chapter 6 Presentation
• ERD Handout
• Chapter 7 Presentation
• Chapter 8 Presentation
• Normalization Handout

• Unit 2 SQL
• Chapter 1 Presentation
• Chapter 2 Presentation
• Chapter 9 Presentation
• Chapter 3 Presentation
• Chapter 10 Presentation
• Chapter 11 Presentation
• Chapter 12 Presentation

• Unit 3 Project
• Chapter 18 Presentation
• What is a Well-Prepared Portfolio

• Check offs
• Single Table Selects
• Multiple Table Selects
• Table Views
• Table Updates
• Sunbelt University Assignment
  • Sunbelt Assessment
    
• Portfolios Assessment

• Project Criteria