In this course, you will be studying the following subjects:
- Be able to design a database.
- Be able to setup a database using DBMS.
- Efficiently use SQL queries
- Be able to self-study other advanced techniques of specific DBMS.
Thank you for your interest in our Database Design and Implementation Course. We hope that you explore and acquire loads of knowledge during the course.
Why should I take this course?
The term "building a System" is usually referred to the use of a programming language/ technology to write code. However, that is not really adequate. Storing data to support Input/Output of specific algorithms, such as report exporting algorithms, is the last but not least. Your enormous calculation will become worthless if the result “evaporates” after execution.
To put it in a nutshell, if a program is considered as a data processor, database is the storage. Evidently, both of them are equally important.
What is in this course?
In application programming, an executable code is not good enough. A great code should have a good design, which has abundant consequent advantages. Database programming is not an exception; a well-designed database helps the system work smoothly. To achieve that, this course is designed to equip you from fundamental theory to advanced setup of a database.
Letʼs get ready and explore the course with our mentors!
1. Theoretical basis: Understand the concepts of database and DBMS. Know relational theory to figure out the principles to build a relational database.
2. Analysis and design: Be able to analyze user requirements, use technical model language to convert users' complicating requirements to technical model, which is familiar to system implementation engineer.
3. Database setup: Deploy initialization and data manipulation. Be able to write queries to search data. Focus on understanding database structure.
4. Database programming: Work with some specific objects of database. Focus on skills to work with database.
Grading policies and Evaluation:
(Marks are rounded to the nearest tenth)
1. Progress evaluation:
- Asking questions, 15% total points.
- Quiz, 20% total points.
- Assignment, 40% total points.
2. Final exam evaluation:
- Oral test, 25% total points. Compulsory prerequisites to take the final exam:
- Ask at least 8 questions, which are accepted by mentor(s).
- Complete all quizes with perfect scores (100%)
- Get more than zero points (>0) in every assignment. Passing conditions:
- The mark of the final exam isn't less than 4 out of 10 ( >= 4/10)
- Total score isn't less than 5 out of 10 ( > = 5/10)