IT240 databases 1
Overview
This course aims to give students an introduction to the basic concepts of data modeling and database design principles. This course focuses on concepts and methods of building relational models and OO relational models. It also focuses on understanding database models and matching the data with these models. The course covers also the basic rules for the Structured Query Language.
Topics
click here to view topics covered
-
Introduction to database systems
-
Data models: relational and object oriented
-
Concepts and methods of databases analysis and design
-
ER modelling
-
relational algebra & calculations
-
Database design
-
Indexing and performance tuning
-
SQL
I taught this course for several semesters from 2009 through 2016 at University of Business and Technology