Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Working with SQL Server Spatial Data

Spatial data represents the information about the physical location and shape of geometric objects. SQL Server can process Be introduced to spatial data types and how they align with international standards, and how they can be used in applications. SQL Server can process both planar and geodetic data, and this course will explain the difference between these two types of data, as well as explaining how SQL Server data types relate to relevant industry standards and measurement systems.

Description

Spatial data represents the information about the physical location and shape of geometric objects. SQL Server can process  This "Working with SQL Server Spatial Data" LearnSmart course will introduce spatial data types and how they align with international standards, and how they can be used in applications. SQL Server can process both planar and geodetic data, and this course will explain the difference between these two types of data, as well as explaining how SQL Server data types relate to relevant industry standards and measurement systems. This course will be paired with demos that give real world examples of the concepts that will be discussed, as well as knowledge checks to help test the students knowledge throughout the course.


Topics Covered Include:
-Spatial Data
-Working with SQL Server Spatial Data Types
-Using Spatial Data in Applications

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Working with SQL Server Spatial Data: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-464): Working with SQL Server Spatial Data"" Course."
  • Spatial Data
    Course Introduction
    0:47
    Types of Spatial Data
    3:22
    OGC Object Hierarchy
    1:01
    Spatial Reference Identifiers
    1:24
    SHOW ME Demonstration: Viewing Available Spatial Reference Systems
    1:50
    Knowledge Check
    0:38
  • Working with SQL Server Spatial Data Types
    SQL Server Spatial Data
    2:50
    User vs System SQL CLR Types
    1:57
    Geometry Data Types
    1:15
    SHOW ME Demonstration: Working with Geometry Data Types
    1:42
    Geography Data Types
    0:39
    SHOW ME Demonstration: Working with Geography Data Types
    1:22
    Spatial Data Formats
    1:39
    OGC Methods and Properties
    2:37
    Knowledge Check
    0:32
  • Using Spatial Data in Applications
    Spatial Data in Applications
    0:59
    Tessellation Process
    1:06
    SHOW ME Demonstration: Using Spatial Data to Solve Business Problems
    1:47
    Spatial Indexes
    1:22
    Implementation of Spatial Indexes
    3:05
    Knowledge Check
    0:37
    Conclusion
    0:42

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor