Databases questions and answers
SQL and NoSQL modelling, indexing and query performance. Page 9 of 20.
System Design practice on Codemia
Work through 120+ system design problems with detailed solutions, from rate limiters to multi-region storage.
Answers 481-540
- Couchbase mobile replication through REST-API
- CouchDB - Get DB's update_seq based on document
- CouchDB - hierarchical comments with ranking. Hacker News style
- CouchDB data synchronization
- CouchDB Filtered Replication
- CouchDB filtered replication - remove a document
- CouchDB Load Balancing Primary write-only and Replicas read-only
- CouchDB replication - Unauthorized to access or create database
- Could Google Spanner be implemented by Raft instead of TrueTime?
- Could not insert new outlet connection Could not find any information for the class named
- Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0
- Could not load file or assembly 'System.Data.SQLite
- Couldn't connect to server 127.0.0.127017
- Count table rows
- Count the number of occurrences of a string in a VARCHAR field?
- Count(*) vs Count(1) - SQL Server
- Count with IF condition in MySQL query
- Counting according to query
- Counting all entries with KSQL
- CQL3 How to retrieve the TTL when there is only a primary key?
- Create a Cumulative Sum Column in MySQL
- Create a DynamoDB table from json
- Create a new database with MySQL Workbench
- Create a new Ruby on Rails application using MySQL instead of SQLite
- Create a temporary table in a SELECT statement without a separate CREATE TABLE
- Create an index on a huge MySQL production table without table locking
- Create AWS Athena view programmatically
- Create boolean column in MySQL with false as default value?
- Create Cassandra table using cql3 with default TTL
- Create new user in MySQL and give it full access to one database
- Create table with Global secondary index using DynamoMapper and class Annotation
- Create the perfect JPA entity
- @CreatedDate annotation does not work with MySQL
- Creating a copy of a database in PostgreSQL
- Creating a database in Orientdb in distributed mode
- Creating a KSQL Stream How to extract value from complex json
- Creating A New MySQL User In Amazon RDS Environment
- Creating and migrating a devise-driven User model in a main/replica context
- Creation timestamp and last update timestamp with Hibernate and MySQL
- Dapper async and transaction
- Data allocation in the distributed databases
- Data can't be written in dolphindb distributed database
- Data modelling for dynamodb where entity has one to many and many to many relationships
- Data not distributed across cluster in Cassandra
- Data sharing/replication among some specific nodes in a distributed database or memory grid
- Data still remains in Kafka topic even after retention time/size
- data structure for indexing big file
- Data structure to find integers within a query range efficiently
- Data truncated for column?
- Database application.yml for Spring boot from applications.properties
- Database architecture/system for one-way multi-source replication into a central database
- Database not found, and IFEXISTStrue, so we cant auto-create it
- Database Replication
- Database replication multiple geographical locations with local database, one main remote database
- Database sharding vs partitioning
- Database Sharding with Concurrency Control And ACID Properties
- Database supporting fast approximate nearest neighbor queries
- Database Switching
- Database synchronization time in cassandra
- Database, Table and Column Naming Conventions?
Course
Beginner
27 lessons
10 hours
System Design Fundamentals
Build a strong foundation in designing scalable, reliable distributed systems.
View the course