What is computer security? A set of techniques and policies that seek to minimize the vulnerability of systems or the information they contain. It is about making the cost of improperly accessing a…
Algorithms
Databases
Cybersecurity
DAM
Files and I/O
Read more →
XML stands for "Extensible Markup Language". It has several advantages over other ways of storing information: It is extensible: After being designed and put into production, it is possible to extend…
Databases
DAM
DAW
Java
XML
Read more →
Interface development 2015-09-22 Presentation + Hello in QT Presentation pr00.tar.gz --> Hello in QT 2015-09-23 Sending text with QtDebug pr01b.tar.gz --> Closes the QT window and explanation of the…
Databases
C++
DAM
Mathematics
PHP
Read more →
Markup language: Basic HTML concepts. Databases: Views (cat) User management (cat) Procedures and functions Variables and Handlers (cat) Cursors Control flow constructs Triggers Career Training and…
Databases
Networks
Read more →
This is another great blue/yellow backlight LCD display. As the pin resources of Arduino controller is limited, your project may be not able to use normal LCD shield after connected with a certain…
Arduino
Databases
Read more →
IF, LOOP, ITERATE, LEAVE, REPEAT/UNTIL and WHILE/DO. The IF statement: What is it? It is a statement; IF also exists as a function, and we should not confuse them. Syntax IF searchcondition THEN…
Databases
DAW
SQL
Read more →
What is a cursor? A cursor allows real-time access to the data of each row in a query. This mechanism is very useful when connecting MySQL with applications or performing complex queries. Declaration…
Databases
DAW
SQL
Read more →
CONCEPTES BÀSICS A trigger is an object associated with a table that is activated when an action occurs against that table. Usage example A trigger is set to fire when we insert a new grade outside…
Databases
DAW
SQL
Read more →
MySQL stores user information in the tables of the mysql database (DB). The CREATE USER command creates new MySQL users. To use it, you must have the global CREATE USER privilege or the INSERT…
Databases
DAW
SQL
Terminal
Read more →
Definition: A stored procedure is a set of SQL commands that can be stored on the server. A stored procedure is a program that is physically saved in a database. Its implementation varies from one…
Databases
DAW
SQL
Read more →
VARIABLES Variables are used to store information locally. They can be used to store constants or query results. They are deleted when MySQL is restarted. The definition is divided into three parts…
Databases
DAW
Read more →
With views, we will work with external schemas. To create a view, you need to use the CREATE VIEW statement STRUCTURECREATE VIEW viewname [(columnlist)] AS (query) [WITH CHECK OPTION]; Views do not…
Databases
DAW
SQL
Read more →