Databases and their types
- Relational Databases:
- Design: The data is stored logically in the format of tables which contains rows and colums
- Factors:
- Data is organized in tables
- Each table generally has a Primary key
- Table can have relation with other tables (foriegn key)
- Each table has very strict structure called as schema
- Software that manages databases is called as DBMS
- To insert, update, delete, retrieve (CRUD) data from databases there is a language called SQL (Structured Query Language)
- Vendors
- Oracle
- Microsoft SQL Server
- mySQL
- Postgres
- IBM DB2
- Each vendor might have slight differences in their sql queries
-
Administrative Activties:
- Replications
- Backups and restore
- Performance Tuning
-
How can Azure Help in this Area?
- Azure offers Database as a service
- Azure helps in minimizing knowledge levels required to perform complex activities such as
- replicas
- backups
- restorations
- Azure offers the following database engines as service
- SQL Server
- mysql
- Postgres
