Database Design and Implementation (SF).(Synchronous and Asynchronous E-Learning)
About This Course
At the end of this module, the learner is able to have the following:
-Knowledge-
Different kinds of data and their requirements
Elements of database schemas
Various fields and components of database models
Mechanisms and processes for data maintenance, storage and retrieval
Data warehousing processes
-Abilities-
Identify requirements of various structured and unstructured data
Draft database schemas within design constraints, to meet business / information needs
Incorporate parameters and fields for database models
Implement mechanisms for the maintenance, storage and retrieval of data from database models
Perform data warehousing, aggregating data from multiple specified sources
Translate project specifications, objects and data models into database structures
What You'll Learn
2 Database Design & Implementation in MySQL
3 CRUD in MySQL
4 Advanced SQL
5 Views, Stored Procedures & Triggers in MySQL
6 Advanced Database Concepts
7 Connecting MySQL DB to application
8 Security & Backup in MySQL
9 Database Testing & Documentation
10 Introduction to MongoDB
The learner will perform e-learning and assignments for the “Instructional Units” with online support from the Mentors. Subsequently, the learner will perform a modular project with the guidance of an industry expert who plays the role of "Project Mentor".