How to use JSONB in PostgreSQL
· SQL & Databases
Store, index, and query semi-structured data efficiently using PostgreSQL binary JSON format.
Category: SQL & Databases
60 questions in SQL & Databases.
What are PostgreSQL data types
· SQL & Databases
Explore PostgreSQL rich type system including arrays, ranges, geometric types, and custom composites.
How to backup and restore MySQL databases
· SQL & Databases
Protect your data with logical and physical backup strategies for MySQL using mysqldump and Percona XtraBackup.
What are MySQL triggers
· SQL & Databases
Automate actions in response to insert, update, or delete operations using MySQL triggers.
How to configure MySQL for performance
· SQL & Databases
Tune MySQL server variables and hardware utilization for high-throughput and low-latency workloads.
How to use MySQL stored procedures
· SQL & Databases
Encapsulate reusable SQL logic on the server with MySQL stored procedures, variables, and control flow.
What is the InnoDB engine
· SQL & Databases
Understand the InnoDB storage engine, its ACID compliance, row-level locking, and crash recovery features.
How to back up and restore a MySQL database
· SQL & Databases
Learn practical MySQL backup and restore strategies using mysqldump, physical backups, and point-in-time recovery.
What are database transactions
· SQL & Databases
Understand ACID properties, isolation levels, and how transactions ensure reliable database operations.
How to implement full text search in MySQL
· SQL & Databases
Build fast text search features using MySQL FULLTEXT indexes and MATCH ... AGAINST syntax.