fbpx

Database Courses

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 LinkedInFacebook or Instagram  page for an impression of SpiralTrain. Click on the links below for more information and the schedule.

Databases Course List

NoSQL Data Access course
Course NoSQL Data Access
Code: DAT900
First start: 12-12-2024
2 days € 1499
Course Neo4J Data Access
Course Neo4J Data Access
Code: DAT801
First start: 28-11-2024
2 days € 1499
Course-SQL-Server-Administration
Course SQL Server Administration
Code: DAT505
First start: 14-10-2024
4 days € 2650
Course Queries with PostgreSQL
Course Queries with PostgreSQL
Code: DAT120
First start: 28-10-2024
3 days € 1999
Course Oracle SQL Fundamentals
Course Queries with Oracle SQL
Code: DAT130
First start: 20-11-2024
3 days € 1999
Course Oracle SQL Fundamentals
Course Queries with MySQL
Code: DAT140
First start: 13-11-2024
3 days € 1999
Course Queries with Microsoft SQL
Course Queries with Microsoft SQL Server
Code: DAT110
First start: 20-11-2024
3 days € 1999
Course GraphQL Queries
Course GraphQL Queries
Code: DAT850
First start: 21-11-2024
2 days € 1499
Course SQL Fundamentals
Course SQL Fundamentals
Code: DAT100
First start: 17-10-2024
2 days € 1299
Course MySQL Administration
Course MySQL Administration
Code: DAT300
First start: 12-11-2024
4 days € 2650
Course-PostgreSQL-Administration
Course PostgreSQL Administration
Code: DAT500
First start: 22-10-2024
4 days € 2650
Course-MongoDB-Data-Access
Course MongoDB Data Access
Code: DAT440
First start: 14-10-2024
2 days € 1499
Course APEX Fundamentals
Course APEX Fundamentals
Code: DAT700
First start: 13-11-2024
3 days € 1950
APEX Advanced Course
Course APEX Advanced
Code: DAT800
First start: 27-11-2024
3 days € 1950
Course Oracle PL-SQL Programming
Course Oracle PL-SQL Programming
Code: DAT150
First start: 16-12-2024
3 days € 1999
Course Database Design
Course Database Design
Code: DAT200
First start: 24-10-2024
2 days € 1499

DBMS versus Database

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.

SQL

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.

SQL Standard

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.