TNThe Noidinblagos.hashnode.dev·Aug 13 · 14 min readHOW 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 00
TNThe Noidinblagos.hashnode.dev·Aug 10 · 1 min readSQL - 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 structu00
TNThe Noidinblagos.hashnode.dev·Aug 10 · 1 min readSQL - 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 grouping00
TNThe Noidinblagos.hashnode.dev·Aug 10 · 1 min readSQL 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. T00
TNThe Noidinblagos.hashnode.dev·Aug 10 · 3 min readSQL 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 View00
