Dataford

Congratulations Sumithra! Keep up the great work 👏👏👏👏

I’m happy to share that I’ve obtained a new certification: Intermediate SQL from Dataford!

Here's how I landed offers from Meta, DoorDash, and other top tech companies: 𝗦𝘁𝗲𝗽 𝟭: 𝗣𝗵𝗼𝗻𝗲 𝗰𝗮𝗹𝗹 𝘄𝗶𝘁𝗵 𝘁𝗵𝗲 𝗿𝗲𝗰𝗿𝘂𝗶𝘁𝗲𝗿 The interview lasts about 30 minutes. The recruiter will ask about your experience to ensure you fit the role well. 𝗠𝘆 𝘁𝗶𝗽 💡: Prepare a 30-second pitch about yourself, highlighting your relevant experience and why you want to join the company. Be sure to mention all relevant skills, such as SQL, Python, and A/B testing. 𝗦𝘁𝗲𝗽 𝟮: 𝗧𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 The next round is the technical interview, where they'll test your SQL knowledge. Make sure you’ve mastered this language! 𝗠𝘆 𝘁𝗶𝗽 💡: Sign up on the Dataford website and start practicing across all these 6 topics → Basic Functions → Ratios → Ranking → Window Functions → Percentile → Text Analysis 𝗦𝘁𝗲𝗽 𝟯: 𝗧𝗮𝗸𝗲-𝗛𝗼𝗺𝗲 𝗔𝘀𝘀𝗶𝗴𝗻𝗺𝗲𝗻𝘁 (𝘀𝗼𝗺𝗲𝘁𝗶𝗺𝗲𝘀!) I really hate when companies ask for this. 𝗠𝘆 𝘁𝗶𝗽 💡: If they do, make sure they pay you for your time—your time is super valuable. 𝗦𝘁𝗲𝗽 𝟰: 𝗧𝗵𝗲 𝗢𝗻-𝘀𝗶𝘁𝗲 𝗶𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 You will get to meet 4-5 people, ~45 min each: → 1 SQL Interview → 2-3 problem solving (i.e case studies) → 1 behavioral round 𝗠𝘆 𝘁𝗶𝗽 💡: → Practice business sense frameworks because they'll ask open-ended questions to assess your problem-solving skills.  → Read up on the company values for your behavioral interview → At Dataford, we’ve got a list of interview questions from experts to help you prepare. And last but not least, 𝗬𝗢𝗨 𝗚𝗢𝗧 𝗧𝗛𝗜𝗦! ♻ Repost if you find this useful

Congrats Feyisayo! Keep up and looking forward to more Dataford certifications!!!!

