Azure Classroomnotes 02/May/2023

Database

  • Database is used to store information/data generated or required by/for the application

Relational Databases

  • Relational Databases store the data in the form of tables (rows and column).
    Preview
  • They SQL (Structured Query Language) to perform data operations
  • Each table has strict structure called as schema
  • Vertical Scaling is used to solve performance issues
  • Horizontal Scaling requires replications
    Preview
  • Generally if your application has more read operations than write, create read replicas
    Preview
  • Structured data refers to data that can be queried
  • Typical Activities in running databases on-premises
    • Network setup
    • Installing Operating Systems
    • Installing Database Engine
    • Configuring Databases
    • Admin Activities
      • User Management
      • Backup
      • Replications
      • Updating OS/Databases (Patching)

NoSQL Database

  • There was a need for a database to store semi-structured data, handles high volumes of data, horizontal scaling is inbuilt.
  • NOSQL (Not Only SQL)
  • NOSQL has 4 popular types
    Preview
  • NOSQL does not impose strict schema
  • Generally NoSQL Databases have built in support for horizontal scaling.
  • Typical Activities in running databases on-premises
    • Network setup
    • Installing Operating Systems
    • Installing Database Engine
    • Configuring Databases
    • Admin Activities
      • User Management
      • Backup
      • Replication configuration
      • Updating OS/Databases (Patching)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About continuous learner

devops & cloud enthusiastic learner