Job Searching Ep. 2 | studying sql & python (w/ tips!), trying to enjoy unemployment life

Місяць тому

Hello friends,
I received some call-back interviews so in this video I started preparing for tech screens! There are amazing videos out there that actually teach the technical aspects of SQL & Python, so instead, I wanted to share some of my favorite resources that have been helping me. As always, I hope you enjoy!
xx,
Julia
[let’s connect!]
instagram: @julia.fei
/ julia.fei
[study resources]
product data science →
• vlogs: • //data science
• / what-does-a-product-da...
sql →
• mode.com/sql-tutorial
• leetcode.com/studyplan/top-sq...
• / sql-window-functions
• @emma_ding • Master SQL Window Func...
python →
• www.kaggle.com/learn/pandas
• github.com/guipsamora/pandas_...
[products mentioned]
• pinstripe pants (ivory stripe, M): go.magik.ly/ml/1sw0y/
• button-down shirt (similar): go.magik.ly/ml/216i5/
• jacket (similar): go.magik.ly/ml/216i3/
• necklace: bit.ly/499shdZ
• infinite hoops: bit.ly/3xaXkJh
• molten hoops: bit.ly/3TMTxdY
[cooking]
• thit kho recipe: helenrecipes.com/recipe-42-th...
[freebies]
+ Try out Notability: apps.apple.com/app/apple-stor...
+ 20% off your first Outdoor Voices order: JULIA20
+ 10% off your first Mejuri purchase: mejurifinecrew.sjv.io/juliafei
+ 30-day free trial for copyright-free music: www.epidemicsound.com/referra...
+ shop my amazon favorites: www.amazon.com/shop/juliafei
[about me]
Hi everyone my name is Julia ~ I'm a 20-something-year-old data scientist navigating through life in NYC. You can find vlogs, fashion & beauty content, productivity videos, and more on my channel. Thanks for stopping by & I hope you enjoy :)
[ftc]
This video is not sponsored. There are some affiliate links above, meaning I may earn a small commission if any purchases are made. Thank you for supporting my channel - it means the world to me ♥
[business Inquiries only]
email: laujuliafei@gmail.com

КОМЕНТАРІ: 260

@jdp486 Місяць тому

Making a note to start with "my expertise is in..." before diving into the details of my experience. So smart.

@93gus Місяць тому

Does she have any whyte friends? I can be her first whyte friend.

@Nop3.1 Місяць тому

@@93gus cringe

@its_jei Місяць тому

As a software engineer, I feel this. We usually go through 4-6 interview stages for each company. Good luck, Julia! You absolutely got this! Both SQL and Python are very powerful languages to have a firm grasp on.

@Nop3.1 Місяць тому

getting interview number 1 is the hardest part! Tech employers with unrealistic expectations of every single job is annoying asf.

@user-tz9jh6pv2j 28 днів тому

good luck everyone. i along with 4 others on my team, (and like 1000s others) are SWEs with like 8+ YOE. we got laid off in like... dec. we're fighting you guys for roles.

@dearkathlyn Місяць тому

Hey Julia~ best of luck on your job search! I already know you’ll land a job you love because you know what you want and it’s inspirational to see how you strive to go for it. You’re much younger than I am, but I think you just inspired me to review my database knowledge and update myself. Please keep the videos coming and I hope the next level interviews go well for you!

@thatstrueblue Місяць тому

These are so helpful, and thank you for providing the links! I'm not in the same niche, but SQL is required more often even if you're a content writer. Every piece of advice you give is really precious. I hope you're getting some well-deserved rest as well 💜

@fang-wenhsiao2696 Місяць тому

Thank you so much Julia for sharing the Job Searching journey with us! I'm also searching for a data analyst role in Berlin. The tips you share are so valuable! Wish us good luck 🧡

@aliynarouise Місяць тому

the fact that you're making information and methods about your role as a product data scientist accessible is so great! I definitely see you in a leadership role where you teach a course or offer modules on the field of data science/tech in general

@cherie4665 Місяць тому

Yay a new video! As much as I enjoy your increased posting frequency, I still pray and hope you land a great job soon haha. Good luck! (And thanks for the awesome job hunting tips!!)

@gastronomee_ Місяць тому

