Coder Baba

What types of SQL commands (or SQL subsets) do you know? Data Definition Language (DDL) – to define and modify the structure of a database. Data Manipulation Language (DML) – to access, manipulate, and modify data in a database. Data Control Language (DCL) – to control user access to the data in the database and give or revoke privileges to a specific user or a group of users. Transaction Control Language (TCL) – to control transactions in a database. Data Query Language (DQL) – to perform queries on the data in a database to retrieve the necessary information from it. examples of common SQL commands DDL: CREATE, ALTER TABLE, DROP, TRUNCATE, and ADD COLUMN DML: UPDATE, DELETE, and INSERT DCL: GRANT and REVOKE TCL: COMMIT, SET TRANSACTION, ROLLBACK, and SAVEPOINT DQL: – SELECT

🚀 Top 10 GitHub Repositories Every Web Developer Should Know 🌐 1️⃣ Web Developer Roadmap: https://github.com/kamranahmedse/developer-roadmap 2️⃣ 30 Seconds of Code: https://github.com/30-seconds/30-seconds-of-code 3️⃣ Awesome Cheatsheets: https://github.com/LeCoupa/awesome-cheatsheets 4️⃣ CSS Protips: https://github.com/AllThingsSmitty/css-protips 5️⃣ 33 JS Concepts: https://github.com/leonardomso/33-js-concepts 6️⃣ You Don’t Know JS (2nd Edition): https://github.com/getify/You-Dont-Know-JS/tree/2nd-ed 7️⃣ Front-End Checklist: https://github.com/thedaviddias/Front-End-Checklist 8️⃣ JavaScript Questions: https://github.com/lydiahallie/javascript-questions 9️⃣ Clean Code JavaScript: https://github.com/ryanmcdermott/clean-code-javascript Join our community for more resources like these: https://t.me/coder_baba 🔗 #WebDevelopment #CodingLife #GitHub #JavaScript #CSS #FrontendDeveloper #CleanCode #Programming #CoderBaba #DeveloperResources 🚀👨‍💻

🔥 Exclusive Offer for Video Editors! 🔥 If you're looking for premium video editing tools and top-tier resource materials, this is the deal for you! 🚀 🎥 Video Editing Software: 🎬 Capcut Pro: InShot Pro: KineMaster Pro: Sportify Pro: Canva Pro: Filmora 13 Android: Filmora 13 + AI for PC: Adobe Premiere Pro PC: 🎁 Extra Bonuses worth ₹5,000+ Editing Resources ✨ Features: No watermark All Pro features Latest version Lifetime validity Desktop/Mobile Free Bonus: Canva Pro & Sportify Pro 🔥 All software and resources just at Rs.199 only for Lifetime! 🔥 To make your payment💳, visit: https://instamojo.com/@coderbaba After successful payment, please send me a DM on Instagram with your payment proof to get access! 📩📸 Don’t miss out on this incredible deal! Get everything you need to take your video editing to the next level!

🚀Top 40 CSS Interview questions: Q1: Explain the three main ways to apply CSS styles to a web page. 🖌 Q2: What is CSS? 🧐 Q3: How to use variables in Sass? 💡 Q4: Explain CSS sprites, and how you would implement them on a page or site. 🎨 Q5: Explain the CSS box model and the layout components that it consists of. 📦 Q6: What is a CSS rule? 📜 Q7: Explain what the @extend directive is used for in Sass? 🚀 Q8: Have you played around with the new CSS Flexbox or Grid specs? 🎛 Q9: What is DOM (Document Object Model) and how is it linked to CSS? 🧩 Q10: What is Sass? 💻 Q11: What existing CSS frameworks have you used locally, or in production? How would you change/improve them? 🛠 Q12: Describe floats and how they work. 🌊 Q13: What is Selector Nesting in Sass used for? 🕸 Q14: List out the key features of Sass. ✨ Q15: What is the difference between classes and IDs in CSS? 🔖 Q16: List out the data types that Sass supports. 📊 Q17: What's the difference between SCSS and Sass? 🤔 Q18: Explain the usage of the table-layout property. 🗃 Q19: What's the difference between a relative, fixed, absolute, and statically positioned element? 📍 Q20: Have you ever worked with retina graphics? If so, when and what techniques did you use? 👓 Q21: What are the advantages/disadvantages of using CSS preprocessors? ⚖️ Q22: How is responsive design different from adaptive design? 📱 Q23: What are CSS selectors? Name some. 🔍 Q24: What does Accessibility (a11y) mean? ♿️ Q25: What is a CSS preprocessor and why use one? 💻 Q26: How would you approach fixing browser-specific styling issues? 🛠 Q27: What’s the difference between resetting and normalizing CSS? Which would you choose, and why? 🧹 Q28: Explain your understanding of the box model and how you would tell the browser in CSS to render your layout in different box models. 🖼 Q29: Describe pseudo-elements and discuss what they are used for. 👻 Q30: How does CSS actually work (under the hood of the browser)? 🛠 Q31: What is a Grid System in CSS? 📐 Q32: Explain the purpose of clearing floats in CSS. 🧼 Q33: What does * { box-sizing: border-box; } do? What are its advantages? 🛡 Q34: Can you explain the difference between coding a website to be responsive versus using a mobile-first strategy? 📱➡️💻 Q35: Explain the basic rules of CSS Specificity. 📊 Q36: How do you optimize your webpages for print? 🖨 Q37: Have you ever used a grid system, and if so, what do you prefer? 🔲 Q38: What are the different ways to visually hide content (and make it available only for screen readers)? 👀🙈 Q39: Describe z-index and how a stacking context is formed. 📚 Q40: Is there any reason you'd want to use translate() instead of absolute positioning, or vice versa? And why? 🔄 Available now on my Telegram channel: @coder_baba 📲 Link in bio! Don't miss out—head over to the channel and grab your copy today! 🚀 #CoderBaba #StudyNotes #PDFDownload #TechEducation #LearningResources #TelegramChannel

