Udemy - Introduction to Spatial Databases with PostGIS and QGIS 3

[dkmdkm]

Free Download Udemy - Introduction to Spatial Databases with PostGIS and QGIS 3
Last updated: 5/2020
Created by: Michael Miller
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English + subtitle | Duration: 69 Lectures ( 12h 39m ) | Size: 1.92 GB

Learn Spatial SQL and database management for GIS Professionals
What you'll learn
Understand the advantages of storing spatial information in spatially enabled databases
Install PostGIS locally for development purposes and/or access an instance of PostGIS that is running on their organizations intranet, a web host, or the cloud
Write SQL queries to retrieve and analyze spatial data.
Use the tools available in PostGIS to validate data and control user access
Perform basic database administration functions to keep your spatial database running smoothly
Requirements
You should be familiar with GIS concepts and be willing to learn QGIS. My course QGIS 3.0 for GIS professionals will provide all the background that is necessary but it is not a formal pre-requisite.
Description
This course is intended to provide an introduction to spatial databases in general and PostGIS in particular to GIS professionals who are interested in expanding their skillset to multi-user enterprise level spatial databases. This course uses the latest (as of 2/18) versions of PostgreSQL (10.1), PostGIS (2.4), and QGIS (3.0). I believe it is the most current and thorough course on spatial databases available today. You will learn
What a spatial database is and why you would want to use one.What SQL is, why you would want to use it, and how it can be applied to geospatial concepts.How to install PostGIS locally for development purposes and how to access a production version via a network or the internet.How to load your spatial data into PostGIS and access it from a variety of clients, especially QGISThe basics of SQL for both spatial and non-spatial queriesHow to validate data and control user access with the tools built-in to PostGISOptimizing your queries for the best performanceHow to work with raster data in PostGISThe basics of programming custom functions with PL/pgSQLThe basics of database administration to keep your database operating smoothly
Who this course is for
GIS professionals who are interested in expanding their GIS skillsets into multi-user enterprise level spatial databases.
Homepage:

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

No Password - Links are Interchangeable

 

[0dayddl]

1.93 GB | 17min 55s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English​

Files Included :

Spoiler

1 -Introduction.mp4 (6.62 MB)
2 -What can a spatial database do for you.mp4 (10.1 MB)
3 -What is a spatial database exactly.mp4 (14.56 MB)
4 -Where does a spatial database live.mp4 (7.74 MB)
5 -What is SQL and why would you want to use it.mp4 (13.17 MB)
1 -Introduction.mp4 (46.18 MB)
2 -Registering for a web hosting service.mp4 (120.59 MB)
3 -Moving the database to a remote server.mp4 (105.81 MB)
4 -Deploying to the AcuGIS Cloud.mp4 (194.4 MB)
5 -Performance considerations.mp4 (122.35 MB)
6 -Strategies for mitigating slow response times.mp4 (114.27 MB)
1 -Backing up and exporting data.mp4 (29.96 MB)
2 -Where to go next.mp4 (3.66 MB)
1 -Bonus Lecture How to get the most from my series of Udemy courses.mp4 (69.51 MB)
1 -Installing PostGIS on your local computer.mp4 (43.57 MB)
2 -Installing QGIS.mp4 (9.41 MB)
3 -Loading spatial data into PostGIS.mp4 (46.66 MB)
4 -Loading non-spatial data into PostGIS.mp4 (19 MB)
5 -Accessing PostGIS from the commandline, the pgAdmin GUI, QGIS, and ArcGIS.mp4 (46.72 MB)
6 -Organization of a database.mp4 (11.64 MB)
1 -The SQL SELECT statement.mp4 (19.07 MB)
10 -SQL Expressions and Functions Part 2.mp4 (39.3 MB)
11 -The CASE Statement.mp4 (8.31 MB)
12 -SQL Views.mp4 (13.44 MB)
2 -The WHERE clause.mp4 (10.98 MB)
3 -Aggregate functions and the GROUP BY clause.mp4 (10.77 MB)
4 -Multi-table Queries Part 1.mp4 (19.73 MB)
5 -Multi-table Queries Part 2.mp4 (34.11 MB)
6 -Data Types in PostgreSQL Part 1.mp4 (36.28 MB)
7 -Data Types in PostreSQL Part 2.mp4 (32.84 MB)
8 -The FROM clause implies a loop.mp4 (9.88 MB)
9 -SQL Expressions and Functions Part 1.mp4 (29.31 MB)
1 -The PostGIS Vector Geometry model.mp4 (8.56 MB)
2 -The Spatial Reference ID.mp4 (25.19 MB)
3 -The Geometry Field.mp4 (10.32 MB)
4 -Geometry vs Geography data type.mp4 (23.54 MB)
5 -Spatial Queries - Working with Geometries.mp4 (37.59 MB)
6 -Spatial Queries - Measurements.mp4 (15.76 MB)
7 -Spatial Queries - Accessing the geometry.mp4 (32.08 MB)
8 -Spatial Queries - Testing spatial relationships.mp4 (25.22 MB)
1 -Multi-table Spatial Queries.mp4 (14.24 MB)
2 -Optimizing your queries.mp4 (24.69 MB)
3 -Spatial aggregate functions.mp4 (11.87 MB)
4 -Geometry processing functions Part 1.mp4 (24.31 MB)
5 -Geometry processing functions Part 2.mp4 (11.28 MB)
6 -Challenge Scenarios Part 1.mp4 (32.06 MB)
7 -Challenge Scenarios Part 2.mp4 (27.77 MB)
1 -Creating tables.mp4 (23.51 MB)
2 -Primary and Foreign Keys.mp4 (40.6 MB)
3 -Creating indexes.mp4 (14.58 MB)
4 -Creating custom data types.mp4 (9.38 MB)
5 -Modifying data structures with the ALTER statement.mp4 (7.39 MB)
6 -GUI methods for defining data structures.mp4 (9.29 MB)
1 -Adding new records with the INSERT statement.mp4 (12.33 MB)
2 -Adding geometry to a feature with the INSERT statement.mp4 (18.06 MB)
3 -Modifying data with the UPDATE statement.mp4 (15.82 MB)
4 -Deleting records.mp4 (10.69 MB)
5 -Challenge exercise Putting it all together.mp4 (29.84 MB)
1 -Creating Roles with SQL.mp4 (7.38 MB)
2 -Granting privileges with SQL.mp4 (12.3 MB)
3 -Example - roles and privileges in pgAdmin4 GUI.mp4 (19.23 MB)
4 -Example - roles , privileges, and multi-user editing in QGIS.mp4 (9.45 MB)
1 -Transactions.mp4 (8.27 MB)
2 -User defined functions - SQL.mp4 (32.36 MB)
3 -User defined functions - PLpgSQL - Introduction.mp4 (11.05 MB)
4 -User defined functions PLpgSQL - Branching and looping.mp4 (15.21 MB)
5 -User defined Functions - PLpgSQL - Error handling.mp4 (19.75 MB)
6 -Triggers.mp4 (12.09 MB)
7 -Pulling it all together - examples.mp4 (9.28 MB)

]
Screenshot

Spoiler

TurboBit

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

RapidGator

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!

Bitte Anmelden oder Registrieren um Code Inhalt zu sehen!