GeneralBeginnerBasic Concepts of DBMS
Learn the core DBMS concepts through one worked SQL example: tables, primary and foreign keys, relationships, normalization, ACID transactions and indexes.
Tanishk · 7 min
Loading…
General database
Database concepts, industry news and topics that span every engine.
Articles and news that aren't tied to a single database engine: data management fundamentals, big data, the Microsoft data platform, security, data science and the wider database industry.
GeneralBeginnerLearn the core DBMS concepts through one worked SQL example: tables, primary and foreign keys, relationships, normalization, ACID transactions and indexes.
GeneralFind out who owns Ingres now, what Actian Ingres offers in its current releases, and which command-line and graphical tools you use to run it.
GeneralBeginnerFollow the tuning loop: find the costliest queries, read their execution plans, fix them with indexes or rewrites, and check statistics, memory and locks.
GeneralBeginnerSee what became of the 2016 Hadoop stack and what replaced it: object storage, Iceberg and Delta Lake tables, lakehouses and cloud SQL warehouses.
#big-data
GeneralBeginnerUnderstand what database as a service covers, which tasks stay your responsibility, what you give up, what it costs, and how to evaluate a provider.
GeneralBeginnerOpen data sets are available to public by the US government and other entities. Here is a list of some open data set providers.
#backup-&-recovery
GeneralBeginnerUnderstand what big data means, how to tell whether your data really needs distributed tools, and which categories of big data technology are in use today.
#big-data