Top Github repositories which would be really helpful for job preparation, upskilling and much more đź’« - Free programming books : https://lnkd.in/gbSk9NRr- System Design : https://lnkd.in/graSZG3Phttps://lnkd.in/gykTqH6k- Project Based Learning : https://lnkd.in/gjewtywD- Coding Interview : https://lnkd.in/ge7e7gyh- Resources for Preparation of Placements : https://lnkd.in/d6zpHj4P- Data Science : https://lnkd.in/gbnGnGRD- Projects : https://lnkd.in/gNvjU9jr- For Roadmaps : https://lnkd.in/gYNSH-dc- JavaScript :... Continue Reading →
INTERMEDIATE GCP QUESTIONS AND ANSWERS
Why does Google Cloud Platform differ from other services? Google Cloud Platform (GCP) has a number of distinct characteristics and features that differentiates it from other cloud services: Google-grade Security: GCP uses the same robust architecture and security model Google uses for its own products like Gmail and Search. Advanced Data Analytics and Machine Learning:... Continue Reading →
Basic GCP questions and answers
What are the many levels of cloud architecture? The following are the many layers of cloud architecture: Physical Layer: This layer contains the network, physical servers, and other components.Infrastructure layer: This layer includes virtualized storage levels, among other things.Platform layer: This layer consists of the applications, operating systems, and other components.Application layer: It is the... Continue Reading →
Delete Duplicates in SQL Data
1. Using rowidSQL > delete from empwhere rowid not in(select max(rowid) from emp group by empno);This technique can be applied to almost scenarios. Group by operation should be on the columns which identify the duplicates.2. Using self-joinSQL >Â delete from emp e1where rowid not in(select max(rowid) from emp e2where e1.empno = e2.empno );3. Using row_number()SQL >Â delete... Continue Reading →
CODEBOX 