Abbottabad University of Science & Technology · Free online courses for AUST students
Verify a certificate aust.edu.pk
Abbottabad University of Science & Technology CourseHub
Log in

Database Systems: Design and SQL

Uncategorized
Wishlist Share

About Course

This course is the online companion to CS-302 Database Systems (3+1 credit hours). You will model a problem domain with entity-relationship diagrams, turn it into a normalised relational schema, query and update it with SQL, and see how transactions keep data correct when many users work at once.

Each topic has video lectures, downloadable notes and a short quiz. Pass the final assessment to complete the course and earn your certificate.

What Will You Learn?

  • Model a problem domain with entity-relationship diagrams
  • Turn a model into tables with primary and foreign keys
  • Normalise a schema to third normal form
  • Write SQL to create, query, join and update tables
  • Explain transactions, ACID and concurrency control

Course Content

Relational Modelling and Normalisation
Modelling data with entity-relationship diagrams, turning them into tables, and removing redundancy with normalisation.

  • Entity Relationship Diagrams
    00:00
  • Normalisation: 1NF to 3NF
    00:00
  • Modelling and Normalisation Quiz

SQL and Transactions
Creating, querying, joining and updating tables with SQL, and keeping data correct with transactions.

Final Assessment
Covers every topic. Score at least 60% to complete the course and earn your certificate.