Last Semester

Textbook: Head First SQL (Lynn Beighley)

Content:

  • Introduction (today) + basic SQL statements
  • SELECT, DELETE, UPDATE, NULL values
  • Be normal
  • ALTER, advanced UPDATE and SELECT
  • Multiple tables, creating table from data, Cartesion joins
  • Joins and subqueries
  • More joins and set operators
  • ER modeling
  • Constraints, views, transactions, and security
  • Database applications (1)
  • Database applications (2), review, and information about the exam

Arrangement (except the first):

  • Exercises for the first half
  • Lectures for the second half
  • Exercises/lectures the same venue!

Learning Goal:

  • Professional terminology of the subject of database
    • Proper understanding and use of relevant terms
  • Grasp of SQL statements
    • Use the right constructs and correct formulation (syntax) to solve practical problems.
    • CRUD: Create/Read/Update/Delete data.
  • Be able to know/do good database design
    • What, how and why?
  • Database applications
    • Application development and tuning
  • Database administration (a little)
    • How to share your data conveniently and safely?

Exam:

  • Open book, written exam
  • Question types
    • Multiple choices
    • Matching
    • SQL writing
    • ERD designing and table creating