Manage spatial data with Microsoft SQL Server

Training

Online

up to £ 100

Description

  • Type

    Training

  • Methodology

    Online

  • Class hours

    4h

  • Start date

    Different dates available

"Are you a database user who wants to learn about spatial data analytics?  Are you a GIS professional stuck in a rut of only knowing how to use a GIS GUI? Do you want to learn how to automate tasks, but are afraid of computer programming. If so, SQL is the most powerful tool you can learn to help you perform complex GIS tasks. This course is designed to teach you how to write SQL to replicate many database and GIS tasks using Microsoft's SQL Server. We will start at a very basic overview, and then proceed to more advanced topics related to GIS.Through a series of lectures, I will work side-by-side with you to develop SQL queries in SQL Server that perform advanced GIS tasks, some of which might be impossible to perform in the GUI. Once my students learn GIS, they very rarely want to return back to using the GUI.By writing SQL code alongside me, you will see how solving GIS tasks in SQL is like a second nature. This is a very comprehensive course that should take multiple days to complete - but don't worry about that - you will be having a lot of fun learning how powerful SQL can be, and continually ask yourself ""why didn't I start using SQL sooner!"""

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Students who complete this task will be comfortable writing traditional SQL and spatial SQL within SQL Server. They will understand how to address different data types, functions, and SQL workflows for traditional and spatial data operations.

This course is targeted toward database professionals who want to learn how to leverage spatial data constructs within SQL Server to solve spatial problems. While there are many databases that support spatial constructs, this course will focus on the use of SQL Server to accomplish these tasks.

While it is not an absolute necessity, students taking this course should be familiar with spatial data concepts and have some familiarity with database technology.

"-100% online -Access to the course for life -30 days warranty money back -Available from desktop or mobile app -Can begin and finish the course any time -Can repeat the course any times"

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2020

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 3 years

Subjects

  • Database training
  • spatial
  • SQL
  • Database
  • Server
  • GIS
  • GIS Data
  • GIS Analyst
  • GIS Training
  • GIS Technology
  • Programming
  • SQL Database
  • SQL Tools
  • SQL Server Express
  • Programming skills
  • Programming Language
  • Coding Technologies
  • Programming platform
  • Spatial Data
  • Spatial Design

Course programme

"Starting the Course, Loading Software and Data
Install SQL Server and SQL Server Management Studio
Install Data
Course Overview
Overview of SQL
Is Spatial Special?
Why SQL is Superior
SQL Data Types
Numeric Data Types
Boolean operations
Character Operations
Date and Time Functions
Spatial Functions
Traditional SQL Statements
Select Statement
Group By Statement
Case Statement
SQL Potpourri
Editing data in SQL Server
Spatial Functions for Vector Data
Spatial Type Functions
Spatial Functions (mop up)
Geographic Models
Nearest Neighbor Index
Huff Model for Retail Gravitation
variogram of last spring frost data
Bonus: Real World Example
flooding and emergency response
Course completion, and where to go next"

Manage spatial data with Microsoft SQL Server

up to £ 100