Query on Moodle database

I need to perform a query on a Moodle platform that pulls data from the database, having the columns:

- Student name

- Cohort (one per column)

- Course

- Course Teacher

- Final Grade

- Grade item (which idnumber = "primer-trimestre")

- Grade item (which itemname = "Inasistencia 1er")

- Grade item (which itemname = "Justificadas 1er")

- Grade item (which itemname = "Evasiones 1er")

- Grade item (which itemname = "Retardo 1er")

- Grade item (which itemname = "Prueba Trimestral 1er")

- Grade item (which itemname = "Cognitiva AR")

- Grade item (which itemname = "Actitudinal AR")

- Grade item (which itemname = "Procedimental AR")

These are the related tables on the database where the information of the previously described columns is stored:

- course

- grade_items

- cohort

- cohort_members

- user

- user_enrollment

The result must look like this sample dataset:

[login to view URL]

The following link contains some SQL codes that you may find useful as they already pull some of the required information from the database:

[login to view URL]

I will share a full DB dump for you to test first, once we start a conversation.

This project is quite urgent; so I'd prefer if you have already worked with Moodle and understand how its database works; it would save time. You may use any technology you want as long as you can retrieve the required data as shown above - PHP & MySQL, or only MySQL (a set of queries).

Thank you.

Taidot: Learning Management Systems (LMS), Moodle, MySQL, SQL

Näytä lisää: moodle plugins, how to fetch data from database in moodle, moodle configurable reports ad hoc reports, ad-hoc database queries, moodle course completion query, moodle account, moodle configurable reports sql examples, moodle sql queries, web query access database, query mysql database information, mysql modify sql dump file, moodle database template editing, bash script query mysql database, vbnet database project sql server, web template database entry sql server, visual basic 2008 query access database, import sql dump php, query online database asp, sql query remote database mysql, convert sql dump database

Tietoa työnantajasta:
( 26 arvostelua ) Bogotá, Colombia

Projektin tunnus: #19817040

Myönnetty käyttäjälle:


Buenos dias, como lo platicamos, pongo aca mi propuesta para el desarrollo de las consultas de moodle

$150 USD 1 päivässä
(70 Arvostelua)

21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, I am SQL expert skilled with MSSQL, MySQL and ORACLE. I have to say that I haven't work in Moodle environment but I can most certainly write the query you require. All database management systems are very simila Lisää

$105 USD 2 päivässä
(31 arvostelua)

Greetings! My name is Neha. We would love to have the opportunity to discuss your project with you. We can read through the job details extremely carefully and absolutely sure that we can do the project very well Lisää

$110 USD 4 päivässä
(139 arvostelua)

HI there, I am interested in the project. I can write the mysql query to get the required data into a csv file as per the requirement. Can start right away and do it within 2 hours. Thank You.

$95 USD 2 päivässä
(100 arvostelua)

Hi , I can start immediately as per your requirement. I am a highly motivated professional expert in programming and design. I will be more than happy to assist you in this journey. I do have few questions to start Lisää

$105 USD 10 päivässä
(47 arvostelua)

Hi there, I am a Sr. Developer with 10+ years of experience of development and also I have a team of expertise for Web And App development & design . It would be really great if we can get connected here to understan Lisää

$250 USD 7 päivässä
(40 arvostelua)

We already have built large scale applications, CRMs, ERPs and huge systems can be found at our website. Like [login to view URL] [login to view URL] [login to view URL] [login to view URL] https: Lisää

$105 USD 6 päivässä
(31 arvostelua)

Hi, I am interested in the task and have an experience in it. please ping me to discuss more. thanks

$80 USD 2 päivässä
(29 arvostelua)

Hi, I have 5+years Experience in Website/Software Design & Website Development. I'm an Expert in: -Frontend & Backend Development -Python -Data Science -Machine Learning -JVM technologies -Jquery, PHP -Ion Lisää

$105 USD 10 päivässä
(7 arvostelua)

hi, I'm a data engineer with over 5 years of experience and expertise in the field of databases, data analysis. I have lot of experience of SQL and worked on many databases such as oracle, mysql, db2, ms sql server, a Lisää

$88 USD 2 päivässä
(2 arvostelua)

Hello, there I am understanding Moodle and ready to get started now. I have done similar scheduling software. Please call me so that we can move on. Thanks.

$100 USD 3 päivässä
(3 arvostelua)

Hi. I built several awesome sites and you should check it on my portfolio and following links. [login to view URL] [login to view URL] [login to view URL] [login to view URL] Lisää

$80 USD 2 päivässä
(7 arvostelua)

Dear sir I am Moodle expert with an exposure to moodle data base, sql queries etc i will do the task and represent the data as attached format Please initiate further for better understanding

$100 USD 3 päivässä
(4 arvostelua)

Hi, How are you? I am very interest in your project. As I am a professional Expert with great experience and skills, I am sure that I can help you I'm ready to start to work on your project right now. If we clarif Lisää

$100 USD 10 päivässä
(5 arvostelua)

Hello. I looked carefully at your posts. sql database manage & programming is my best work. also i have a enough history in this part. If you have the opportunity to talk to me, I think I can create a less cost eff Lisää

$80 USD 3 päivässä
(7 arvostelua)

How are you? I really would like to work for you. I'm full stack professional developer who has 6 years. I have rich development experience and have developed many web apps. If you hire me Lisää

$100 USD 10 päivässä
(1 arvostelu)

Hello there! My name is Chris, I'm a UK based and native English speaking web developer and app expert with 10 years experience building and maintaining complex web apps and websites. I've built and maintained applic Lisää

$110 USD 7 päivässä
(1 arvostelu)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th Lisää

$99 USD 7 päivässä
(0 arvostelua)

Hello, I'm an Experienced Web Developer and guarantee you to serve with admirable, clean code and high standard quality work. Lets discuss job in details. Recent work Portfolio:- [login to view URL] http Lisää

$95 USD 7 päivässä
(0 arvostelua)

✅Hello, Nice to meet you. I'm a Moodle expert and have vast experience with this CMS; below are few of my Moodle Works: [login to view URL] [login to view URL] [login to view URL] ht Lisää

$108 USD 2 päivässä
(0 arvostelua)
$80 USD 10 päivässä
(0 arvostelua)