CODING ARMY ✔️

https://www.linkedin.com/in/ali-hassan-engineer *Follow Ali Hassan - for cyber security related posts 🥰*

https://chat.whatsapp.com/IrUcwuzAsuGJ6L9FKHNlyI *JOIN CODING ARMY #4*

https://www.linkedin.com/in/aziz-u000 *Let's connect on LinkedIn*

SQL Interview Questions with Answers 1. How to change a table name in SQL? This is the command to change a table name in SQL: ALTER TABLE table_name RENAME TO new_table_name; We will start off by giving the keywords ALTER TABLE, then we will follow it up by giving the original name of the table, after that, we will give in the keywords RENAME TO and finally, we will give the new table name. 2. How to use LIKE in SQL? The LIKE operator checks if an attribute value matches a given string pattern. Here is an example of LIKE operator SELECT * FROM employees WHERE first_name like ‘Steven’; With this command, we will be able to extract all the records where the first name is like “Steven”. 3. If we drop a table, does it also drop related objects like constraints, indexes, columns, default, views and sorted procedures? Yes, SQL server drops all related objects, which exists inside a table like constraints, indexes, columns, defaults etc. But dropping a table will not drop views and sorted procedures as they exist outside the table. 4. Explain SQL Constraints. SQL Constraints are used to specify the rules of data type in a table. They can be specified while creating and altering the table. The following are the constraints in SQL: NOT NULL CHECK DEFAULT UNIQUE PRIMARY KEY FOREIGN KEY React ❤️ for more

*HOW MANY PROGRAMING LANGUAGES ARE THERE? 🤔*

*📚 What Makes ChatGPT Chat? Reinforcement Learning from Human Feedback (RLHF) 📚* https://youtu.be/KvTGUI4Tznw?si=FOP1MpTJRuW0y0U0 *Highly recommended - Modern AI Lecture by University of Washington - professor Natasha J.* *if you're in AI (ML/DL) especially in reinforcement learning (RL) this is for you.*

*ChatGPT prompt to learn any skill* I am seeking to become an expert professional in [XYZ]. I would like ChatGPT to provide me with a complete course on this subject, following the principles of Pareto principle and simulating the complexity, structure, duration, and quality of the information found in a college degree program at a prestigious university. The course should cover the following aspects: Course Duration: The course should be structured as a comprehensive program, spanning a duration equivalent to a full-time college degree program, typically four years. Curriculum Structure: The curriculum should be well-organized and divided into semesters or modules, progressing from beginner to advanced levels of proficiency. Each semester/module should have a logical flow and build upon the previous knowledge. Relevant and Accurate Information: The course should provide all the necessary and up-to-date information required to master the skill or knowledge area. It should cover both theoretical concepts and practical applications. Projects and Assignments: The course should include a series of hands-on projects and assignments that allow me to apply the knowledge gained. These projects should range in complexity, starting from basic exercises and gradually advancing to more challenging real-world applications. Learning Resources: ChatGPT should share a variety of learning resources, including textbooks, research papers, online tutorials, video lectures, practice exams, and any other relevant materials that can enhance the learning experience. Expert Guidance: ChatGPT should provide expert guidance throughout the course, answering questions, providing clarifications, and offering additional insights to deepen understanding. I understand that ChatGPT's responses will be generated based on the information it has been trained on and the knowledge it has up until September 2024. However, I expect the course to be as complete and accurate as possible within these limitations. Please provide the course syllabus, including a breakdown of topics to be covered in each semester/module, recommended learning resources, and any other relevant information `Copy and paste, make sure to replace XYZ with the topic you want to learn.`

According to wiki there are 700+ https://en.m.wikipedia.org/wiki/List_of_programming_languages

*WE ARE 17K NOW! ••• THANKS EVERYONE FOR JOINING US ❤️👏😊🎉🎉* *PLEASE NOTE THAT WE HAVE MANY OTHER GROUPS AND COMMUNITIES, WHICH YOU CAN FIND IN THE CHANNEL DESCRIPTION.* *KINDLY CHECK THE CHANNEL DESCRIPTION FOR MORE INFORMATION. And don't forget to turn on the bell 🔔 notification icon in the top right corner, just press once 😉*

😂 😂 Hello world ❌ Asalamalikum Dunya ✅