Lesson 26:Database Locks and Concurrency Control Introduction to Concurrency Control The prevention of concurrent access in a database is crucial for the sake of achieving the recoverability of t...

Query Optimization What is query optimization? Query Optimization is a crucial aspect of database management systems (DBMS) that seeks to determine the most efficient way to execute a given que...

Transaction What is transaction ? In a database management system (DBMS), a transaction is a sequence of one or more operations (such as read, write, update, or delete) executed as a single log...

Hyperparameter Tuning, Regularisation and Optimization In this blog, we will run through how to tune the best hyperparameter settings and adjust the AI model’s internal parameters to minimize the ...

Indexing Indexing of Spatial and Temporal Data A spatial-temporal index is an advanced index structure where the indexing key is the location and timestamp of an object. Indexing spatial and t...

Convolutional Neural Networks In the vast landscape of artificial intelligence, there exists a cornerstone technology that has reshaped our understanding of image processing and pattern recognitio...

Database From Scratch While relational databases offer powerful data management capabilities, creating a simple database from scratch using Python is possible. This approach involves building func...

Document based databases. Document based database is a type of NoSQl database which does not use the relational model to store data, instead it uses the documents to store the data in the database...

Normal Form Normalization refers to the process of organizing the attributes and tables of a relational database to minimize redundancy and dependency. A Normal Form is a set of guidelines or rul...

Ranking in SQL The RANK ( ) function is one of the window functions in SQL. What is a Window function? A window function is a special function that looks at the data and computes the results for...