HOW I SET UP A LINUX LAB & SSH ON MY LAPTOP TO PRACTICE PRODUCTION COMMANDSWHY I REQUIRE A LAB ? When I first started working in production support, I quickly realized that Linux commands are a part of the job. We use them to look at logs, check processes, see how much disk Aug 13 · 14 min readblagos.hashnode.dev
SQL - TRUNCATE VS DELETE DIFFERENCETRUNCATEDELETEIt is DDL command.It is DML command.It does not support where clause.It is support where clause.It is permanent delete.It is temporary deletion.It delete all table but keeps it's structuAug 10 · 1 min readblagos.hashnode.dev
SQL - WHERE VS HAVING DIFFERENCEWHERE HAVING Where clause applied to single row. Having clause applied to groups. Where clause filter the records before grouping the data. ( pre -filer ) Having filter the records after groupingAug 10 · 1 min readblagos.hashnode.dev
SQL INDEXESIt is a database object which is used to retrieve data from the database more quickly. WHY WE USE INDEX : To retrieve data from the database quickly. To improve the performance of SELECT queries. TAug 10 · 1 min readblagos.hashnode.dev
SQL VIEWSIt is a database object. It is a logical or virtual table in the database . A VIEW does not store data physically. VIEWS TYPES : Simple View Complex View Only Read With View With Check Option ViewAug 10 · 3 min readblagos.hashnode.dev
