Database Fundamentals

Core database concepts like ACID, indexing, and normalization.

Edit Topic ✏️

Questions (10)

Beginner5m

Primary Key vs Unique Key

CassandraMongoDBMySQLPostgreSQLSQL Server
Easy5m

DELETE vs TRUNCATE

CassandraMongoDBMySQLPostgreSQLSQL Server
Easy10m

SQL Joins and Their Types

MySQLPostgreSQLSQL Server
Easy5m

Using Views in SQL Server

SQL Server
Medium10m

Clustered Index

CassandraMongoDBMySQLPostgreSQLSQL Server
Medium10m

Common Table Expressions (CTEs)

PostgreSQLSQL Server
Medium5m

Local vs Global Temporary Tables

SQL Server
Hard20m

Sharding vs Partitioning

System Design
Hard10m

@@IDENTITY vs SCOPE_IDENTITY vs IDENT_CURRENT

SQL Server
Hard20m

B-Tree Indexes & SARGability

MongoDBMySQLPostgreSQLSQL Server