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 »
Development stored procedure in Sql to massively correct permissions task completion
permissions over task completion course Leer más »
WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database. Alongside, PhpMyAdmin allows you to manage easily your databases.
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 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
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
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 »
//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 »
Cannot load from mysql.proc. The table is probably corrupted SHOW ENGINES
Repairing a mysql table corrupted Leer más »
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
