JMB Materials
Открыть в Telegram
All Programming Language Materials All free Courses All free materials For Daily Job updates: https://t.me/jobsmukyambigilu
Больше1 257
Подписчики
-124 часа
-17 дней
-1230 день
Архив постов
1 257
Check out the latest 20+ job opportunities just uploaded! Don’t miss your chance—apply now and fast-track your career!
Follow the Jobs Mukyam Bigilu channel on WhatsApp: https://whatsapp.com/channel/0029Vamjco9FXUucOWQnKa2h
1 257
Repost from Jobs Mukyam Bigilu
Hello everyone! 🚨 Important update ‼️‼️‼️
‼️Due to recent news about potential restrictions on Telegram in India, we’re moving our updates and support to a new WhatsApp channel to ensure you don’t miss out on any important information.
✅To stay connected with us please join with us
✅Click below and join 👇( hardly it takes 5 sec of time to join 😐)
📌📌 Follow our channel on WhatsApp:
https://whatsapp.com/channel/0029Vamjco9FXUucOWQnKa2h
❤️Thank you for your continued support
1 257
Interview series part 1
Here are 10 common job interview questions you might encounter in 2024:
1. Can you tell me about yourself?
- This question is often an icebreaker. Focus on your professional background, highlighting relevant experiences, skills, and why you're interested in the role.
2. Why are you interested in this role/company?
- Interviewers want to see if you've researched the company and understand how your skills align with the job requirements and company values.
3. What are your strengths and weaknesses?
- When discussing strengths, focus on qualities that are relevant to the job. For weaknesses, mention something you are working on improving, and how you’re doing so.
4. Can you describe a challenging situation you've faced at work and how you handled it?
- This behavioral question assesses your problem-solving abilities and how you handle pressure. Use the STAR method (Situation, Task, Action, Result) to structure your answer.
5. How do you prioritize your work when you have multiple deadlines?
- This question evaluates your time management and organizational skills. Discuss strategies like prioritization, delegation, and time-blocking.
6. Where do you see yourself in five years?
- Employers ask this to gauge your long-term interest in the role and company. Express your career aspirations while aligning them with the company's potential growth.
7. How do you stay current with industry trends?
- Demonstrating that you’re proactive about staying informed about the industry can set you apart. Mention any specific resources, courses, or networks you use.
8. Can you give an example of how you’ve worked effectively in a team?
- Collaboration is key in many roles. Share a story that shows your ability to work well with others, including how you contribute to a team's success.
9. How do you handle feedback?
- Employers value employees who can accept constructive criticism and use it to improve. Give an example of how you received and acted on feedback in the past.
10. Why should we hire you?
- This is your chance to sell yourself. Highlight your unique skills, experiences, and how they make you the ideal candidate for the role.
These questions reflect the key competencies employers are likely to focus on in 2024, including adaptability, continuous learning, and teamwork.
1 257
Majority of top companies hiring for analytic roles (Data Analyst/Business Analyst) focus heavily on SQL understanding as a selection criteria, which according to me, should be the first thing you start your preparation with.✅️📍
I have divided this SQL roadmap into 3 steps (Basics, Level Up & Practice), and it should take around 1 month to complete.
Step 1 - Basics 🔢 :✅️
➡What is a Relational Database / RDBMS?
➡SQL Data Types - Varchar, text, int, number, date, float, boolean.
➡SQL commands - select, where, like, distinct, between, group by, having, order by, insert into, case when, update, truncate, delete, commit, rollback (basically all the DDL, DML, DCL, TCL commands in SQL).
➡Integrity Constraints - Primary key, foreign key, not null, unique.
➡Operators arithmetic, logical, and comparison operations.
➡Use of distinct, order by, limit, and top.
➡Use of union and union all.
➡Joins in SQL inner, left, right, outer, self, full outer, cross join.
Step 2 - Level up ⬆⬆ : ✅️
➡Normalization in SQL
➡Aggregate, date, and string functions
➡Sub-Queries
➡CTE table / with clause
➡In-built SQL functions
➡Window functions
➡Views
Step 3 - Practice SQL Questions on leetcode & hackerrank ✅️