You'll never land a job in Data. I remember hearing that voice. Don't listen to it. 𝗛𝗲𝗿𝗲 𝗮𝗿𝗲 𝗺𝘆 𝟱 𝘁𝗶𝗽𝘀 𝘁𝗼 𝗴𝗲𝘁 𝘆𝗼𝘂 𝘁𝗵𝗲𝗿𝗲: 𝟭) 𝗪𝗿𝗶𝘁𝗲 𝗖𝗼𝗱𝗲 𝗘𝘃𝗲𝗿𝘆 𝗗𝗮𝘆 - Solve 2 to 3 Real SQL Interview Questions daily on Dataford - Join Real Challenges on Kaggle and contribute to the community - Extend your skills with Python for Data Analytics and Statistics 𝟮) 𝗙𝗮𝗸𝗲 𝗶𝘁 𝘂𝗻𝘁𝗶𝗹 𝘆𝗼𝘂 𝗺𝗮𝗸𝗲 𝗶𝘁 - Include data analysis into your current role, even if you're not officially one yet. - Offer to take on your team’s reporting tasks or support any of their projects. - Change your resume job title to match the position you want. 𝟯) 𝗕𝘂𝗶𝗹𝗱 𝗮 𝗩𝗘𝗥𝗬 𝘀𝘁𝗿𝗼𝗻𝗴 𝗻𝗲𝘁𝘄𝗼𝗿𝗸 - Follow Data Analyst/Scientist and publications like Towards Data Science and Hugging Face. - Connect with Data Analyst/Scientists on LinkedIn (mostly the ones that work in companies you aim to join at some point!) - Every expert started as a beginner, so 𝗱𝗼𝗻'𝘁 𝗯𝗲 𝗮𝗳𝗿𝗮𝗶𝗱 𝘁𝗼 𝗿𝗲𝗮𝗰𝗵 𝗼𝘂𝘁. 𝟰) 𝗚𝗮𝗶𝗻 𝘀𝗼𝗺𝗲 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 - Apply for internships, even unpaid ones, to gain practical experience. - Reach out to small businesses or startups through community groups and offer your skills for free  - 𝗣𝗿𝗶𝗼𝗿𝗶𝘁𝗶𝘇𝗲 𝗴𝗮𝗶𝗻𝗶𝗻𝗴 𝗲𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 𝗼𝘃𝗲𝗿 𝗺𝗮𝗸𝗶𝗻𝗴 𝗺𝗼𝗻𝗲𝘆 𝗮𝘁 𝘁𝗵𝗶𝘀 𝘀𝘁𝗮𝗴𝗲. 𝟱) 𝗘𝗻𝗷𝗼𝘆 𝘁𝗵𝗲 𝗽𝗿𝗼𝗰𝗲𝘀𝘀 - Think of landing a job as a game where you pass levels and have fun along the way. - Break down your job search into funnel steps: Resume --> Recruiter Interview --> Hiring Manager Round --> Last Round And get better on each step!   Don't forget to 𝗳𝗼𝗰𝘂𝘀 𝗼𝗻 𝘁𝗵𝗲 𝗽𝗿𝗼𝗰𝗲𝘀𝘀, 𝗻𝗼𝘁 𝗷𝘂𝘀𝘁 𝘁𝗵𝗲 𝗲𝗻𝗱 𝗴𝗼𝗮𝗹 𝟲) 𝗥𝗲𝗽𝗼𝘀𝘁 𝗮𝗻𝗱 𝗙𝗼𝗹𝗹𝗼𝘄 𝗺𝗲 If you don't, you will probably never land a job 😂 (jk!)

I'm just gonna call us the Dynamic Duo! 🎉 First co-branded workshop with Amney Mounir and Dataford last night! The workshop was a HIT with 10/10 ratings from attendees! Excited for this partnership and the impact we can bring to jobseekers! Thanks for inviting me, Amney! It was so much FUN! 😃 LFG! 💥

This is the resume that got me a job offer at Meta, and here are 9 tips to help enhance yours: 1) Don’t repeat yourself: Mention SQL once and save room for other important details. 2) Talk about people: Highlight experience with cross-functional teams. 3) Talk about impact: Explain why your work matters. 4) Keep it simple: Make your resume inviting and easy to read 5) Experience > Completion. Mention unfinished projects, it's fine! 6) Use strong words. 7) Simplify job titles for clarity. 8) Speak Data. Use technical vocabulary to show your expertise. 9) Important Experience > Every experience. Focus on the most relevant roles. Remember that getting an interview is a numbers game: resume quality * applications = total interviews. If you apply with a blank resume, you can expect zero responses. That is why it's important to invest in your resume's quality before sending out applications. I partnered with Stefanie, Ex-Recruiter at Google, Nvidia, and Apple to boost your resume to help you land more interviews. Comment if you want to join, and I'll send over the link to register! Only 3 spots left!

