Programming Bay
2.19K subscribers
78 photos
1 video
3 files
189 links
Here we will provide premium free online courses, projects, trainings,internships,placement and jobs related material and updates.

admin: @tcpl20

Join discussion group: @programming_bay
Download Telegram
Accenture is hiring Web Developer Associate
For 2023, 2024, 2025 grads
Location: Mumbai

πŸ“ŒApply Now:

https://www.accenture.com/in-en/careers/jobdetails?id=AIOC-S01648837_en

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
Infosys hiring .Net Dev

πŸ“ŒApply Now:

https://career.infosys.com/jobdesc?jobReferenceCode=INFSYS-EXTERNAL-247823&sourceId=4003

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
Siemens Energy
Position: AI/Machine Learning Engineer
Qualifications: Bachelor’s Degree
Experience: Freshers
Location: Gurgaon, India

πŸ“ŒApply Now:

https://jobs.siemens-energy.com/en_US/jobs/FolderDetail/AI-Machine-Learning-Engineer/299962

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
MakeMyTrip is hiring for Project Based Internship (Marketing)
Salary/Stipend: 3-4 LPA

πŸ“ŒApply Now:
https://gommt.darwinbox.in/ms/candidatev2/main/careers/jobDetails/a6a43714b58f9c

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
JB Poindexter (India) Private Limited is hiring for Jr Pricing Analyst
Experience: 0-1 years
Salary: 5-6 LPA

πŸ“ŒApply Now:
https://jobs.dayforcehcm.com/en-US/jbpco/jbpindia/jobs/45887

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
American Express is hiring for Software Engineer I
Experience: 0-2 years
Salary: 15-25 LPA

πŸ“ŒApply Now:
https://egug.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/26010680

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
Gainwell Technologies
Position: C Unix Developer
Qualification: Bachelor’s Degree
Experiencο»Ώe: Experienced
Location: Remote


πŸ“ŒApply Now:
https://jobs.gainwelltechnologies.com/job/Bangalore-C-Unix-Developer-KA-560100/1371756000/

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
𝐆𝐄 π‡πžπšπ₯π­π‘π‚πšπ«πž
Position: Graduate Engineer Trainee
Qualifications: Bachelor’s Degree
Experience: Freshers
Location: Pune, India


πŸ“ŒApply Now:
https://careers.gehealthcare.com/global/en/job/R4043850/Graduate-Engineer-Trainee

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
Platform Science is hiring for Data Engineer
Batch: 2023, 2024, 2025

πŸ“ŒApply Now:

https://job-boards.greenhouse.io/platformscience/jobs/7765813003

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
Priceline is hiring for Associate Software Engineer
Batch: 2024, 2025

πŸ“ŒApply Now:
https://priceline.wd1.myworkdayjobs.com/Priceline/job/Mumbai/Associate-Software-Engineer_R5752-1

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
Artpark is hiring for Data quality check executive (Freelance)
Batch: 2023, 2024, 2025, 2026

πŸ“ŒApply Now:

https://www.artpark.in/careers/quality-check-executive-freelance

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
Octave is hiring for Software Engineer
Batch: 2021, 2022, 2023, 2024

πŸ“ŒApply Now:

https://careers.octave.com/job/Software-Engineer/2950-en_US

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
American Express is hiring for Software Engineer I
Batch: 2024, 2025, 2026

πŸ“ŒApply Now:

https://egug.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/26010683

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
ACI Worldwide is hiring for Software Engineer
Batch: 2023, 2024, 2025

πŸ“ŒApply Now:
https://ebwg.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX/job/18478

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
fmg is hiring Software Engineer Intern (PHP & Java)
For 2026, 2027 grads
Location: Bangalore

πŸ“ŒApply Now:

https://fridaymediagroup.com/open-positions/software-engineer-intern-

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
carelon care solutions is hiring Associate Software Engineer
For 2024, 2025 grads
Location: Multiple

πŸ“ŒApply Now:

https://elevancehealth.wd1.myworkdayjobs.com/carelonglobal_in/job/IND-KA-Bengaluru-Bagmane-Solarium-City/Associate-Software-Engineer---III_JR200918

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
BJAK is hiring Software Engineer (Backend)
For 2023, 2024, 2025 grads

πŸ“ŒApply Now:

https://jobs.ashbyhq.com/bjakcareer/91d1eff2-5941-4842-be80-568701debc16

Free Courses With CertificatesπŸ‘‡
https://bit.ly/Free_Courses_With_Certificates

Upload CV Get Dream Job HereπŸ‘‡
https://bit.ly/Dream_Job_Internship

Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

Share with your College Whatsapp Groups & Friends too

All the best πŸ‘πŸ‘
βœ… SQL Interview Questions with Answers

1. What is a window function? 
A window function computes results over a group ("window") of rows related to the current row, without collapsing them (like GROUP BY).

