CS 122: Introduction to SQL.


Syllabus for CS 122

Projects and Solutions
ProjectsSolution
  Solution for Project 2
  Solution for Project 3
  Solution for Midterm.
  Solution for project 4.
Project 5: Normalization.
Excel file.


Lessons (new) and Reading Assignments:
Lessons Reading Assignments
  • Data type.

    •      - Lesson 1.
         - Lesson 1b.     		Chapters: 1, 2, 3, 4, 5, 6, 7, 8.
    Do as many exercises as you could at the end of each chapter.
  • Lesson 2.

    •       Student.csv file.
          FTStudent.csv file.
  • Lesson 3: Aggregate funcstion and subqueries.
    (updated on 05/12/05)

    •      - Lesson 3b: Mathematical functions.
  • Lesson 4: Date formatting.
  • Lesson 5A (Spring 2005):
           Subqueries and their usages.

    •     Lesson 5:
           (a) UNION, sub-queries.
           (b) UNION, sub-queries.
           Link to download BookOrderDetails.txt file. (tab delimited)
  • Lesson 6: string manipulation, subqueries.
  • Lesson 7: JOIN, LEFT JOIN, RIGHT JOIN.
  • Blob objects storage.
  • Lesson 8: CASE and IF statements in MySQL.
  • Lesson 9: Normalization- a case study.
    •        EXTRA: Stored procedures and functions.
           Lesson Extra: Processing Mysql queries from Unix prompt..
           Backing up your database.
  • MS Access database (Lyric2K.mdb).


    • Lessons (old) and Reading Assignments:
    Lessons Reading Assigmnets
  • Lesson 3,
  • Lesson 4,
  • Lesson 4B,
  • Lesson 5,
  • Lesson 5B,
  • Orders2Modified.xls.
    		•