You don’t need a fancy bootcamp to learn SQL. Here’s roadmap for learning SQL in just 6 weeks and for free. 𝗪𝗲𝗲𝗸 1: 𝗹𝗲𝗮𝗿𝗻 𝘁𝗵𝗲 𝗯𝗮𝘀𝗶𝗰𝘀 𝗼𝗳 𝗦𝗤𝗟 Your first week is about learning what SQL is and getting comfortable with getting data out of a table. ↳ What is SQL? https://lnkd.in/gfknRwPd ↳ Learn about what a table is: https://lnkd.in/gFkzizvt ↳ Learn basic SQL syntax:   ↳ Install MySQL: https://lnkd.in/gaWTF_6y   ↳ Learn SELECT & FROM: https://lnkd.in/g-ShvjqG   ↳ Learn WHERE: https://lnkd.in/ggmHagak 𝗪𝗲𝗲𝗸 2: 𝗹𝗲𝗮𝗿𝗻 𝗮𝗯𝗼𝘂𝘁 𝗮𝗴𝗴𝗿𝗲𝗴𝗮𝘁𝗶𝗼𝗻𝘀 𝗮𝗻𝗱 𝗚𝗥𝗢𝗨𝗣 𝗕𝗬 Your second week is all about aggregating the data, similar to pivot tables in Excel. This is where it gets exciting because you’re now transforming the data in the table. ↳ Learn about aggregations COUNT, SUM, AVG, MAX, and MIN: https://lnkd.in/gxDJYbPS ↳ Learn about GROUP BY, HAVING & WHERE: https://lnkd.in/gJwyW-NE 𝗪𝗲𝗲𝗸 3: 𝗹𝗲𝗮𝗿𝗻 𝗮𝗯𝗼𝘂𝘁 𝗱𝗮𝘁𝗮𝗯𝗮𝘀𝗲𝘀 𝗮𝗻𝗱 𝗝𝗢𝗜𝗡𝘀 In your third week, you’re going to learn about what a relational database. This sets the foundations for learning about JOINs. ↳ What is a relational database: https://lnkd.in/gdrHG5zm ↳ Learn about JOINs: https://lnkd.in/gVYAKrR5 𝘉𝘦 𝘱𝘢𝘵𝘪𝘦𝘯𝘵 𝘸𝘪𝘵ℎ 𝘺𝘰𝘶𝘳𝘴𝘦𝘭𝘧. 𝘑𝘖𝘐𝘕𝘴 𝘢𝘳𝘦 𝘰𝘯𝘦 𝘰𝘧 𝘵ℎ𝘦 𝘮𝘰𝘴𝘵 𝘤𝘰𝘮𝘱𝘭𝘪𝘤𝘢𝘵𝘦𝘥 𝘵𝘰𝘱𝘪𝘤𝘴 𝘪𝘯 𝘚𝘘𝘓. 𝘐𝘧 𝘺𝘰𝘶 𝘧𝘪𝘯𝘥 𝘺𝘰𝘶𝘳𝘴𝘦𝘭𝘧 𝘤𝘰𝘯𝘧𝘶𝘴𝘦𝘥 𝘢𝘧𝘵𝘦𝘳 𝘰𝘯𝘦 𝘷𝘪𝘥𝘦𝘰, 𝘬𝘦𝘦𝘱 𝘸𝘢𝘵𝘤ℎ𝘪𝘯𝘨 𝘰𝘵ℎ𝘦𝘳𝘴 𝘰𝘯 𝘠𝘰𝘶𝘛𝘶𝘣𝘦 𝘶𝘯𝘵𝘪𝘭 𝘪𝘵 “𝘤𝘭𝘪𝘤𝘬𝘴”. 𝗪𝗲𝗲𝗸 4: 𝗹𝗲𝗮𝗿𝗻 𝘁𝗼 𝘂𝘀𝗲 𝗖𝗧𝗘𝘀 𝗮𝗻𝗱 𝘀𝘂𝗯-𝗾𝘂𝗲𝗿𝗶𝗲𝘀 In week 4, you’re now ready for multi-step queries. You’re really advancing in your SQL skills at this point, and you should be proud of yourself! ↳ Learn about CTEs: https://lnkd.in/g3pENkDj ↳ Learn about sub-queries: https://lnkd.in/gp6Jm6tS 𝗪𝗲𝗲𝗸 5 - 6: 𝗯𝘂𝗶𝗹𝗱 𝘆𝗼𝘂𝗿 𝗼𝘄𝗻 𝗽𝗿𝗼𝗷𝗲𝗰𝘁(𝘀) Now that you’re in month 2, you’re ready to start working on your own projects. This may be daunting at first, but this is how you really learn to apply your skills. ↳ Start with this guided project: https://lnkd.in/gpdwnyNr ↳ After a guided project, started working on your own project! Kaggle is a great place to find datasets to work with: www.kaggle.com Pro tip #1: If you get stuck, remember ChatGPT is your best friend! Pro tip #2: Don’t overcomplicate your personal projects, simple is always better. Pro tip #3: Keep a SQL cheat sheet on your desk to help you remember the SQL syntax. ♻️ Found this useful? Repost this to share with others in your network. 👋🏽 Btw, I post Data Science tips daily. Follow me for more!

