Geological Database Management

• PAPUA NEW GUINEA (PORT MORESBY): 23-27/6/25

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

1. Install Microsoft SQL server 2019
2. Import Sample Database
3. Different ways to select records from table -SELECT statement
4. Filter the records of a table – WHERE clause

SECTION 2: Operators

5. Arithmetic Operators
6. +Operator and Concatenation
7. NULL value
8. AND & OR operators
9. Select records between 2 ranges and from a list (BETWEEN & IN)
10. Match patterns (Using Wildcard filtering)

SECTION 3: Sorting, Grouping and Functions

11. Sorting the Result
12. Group the Result and Numeric functions
13. String functions
14. Date functions
15. HAVING clause

SECTION 4: Sub Queries and joining rows and columns from multiple tables

16. Sub Queries
17. UNION & UNION ALL
18. INNER JOIN /JOIN
19. LEFT JOIN
20. RIGHT JOIN
21. FULL JOIN

SECTION 5: Creating a table, inserting records, and updating the records

22. Data type in Microsoft SQL server
23. Create a table
24. Insert Records into a table
25. Update an existing Record
26. ALTER Statement
27. Delete records from Table
28. Delete TABLE permanently
29. Backup a database

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.

Course Delivery:

This course is a hands-on coding course, led by the instructor. No experience in coding, scripting, or macro writing is necessary.

About Microsoft SQL Server:

Microsoft SQL Server is a relational database management system developed by Microsoft. Microsoft supplies free versions.

About Microsoft SQL Server Management Studio:

Microsoft SQL Server Management Studio (SSMS) is a free software application developed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server.