Geological Database Management

ZAMBIA (LUSAKA):
MALI (BAMAKO):
NAMIBIA (WINDHOEK):
GHANA (ACCRA);

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

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

SECTION 2: Operators

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

SECTION 3: Sorting, Grouping and Functions

Sorting the Result
Group the Result and Numeric functions
String functions
Date functions
HAVING clause

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

Sub Queries
UNION & UNION ALL
INNER JOIN /JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN

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

Data type in Microsoft SQL server
Create a table
Insert Records into a table
Update an existing Record
ALTER Statement
Delete records from Table
Delete TABLE permanently
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.