Interviewing is often the HARDEST part of the job hunt. But there's a catch-22 with interviewing. It's one of the hardest skills to develop. Why? Because often the only context for developing this skill is during a live interview or a mock interview with peers (but not everyone has this resource). Making knowing HOW to interview difficult. This is why I love Dataford's new Interview Hub. It's a collection of recorded mock interviews with experts from companies like Google, Amazon, and Meta. These give an insider view into how established data professionals in tech answer challenging but realistic interview questions. It's an incredible resource. I've never seen anything like it. They've put a ton of work into building out this feature for their premium users. Check it out here: https://lnkd.in/dd_4rV5w PS - Share your top interviewing tip below 👇

𝐒𝐐𝐋 𝐈𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰 𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧𝐬: 𝐁𝐚𝐬𝐢𝐜, 𝐈𝐧𝐭𝐞𝐫𝐦𝐞𝐝𝐢𝐚𝐭𝐞, 𝐚𝐧𝐝 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐋𝐞𝐯𝐞𝐥𝐬 Preparing for an SQL interview? Here's a breakdown of common questions categorized by difficulty level to help you in your next interview: 𝐁𝐚𝐬𝐢𝐜 𝐋𝐞𝐯𝐞𝐥: 1. How to find duplicates in a table? 2. How do you handle NULL values in SQL? 3. Difference between INNER and LEFT JOIN. 4. Difference between UNION and UNION ALL. 5. What is the purpose of the GROUP BY clause in SQL? 𝐈𝐧𝐭𝐞𝐫𝐦𝐞𝐝𝐢𝐚𝐭𝐞 𝐋𝐞𝐯𝐞𝐥: 6. What are the different types of joins in SQL? 7. How do you optimize SQL queries for better performance? 8. Find records in a table that are not present in another table. 9. Find the second highest salary employees in each department. 10. Explain the difference between primary key and foreign key constraints. 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐋𝐞𝐯𝐞𝐥: 11. Update a table and swap gender values. 12. How do you handle transactions in SQL? 13. What is a subquery and how is it different from a join? 14. Find employees with a salary more than their manager's salary. 15. Explain the concept of indexing in databases and its importance. 16. Explain the ACID properties in the context of database transactions. I am sure there are a lot more questions, if not these exact questions, you will be asked a similar question most times. Mastering these SQL concepts will not only help you excel in interviews but also in real-world database management scenarios. Keep learning and exploring! Feel free to add any questions if I missed anything:) Here are a few websites to practice SQL: 1. Dataford : https://lnkd.in/dfSANRjE 2. Interview Query : https://lnkd.in/d_uP8aG5 3. Analyst Builder : https://lnkd.in/d-eZ6p5u 4. LeetCode : https://leetcode.com/ #SQL #databasemanagement #interviewprep #dataanalysis