Introduction
The database is the backbone of any application. The success and failure of the application depend on various things and the database is also one of them. The performance of the application depends on the efficient and effective usages of databases likes –
- Database Connection Pool (Data Source)
- Database SQL to persist the records
- Database View to retrieve the records
- Database Stored Procedure to execute a sequence of commands to complete the work
Leaning and having a good understanding of the database SQL is very important to grow in your career. The data is gold nowadays. It will play a vital role in the future. New technologies & practices like Data Science, AI, Machine Learning, Smart Advertisement, etc. are utilizing data and producing a good result. Every developer must know the basic concept of the database and s/he must be able to write SQL, View, and Stored Procedures.
There are various types of database available nowadays. Please find them below
- Relational Database
- NoSQL Database
- Object Oriented Database
- Cloud Database
- Centralized Database
- Distributed Database
- Network Database
- Hierarchical Database
Some examples of the database are given below –
- Relational Database
- Oracle Database
- IBM DB2 Database
- MySQL Database
- Microsoft SQL Server
- Postgres
- Maria DB
- H2
- Java DB
- NoSQL Database
- MongoDB
- Cassandra
- ElasticSearch
- Amazon DynamoDB
- HBase
- Object Oriented Database
- IBM Db2
- Google Cloud Storage for Firebase
- InterSystems Caché
- InterSystems IRIS
- Visual FoxPro
- Actian NoSQL
- Cloud Database
- Amazon RDS
- Amazon SimpleDB
- Amazon DynamoDB
- Oracle cloud database
- Google Cloud SQL
- Google Cloud Bigtable
- IBM Db2 on Cloud
- MongoDB Atlas
- OpenStack
- DataStax Astra
- SAP HANA Cloud
- Centralized Database
- Mainframe computer
- Distributed Database
- Apache Ignite
- Apache Cassandra
- Apache HBase
- Couchbase Server
- Amazon SimpleDB
- Clusterpoint
- FoundationDB
- Network Database
- Integrated Data Store (IDS)
- IDMS (Integrated Database Management System)
- Raima Database Manager
- TurboIMAGE
- Univac DMS-1100
- Hierarchical Database
- The IBM Information Management System (IMS)
- RDM Mobile