-
Learning by doing
-
Trainers with practical experience
-
Classroom training
-
Detailed course material
-
Clear content description
-
Tailormade content possible
-
Training that proceeds
-
Small groups
Data is stored in databases, managed using Database Management Systems and often queried with SQL. SpiralTrain provides classroom training in the administration of Database Management Systems such as PostGreSQL, MySQL, MariaDB, Oracle and the NoSQL database MongoDB. SpiralTrain also provides training in SQL. Visit our LinkedIn, Facebook or Instagram page for an impression of SpiralTrain. Click on the links below for more information and the schedule.
A database is the name for the system in which data is collected, organized and linked. We need to distinguish a database and a Data Base Management System (DBMS). The database is the set of data, arranged according to a specific model and stored on a server. A Data Base Management System (DBMS) is the software that organizes the data on the server. Extensive analyzes are possible via the database model. Most databases are able to provide specialized reports of the data.
DBMS’s usually use the programming language SQL (Structured Query Language) to grant access to and edit the database. SQL (Structured Query Language) is a language used to store, edit and retrieve data stored in relational databases. The first form of SQL appeared in 1974, when a group at IBM developed the first prototype of a relational database. The first commercial relational database was released by Relational Software, later Oracle.
There is a standard for SQL. However, the SQL for each major RDBMS differs in the details. There are two reasons for this: 1) the SQL standard is quite complex and it is not practical to apply the full standard and 2) every database vendor wants to distinguish its product.