Databases questions and answers
SQL and NoSQL modelling, indexing and query performance. Page 4 of 20.
System Design practice on Codemia
Work through 120+ system design problems with detailed solutions, from rate limiters to multi-region storage.
Answers 181-240
- Best way to update LINQ to SQL classes after database schema change
- Best way to work with dates in Android SQLite
- BIGINT mysql performance compared to INT
- Bigtable secondary indexes Best practices/Recommended-ways
- Binary Data in MySQL
- binary vs. string vs. number for storing UUID in DynamoDB partition key?
- binlog_format STATEMENT and CURRENT_TIMESTAMP with MySQL replication
- Boolean vs tinyint1 for boolean values in MySQL
- Brew Cassandra Installation
- brew install mysql on macOS
- Bulk insert with SQLAlchemy ORM
- Bulk insert with SQLAlchemy ORM
- Bulk Update in C
- C Equivalent of SQL Server DataTypes
- C equivalent of the IsNull function in SQL Server
- c working with Entity Framework in a multi threaded server
- Calculate difference between two datetimes in MySQL
- Calculate size of items in my Amazon DynamoDB table
- Calculating the size of a table in Cassandra
- Calling external services (Rest api)/database CRUD operations within Orleans Grain
- Calling redis-cli in docker-compose setup
- Can 2 Debezium Connectors read from same source at the same time?
- Can a database be replicated to an EC2 instance from outside Amazon?
- can AWS Lambda connect to RDS mySQL database and update the database?
- Can cassandra nodes be highly portable?
- Can celery gracefully endure a mongodb failover when using it as a broker?
- Can compacted Kafka topic be used as key-value database?
- Can Debezium Capture Changes of a Postges Materialized View
- Can Druid replace Cassandra?
- Can I concatenate multiple MySQL rows into one field?
- Can I concatenate multiple MySQL rows into one field?
- Can I create a secondary index on multiple columns in cassandra
- Can I delete data rows in tables from Athena?
- Can I force cleanup of old tombstones?
- Can I generate script of a migration with EF code first and .net core
- Can I make http requests directly to the janusGraph server?
- Can I query MongoDB ObjectId by date?
- Can I restore a single table from a full mysql mysqldump file?
- Can I return the 'id' field after a LINQ insert?
- Can I store images in MySQL
- Can I take advantage of Yugabytes compatability?
- Can I use bigchainDB server with django instead of using sqlite?
- Can I use database names without url to start replication in CouchDB?
- Can I use MongoDB with Entity Framework?
- Can I use mysql's built-in function get_lock?
- Can I use NOT FOR REPLICATION in Merge Replication with rowguid field?
- Can I use PouchDB with Dynamo on the back instead of Couch?
- Can I write a program to see if a table exists in YugaByte's YCQL (Cassandra) api?
- Can I write sub query in KSQL?
- Can magento use multiple MySQL slaves?
- Can MySQL convert a stored UTC time to local timezone?
- Can one use the Django database layer outside of Django?
- Can rollback still occur on a MongoDB replica set with J1 and WMajority?
- Can someone explain mappedBy in JPA and Hibernate?
- Can SQL reads return stale data?
- Can table columns with a Foreign Key be NULL?
- Can the DynamoDB single table design play nicely with a Microservices architecture?
- Can we have more than 1024 nodes in Couchbase?
- Can we make 2 phase commit protocol to be non-blocking if assumptions of 3PC used on it?
- Can we restore to same dynamodb table from backup
Course
Beginner
27 lessons
10 hours
System Design Fundamentals
Build a strong foundation in designing scalable, reliable distributed systems.
View the course