Best of luck! I spent a long time finding work that resonated as well so feeling what you’re feeling. You got this!

@LovelyArcticBirds-dq1sj Місяць тому

I must confess, you had me glued for 13 minutes straight. You are good at what you do. Thank you.

@Snowyness Місяць тому

Same, and I'm not even in the tech industry. Regardless, the whole process is super interesting to see!

@gabemcmillan Місяць тому

Thank you Julia for posting. Having lived in nyc a while back, I really enjoy these videos.

@kimitursi762 Місяць тому

Love that you provided real, unsponsored resources that you personally use to study SQL and Python!! I'll need to learn some SQL for a new role so this will be so helpful, ty!

@aneoden7551 14 днів тому

I mean..how??? the quality of the editing got me speechless..great timing between subjects, change of screens, even blurring people's faces at the coffee shop part...also all the informations you shared with us, with links in the description, this is amazing! Also, you're very fun, loved to know more about your routine! Thank you for this quality content!

@adammich01 Місяць тому

Great to give yourself some space for the job search and not feel "rushed". Obviously everyone's situation is different but I was laid off last year. A little further in my career in tech, at the Sr. Director level, but it was quite a shock. It was the first time in 20 years I didn't have a job. I gave myself 3 months off (severance). Gave me time to rethink what was important to me and my family. I started consulting. Interviewed for lots of roles but didn't find anything I really felt was right. So still consulting and working on starting my own business. It's a journey. Also, learn to love the power of "no". When you say "no" to something (a role that's a bad fit, etc) you are only eliminating 1 possible option. All the other options in the universe are still available to you. When you say "yes" to something you eliminate ALL OTHER options. So make sure the "yes" is something you really feel good about. Good luck!

@prernatripathy8406 22 дні тому

Great advice. Thankyou

@TheSdk19 3 дні тому

Need more of your knowledge! 😮

@spacedog6229 Місяць тому

Really enjoyed how specific you were in your studying process. I’m a chemical engineer so I don’t do any of this but it was super intriguing to see a different world. Good luck on your job search!

@abbytpco 19 днів тому

i've been enjoying this series, julia! it makes me more hopeful with my current unemployed life and ongoing job search

@sharissebullock Місяць тому

i love your tech-heavy videos! it’s so interesting to see the specifics of what you did in your previous role. good luck on the job hunt! any company would be lucky to have you on their team :)

@dawidbujak 21 день тому

This is tech-heavy ?

@esperanzagonzalezcoons Місяць тому

Great info! How you feel when you’re day is free and your friends are working is how some retired people feel but I’m so looking forward to retirement in a few years. I enjoy your Vlogs and think of me when I was in my 20s in New York if I would’ve stayed but decided to leave for a challenge in Puerto Rico. Your vlogs are for young and slightly older, starting careers and finishing them as well. Praying for you and your future. Your recipes look delicious.

@hanaasagiii Місяць тому

Hey Julia! I'm now using Mode to SQL and really like it. Thanks for sharing this and good luck to your job hunting journey!

@ericliu9359 Місяць тому

Thank you for sharing the resources! As someone who's also going through technical interviews these resources are helping a ton

@TheMisschrisaz Місяць тому

I’m glad you are taking some time out for yourself during your job search. Those cheat days are so important. Hope you have a great week!

@wangzhao8398 Місяць тому

This is very helpful, wish you all the best Julia!

@rmoorefla Місяць тому

As always, wishing you the best in all your endeavors. I know you'll do just fine. Enjoyed Dr. Slump & currently impatiently waiting for each new episode of Queen of Tears to drop.

@reelabdalla1289 Місяць тому

Juliaaaa love you , literally I like your video before watching ❤🎉

@eimon928 Місяць тому

Julia, i'm here to just let u know that you are my favorite youtuber. I am also studying python and sql. I've been watching your videos for quite a period and you inspire me a lot to be in this career path. I am still a beginner and trying to get into the job market so I wish the best for both of us!

@sagea2042 Місяць тому

Such an inspiration! Wish the best for you in your journey since I am in the same position. Best of luck!

@amartyabhattacharya Місяць тому

