Application Designer and Developer – RNCP37873 BC02
€463.32
Tax included
This e-learning training prepares for block RNCP37873BC02 of the Application Designer and Developer certification. It enables learners to acquire essential skills in information systems design and dynamic web development using MERISE methodology, PHP programming, and SQL/MySQL databases. Through practical modules and case studies, you will learn how to analyze software requirements, model a database, and develop interactive web applications connected to a database.
👉 Audience: beginner developers, career changers, IT enthusiasts
👉 Duration : 46 hours
👉 Objective: design and develop a dynamic web application
👉 Intended for: individuals aiming for a career in application development
Description
💻 Application Designer and Developer – Block RNCP37873BC02
The e-learning training Application Designer and Developer – BC02 enables learners to acquire the skills needed to analyze, design, and develop software applications based on databases and dynamic web technologies.
The program is structured around three main areas: information system design with MERISE, PHP/MySQL programming, and mastery of the SQL language (general presentation page 1).
🧠 Analysis and Design of Information Systems (MERISE)
This module introduces analysis methods used to structure a software project before development (pages 2 and 3).
| Skill | Learning Outcomes |
|---|---|
| Requirement Analysis | Collecting requirements and defining the project |
| Modeling | CDM, LDM, and PDM |
| Diagrams | Use cases and process analysis |
| Prototyping | Designing and structuring an application |
⚙️ Dynamic Web Development with PHP & MySQL
The PHP/MySQL module forms the technical core of the training (pages 4 and 5).
- PHP syntax and fundamentals
- Variables, conditions, and loops
- Functions and object-oriented programming
- Handling HTML forms
- Connecting and interacting with MySQL
- File and session management
- Error handling and security
🗄️ Mastering SQL and Databases
The SQL module enables learners to design and efficiently manage relational databases (pages 6 and 7).
| SQL Concepts | Applications |
|---|---|
| Data Definition | CREATE, ALTER, and constraints |
| Data Manipulation | INSERT, UPDATE, DELETE |
| Queries | SELECT, WHERE, JOIN, GROUP BY |
| Analysis | Aggregate functions and subqueries |
🛠️ Practical Exercises and Application Projects
Hands-on exercises allow learners to apply the skills acquired:
- Creating business-oriented databases
- Developing dynamic web applications
- User management and form handling
- Working with real data sets
🎯 Learning Objectives
- Analyze and design an information system
- Model a database
- Develop PHP applications connected to MySQL
- Write and optimize SQL queries
- Create a complete dynamic web application
⚙️ Training Details
| Format | Interactive e-learning (HTML5 – SCORM standard) |
|---|---|
| Duration | 46 hours |
| Technologies | MERISE, PHP, MySQL, SQL |
| Compatibility | PC, Mac, tablet and smartphone |
❓ Frequently Asked Questions
Yes, it prepares for the RNCP37873BC02 block of the Application Designer and Developer professional certification.
You benefit from 12 months of access to complete the training at your own pace.
Yes, the training is accessible on computer, tablet, and smartphone.
You can choose between two payment options to access the training :
- One-time payment: you pay the full amount at purchase and receive immediate access for 12 months.
- 12 monthly payments: you pay in 12 monthly installments. After the 12 months, your subscription switches to automatic monthly renewal, which you can cancel at any time if you do not wish to extend access.
In both cases, you get immediate access to the entire training.
The Premium version offers personalized guidance to help you progress faster and answer all your questions. This option includes :
- A chat with a tutor available during business hours for technical and educational questions.
- Email support outside working hours and days.
- Personalized assistance if you encounter difficulties understanding a concept or completing a module.
The Premium version is ideal if you want to learn with human support, be guided step by step, and receive fast and reliable answers.
Product Details
FL-CDA2-OMT
Specific References
Reviews
No customer reviews for the moment.