Position: IT-intern

Company: Seagate

Salary: 15k To 30k Monthly*

Degree: Any Graduate

Experience: Freshers or Experienced

Location: Pune, India

Apply Now: Click here to apply

🚀 Big News! 🚀

Searching for jobs, internships, placements, or free courses? Off-Campus Job Updates is here to help! 💼🔥

✅ Latest job and internship updates
✅ Placement news
✅ Interview tips
✅ Free courses to grow your skills

Join now and get regular updates! Share with your friends and groups so they don’t miss out! 😄🙌

🔗👉 Join here: https://t.me/Offcampusjobupdateslive

👉 WhatsApp Channel: https://whatsapp.com/channel/0029Vaog2gOLNSa9xawdms1m

Hello everyone, the channel above is mine. 😄🙌

I will be posting all Job Updates exclusively on my new channel, Off-Campus Job Updates 💼📈

For the latest job information and opportunities, Join now! I will not be posting any more job-related updates here.

👉 Join Now: https://t.me/Offcampusjobupdateslive

Hey everyone! 🙌

Please share this with your friends and groups. 😄✅

Your support motivates us to post more about unique opportunities and career growth! 🚀 Thanks a lot! 🙏

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

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 🔥🔥

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 👍👍

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 👍👍

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 :)

🚀 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! ✅

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 👍👍

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 ✅

📌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 👍👍

HTML CheatSheet 💻🔥

Check it out this post! 👇

https://www.instagram.com/p/DAax-bIzmgq/?igsh=ODR0MHo2MW1lN3Ey

If this message receives 400 Hearts '❤️,' I will share Free Java Handwritten Notes by an expert teacher (Complete Java Notes).

Hit that ❤️ and let’s reach 400 fast so I can share the notes ASAP! 👆