- HUNGARY: 9-13/3/26
- DUBAI: 13-17/4/26
- TÜRKIYE: 1-5/6/26
- AZERBAIJAN: 6-10/7/26
- PORTUGAL: 28/9-2/10/26
Course Brief
SQL databases are used widely in the mining industry. They are commonly managed by Geoscience Database Managers. Geoscientists and Engineers need geoscience data for their day-to-day work and have to request data from the geological database managers.
With the right IT systems configurations such as read-only permissions, Geoscientists and Engineers equipped with SQL skills would be able to access data required for their work either through their domain software or using SQL server management studio.
This course has been developed for Geoscientists and Engineers, who are looking for a quick way to find the data they need. The course is based on an industry-standard Geological database, the content is focussed and simplified to deliver the required data with only one or two commands.
The course is divided into five sections:
SECTION 1: Installation and Select Statement
SECTION 2: Operators
SECTION 3: Sorting, Grouping and Functions
SECTION 4: Sub Queries and joining rows and columns from multiple tables
SECTION 5: Creating a table, inserting records, and updating the records
Requirements:
A laptop is required for the workshop with administrative permission to add software.
The minimum specifications for laptops are:
- Windows™ operating system and an external mouse to navigate the software.
- Wi-Fi module for connection to the internet.
- An Intel-compatible platform running Windows 11, 10 /8.1/8 /7 /Vista /XP /2000
- At least 256 MB of RAM, a mouse, and enough disk space.
- Administrative privileges are required to install and run R‑Studio utilities.
Training data will be provided for the course. Please note that the free versions of the software Microsoft SQL Server and Microsoft SQL Server Management Studio will be used.