Examples: ROW_NUMBER(), RANK(), SUM() OVER(...) for running totals, rankings, or moving averages.

2. What is the difference between RANK() and ROW_NUMBER()? 
β€’ ROW_NUMBER(): assigns unique sequential numbers to all rows, even if values are equal.
β€’ RANK(): gives same rank to tied values, then skips the next rank (e.g., 1, 1, 3).

3. How do you find the second highest salary? 
SELECT salary 
FROM ( 
  SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) as rnk 
  FROM employees 
) t 
WHERE rnk = 2; 
This avoids ties if you want exactly the second‑highest value.

4. What is a recursive CTE? 
A recursive CTE refers to itself in its WITH definition, usually in the form "anchor + UNION ALL recursive step". It is used for hierarchical data like managers‑employees, org charts, or tree structures.

5. What is the difference between correlated and non-correlated subquery? 
β€’ Non‑correlated: runs once, independent of the outer query.
β€’ Correlated: references columns from the outer query and runs once per outer row (e.g., SELECT ... FROM t1 WHERE col > (SELECT AVG(col) FROM t2 WHERE t2.id = t1.id)).

6. How do you remove duplicates without DISTINCT? 
Use window functions: 
DELETE FROM ( 
  SELECT ROW_NUMBER() OVER (PARTITION BY col1, col2 ORDER BY id) as rn 
  FROM table 
) t 
WHERE rn > 1; 
Or use GROUP BY and keep one row per group.

7. What is an INDEX and when do you use it? 
An index speeds up data retrieval on specified columns (used in WHERE, JOIN, ORDER BY). Use it on columns that are frequently filtered or joined; avoid on very small tables or columns updated often.

8. Explain self-join with example. 
A self‑join joins a table to itself using aliases. Example: 
SELECT e1.name as employee, e2.name as manager 
FROM employees e1 
LEFT JOIN employees e2 ON e1.manager_id = e2.id
Useful for parent‑child relationships.

9. What is the difference between DELETE, DROP, and TRUNCATE? 
β€’ DELETE: removes rows (can be filtered by WHERE), can be rolled back.
β€’ TRUNCATE: removes all rows quickly, resets storage; often not logged per row.
β€’ DROP: removes entire table (structure + data); cannot be rolled back.

10. How do you pivot/unpivot data in SQL? 
β€’ Pivot: turns rows into columns (e.g., sales per month as columns) using PIVOT or conditional aggregation (MAX(CASE WHEN ... END)).
β€’ Unpivot: turns columns into rows (e.g., multiple month columns β†’ one month column) using UNPIVOT or UNION ALL/VALUES.

11. What is LAG() and LEAD()? 
β€’ LAG(col, n): value of col from n rows before current row.
β€’ LEAD(col, n): value from n rows after. Used for time‑series analysis (MoM change, prior/next values).

12. How do you handle NULL in aggregates? 
Most aggregates (SUM, AVG, MAX, MIN) ignore NULL. 
β€’ COUNT(col) ignores NULL; COUNT(*) counts all rows.
β€’ Use COALESCE() or ISNULL() to replace NULL before aggregating.

13. What is the difference between VIEW and MATERIALIZED VIEW? 
β€’ VIEW: virtual table; query runs every time you select.
β€’ MATERIALIZED VIEW: stores result physically and refreshes periodically; faster reads, slower updates.

14. Explain ACID properties. 
β€’ Atomicity: transaction is "all or nothing".
β€’ Consistency: valid state before and after.
β€’ Isolation: concurrent transactions don't interfere.
β€’ Durability: committed changes survive crashes.

indexes on WHERE, JOIN, ORDER BY columns.


Claim your Free $5 Bonus HereπŸ‘‡
https://bit.ly/3wUxw09

Join our WhatsApp Channel πŸ‘‡

https://whatsapp.com/channel/0029VbAi27y0lwghBe9mE42i

WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ Jobs and Internships Updates
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsupdates ]

---

2️⃣ Jobs and Internships India
πŸ“Ž Channel Link:
[ https://t.me/jobsandinternshipsindia ]

---

3️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]
Complete roadmap to learn Python and Data Structures & Algorithms (DSA) in 2 months

### Week 1: Introduction to Python

Day 1-2: Basics of Python
- Python setup (installation and IDE setup)
- Basic syntax, variables, and data types
- Operators and expressions

Day 3-4: Control Structures
- Conditional statements (if, elif, else)
- Loops (for, while)

Day 5-6: Functions and Modules
- Function definitions, parameters, and return values
- Built-in functions and importing modules

Day 7: Practice Day
- Solve basic problems on platforms like HackerRank or LeetCode

### Week 2: Advanced Python Concepts

Day 8-9: Data Structures in Python
- Lists, tuples, sets, and dictionaries
- List comprehensions and generator expressions

