Mysql

Student Tracking progress in each Course

Customized Report configurable reports Tracking student progress every 15 days Customized sql adapted Conditional activities – a group of settings in a resource or activity which sets conditions upon entry into, or if an activity or resource can be even seen by the student Activity completion – A activity setting that sets the completion standard […]

Student Tracking progress in each Course Leer más »

Database normalization E R M

Responsible Database normalization E R M on Foco campus.es , campus.net , Moodle 2.8  -Spain -Based in Madrid ,Salamanca,Jaen Solid skills acquired through experience or education; the theoretical or practical understanding of a subject.Database schema https://docs.moodle.org/dev/Database_schema_introduction   **************************************************************************************** Database normalization, or simply normalisation, is the process of organizing the columns (attributes) and tables (relations) of

Database normalization E R M Leer más »

MySQL Workbench

MySQL Workbench MySQL open source software is provided under the GPL License. OEMs, ISVs and VARs can purchase commercial licenses. MySQL Workbench provides DBAs and developers an integrated tools environment for: Database Design & Modeling SQL Development Database Administration Database Migration

MySQL Workbench Leer más »

HeidiSQL

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers

HeidiSQL Leer más »

MySQL Stored Procedure

DELIMITER $$ CREATE PROCEDURE mysql_update_field() BEGIN DECLARE x INT; DECLARE number INT; DECLARE contador INT; SET x = 1; SET number=1; select count(*) into contador from mdl_user; REPEAT IF exists(select * from mdl_user where id=number) THEN UPDATE mdl_user SET idnumber=username; END IF; SET  x = x + 1; SET number =number+1; SET contador=contador+1; UNTIL x 

MySQL Stored Procedure Leer más »

Web services , API rest , Moodle

//METHODS THE CALL AND THE RESPONSE /// method 1 REST CALL header(‘Content-Type: text/plain’); $serverurl = $domainname . ‘/webservice/rest/server.php’. ‘?wstoken=’ . $token . ‘&wsfunction=’.$functionname; require_once(‘./curl.php’); $curl = new curl; //if rest format == ‘xml’, then we do not add the param for backward compatibility with Moodle < 2.2 $restformat = ($restformat == ‘json’)?’&moodlewsrestformat=’ . $restformat:»; $resp

Web services , API rest , Moodle Leer más »

mysqldump

mysqldump — A Database Backup Program The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server. The mysqldump command can also generate output

mysqldump Leer más »