Tag: Databases

>> Database, Table, and Column Naming Conventions

>> Online Transaction Processing vs. Online Analytical Processing

>> Difference Between Lock and Latch in Database

>> Differences Between SQL and NoSQL

>> How Does Database Indexing Work?

>> Statements and Queries in SQL

>> Database Sharding vs. Partitioning

>> What Is an Entity Relationship Diagram?

>> An Introduction to Management Information System (MIS)

>> Data Storage: What Does CRUD Means?

>> What Is Blob Storage?

>> Indexing: Inverted Index

>> What Are Serialization and Deserialization in Programming?

>> What Is an ORM? How Does It Work? How Should We Use One?

>> Explanation of BASE Terminology

>> What Is a Data Lake?

>> Should We Deploy Database and Web Server Apart?

>> What Are Data Warehouses?

>> Lookup Table in Databases

>> Storing a Tree Structure in a Relational Database

>> What Is SQL Injection?

>> Real World Examples of Tree Structures

• Gameplay Algorithms

>> Database Design in a Microservices Architecture

>> Offline Concurrency Control