The latest articles on DEV Community by Shruti Maheshwari (@shruti_maheshwari_). https://dev.to/shruti_maheshwari_ https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1701360%2F0ef66280-3f9c-4126-a048-08a94de24328.jpeg https://dev.to/shruti_maheshwari_ en Shruti Maheshwari Sun, 30 Jun 2024 19:47:39 +0000 https://dev.to/shruti_maheshwari_/top-sql-interview-questions-3gp0 https://dev.to/shruti_maheshwari_/top-sql-interview-questions-3gp0 <p>Welcome to Day 01 of our 21-day coding challenge! Today, we're diving into some of the most common SQL interview questions. Whether you're prepping for an interview or just looking to sharpen your SQL skills, these questions will give you a solid foundation.</p> <p>1.What is SQL?<br> 2.What are the different types of SQL commands?</p> <ol> <li>What is a primary key? 4.What is a foreign key?</li> <li>What is a JOIN? Explain different types of JOINs 6.What is normalization? Explain its types. 7.What are indexes? 8.What is a stored procedure? 9.What is a trigger? 10.Explain ACID properties.</li> </ol> <p><strong>Practical Questions:</strong></p> <p>1.How do you retrieve unique records from a table.<br> 2.How do you find the second highest salary from an Employee table?<br> 3.How do you update a record in a table?<br> 4.How do you delete a record from a table?<br> 5.What is a view and how do you create one?</p> <p>Happy coding! Stay tuned for Day 02 where we’ll cover some exciting topics to keep your coding skills sharp.</p> <h1> 21DaysOfChallenge #SQL #CodingInterview #TechInterviews </h1> Shruti Maheshwari Fri, 28 Jun 2024 21:40:55 +0000 https://dev.to/shruti_maheshwari_/level-up-your-web-development-skills-and-interview-preparation-with-the-21-days-code-challenge-4fdl https://dev.to/shruti_maheshwari_/level-up-your-web-development-skills-and-interview-preparation-with-the-21-days-code-challenge-4fdl <p>Hey fellow developers and job seekers! Are you ready to enhance your web development skills and ace those tech interviews? Join us for a specialized edition of the 21 Days Code Challenge focused on Web Development and Interview Preparation!</p> <p>Are you up for the challenge? Let's level up our skills and crush those interviews together! 💻🔥 Drop a comment if you're joining or tag a friend who should! Let's make these 21 days count! 🚀</p> webdev javascript beginners programming Shruti Maheshwari Fri, 28 Jun 2024 21:31:46 +0000 https://dev.to/shruti_maheshwari_/software-engineer-mgp https://dev.to/shruti_maheshwari_/software-engineer-mgp <p>Hello Dev community!</p> <p>I'm thrilled to share that I'm beginning my journey as a software engineer, and I couldn't be more excited about what lies ahead. Having recently graduated with a degree in Computer Science, I've eagerly awaited this moment to dive deep into the world of coding, problem-solving, and innovation.</p> <p>So here's to new beginnings, continuous learning, and making a mark in the ever-evolving world of software engineering. Let's code, create, and innovate together.</p> webdev beginners career news