: 
Last updated 7/2017
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 597.98 MB | Duration: 4h 1m
Spatial SQL: a language for geographers
What you'll learn
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.
Requirements
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.
Description
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!"
Overview
Section 1: Starting the Course, Loading Software and Data
Lecture 1 Install SQL Server and SQL Server Management Studio
Lecture 2 Install Data
Lecture 3 Course Overview
Section 2: Overview of SQL
Lecture 4 Is Spatial Special?
Lecture 5 Why SQL is Superior
Section 3: SQL Data Types
Lecture 6 Numeric Data Types
Lecture 7 Boolean operations
Lecture 8 Character Operations
Lecture 9 Date and Time Functions
Lecture 10 Spatial Functions
Section 4: Traditional SQL Statements
Lecture 11 Select Statement
Lecture 12 Group By Statement
Lecture 13 Case Statement
Lecture 14 SQL Potpourri
Lecture 15 Editing data in SQL Server
Section 5: Spatial Functions for Vector Data
Lecture 16 Spatial Type Functions
Lecture 17 Spatial Functions (mop up)
Section 6: Geographic Models
Lecture 18 Nearest Neighbor Index
Lecture 19 Huff Model for Retail Gravitation
Lecture 20 variogram of last spring frost data
Section 7: Bonus: Real World Example
Lecture 21 flooding and emergency response
Lecture 22 Course completion, and where to go next
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.
Homepage
https://www.udemy.com/course/sqlserver-spatial/Download From 1DL
https://1dl.net/fhvz1u4vgkn5/yqlwt.Manage.Spatial.Data.With.Microsoft.Sql.Server.rar
https://rapidgator.net/file/b0c72c4a1e46a54d077149306a123e1a/yqlwt.Manage.Spatial.Data.With.Microsoft.Sql.Server.rar.html
https://uploadgig.com/file/download/aA482d17fecc3c8a/yqlwt.Manage.Spatial.Data.With.Microsoft.Sql.Server.rar
https://nitroflare.com/view/8909F057D39D45F/yqlwt.Manage.Spatial.Data.With.Microsoft.Sql.Server.rar
Links are Interchangeable - No Password - Single Extraction