Day 10-11: Strings and File I/O
- String manipulation and methods
- Reading from and writing to files

Day 12-13: Object-Oriented Programming (OOP)
- Classes and objects
- Inheritance, polymorphism, encapsulation

Day 14: Practice Day
- Solve intermediate problems on coding platforms

### Week 3: Introduction to Data Structures

Day 15-16: Arrays and Linked Lists
- Understanding arrays and their operations
- Singly and doubly linked lists

Day 17-18: Stacks and Queues
- Implementation and applications of stacks
- Implementation and applications of queues

Day 19-20: Recursion
- Basics of recursion and solving problems using recursion
- Recursive vs iterative solutions

Day 21: Practice Day
- Solve problems related to arrays, linked lists, stacks, and queues

### Week 4: Fundamental Algorithms

Day 22-23: Sorting Algorithms
- Bubble sort, selection sort, insertion sort
- Merge sort and quicksort

Day 24-25: Searching Algorithms
- Linear search and binary search
- Applications and complexity analysis

Day 26-27: Hashing
- Hash tables and hash functions
- Collision resolution techniques

Day 28: Practice Day
- Solve problems on sorting, searching, and hashing

### Week 5: Advanced Data Structures

Day 29-30: Trees
- Binary trees, binary search trees (BST)
- Tree traversals (in-order, pre-order, post-order)

Day 31-32: Heaps and Priority Queues
- Understanding heaps (min-heap, max-heap)
- Implementing priority queues using heaps

Day 33-34: Graphs
- Representation of graphs (adjacency matrix, adjacency list)
- Depth-first search (DFS) and breadth-first search (BFS)

Day 35: Practice Day
- Solve problems on trees, heaps, and graphs

### Week 6: Advanced Algorithms

Day 36-37: Dynamic Programming
- Introduction to dynamic programming
- Solving common DP problems (e.g., Fibonacci, knapsack)

Day 38-39: Greedy Algorithms
- Understanding greedy strategy
- Solving problems using greedy algorithms

Day 40-41: Graph Algorithms
- Dijkstra’s algorithm for shortest path
- Kruskal’s and Prim’s algorithms for minimum spanning tree

Day 42: Practice Day
- Solve problems on dynamic programming, greedy algorithms, and advanced graph algorithms

### Week 7: Problem Solving and Optimization

Day 43-44: Problem-Solving Techniques
- Backtracking, bit manipulation, and combinatorial problems

Day 45-46: Practice Competitive Programming
- Participate in contests on platforms like Codeforces or CodeChef

Day 47-48: Mock Interviews and Coding Challenges
- Simulate technical interviews
- Focus on time management and optimization

Day 49: Review and Revise
- Go through notes and previously solved problems
- Identify weak areas and work on them

### Week 8: Final Stretch and Project

Day 50-52: Build a Project
- Use your knowledge to build a substantial project in Python involving DSA concepts

Day 53-54: Code Review and Testing
- Refactor your project code
- Write tests for your project

Day 55-56: Final Practice
- Solve problems from previous contests or new challenging problems



WhatsApp Community Link πŸ‘‡

https://chat.whatsapp.com/HPJDqRr6G1sKQIqfdJF3pL

1️⃣ GROUP FOR PROGRAMMERSπŸ–₯
πŸ“Ž Channel Link:
[ https://t.me/realgroupforprogrammer ]

---

2️⃣ Coding Community
πŸ“Ž Channel Link:
[ https://t.me/Coding_CommunityOfficial ]

---

3️⃣ Programming Bay
πŸ“Ž Channel Link:
[ https://t.me/programmingbay ]
Challenge Name: TVS Credit EPIC

Eligibility: 2nd, 3rd and 4th year students are eligible to participate.

● Direct Interview opportunity and PPI
● Cash prizes
● Participation Certificates

Apply Link:
https://bit.ly/TVS_Credit_Challenge

Do share with your Friends too
🚨 Earn Passive Money Easily 🚨

Since your device is already connected to the internet, you can actually get paid for the data you aren't using.

Honeygain is a trusted app that runs quietly in the background of your phone or PC. It just securely shares your unused bandwidth with researchers and pays you for it. Your connection stays 100% encrypted, and it never accesses your personal data, files, or browsing history.

🎁 Official Bonus:
If you use the invite link below, you get an instant $5 starting bonus to help you reach your first cash payout faster.

πŸ‘‡ How to set it up in 2 minutes:

1. Click the link and create your free account:
https://bit.ly/3wUxw09

2. Download the app (works on Android, Windows, Mac, or Linux).

3. Log in, let it run in the background, and collect your passive income.


πŸ”— Claim your free $5 Bonus here:
https://bit.ly/3wUxw09

πŸ’‘ Pro-Tip: You can connect both your phone and your laptop to the same account to double your earning speed!