Hey Julia! Hope you are doing well. I am a ML Research Engineer myself and have been watching your vlogs for the past couple of years. Your videos are so much peaceful that it becomes an addiction after a point. And the recent videos are so much relatable, specially this one. The perfect blend of tech+lifestyle vlog. So thankful to you for these vlogs! All the best for the next interviews!

@maielavegavlog Місяць тому

Thanks for the video Julia❤ good luck on the job hunt!

@jessicahuang6310 5 днів тому

watching this is so reassuring because I know you'll do great, and that you'll learn so much from these hard times-and so will the rest of us! also, your hair is amazing

@raspada306 Місяць тому

Really great video! I'm currently going through a similar experience as a Front End Engineer after being laid off a couple months ago. It's nice to see others dealing with the same things, I don't feel quite as alone in my experience now. Good luck on your interviews!

@benjaminsaucedo3569 Місяць тому

Thanks for all the SQL resources! I’ve been using W3 schools for a while but haven’t gotten much out of their practice problems. Good luck with the job hunt!❤ (coming from one tech person to another 😊)

@kvcha5725 27 днів тому

Such good advice- interviewing is a huge time commitment so it’s best to weed out the roles that are not a good fit ❤

@thej00se Місяць тому

Thanks for sharing your resources. I've been wanting to improve my tech skills. And the pork recipe I'm super excited for it. Best of luck on landing your next role. I'm sure it will come so enjoy your free time and friendships!

@kungkungx3 Місяць тому

hi julia, thank you for this video. I lost my job a year ago and hav been struggling to land anything since, i'm trying to transition into a career in data analysis despite my old age of 32 as hard as it probably will be. However your videos have helpd me figure out where to start. Hopefully I wlil become someone as inpsiring as yourself in this journey and thank you for helping me stay motivated in this hard time. You'll definitely land that next dream position. Love your content!

@nickodell2318 Місяць тому

Love the technical videos! I'm a data analyst and your content always inspires me to improve my skills.

@RiseAboveRoots987 Місяць тому

Hi, I am changing my career from Mechanical Engineer to data analyst. Could you tell me what skills should I develop and what certificates need to land the first job? I am following python sql courses right now. Thanks in advance. @nickodell2318

@b_c_. Місяць тому

Love the study process, thanks for sharing ... looking forward to more & G'Luck with new job 💕

@rodeketan Місяць тому

Hey Julia. Love your videos! Thank you for sharing your job search journey. I’d love to hear more about A/B test resources from you. Thanks! Keep it up.

@Sunflower94H Місяць тому

Thank you for sharing your journey with us, your advice is appreciated. You are going to do extremely well!!!!

@sunshinemindset8497 Місяць тому

Looking forward to seeing the next stages of your job search xxx

@KuroUmbreon Місяць тому

This video was motivating! I also might have some technical interviews soon, so I need to make a study plan and get into things. Great video! :)

@josedosreis6630 Місяць тому

Hi Julia! I just wanted to say that your videos inspire me a lot. I've been working as a data analyst for more than 3 years and recently finished a data science bootcamp. After being let go from my previous job, I'm currently looking for a new job as well. I really appreciate your tips and the resources you recommend for practicing SQL and Pandas, as these are indeed the main tools for us. Maybe we can connect one day! I wish you the best of luck 🤘🏼

@moon.benjee Місяць тому

focus is def the key! Best of luck Julia

@sunainajain05 Місяць тому

You are amazing! As I want to become a Data Scientist too, and your videos always motivate me. Thank you.

@marcviolides1565 Місяць тому

As someone who is in a job search for an entry-level data science position, I love the specific resources and tips you are giving out (what to focus on like pandas instead of general leetcode style question) and if you could do a whole video on that it would be even better. Stay healthy!

@chi2om Місяць тому

Super helpful. I enjoyed learning sql and R. My only issue with coding is I feel like I easily forget things lol. Practice is definitely the way. I hope you find the perfect role for you soon!

@allthehui Місяць тому

I recently just went through a 2.5 month job search journey as a product manager (in nyc and was also full-time searching after taking a gap year!) There were soooo many stages for each of my interviews as well. Best of luck and you got this!!

@animancy9824 Місяць тому

I am looking for a job as well Julia, and you just posting this video helps me to know we not alone in this process you're the best

