Geospatial Database and RDBMS
Module 1 : Concepts of Database
- Introduction to Database
- What is Database, how to use it in developing complex applications
- Types of databases
- Different types of databases and their use cases
- SQL and NoSQL databases
- Selected querying language for typical use cases
- Use cases and applications of database
- How companies ranging from giant to startups utilises databases to store information
- Introduction to DBMS
- How to interact with databases
Module 2 : Concepts of RDBMS
- Introduction to RDBMS
- What is Relational databases and how to manage it
- Keys in RDBMS
- Different types of keys that can be assigned to fields
- Constraints in RDBMS
- Different types of Conditions that can be applied to fields to make connections and their use case
- RDBMS hierarchy
- How to use roles, users, Tablespaces, etc.
- RDBMS components
- How to use tables, schema, etc.
Module 3 : Understanding PostgreSQL
- Overview of PostgreSQL
- Introduction to world’s most advance open source database
- PostgreSQL Capabilities
- Different features of PostgreSQL
- Using Commandline to access database
- Operating database using commandline
- Using Web UI (pgAdmin) to access database
- Operating database using web UI such as pgAdmin
- Understanding SQL
- Introduction to Structured Query Language
- SQL Queries
- Different verbs used in Querying data
- CRUD in SQL
- Operations on data to Create, Retrieve, Update, Delete
Module 4 : Advance PostgreSQL
- Views
- Introduction and application of views
- Indexes
- Introduction and application of Indexes to increate querying speed
- Functions
- Creating functions inside RDBMS
- PostgreSQL Security
- Securing Data in PostgreSQL
- Optimizing performance
- Making PostgreSQL Production ready
Practice Day
- CRUD Operations using PostgreSQL
- Creating basic application to work in PostgreSQL and perform CRUD
Module 5 : Understanding PostGIS
- Introduction to PostGIS
- Introduction and installation of PostGIS
- Spatial functions in PostGIS
- Different types of functions and methods available in PostGIS to perform spatial queries and their use case
- Spatial Indexing data in PostGIS
- How and why to spatially index data
Module 6 : Creating Web Application
- Creating Frontend – Javascript + Openlayers
- Creating Front end web application to interact with map
- Creating Backend – PHP + PostgreSQL
- Create Backend logic to connect database with web application
- Making connections with Database
- Performing SQL queries from front end to database using back end
Module 7 : PostgreSQL Alternatives
- Working with MySQL
- Introduction to MySQL
- Working with firebase
- Introduction to firebase
Related Courses
