PostgreSQL Query for Moodle Course Data
Budget: £20 – £250 GBP
I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any.
Key requirements include:
- Extracting user's name and completed activities.
- Differentiating SCORM packages and calculating time spent on them.
- Handling users with no completed activities by including them in the results with zero activity count.
If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this task should understand how to navigate Moodle's database structure for effective data extraction.
Key requirements include:
- Extracting user's name and completed activities.
- Differentiating SCORM packages and calculating time spent on them.
- Handling users with no completed activities by including them in the results with zero activity count.
If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this task should understand how to navigate Moodle's database structure for effective data extraction.