Topic : Indexing Indexing of Spatial and Temporal Data Spatial and temporal indexing are essential techniques in database management systems, particularly for handling geospatial and time-series ...

Topic : Non-Relational Databases Non-relational data and NoSQL A non-relational database is a database that stores data in non-tabular form. These databases use a storage model that is optimized...

Topic : Normal Forms First, what is normalization? Normalization is the process of organizing a database to minimize redundancy and dependency by dividing large tables into smaller tables and def...

Topic : Advanced Aggregation Functions Advanced aggregate functions are more complex and specialized functions used in databases, particularly in SQL to perform calculations on groups of rows and...

Topic : Null Values and Set Operations in SQL In this class, I learned what a null value and set operations is and where to apply them. Firstly, set operations are special types of operators whic...

Unit 1: Introduction to Neutral Networks and Deep Learning. What is AI? Ability of a machine to imitate human behavior. AI aims to simulate human-like intelligence in machines, enabling them to...

Topic : Database Users and Database Administrators In the second flipped class of DBS101, I learned the fundamentals on Entity Relationship Diagrams. An Entity Relationship Diagram is a graphical...

Unit 2: Data Preprocessing Data preprocessing is the determining step in data analysis, involving cleaning, transforming, and organizing raw data into a format suitable for analysis. It includes...

Topic : Database Users and Database Administrators On the first flipped class of DBS101, I learned about the roles of different types of database users and the responsibilities of database admini...

Topic : Database Storage Structures Todays guided session focused on three main task on the storage and buffer management which are simulating disk blocks, RAID configuration and buffer pools. ...