Teaching

January - April 2021

Advanced SQL (procedures/functions/triggers), Database design and normal forms, Database application development, Storage structures and indexing/hashing, Query processing and optimization, Transactions, Lock-based concurrency control.

August - November 2020

Purpose and evolution of database management systems, Relational model of data, Formal relational languages (relational algebra/calculus), SQL, Introduction to database design

August - November 2020

Basics of group theory (Abelian groups, Group actions), Simplicial Complexes, Homology and computation using matrix reduction method, Persistent Homology.

August - November 2020

Project Work.

May - July 2020

Advanced SQL (procedures/functions/triggers), Database design and normal forms, Database application development, Storage structures and indexing/hashing, Query processing and optimization, Transactions, Lock-based concurrency control.

May - July 2020

Purpose and evolution of database management systems, Relational model of data, Formal relational languages (relational algebra/calculus), SQL, Introduction to database design

January - April 2020

Advanced SQL (procedures/functions/triggers), Database design and normal forms, Database application development, Storage structures and indexing/hashing, Query processing and optimization, Transactions, Lock-based concurrency control.

January - April 2020

Research Internship.

August - November 2019

Purpose and evolution of database management systems, Relational model of data, Formal relational languages (relational algebra/calculus), SQL, Introduction to database design

August - November 2019

Basics of group theory (Abelian groups, Group actions), Simplicial Complexes, Homology and computation using matrix reduction method, Persistent Homology.

August - November 2019

Research Internship

August - November 2019

Basics of group theory (Abelian groups, Group actions), Simplicial Complexes, Homology and computation using matrix reduction method, Persistent Homology.

January - April 2019

Advanced SQL (procedures/functions/triggers), Database design and normal forms, Database application development, Storage structures and indexing/hashing, Query processing and optimization, Transactions, Lock-based concurrency control.

August - November 2018

Purpose and evolution of database management systems, Relational model of data, Formal relational languages (relational algebra/calculus), SQL, Introduction to database design

January - April 2018

January - April 2018

Advanced SQL (procedures/functions/triggers), Database design and normal forms, Database application development, Storage structures and indexing/hashing, Query processing and optimization, Transactions, Lock-based concurrency control.

August - November 2017

Purpose and evolution of database management systems, Relational model of data, Formal relational languages (relational algebra/calculus), SQL, Introduction to database design

August - November 2017

The course introduces indexing techniques for spatial and temporal data, covering even more abstract metric spaces. It describes a range of indexing techniques targeting different types of data, including their underlying principles and properties, as well as their support for queries and updates. The contents of this course are collected from state-of-the-art research papers (i.e., not found in textbooks). - Below is a broad breakdown of the course - Indexing low-dimensional data (1-5 dimensions) E.g. Indexing Spatial Data with R-trees, R-tree variants, Space-Filling Curves (Hilbert, Z-curves etc), Quad-trees etc. - Indexing high-dimensional data E.g. Locality Sensitive Hashing (LSH), VA File - Indexing Metric Spaces E.g. Metric Trees, GNAT, VP-Tree, iDistance - Indexing Time Series E.g. TS tree, Chebyshev Polynomials, Wavelet-based indexing, MR Index

January - April 2017

Advanced SQL (procedures/functions/triggers), Database design and normal forms, Database application development, Storage structures and indexing/hashing, Query processing and optimization, Transactions, Lock-based concurrency control.

January - April 2017

July - November 2016

Introduction to C and C++ programming. Problem solving and algorithms. Input and output operations, decision control structure, loop control structure, arrays, strings, etc. Pointers, arrays, structures, functions, file operations, classes, object oriented programming. Lab is also included in this course.

January - April 2016

Purpose and evolution of database management systems, Relational model of data, Formal relational languages (relational algebra/calculus), SQL, Introduction to database design

January - April 2016

January - April 2016

Purpose and evolution of database management systems, Relational model of data, Formal relational languages (relational algebra/calculus), SQL, Introduction to database design

January - April 2016

July - November 2015

The course introduces indexing techniques for spatial and temporal data, covering even more abstract metric spaces. It describes a range of indexing techniques targeting different types of data, including their underlying principles and properties, as well as their support for queries and updates. The contents of this course are collected from state-of-the-art research papers (i.e., not found in textbooks). - Below is a broad breakdown of the course - Indexing low-dimensional data (1-5 dimensions) E.g. Indexing Spatial Data with R-trees, R-tree variants, Space-Filling Curves (Hilbert, Z-curves etc), Quad-trees etc. - Indexing high-dimensional data E.g. Locality Sensitive Hashing (LSH), VA File - Indexing Metric Spaces E.g. Metric Trees, GNAT, VP-Tree, iDistance - Indexing Time Series E.g. TS tree, Chebyshev Polynomials, Wavelet-based indexing, MR Index