Top 50 Linux Commands You Must Know as a Regular User... 1. ls - view contents of directory (list) 2. pwd - path of the current directory 3. cd - change directoryn 4. mkdir - make new directory 5. mv - move files / rename files 6. cp - copy files 7. rm - remove files 8. touch - create blank new file 9. rmdir - delete directory 10. cat - list content of file to terminal 11. clear - clear terminal window 12. echo - move data into a file 13. less - Read text file one screen at a time 14. man - show manual of Linux commands 15. sudo - enables you to perform tasks that require administrative or root permissions 16. top - task manager in terminal 17. tar - used to archive multiple files into a tarball 18. grep - used to searching words in specific files 19. head - view first lines of any text file 20. tail - view last lines of any text file 21. diff - compares the contents of two files line by line 22. kill - used for killing unresponsive program 23. jobs - display all current jobs along with their statuses 24. sort - is a command line utility for sorting lines of text files 25. df - info about system disk 26. du - check how much space a file or directory takes 27. zip - to compress your files into a zip archive 28. unzip - to extract the zipped files from a zip archive 29. ssh - a secure encrypted connection between two hosts over and insecure network 30. cal - shows calendar 31. apt - command line tool for interaction with packaging system 32. alias - custom shortcuts used to represent a command 33. w - current user info 34. whereis - used to locate the binary, source, manual page files 35. whatis - used to get one-line man page description 36. useradd - used to create a new user 37. passwd - used to changing password of current user 38. whoami - print current user 39. uptime - print current time when machine starts 40. free - print free disk space info 41. history - print used commands history 42. uname - print detailed information about your Linux system 43. ping - to check connectivity status to a server 44. chmod - to change permissions of files and directories 45. chown - to change ownership of files and directories 46. find - using find searches for files and directories 47. locate - used to locate a file, just like the search command in Windows 48. ifconfig - print ip address stuff 49. ip a - similar to ifconfig but shortest print 50. finger - gives you a short dump of info about a user Follow me @Coder_Baba #coderbaba #linux #Programming #code #CodingTutorial

Capgemini Tableau Interview Questions: 1. How do you connect Tableau to different data sources? 2. Explain the concept of data blending in Tableau. 3. How can you optimize Tableau extracts for better performance? 4. What are the different types of joins in Tableau, and when would you use each type? 5. How do you create a dual-axis chart in Tableau? 6. What is the purpose of a calculated field in Tableau, and how do you create one? 7. Explain the difference between a context filter and a normal filter in Tableau. 8. How do you create a parameter in Tableau, and what are its use cases? 9. What is Tableau Server, and how does it differ from Tableau Desktop? 10. How can you handle null values in Tableau? ### Deloitte Tableau Interview Questions: 1. How can you create a dashboard in Tableau? 2. What is the difference between live connection and extract in Tableau? 3. Explain the use of LOD (Level of Detail) expressions in Tableau. 4. How do you create a story in Tableau, and what are its benefits? 5. What is the purpose of the Pages shelf in Tableau? 6. How do you implement row-level security in Tableau? 7. Describe how to use Tableau's data interpreter. 8. How do you schedule data refreshes in Tableau? 9. What is the difference between a bar chart and a Gantt chart in Tableau? 10. How can you customize tooltips in Tableau? ### Accenture Tableau Interview Questions: 1. How do you create a calculated field that uses an IF statement in Tableau? 2. What is the use of Tableau Public, and how does it differ from Tableau Online? 3. Explain the difference between dimensions and measures in Tableau. 4. How do you create a heat map in Tableau? 5. What are table calculations in Tableau, and how do you use them? 6. How can you use the Tableau Prep tool? 7. What is the purpose of the Measure Names and Measure Values fields in Tableau? 8. How do you create a funnel chart in Tableau? 9. Explain how to use filters in a Tableau dashboard. 10. What are some best practices for designing dashboards in Tableau? https://youtube.com/shorts/W6DpGnlpJWY?feature=share #dataanalyst #tableau #DataAnalyst #Tableau #BusinessIntelligence #DataVisualization #Analytics #DashboardDesign #InterviewQuestions #DataScience #TechInterviews #CareerGrowth

Top 30 Capgemini Tableau Interview Questions: https://youtube.com/shorts/W6DpGnlpJWY?feature=share

Capgemini Tableau Interview Questions: https://youtu.be/i73bCGbHuiM

📚 Company-Specific DSA Material: LeetCode Questions 📚👇