Coders Learning

📌Save Your time with this Short Cuts Ctrl + A - Select All Ctrl + B - Bold Ctrl + C - Copy Ctrl + D - Fill Ctrl + F - Find Ctrl + G - Find next instance of text Ctrl + H - Replace Ctrl + I - Italic Ctrl + K - Insert a hyperlink Ctrl + N - New workbook Ctrl + O - Open Ctrl + P - Print Ctrl + R - Nothing right Ctrl + S - Save Ctrl + U - Underlined Ctrl + V - Paste Ctrl W - Close Ctrl + X - Cut Ctrl + Y - Repeat Ctrl + Z - Cancel F1 - Help F2 - Edition F3 - Paste the name F4 - Repeat the last action F5 - Goto F6 - Next Pane F7 - Spell Check F8 - Extension of the mode F9 - Recalculate all workbooks F10 - Activate Menubar F11 - New graph F12 - Save As Shift + F1 - What is it? Shift + F2 - Edit cell comment Shift + F3 - Paste the function into the formula Shift + F4 - Search Next Shift + F5 - Find Shift + F6 - Previous Panel Shift + F8 - Add to the selection Shift + F9 - Calculate the active worksheet Shift + F10 - Popup menu display Shift + F11 - New spreadsheet Shift + F12 - Save Ctrl + F3 - Set name Ctrl + F4 - Close Ctrl + F5 - XL, size of the restore window Ctrl + F6 - Next Workbook Window Shift + Ctrl + F6 - Previous Workbook Window Ctrl + F7 - Move window Ctrl + F8 - Resize Window Ctrl + F9 - Minimize the workbook Ctrl + F10 - Maximize or Restore Window Ctrl + F11 - Inset 4.0 Macro sheet Ctrl + F1 - Open File Alt + F1 - Insert a graph Alt + F2 - Save As Alt + F4 - Output Alt + F8 - Macro dialog Alt + F11 - Visual Basic Editor Ctrl + Shift + F3 - Create a name using the names of row and column labels Ctrl + Shift + F6 - Previous Window Ctrl + Shift + F12 - Printing Alt + Shift + F1 - New spreadsheet Alt + Shift + F2 - Save Alt + = - AutoSum Ctrl + `- Toggle value / display of the formula Ctrl + Shift + A - Insert the argument names in the formula Alt + down arrow - automatic view list Alt + '- Format Style Dialog Ctrl + Shift + ~ - General Format Join @coderslearning for more! ✅ KEEP LEARNING 👍👍

MERN Stack Developer Roadmap 2024: Step 1: 🌐 Master Web Basics Step 2: 🖥️ HTML/CSS Proficiency Step 3: ✨ Deep Dive into JavaScript Step 4: 🗂️ Version Control with Git Step 5: 🐍 Node.js for Server-Side Step 6: 🗃️ Express.js for Routing Step 7: 📦 NPM for Package Management Step 8: 📚 MongoDB for Databases Step 9: 🌟 React.js for Frontend Step 10: 🔐 Implement Security (JWT) Step 11: 🚀 App Deployment (Heroku, Netlify) Step 12: 🐳 Docker Basics Step 13: ☁️ Explore Cloud Services Step 14: 🔄 CI/CD with GitHub Actions Step 15: 🧪 Testing with Jest Step 16: 📜 API Documentation Step 17: 📢 Build a Portfolio Step 18: 💼 Resume Crafting Step 19: 🛑 Interview Preparation Step 20: 🔍 Job Hunting Strategy I have curated the best resources to learn Mern Stack 👇👇 https://bit.ly/3MxD4Ww START Your MERN Journey ✅

MERN Stack Developer Roadmap 2024: Step 1: 🌐 Master Web Basics Step 2: 🖥️ HTML/CSS Proficiency Step 3: ✨ Deep Dive into JavaScript Step 4: 🗂️ Version Control with Git Step 5: 🐍 Node.js for Server-Side Step 6: 🗃️ Express.js for Routing Step 7: 📦 NPM for Package Management Step 8: 📚 MongoDB for Databases Step 9: 🌟 React.js for Frontend Step 10: 🔐 Implement Security (JWT) Step 11: 🚀 App Deployment (Heroku, Netlify) Step 12: 🐳 Docker Basics Step 13: ☁️ Explore Cloud Services Step 14: 🔄 CI/CD with GitHub Actions Step 15: 🧪 Testing with Jest Step 16: 📜 API Documentation Step 17: 📢 Build a Portfolio Step 18: 💼 Resume Crafting Step 19: 🛑 Interview Preparation Step 20: 🔍 Job Hunting Strategy I have curated the best resources to learn Mern Stack Development 👇👇 https://bit.ly/3MxD4Ww START Your MERN Journey ✅

Google is hiring for internship roles Position: Software Engineering interns Qualification: Bachelor's Degree Salary: ₹75k to ₹1.5L Per month* Experience: Freshers Location: Bengaluru, India 📌Apply Now: https://cuvette.tech/app/other-jobs/66f161af7ab08cc41a2bba63?referralCode=KJ12IG 👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaog2gOLNSa9xawdms1m 👉Telegram Link: https://t.me/Offcampusjobupdateslive Like for more ❤️ All the best 👍👍

🚀 Top 5 Apps to Learn Coding 10x Faster in 2024! Looking to speed up your coding journey? These apps will help you learn faster and smarter: 1. Momo: https://mimo.org 2. Sololearn: https://www.sololearn.com 3. Codecademy: https://www.codecademy.com 4. Dailydev: https://daily.dev 5. Khan Academy: https://www.khanacademy.org 💡 Pro tip: Stay consistent and watch your coding skills grow! Join @coderslearning for more awesome resources! ✅

✅ Learn New Skills FREE 🔰 1. Web Development ➝ ◀️ https://t.me/webdevcoursefree 2. CSS ➝ ◀️ http://css-tricks.com 3. JavaScript ➝ ◀️ http://t.me/javascript_courses 4. React ➝ ◀️ http://react-tutorial.app 5. Data Engineering ➝ ◀️ https://t.me/sql_engineer 6. Data Science  ➝ ◀️ https://t.me/datasciencefun 7. Python ➝ ◀️ http://pythontutorial.net 8. SQL ➝ ◀️  https://t.me/sqlanalyst 9. Git and GitHub ➝ ◀️ http://GitFluence.com 10. Blockchain ➝ ◀️ https://t.me/Bitcoin_Crypto_Web 11. Mongo DB ➝ ◀️ http://mongodb.com 12. Node JS ➝ ◀️ http://nodejsera.com 13. English Speaking ➝ ◀️ https://t.me/englishlearnerspro 14. C#➝ ◀️ https://learn.microsoft.com/en-us/training/paths/get-started-c-sharp-part-1/ 15. Excel➝ ◀️ https://t.me/excel_analyst 16. Generative AI➝ ◀️ https://t.me/generativeai_gpt 17. Java ◀️ https://t.me/Java_Programming_Notes 18. Artificial Intelligence ◀️ https://t.me/machinelearning_deeplearning 19. Data Structure & Algorithms ◀️ https://t.me/dsabooks 20. Backend Development ◀️ https://imp.i115008.net/rn2nyy 21. Python for AI ◀️ https://deeplearning.ai/short-courses/ai-python-for-beginners/ Join @coderslearning for more free courses Like for more ❤️ ENJOY LEARNING👍👍

Complete 14-day roadmap to learn SQL learning: Day 1: Introduction to Databases - Understand the concept of databases and their importance. - Learn about relational databases and SQL. - Explore the basic structure of SQL queries. Day 2: Basic SQL Syntax - Learn SQL syntax: statements, clauses, and keywords. - Understand the SELECT statement for retrieving data. - Practice writing basic SELECT queries with conditions and filters. Day 3: Retrieving Data from Multiple Tables - Learn about joins: INNER JOIN, LEFT JOIN, RIGHT JOIN. - Understand how to retrieve data from multiple tables using joins. - Practice writing queries involving multiple tables. Day 4: Aggregate Functions - Learn about aggregate functions: COUNT, SUM, AVG, MIN, MAX. - Understand how to use aggregate functions to perform calculations on data. - Practice writing queries with aggregate functions. Day 5: Subqueries - Learn about subqueries and their role in SQL. - Understand how to use subqueries in SELECT, WHERE, and FROM clauses. - Practice writing queries with subqueries. Day 6: Data Manipulation Language (DML) - Learn about DML commands: INSERT, UPDATE, DELETE. - Understand how to add, modify, and delete data in a database. - Practice writing DML statements. Day 7: Data Definition Language (DDL) - Learn about DDL commands: CREATE TABLE, ALTER TABLE, DROP TABLE. - Understand constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL. - Practice designing database schemas and creating tables. Day 8: Data Control Language (DCL) - Learn about DCL commands: GRANT, REVOKE for managing user permissions. - Understand how to control access to database objects. - Practice granting and revoking permissions. Day 9: Transactions - Understand the concept of transactions in SQL. - Learn about transaction control commands: COMMIT, ROLLBACK. - Practice managing transactions. Day 10: Views - Learn about views and their benefits. - Understand how to create, modify, and drop views. - Practice creating views. Day 11: Indexes - Learn about indexes and their role in database optimization. - Understand different types of indexes (e.g., B-tree, hash). - Practice creating and managing indexes. Day 12: Optimization Techniques - Explore optimization techniques such as query tuning and normalization. - Understand the importance of database design for optimization. - Practice optimizing SQL queries. Day 13: Review and Practice - Review all concepts covered in the previous days. - Work on sample projects or exercises to reinforce learning. - Take practice quizzes or tests. Day 14: Final Review and Projects - Review all concepts learned throughout the 14 days. - Work on a final project to apply SQL knowledge. - Seek out additional resources or tutorials if needed. Here are some practical SQL syntax examples for each day of your learning journey: Day 1: Introduction to Databases - Syntax to select all columns from a table:

   SELECT * FROM table_name;
  

Day 2: Basic SQL Syntax - Syntax to select specific columns from a table:

   SELECT column1, column2 FROM table_name;
  

Day 3: Retrieving Data from Multiple Tables - Syntax for INNER JOIN to retrieve data from two tables:

   SELECT orders.order_id, customers.customer_name
  FROM orders
  INNER JOIN customers ON orders.customer_id = customers.customer_id;
  

Day 4: Aggregate Functions - Syntax for COUNT to count the number of rows in a table:

   SELECT COUNT(*) FROM table_name;
  

Day 5: Subqueries - Syntax for using a subquery in the WHERE clause:

   SELECT column1, column2 
  FROM table_name 
  WHERE column1 IN (SELECT column1 FROM another_table WHERE condition);
  

Day 6: Data Manipulation Language (DML) - Syntax for INSERT to add data into a table:

   INSERT INTO table_name (column1, column2) VALUES (value1, value2);
  

Here you can find essential SQL Job Updates & Resources👇 https://t.me/Offcampusjobupdateslive Like this post if you need more 👍❤️ Hope it helps :)

Naukri is hiring for Freshers For Trainee! Location: Online (Virtual) Qualification: Any Graduate Experience: Freshers Batch: 2022, 2023, 2024, 2025, 2026, 2027 Salary: Best In Industry 𝗟𝗶𝗻𝗸: https://trk.opiclepxl.com/click?campaign_id=2394&pub_id=2546 All the best 👍👍

Free Courses / Certifications for a full-stack career in 2024: 1. Web design https://freecodecamp.org/learn/2022/responsive-web-design/ 2. JavaScript https://freecodecamp.org/learn/javascript-algorithms-and-data-structures/ 3. Front-end libraries https://freecodecamp.org/learn/front-end-development-libraries/ 5. Back-end and APIs https://freecodecamp.org/learn/back-end-development-and-apis/ 6. Databases https://freecodecamp.org/learn/relational-database/ 7. Full Stack Web Development Bootcamp https://bit.ly/3MxD4Ww Join @coderlearning for more free resources ‼️ Join @offcampusjobupdateslive for new job updates! ✅ ENJOY LEARNING 👍👍

Best YouTube Channels to Learn Coding for FREE 🖥️✅ Full post is here 👇👇 https://www.instagram.com/p/DAIrouSzs1g/?igsh=MWRvNm94ZGM1MDhzMw== Do check it and don't forget to Like, Comment and Share 🔥🔥

😄 Hi Everyone, for upcoming placement updates join 🔥🔥 @offcampusjobupdateslive 🔥🔥 🔥🔥 @offcampusjobupdateslive 🔥🔥

🚀 Reminder: Free 2-Day Full Stack Workshop by Skillected Starts Today! 🚀 🗓️ Date: 19th & 20th September ⏰ Time: 6:00 PM - 8:00 PM (IST) 🌐 Join here: https://www.skillected.com/sessions/-Free-Workshop-Build-Frontend--Backend-Using-JavaScript-in-2-Days--66e7ffcbc746cc1e3455f30c 💡 Don’t miss your chance to learn Frontend & Backend Development using JavaScript!

Only 5 seats left! 🤯 Classes is going to start at 6pm today! Be ready everyone! 🙌

Only 20 seats left! 😨 Hurry up! Friends! 🙌

Only 35 seats left! 😱 Register now before it's too late! ⚡