Databases
This section contains posts related to databases.
.png?locale=en)
Indexes in databases. Types of indexes.
Indexes in databases are used to speed up search and data retrieval. They work similarly to pointers in a book, allow...
What is a transaction? What are the main properties of tr...
h1,h2,h3{color:#FFF;margin-bottom:16px} p{color:#B0B0B0;margin-bottom:16px} a{color:#64B5F6;text-decoration:none} a:...
.png?locale=en)
JOIN: LEFT/RIGHT/INNER/OUTER
SQL Joins SQL JOIN is an operation that allows combining data from multiple tables based on related columns. Main t...
SQLBolt
SQLBolt - a series of interactive lessons and exercises designed to help you quickly learn SQL right in your browser....
What is PostgreSQL?
PostgreSQL is a DBMS that uses a relational model for its databases and supports the standard SQL query language. Pos...