@yosef5508 19 днів тому

Ty gorgeous girl for taking the time. You are so sweet at teaching and getting the feeling across. Don't give up, which I think you won't, otherwise, you will demoralize me on the quest to continue🤗.

@chloeshih Місяць тому

Your videos are just getting better and better Julia!!! I love it!!

@user-we8dn5ub9z Місяць тому

I work in healthcare and have no idea what’s going on but was glued to the screen anyway!

@AbigailMCruz_ Місяць тому

okay girl but your hair!!! looks so nice. love the way it looks

@annetteyang Місяць тому

Loved this

@JcOnAFieldtrip Місяць тому

what an awesome video! thank you for all your tips so helpful!

@mahirislam1930 6 днів тому

I am looking to get into data science with a background in IT, this video really helped in terms of resources to get started and a direction to take, so thank you very much for that!

@gellirollz Місяць тому

Video idea alert, I love how you said you know what you want out of the job, what you want to do in the job and skills you want to either use or skills you want to gain. Can you do a video on the skills you have vs what you want to expand on the job, how you know exactly what job you want and want to do on the job and even do a interview scenario of the answers and questions you face on interviews and how you answer them? I am in marketing and I know its board but I usually apply to social media roles or digital marketing roles ( this role you need more SEO, Paid ads experience which I new at), but I think my issue is I dont know what I want, what industry I want t work in or what I want to do.. At this point I want a job lol, but I would love some advice or how you figured out what you want in a job and what company/industry you want to work for

@SiraSam Місяць тому

yay love this channel and this series keep up the vids❤ from Thailand

@freebabe4real Місяць тому

this video is a godsend right now! best of luck with your search & thank you for sharing your journey

@nadia6579 Місяць тому

Thank you so much for the python and sql resources!

@martymas502 Місяць тому

I made Thit Kho for the first time after seeing it in your video...thank you for sharing this recipe! It was soooo good!

@gilt0301 Місяць тому

actually so much useful info! Appreciate so much

@stellaxamy Місяць тому

Keep it up Julia. Been following your journey and thanks for sharing the realistic process with us. Hope to have you on our podcast sometimes

@rachelmorgan6291 Місяць тому

You are amazing! You will get a job and enjoy it. You will look back on this process and grow as an individual.

@saldiamond 17 днів тому

I am a very casual SQL user for my job and i am on and off with studying more advanced concepts. I learned a bit of python too and started a personal project, but there's been no progress in a while. Life has gotten super busy and stressful for me recently, but this video has me inspired to get back at it!

@srali7609 23 дні тому

all the best to keep working hard and study hard too, i know what its like iv been there. hope you land a good job

@balintlaszlo1999 Місяць тому

Hy Julia I'm glad to see you again studying data base for new career. I hope, to find a new job where you feel fulfilled and where you can advance step by step. I Wish good LUCK!!!!

@NhatVo-hg6qs 3 дні тому

your video is an inspiration. Thank you and good luck!!!

@SHIBIYAYA 20 днів тому

Thank you for sharing all those websites! It will sooo useful for me 😄

@moabbas5525 28 днів тому

Thank you so much for all the valuable information and links

@ko_grindz Місяць тому

I hope you find what you are looking for. You got this Julia

@tommyls4357 Місяць тому

I am also in New York and looking for a new job. I am currently employed though. You're right. The interviewing cycle for tech positions is brutal. Moreover, for every company the kind of preparation needed is different. For the last two months I've just been focusing on preparing for Meta, and I still don't feel confident. After this I'll try for other companies like Google, which will have it's own prep. The HR/Recruiter call ALWAYS goes well though! Haha. They are the best. Anyway, good luck. I cannot get myself to quit my job and look for a new one. So I mostly spend nights and weekends in preparing.

@aninditab57 Місяць тому

I've been watching your videos since September 2022 and I think this is likely my most favourite video from you yet. I have been on a break for 2 years and some change - mostly from COVID-induced health complications and then working on my mental health - and you've provided just simply fabulous ways to get started. Quick question: for the kaggle resources, is there a subscription involved or just creating a free account is enough?

@Ghost-sz7uo Місяць тому

dr. slump was so good! best k drama i've watched in a while.

