Geo-ICT Training Center, The Netherlands
200 courses, 20 online supports,
60 moocs, 30 trainees
Course: SQL Basic
- Planning en Aanmelden
The SQL Basic course lasts 2 days and costs € 895. SQL is the language for querying databases. If you work in (Geo) ICT you will certainly have to deal with it. In almost all relational databases such as Oracle and PostGreSQL, SQL can be used to consult and edit the data. If you have mastered the basics of this language, you can easily set up databases, define tables, build queries and perform data manipulations. Multiple dialects of SQL. They all look alike. There is one ANSI-based standard SQL. This standard SQL is used in this course. The Oracle Spatial and PostGIS follow-up courses are particularly interesting for people interested in geographic data.
You will practice with various commands such as: create, select, inner and outer joins, update, delete. You will also be introduced to defining views and using operators and variables. You will be given the practice database home so that you can further improve your skills in SQL with self-study.
Learning objectives of this course
- After this course you are familiar with the language SQL
- You can independently write SQL queries that work the same for many different databases