Tai Titans Dev
  • Welcome
    • About Me
    • Experience Project
  • Interviews
    • Java Core
      • Java Basic
      • Collection
      • Concurrency
      • Memory Management
      • Java Strings
  • Hibernate
  • Monads
  • OOP
  • SOLID
  • SQL
  • NoSQL
  • Network
  • Redis
  • Kafka
  • Docker
  • DSA
  • ElasticSearch
  • Design Pattern
  • AWS
  • Document
    • Java Core
      • Java 21 SE
        • Language Specification
          • Chapter 1. Introduction
          • Chapter 2. Grammars
          • Chapter 3. Lexical Structure
          • Chapter 4. Types, Values, and Variables
          • Chapter 5. Conversions and Contexts
          • Chapter 6. Names Convention
          • Chapter 7. Packages and Modules
          • Chapter 8. Classes
          • Chapter 9. Interfaces
          • Chapter 10. Arrays
          • Chapter 11. Exceptions
          • Chapter 13. Binary Compatibility
          • Chapter 14. Blocks, Statements, and Patterns
          • Chapter 15. Expressions
          • Chapter 16. Definite Assignment
          • Chapter 17. Threads and Locks
          • Chapter 18. Type Inference
          • Chapter 19. Syntax
        • Virtual Machine Specification
          • Chapter 1. Introduction
          • Chapter 2. The Structure of the Java Virtual Machine
          • Chapter 3. Compiling for the Java Virtual Machine
          • Chapter 4. The class File Format
          • Chapter 5. Loading, Linking, and Initializing
          • Chapter 6. The Java Virtual Machine Instruction Set
          • Chapter 7. GarbageCollection
      • Java Concurrency
      • Java Concurrency 2
      • Maven
      • Java Collection
      • Java Generics
      • String, StringBuilder, StringBuffer
      • String Joiner
      • TimeUnit
    • Golang
      • Session
        • Concurrency
        • Golang OOP
        • Golang Basic
        • Golang Basic
      • Session
        • Memory and Performance
        • Handle Error
        • Optimize Code and Best Practice
      • Session
        • Database
        • Gin Example
      • Framework
        • Gin
        • Project Structure
        • GIN Router
        • GIN MVC
        • GIN Error Handler
      • fsync
      • Advance Golang
        • Golang Core
          • Variables
          • Slices
          • Maps
          • Structs
          • Interfaces
          • Pointers
          • Concurrency
            • Goroutine
            • Channels
            • Select
            • Mutex
            • WaitGroup
            • Worker Pool
          • Error handling
          • Memory management
            • Garbage Collection
            • stack vs heap
            • Memory Optimization
    • SQL
      • MySQL vs PostgreSQL
      • PostgreSQL
        • 1. Foundation
      • MySQL
        • INSERT_MYSQL
        • SELECT_MYSQL
        • UPDATE_MYSQL
        • DELETE_MYSQL
      • Indexing
      • Join
      • DatabaseNormalization
      • Compare-And-Swap
      • Cluster-Replication
      • offset-vs-cursor-based-pagination
      • Partitioning
      • Trigger
      • Transactions
        • Isolation Levels
        • MVCC
      • StoredProceduresandTriggers
    • Kafka Theory
      • Introduction
      • Message Broker
      • Kafka Introduction
      • Kafka Architecture with Zookeeper
      • Topic và Partition
      • Kafka with Kraft mode
      • Kafka with KRaft Mode - Docker Compose
      • Offset & Record
      • Kafka Producer
      • Kafka Fetch and HTTP Polling
      • Kafka Consumer
      • Kafka Replication
      • Kafka Producer Advanced
      • Serialization
    • Design Pattern
      • Creational
        • Singleton
        • Builder
    • Networking
      • Networking Models
      • DNS
      • HTTP - HTTPS
      • TCP - UDP
      • Ipv4 - Ipv6
      • LAN
      • PORT
      • PROTOCOLS
      • QUIC
      • TUNNEL
    • Backend Core
      • API-Pagination
      • Architecture
      • Blacklist-Whitelist
      • Caching
      • CDN
      • CleanArchitecture
      • CQRS
      • DDD
      • DependencyInjection
      • DistributedSystem
      • HATEOAS
      • LocalStorage-Cookie-Session
      • Memcached
      • Oauth
      • RESTfulWebServices
      • Servers-URL-Flow
      • Short Polling vs Long Polling
      • SOAP API
      • TypesenseSearch
      • WebHook
      • WebSocket
      • Process vs Thread
    • Spring Framework
      • ApacheTomcat
      • Terminology
      • Core
        • IoC
        • Denpendency_Injection
        • Bean
        • Bean_Proxying
        • ApplicationContext
        • Constructor_Injection
        • Setter_Injection
        • Spring AOP
        • Spring Factory
        • Spring Scope
      • Anotation
        • @SpringBootApplication
        • @Autowired - @Value
        • @Bean - @Conditional
        • @Component
        • @Controller - @RestController -@ResponseBody
        • @Lazy - @Primary - @Qualifier - @DependsOn
        • @Repository- @ComponentScan- @Configuration
        • @Service
        • @Transactional - @Query - @Modifying
      • Spring Data JPA
        • Spring Data JPA
        • SpringDataJPA_Architechture
        • Transaction_And_Concurrency
        • Entity_LifeCycle
        • Auditing_And_Event Listeners
        • Batch Processing__Bulk Operations
        • Multi-Tenancy
        • ORM_ADVANCE
        • Querying_And_Performance_Optimiz
      • Spring Security
        • Chapter 1. Security Theory
          • Authentication
          • Authorization
          • Encryption
          • Session Management
        • Chapter 2. Spring Security
          • 1. Filter Chain
          • 2. Security Context
          • 3. Authentication Flow
          • 4. Authorization Flow
        • Chapter 3. Method Security Theory
          • HTTP_HTTPS
          • JSON Web Token
          • Oauth2
          • OpenID Connect
    • Redis
      • Redis_Architecture
      • Redis_Persistence
      • Why_Redis_Fast
      • Redis Pub/Sub
      • Redis Stream
    • Flow Business
      • Jira
      • GIT
        • Handle GIT
    • Microservices
      • LoadBalancer
      • API-Gateway
      • CircuitBreaker
      • RateLimiter
      • Resilient
      • ProxyRequest
      • Saga Pattern
      • gRPC
    • DDD
      • Structure
  • AWS
    • VPC
    • Subnet
    • Security Group
  • Advance
    • Optimize
      • Database Scaling
        • Sharding
          • Type Sharding
          • Solutions
          • Consistent Hashing
          • Denormalization
        • Replication
          • Structure
          • Master-Slave Replication
Powered by GitBook
On this page
  1. Document

SQL

Lý thuyết chuyên sâu về SQL

MySQL - PostgreSQL - Oracle SQL

PreviousMemory OptimizationNextMySQL vs PostgreSQL

Last updated 16 hours ago

Page cover image