DATABASE SYSTEMS (4/2 Credits)

Learning Outcomes:

On Successful completion of this course, students will be able to: Describe database systems, terminology, environment, and new concept of database; Apply database language and SQL Programming language; Design database using structure data model; Apply No SQL database.

Topics:

1. SQL versus No SQL Databases
2. Database Environment & Architecture
3. The Relational Model & Database Security
4. SQL – Data Definition and Data Manipulation (1)
5. Databases for Mobile Apps
6. SQL – Data Definition and Data Manipulation (2)
7. Entity Relationship (ER) Modeling
8. Normalization
9. Introduction to SQLite, Design and Concepts
10. Android Development with SQLite
11. Introduction to MongoDB and Concepts
12. CRUD operations in MongoDB
13. MongoDB For Mobile Apps
14. Database Environment & The Relational Model
15. SQL – Data Definition Language (1)
16. SQL – Data Manipulation Language (1)
17. SQL – Data Manipulation Language (2)
18. SQL – Data Manipulation Language (3)
19. Normalization & Entity Relationship (ER) Modeling
20. Introduction to SQLite, Design, Concepts
21. Android Development with SQLite
22. Introduction to MongoDB and Concepts
23. CRUD operations in MongoDB
24. Transaction Management
25. SQL – Data Definition Language (2)