Profile
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
1 Introduction to RDBMS & MySQL Database
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".