Category Archives: SQL & Databases

OLTP and OLAP OLTP – Online Transaction processing – inserts , updates and deletes very efficient and fast, OLAP (Online Analytical processing – Data Warehouse) – data insert not efficient, reading data is efficient Indexes are used to retrieve data from the database more quickly than otherwise. The users cannot see the indexes, they areContinue reading “SQL-certification path”