Geospatial Database and RDBMS Overview Curriculum Instructor Module 1 : Concepts of Database Introduction to DatabaseWhat is Database, how to use it in developing complex applicationsTypes of databasesDifferent types of databases and their use casesSQL and NoSQL databasesSelected querying language for typical use casesUse cases and applications of databaseHow companies ranging from giant to startups utilises databases to store informationIntroduction to DBMSHow to interact with databases Module 2 : Concepts of RDBMS Introduction to RDBMSWhat is Relational databases and how to manage itKeys in RDBMSDifferent types of keys that can be assigned to fieldsConstraints in RDBMSDifferent types of Conditions that can be applied to fields to make connections and their use caseRDBMS hierarchyHow to use roles, users, Tablespaces, etc.RDBMS componentsHow to use tables, schema, etc. Module 3 : Understanding PostgreSQL Overview of PostgreSQLIntroduction to world’s most advance open source databasePostgreSQL CapabilitiesDifferent features of PostgreSQLUsing Commandline to access databaseOperating database using commandlineUsing Web UI (pgAdmin) to access databaseOperating database using web UI such as pgAdminUnderstanding SQLIntroduction to Structured Query LanguageSQL QueriesDifferent verbs used in Querying dataCRUD in SQLOperations on data to Create, Retrieve, Update, Delete Module 4 : Advance PostgreSQL ViewsIntroduction and application of viewsIndexesIntroduction and application of Indexes to increate querying speedFunctionsCreating functions inside RDBMSPostgreSQL SecuritySecuring Data in PostgreSQLOptimizing performanceMaking PostgreSQL Production ready Practice Day CRUD Operations using PostgreSQLCreating basic application to work in PostgreSQL and perform CRUD Module 5 : Understanding PostGIS Introduction to PostGISIntroduction and installation of PostGISSpatial functions in PostGISDifferent types of functions and methods available in PostGIS to perform spatial queries and their use caseSpatial Indexing data in PostGISHow and why to spatially index data Module 6 : Creating Web Application Creating Frontend – Javascript + OpenlayersCreating Front end web application to interact with mapCreating Backend – PHP + PostgreSQLCreate Backend logic to connect database with web applicationMaking connections with DatabasePerforming SQL queries from front end to database using back end Module 7 : PostgreSQL Alternatives Working with MySQLIntroduction to MySQLWorking with firebaseIntroduction to firebase admin Start Now Share this course