What's Included in Bootcamp 🖥️
7
25
10
10+
Course Modules
1.1Introduction to Database
What is Database, how to use it in developing complex applications
1.2Types of databases
Different types of databases and their use cases
1.3SQL and NoSQL databases
Selected querying language for typical use cases
1.4Use cases and applications of database
How companies ranging from giant to startups utilises databases to store information
1.5Introduction to DBMS
How to interact with databases
2.1Introduction to RDBMS
What is Relational databases and how to manage it
2.2Keys in RDBMS
Different types of keys that can be assigned to fields
2.3Constraints in RDBMS
Different types of Conditions that can be applied to fields to make connections and their use case
2.4RDBMS hierarchy
How to use roles, users, Tablespaces, etc.
2.5RDBMS components
How to use tables, schema, etc.
3.1Overview of PostgreSQL
Introduction to world's most advance open source database
3.2PostgreSQL Capabilites
Different features of PostgreSQL
3.3Using Commandline to access database
Operating database using commandline
3.3Using Web UI (pgAdmin) to access database
Operating database using web UI such as pgAdmin
3.4Understanding SQL
Introduction to Structured Query Language
3.5SQL Queries
Different verbs used in Querying data
3.6CRUD in SQL
Operations on data to Create, Retrieve, Update, Delete
4.1Views
Introduction and application of views
4.2Indexes
Introduction and application of Indexes to increate querying speed
4.3Functions
Creating functions inside RDBMS
4.4PostgreSQL Security
Securing Data in PostgreSQL
4.5Optimizing performance
Making PostgreSQL Production ready
📚CRUD Operations using PostgreSQL
Creating basic application to work in postgreSQL and perform CRUD
5.1Introduction to PostGIS
Introduction and installation of PostGIS
5.2Spatial functions in PostGIS
Different types of functions and methods available in PostGIS to perform spatial queries and their use case
5.3Spatial Indexing data in PostGIS
How and why to spatially index data
6.1Creating Frontend - Javascript + Openlayers
Creating Front end web application to interact with map
6.2Creating Backend - PHP + PostgreSQL
Create Backend logic to connect database with web application
6.3Making connections with Database
Performing SQL queries fron front end to database using back end
7.1Working with MySQL
Introduction to MySQL
7.2Working with firebase
Introduction to firebase
