In this video, learn about Azure Table storage and how it relates to Cosmos DB. Discover the difference between NoSQL and SQL databases.
- [Instructor] Before you start writing any code or even set up the development environment, it's important to know what Azure Table Storage is all about. When you build an app, you build it so the users can easily interact with data, but to work with data, you need to store them in a local storage or a storage service somewhere on the cloud and for that, we use two different types of databases. We have the SQL databases and the NoSQL databases, but what are the key differences between these types? The SQL databases are also known as the relational databases because they have a clearly predefined schema. On the other hand, the NoSQL databases, as the name already indicates, are the nonrelational databases, and they have dynamic schemas. Since the SQL databases have predefined schemas, it means that they are vertically scalable, which means that you can add as many new tables and relations you want, but it's really hard to change the core schema. On the other hand, the NoSQL database are horizontally scalable, which means that you can keep adding new stuff without having to worry about the database schema. The SQL databases are table based databases. So this means the data is stored in tables and this is the only data model base in SQL. On NoSQL databases, we have four different types. And these are the document based databases, the key-value based databases, the graph based databases, and also the wide-column based databases. Having so many different types makes the NoSQL databases the best option to store unstructured or semi-structured data. Some examples of SQL databases include the MSSQL database and also the Oracle database. And NoSQL database examples are MongoDB, which is the most popular open source option, and also the CosmosDB. But how is the Azure Table Storage related to all this? Well, the Azure Table Storage is a key-value Azure database service that stores semi-structured NoSQL data.