CIS322&L Advanced Database

Learn the Advanced Level: Design Databases in a More Effective Approach
Category:

Computing and Information System

Price:
free
Total Duration:
29:05
Language:
English
Review : 0
Enroll Course

Description



COURSE LEVEL
DURATION
COURSE TYPE
ADVANCED LEVEL
FOUR(4) MONTHS
THEORY & LAB

 




COURSE OBJECTIVE

This course builds to develop students’ advanced skills in the design and development of databases and database management systems, as well as investigating enterprise applications of databases.




LEARNING OUTCOMES FROM THIS COURSE



 Learn to understand the concept of EER Diagram
Learn to implement the concept of the normalization process
Learn to implement different constraints developing a database
Learn to use built-in functions as well as user-defined functions
Understand the concept of designing different complex reports
Solve real-life case scenario progressing to the course






Show more

External Link

AD Lecture-1 |
Phases in Data Modeling
Introduction to EER
Generalization & Specialization
Problem Scenario |
AD-Lecture 3 |
Basic concept of normalization
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
AD-Lecture 2 |
Learn SQL Constraints
AD-Lecture 4 |
Navicat for MySQL Database Creation (Part 1)
Navicat for MySQL Database Creation (Part 2)
Navicat for MySQL Database Creation (Part 3)
Mastering the SQL Language
Multiple Joins in SQL
Aggregate Functions
Group By Function
Union Statements

Nayeema Rahman

Email : nayeema.cis@diu.edu.bd

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