Computing and Information System
COURSE LEVEL | DURATION | COURSE TYPE |
BEGINNER LEVEL | FOUR(4) MONTHS | THEORY & LAB |
|
|
LEARNING OUTCOMES FROM THIS COURSE |
| Learn to understand the concept and the use of database |
| Understand the term Database Management System |
| Learn to understand the concept of Entity Relationship Diagram |
| Learn the use of linked tables & keys in a relational data model |
| Learn the basic commands of SQL for CRUD (create, read, update, delete)functions |
| Learn
to design simple queries in a database |
| DMS-Lecture 1 | | |
| History of Databases | |
| What is a Database? |
| DMS-Lecture 2 | | |
| What is SQL? | |
| What is Database Management System? |
| DMS-Lecture 3 | | |
| What is an ER diagram? How to make an ERD? What are ERD symbols? | |
| Entity-Relationship Diagrams |
| DMS-Lecture 4 | | |
| Linked tables and keys | |
| Datatypes in SQL | |
| How to Install XAMPP Server on Windows 10 | |
| How to install Navicat GUI on Windows? | |
| Setup Navicat using MySQL XAMPP | |
| Create, Use and Drop Databases | |
| Inserting Data Into Tables | |
| The SELECT Query |
Senior Lecturer & Exam Coordinator
Department of Computing & Information System(CIS)
Faculty of Science and Information Technology(FSIT)
Daffodil International University
www.linkedin.com/in/nayeemarahman