Geological Database Management

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

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

SECTION 3: Sorting, Grouping and Functions

  1. Sorting the Result
  2. Group the Result and Numeric functions
  3. String functions
  4. Date functions
  5. HAVING clause

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

  1. Sub Queries
  2. UNION & UNION ALL
  3. INNER JOIN /JOIN
  4. LEFT JOIN
  5. RIGHT JOIN
  6. FULL JOIN

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

  1. Data type in Microsoft SQL server
  2. Create a table
  3. Insert Records into a table
  4. Update an existing Record
  5. ALTER Statement
  6. Delete records from Table
  7. Delete TABLE permanently
  8. Backup a database

Requirements:

A laptop is required for the workshop with administrative permission to add software.

The minimum specifications for laptops are:

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.

Contact us at enquiries@dekadynamics.com for more information