CSE309 Databases
Instructor
:
Assoc. Prof. Dr. Yuriy Mishchenko (Toros University)
Email
:
yuriy.mishchenko@toros.edu.tr
Objective
Introduction to the theory of relational databases, relational algebra, normalization, indexes, CRUD (Create/Read/Update/Delete) databases, SQL query language theory and applications
Program
Introduction to the subject of databases
Relational design, relational algebra, knowledge querying
Relational algebra exercises
Database anomalies and normalization theory
Database design using normalization, Uniform Modeling Language (UML)
SQL structured query language, elements of SQL DDL (data definition language)
SQL DML (data manipulation language), INSERT, UPDATE, DELETE and basic SELECT
MIDTERM
Advances SELECT, GROUP BY, ORDER BY, LIMIT, nested queries
SQL JOINs, VIEWs, and transactions control
Practical questions of SQL queries design
SQL constraints, primary and foreign keys
Database indexes
Indexes design and indexed queries design
Evaluation
Evaluation is performed according to the corresponding Faculty guidelines.
Click
here
to go to homepage.