@TimothyJoo Місяць тому

Love the video Julia! Esp the SQL and Python tips, they were really clear and straight to the point! Also I loved the recourses you gave as I didn’t know about them before the video!! keep it up and excited to see more of your videos / journey through job hunting in tech! 😁😵‍💫

@justlistenduh 27 днів тому

Random viewer but thanks for the SQL tips. I've been looking for SQL spaces to study so this was really helpful.

@selbimammetgulyyeva2349 29 днів тому

Your videos motivate me to study more, thanks 😊

@pranavtyagi1401 Місяць тому

thanks julia for sharing the prep material that you are using for your job hunt. also plz share material using for statistics , ML DL also. all the best

@mainwork5118 Місяць тому

Thank you for this video ❤

@pinkhope84 Місяць тому

Cheat days are more then just ok, they are imported from time to time ❤

@emilyb7752 Місяць тому

Wait putting plants in the sink is such a smart way to bottom water!!! I always put them in a bowl one at a time

@smkeong Місяць тому

Yeah 🎉 Julia good vlog 😊

@kaltoumrachdi2086 3 дні тому

your vidéo is so instructive

@its_jei Місяць тому

ALSO it's funny because I'm also making the braised pork dish today for lunch! I'm making the Cambodian version but both are very similar. I work remote so I just cook on my breaks. :D

@Aripoma 28 днів тому

Mode analytics sql tutorial is so amazing

@rebeccahelga32 Місяць тому

Your hair looked especially good in this video. Just wanted to say that😂❤🎉

@SyriusOLsh Місяць тому

Hi Julia! I came across and started watching your videos because I plan to take a gap year - and prayerfully I get a profitable business and a up and running UKposts channel by the end of it. I really enjoy your sharings and your house tour video is so inspirational because I am very messy with my room. I've also been "studying" your videos as I want to be a UKpostsr, and a small question (hopefully): how do you do the top-down angle video when you're cooking?

@santielewaut Місяць тому

Ive been using a lot of pyspark as well for big datasets, super intuitive and with lazy evaluation

@OGSweetMeat Місяць тому

Another great video!

@tajauberseri-ph3du 15 днів тому

loving this camera

@mix_348 Місяць тому

Hi Julia, another lovely vlog :) I have a question... I'm trying to pivot more into a business analyst role from a sales development role and I'm trying to create a portfolio of work which could showcase my data analytics skills. My current job does require us to analyse some numbers however we solely rely on internal systems so I'm trying to develop my skills using different platforms and languages out there rn. Does any one have advice on how one could create such a portfolio - i.e: in addition to the resources mentioned by Julia in this vid, are there good free resources out there that provide data that we could use to build such portfolio of work? or any advice in general when it comes to pivoting to such roles/building and showcasing technical skills would be much appreciated!

@lenali3149 Місяць тому

I love this video ❤ Would like to know what you studied in the college? How to find a job that you actually like?

@matt_cgy Місяць тому

Super interesting! 👏🏻

@lmhuyen1909 13 днів тому

Thanks for your sharing !!! 😁

@sasss7060 Місяць тому

most realistic useful videos around

@veronicavids Місяць тому

I appreciate your tips (:

@Rebellionrider Місяць тому

Believe me, Python with SQL has proven to be a powerful combination in my career.

@miguelv2985 Місяць тому

Just keep going. I know you will find your next gig!

@programmingtechnical6132 Місяць тому

I almost completed a course over Udemy for SQL and started with SQL 50 over LeetCode, currently just started doing 5 questions per day(same pinch).

@TheLeaveTaking Місяць тому

that is so interesting... in my country (due to demographic change and other reasons), data scientists/analysts etc. (tech people in general) are highly coveted, so I think finding a job would be much easier and less competitive than in NY

@Kreytonchild 29 днів тому

oh man, yeah. I got laid off last month. But yes, currently re-studying Python and SQL again (graduated from software developement last year in August, but haven't quite done much after). Will check out your videos soon.

@apurvsaha4648 Місяць тому

From my experiences i can tell you that to get a good software engineering job , it atleast takes upto 4-6 months as per todays job scenarios but this timeline is not necessary for everyone . Good Luck :)