DATABASE TECHNOLOGY (2/1 Credits)

Learning Outcomes :

On successful completion of this course, student will be able to: Define model data and information in the form of concept diagrams and physical diagrams and apply them to the database in a DBMS, both individually and in teamwork; Explain the concepts of relational algebra, DDL, DML, transaction management on database and concurrency control; Apply to make database applications to manipulate data in databases

Topics :

Introduction to database system ; 1. Introduction MySQL ; 2. MySQl – Create, Drop, Select Database, Data types ; Entity Relational Model ; The Relational Model ; 3. My SQL – Create, Drop, Insert Tables, Select Query, Where Clause ; 4. My SQL – Select Update, Delete Query, Like Clause ; Schema Refinement And Normal Forms ; Schema Refinement And Normal Forms (2) ; 5. MySQL – Sorting, Join Query ; 6. Null Values, Transactions, Alter Command, Indexes ; Physical Database Design And Tuning ; Relational Algebra and Calculus ; SQL : Queries, Programming and Triggers ; SQL : Queries, Programming and Triggers (2) ; SQL : Queries, Programming and Triggers (3) ; Database Application Development ; Overview of Transaction Management ; Concurency Control