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