General Resources

Please report broken links to the instructor.

Relational Model

SQL (ranked from easy to hard)

  • W3Schools
  • Khan Academy
  • SQLZoo
  • HackerRank(requires login)

    • Discussion

    Online Editors

    Frequently Asked Questions

    1. What is a .sql file?

      Ans: You can save a .sql file from Oracle SQLDeveloper using File -> Save.

    2. What is an auto-generated schema?

      Ans: Online editors (mentioned above) and Entity-Relationship tools can auto-geenrate a schema. Use of such tools is forbidden in class.

    3. Can you show me a sample screenshot?

      Ans: A sample screenshot is available here.

    4. Why am I not getting full points on my quiz question?

      Ans: A quiz question is multi-choice, multi-select, which means more than one correct answer. You get full points if you choose all correct answers.

    5. I cannot connect to Oracle Server. I am getting 'Invalid username/password' error.

      Ans: Check instructions to connect to Oracle Server posted on D2L news.

    6. When are worksheets due?

      Ans: Worksheets are due within a week. You do not loose any points if you do not submit within a week, but not keeping up with the worksheets will derail you from this fast-paced class.

    7. D2L Submission folder has no due date. When is HW due?

      Ans: Submission folders do not have due date. Check your HW assignment for a due date or D2L posts for updates.

    8. When are quizzes due?

      Ans: Quizzes have no due date. It is strongly suggested that you do them within a week.

    9. How many attempts for a quiz?

      Ans: 3 attempts and grade is averaged across all attempts.

    10. I got all questions right on my first attempt. Must I take additional attempts?

      Ans: No