I learned SQL for data analytics in 15 days | From Scratch

แชร์
ฝัง
  • เผยแพร่เมื่อ 9 เม.ย. 2023
  • Learn : • SQL Full Course | SQL ...
    Learn : th-cam.com/users/liveLGTbdjoE...
    W3 school : www.w3schools.com/sql/
    Practice : www.sql-practice.com/
    Practice : www.hackerrank.com/domains/sql

ความคิดเห็น • 394

  • @ritabratagoswami7724
    @ritabratagoswami7724 ปีที่แล้ว +469

    Revise all the topics of SQL from W3school everyday and practice Hackerrank. In hackerrank i solved 48 questions out of 55 or 57 questions (i guess🙄). But unable to solve those 9 question coz they r hard category. Not easy to understand and not easy to solve and i do 10a.m-10p.m job so no time hv! The main thing that everyone must focus on sql is window functions, SP, CTE, PIVOT, TRIGGERS and Insert/update or Mearge statement. This are the actual things that industry ask u to solve or explain during interview.

    • @ArpitSharma-kk9tl
      @ArpitSharma-kk9tl ปีที่แล้ว +30

      People think SQL is easy straight forward, I solved most of question for leetcode, HacherRank but still I didn't know SQL properly, basics are easy to catchup in few hours not even in 15 days. But solving and implementation take time

    • @ManojKumar-hy8wc
      @ManojKumar-hy8wc ปีที่แล้ว +27

      @@ArpitSharma-kk9tl True. If you had learnt sql in 10 days then you will be thrown out of the organization in 10 days.

    • @ManojKumar-hy8wc
      @ManojKumar-hy8wc ปีที่แล้ว +8

      @@ArpitSharma-kk9tl Check data lemur and strata scracth too. If you are good at Window functions, CTE's, Joins, Regex in sql, case statements, inbuilt functions and set operations then you can give it a shot.

    • @ArpitSharma-kk9tl
      @ArpitSharma-kk9tl ปีที่แล้ว +1

      @@ManojKumar-hy8wc let me try

    • @reddysekhar.sripathi415
      @reddysekhar.sripathi415 ปีที่แล้ว +2

      @@ManojKumar-hy8wc 🤣🤣🤣

  • @prashantkadam8758
    @prashantkadam8758 ปีที่แล้ว +44

    I like the last line.. nothing will work immediately but surely after sometime. Kudos to you for doing things in a such better way.

  • @kartik-sagarcreation9519
    @kartik-sagarcreation9519 ปีที่แล้ว +32

    you are just amazing👌..please keep sharing inspiring videos like this.....
    your humility is present in your voice🙂..
    the day is close when you'll have millions of subscribers..🎉🎉

  • @souperyummie
    @souperyummie ปีที่แล้ว +5

    this is amazing. thanks for the wonderful info. very short, crisp and to the point info.

  • @alwaysleasinginc1251
    @alwaysleasinginc1251 ปีที่แล้ว +5

    This is a great way to start…will wait on more videos…hopefully you will share tips to learn power bi, python and etc

  • @akashverma1640
    @akashverma1640 ปีที่แล้ว

    Thanks for the roadmap and resource sharing.

  • @aksvlog5092
    @aksvlog5092 ปีที่แล้ว +6

    Links are very useful for me to practice. Hope ill also get this role soon

  • @driptodas986
    @driptodas986 ปีที่แล้ว +2

    Thnx for the guide. I just started practicing sql from w3school only. Will try harder problems from now on.

    • @kashishagarwal8191
      @kashishagarwal8191 2 หลายเดือนก่อน

      Did u start watching the playlist along with website?

  • @anupsakhare
    @anupsakhare ปีที่แล้ว +3

    nice ... Thanks for your guidance!

  • @kezeiah3644
    @kezeiah3644 ปีที่แล้ว +1

    thank you so much for sharing this

  • @akshaypradhan40
    @akshaypradhan40 ปีที่แล้ว +6

    Thnx a lot Saumya for this short trick to learn SQL rapidly..could u provide the hand written notes that u made in .🙏🙏🙏

  • @mounikavarma1176
    @mounikavarma1176 ปีที่แล้ว

    Nothing will work immediately but surely it will workout. Thanks for the motivation

  • @apamwamba
    @apamwamba 11 หลายเดือนก่อน +64

    Truth is that basics of SQL can be covered in as little as a week or less. But mastering SQL at a professional level takes years of practice.

    • @nextgenerationgems
      @nextgenerationgems 6 หลายเดือนก่อน +1

      Very well said.

    • @kashishagarwal8191
      @kashishagarwal8191 2 หลายเดือนก่อน

      Can you please tell me that while learning with W3School I should watch yt video along with website content?

    • @sameerkulkarni6445
      @sameerkulkarni6445 หลายเดือนก่อน

      ​@@kashishagarwal8191 yess you can it will help you

  • @muneebahmed9280
    @muneebahmed9280 ปีที่แล้ว

    Great content and congratulations!

  • @kelvinsharma2056
    @kelvinsharma2056 ปีที่แล้ว +4

    Great video Saumya!
    Please make videos on other skills as well
    Thank you :)

  • @raiyanjiyon5475
    @raiyanjiyon5475 10 หลายเดือนก่อน

    Very informative. Thank you.

  • @chigozie3950
    @chigozie3950 ปีที่แล้ว +1

    Thanks a lot for this video ❤

  • @ashv2745
    @ashv2745 ปีที่แล้ว +30

    Great to know about SQL! Waiting for next skills from you. Thank you❤

    • @techiesaumya
      @techiesaumya  ปีที่แล้ว

      More to come!

    • @Shahid98
      @Shahid98 ปีที่แล้ว

      ​@@techiesaumyama'am aap India ke bahar work karti ho kyaa.. ?? Plz speak little hindi also

    • @ADabtU
      @ADabtU ปีที่แล้ว +1

      Same here. Head First SQL is good one to begin with.

    • @princekhan692
      @princekhan692 ปีที่แล้ว

      @@techiesaumya for which institute is best for learning data analyst

    • @zaikabaaz
      @zaikabaaz ปีที่แล้ว +1

      chal jhuthi

  • @pspkchannel
    @pspkchannel ปีที่แล้ว +1

    thank you ma'm giving this information about sql in this video really helpfull for us keep doing i 'm always support your channel your explanation is really pretty good

  • @pavik7576
    @pavik7576 ปีที่แล้ว

    Thank you for the video ❤

  • @aravindshiva803
    @aravindshiva803 ปีที่แล้ว

    Short and sweet. Keep it up

  • @newyork_life_travel
    @newyork_life_travel ปีที่แล้ว +13

    Thanks for the great information. I am also Data Analyst in the US and am still learning many things. :)

    • @ParshuRam-ey6iz
      @ParshuRam-ey6iz ปีที่แล้ว +1

      plz share ur mail.

    • @ankushstories-fight2win151
      @ankushstories-fight2win151 11 หลายเดือนก่อน

      Hey buddy.. I am working in non tech and want to move data analyst... Pls share your journey

    • @deeppatel4002
      @deeppatel4002 8 หลายเดือนก่อน

      Can I get Your LinkedIn sir plz ?

  • @deeptisoni5294
    @deeptisoni5294 ปีที่แล้ว +7

    you boosted my moral ....thankyou so much❣

  • @avalanaresh2267
    @avalanaresh2267 ปีที่แล้ว

    You given best information...thanq

  • @Shil_theangrybird
    @Shil_theangrybird ปีที่แล้ว +3

    Thats really kind of you to share entire details. canyou take class for noob like us so that we can land into data analytic job role?

  • @pramodsitaprao4186
    @pramodsitaprao4186 ปีที่แล้ว +1

    Superb, keep it up, hats off, keep it up. Keep motivating us. 🎊🎉🎉💃🕺🙏👏👏🔥🔥

  • @ganeshnangalot2383
    @ganeshnangalot2383 ปีที่แล้ว +2

    Thanks for making this video

  • @santoshkiran5858
    @santoshkiran5858 ปีที่แล้ว

    Gradually I got inspired by you
    I'm going to apply same method

  • @magtulunganpinoy5597
    @magtulunganpinoy5597 4 วันที่ผ่านมา

    this video gives me motivation as a beginner. New sub here from the Philippines 😍🥰

  • @KulwinderKaur-kd3bk
    @KulwinderKaur-kd3bk ปีที่แล้ว +6

    Thanks Saumya , this video is was what I looking for. Please make a video on SQL projects / Projects fro resume as a FResher .

  • @idyumana3775
    @idyumana3775 ปีที่แล้ว +1

    Thank you Chie❤

  • @navneethparthasarathy8395
    @navneethparthasarathy8395 ปีที่แล้ว

    Thank you so much for sharing

  • @arjunsaini9725
    @arjunsaini9725 11 หลายเดือนก่อน

    thanks for practice website. I was looking for something like that.

  • @sampathkumar7570
    @sampathkumar7570 ปีที่แล้ว

    Very informative video 👌🏻❤️ Subscribed your channel 👍🏻

  • @Sofia96640
    @Sofia96640 11 หลายเดือนก่อน +5

    Maam you are the best person i have seen on TH-cam who is motivating so much in the journey of being a data analyst please keep making such type of informative videos...they are really really helpful thank you so much...!

    • @techiesaumya
      @techiesaumya  11 หลายเดือนก่อน +1

      Thanks a ton

  • @keerthana15
    @keerthana15 หลายเดือนก่อน

    Thank you for your information thank you

  • @bhaskarsharma7815
    @bhaskarsharma7815 ปีที่แล้ว +3

    Exactly what I was looking for
    Thanks a lot.

    • @techiesaumya
      @techiesaumya  ปีที่แล้ว

      Glad it helped

    • @bhaskarsharma7815
      @bhaskarsharma7815 ปีที่แล้ว

      @@techiesaumya would be very helpful if you could make a video on how really to find a job after learning sql.

  • @PankajMani
    @PankajMani ปีที่แล้ว

    Valuable information👌

  • @him727
    @him727 11 หลายเดือนก่อน +1

    Thanks for sharing 🙏

  • @gayu6369
    @gayu6369 ปีที่แล้ว

    You said you were attend 30 interviews that was really inspired me a lot

  • @SunnyGupta00
    @SunnyGupta00 ปีที่แล้ว

    I learned in 2 days :) thanks for links

  • @aksvlog5092
    @aksvlog5092 ปีที่แล้ว +2

    Great thanks for sharing your journey it motivates us Saumya 👍👍👍👍

  • @sanidhabhaskaran9347
    @sanidhabhaskaran9347 ปีที่แล้ว +3

    Hello. Thankyou for sharing your experience and motivation.
    What's the salary range one can expect while starting as a fresher in data analytics and self-taught in SQL.

  • @sureshkohar8230
    @sureshkohar8230 ปีที่แล้ว +2

    You are soo intelligent madam

  • @astrology_course
    @astrology_course ปีที่แล้ว

    Great Video. Thanks mam.

  • @SanjeevSingh-ep9hu
    @SanjeevSingh-ep9hu หลายเดือนก่อน

    I think , she is enough hardworking as well as 360 talented personality 😊

  • @mr_bornrider_07
    @mr_bornrider_07 ปีที่แล้ว +9

    It was very much usefull, did u do any projects based on that ? bcse for freshers they are asking nd i have started applying, so do u have any suggestion for me on how to prepare for an interview and On which tools they ask more questions(sql, bi, excel or python) it would be very much usefull if u could answer.

  • @ManojKumar-kb7cm
    @ManojKumar-kb7cm ปีที่แล้ว

    Helpful resources ❤

  • @Bk-cs1nr
    @Bk-cs1nr ปีที่แล้ว

    Thanks keep updating ..

  • @anuradha97580
    @anuradha97580 ปีที่แล้ว +1

    Love your videos Saumya. Best of luck 😘

  • @mhasannazari7450
    @mhasannazari7450 ปีที่แล้ว

    Useful video thanks

  • @piyushpant3382
    @piyushpant3382 8 หลายเดือนก่อน

    Thank you ma'am🙏

  • @akshaychaurasiya1309
    @akshaychaurasiya1309 ปีที่แล้ว +4

    can you please share what skills in SQL is required for data analyst.

  • @sofiaa5255
    @sofiaa5255 ปีที่แล้ว

    Thank you so much

  • @Random_Guy_Bharatwale
    @Random_Guy_Bharatwale ปีที่แล้ว

    You just got the views
    Cheers

  • @addgroup8250
    @addgroup8250 11 หลายเดือนก่อน

    such a amazing video

  • @plabanijena1306
    @plabanijena1306 4 หลายเดือนก่อน

    genuine women with truth and struggle in her eyes...i can notice that❣

  • @mrinalmondal1890
    @mrinalmondal1890 ปีที่แล้ว +3

    Soumya, please guide us all how you have mastered all the necessary skills from free resources and provide required links below description..... waiting for your next similar videos...

  • @sukhpreetsinghlohiya5182
    @sukhpreetsinghlohiya5182 ปีที่แล้ว +15

    Hi saumya my name is sukhpreet and iam a BCA last year student , Can u please make a video on a day in your life as a Data Analyst ,that what work you do ,On which tools are u working with n all . It will be really benificial for us

    • @techiesaumya
      @techiesaumya  ปีที่แล้ว

      I will

    • @aena5995
      @aena5995 ปีที่แล้ว

      ​@@techiesaumya is business data analytics worth studying

  • @shaziamohdsajimshagufta65
    @shaziamohdsajimshagufta65 11 หลายเดือนก่อน

    Thank you mam!

  • @gamersk260
    @gamersk260 ปีที่แล้ว +2

    Hi mam, I have already learner SQL from Udemy, is it necessary to learn excel then where it should be learn from? please reply I have watched and like every video from you.

  • @susheelkharat5122
    @susheelkharat5122 ปีที่แล้ว +2

    Thanks for video, please make a video on Power BI and Talbeau

  • @himanshukashyap8281
    @himanshukashyap8281 ปีที่แล้ว +1

    Please answer below question:
    empid, manager id, emp name
    find emp name , nth manager (eg 2nd manager is manager of manager)

  • @perfectionist6624
    @perfectionist6624 ปีที่แล้ว +2

    Mam, it's only basic.
    But in actual work we have difficult tasks.
    How we can prepare ourselves ready to face difficult SQL tasks..and be hardcore knowledge on SQL

  • @criatvEngineer
    @criatvEngineer ปีที่แล้ว +2

    Thank You Didi .. for such amazing content ! Gulabi Dil ❤️ Gulabi Dil ❤️🙏

  • @rajendraprasadpatil
    @rajendraprasadpatil ปีที่แล้ว +38

    Wow, you mastered SQL in just 15 days? You must be some kind of prodigy! It's not like people spend years studying and practicing to master it or anything. Looking forward for you to finish PhD in 2 months, and please share the progress.

    • @sharad3877
      @sharad3877 11 หลายเดือนก่อน +4

      She has not even shared her LinkedIn profile....I don't think she is genuine 😅

    • @alvinfernandes4078
      @alvinfernandes4078 9 หลายเดือนก่อน +5

      The video clearly says “learned sql in 15 days” not mastered.

    • @JohnPauloFigueroa
      @JohnPauloFigueroa 9 หลายเดือนก่อน +3

      You can learn SQL in 2weeks if it is beginner to intermediate but if it is a higher level, it takes months to years

    • @aadhavan7859
      @aadhavan7859 7 หลายเดือนก่อน +2

      another random person in the comment section to mock people

    • @bullet4922
      @bullet4922 7 หลายเดือนก่อน +1

      Extremely poor understanding skills

  • @suyogpatil9584
    @suyogpatil9584 ปีที่แล้ว +1

    If u get good teacher u can learn it in 1 day.

  • @maheshk9229
    @maheshk9229 ปีที่แล้ว +3

    Hi Soumya Thank you for the information its very useful to learn SQL.. Could you please prepare for DevOps Course same like this like free learning and free practicing websites

  • @user-kb4xb1uk4r
    @user-kb4xb1uk4r 2 หลายเดือนก่อน

    I would love to have a book that helps me couples with a practical 🙏

  • @ganeshnangalot2383
    @ganeshnangalot2383 ปีที่แล้ว +2

    Please make more videos like and then make one more video on how to apply for data Analytics job at the end

  • @kashyapnath592
    @kashyapnath592 ปีที่แล้ว +1

    I learned in 12 days. I know one of my friend who learned in 8 days. It's do able.

  • @preciousokocha1705
    @preciousokocha1705 ปีที่แล้ว +2

    I learnt SQL in 10days. I love SQL

  • @PawanJaiwar-kg1lf
    @PawanJaiwar-kg1lf ปีที่แล้ว

    thank u motivational video

  • @ifeanyinwobodo8530
    @ifeanyinwobodo8530 ปีที่แล้ว

    Where do you advice to get inspiration for projects?

  • @u_o_m_i
    @u_o_m_i ปีที่แล้ว +2

    And, what about the POWER BI...?

  • @kameshsharma5164
    @kameshsharma5164 3 วันที่ผ่านมา

    Very Helpful video
    Can you please share the same practising plate form for advance excel.
    Actually W3school gives very easy question as you said.
    Please reply

  • @vinodvihariji2183
    @vinodvihariji2183 11 หลายเดือนก่อน

    # Mastering SQL takes time, at least couple of months........within 15 days can be learned some basic concepts but the ability to solve questions on platform like leetcode need more times..........

  • @ExactFacts-nl8ku
    @ExactFacts-nl8ku 11 หลายเดือนก่อน

    "Dimple girl" nicely explain

  • @devanshshandilya7067
    @devanshshandilya7067 ปีที่แล้ว

    thankyou so much

  • @AkashKhandekar777
    @AkashKhandekar777 ปีที่แล้ว

    Which tool is used most for data analytics

  • @jyotidixit1121
    @jyotidixit1121 ปีที่แล้ว +1

    Can be survive in data analyst field without knowing python or any programming language

  • @fambruh3319
    @fambruh3319 7 หลายเดือนก่อน

    What are the most imp skills required for data analytics?

  • @igSololeveling
    @igSololeveling ปีที่แล้ว

    Can you make all the video on SQL Excel power bi learn fast

  • @shankshimself
    @shankshimself ปีที่แล้ว

    I did all my subjects in one night before exams ... I failed in most. I somehow topped in Databases.

  • @Prakash-qu5qv
    @Prakash-qu5qv ปีที่แล้ว +1

    How am i to get a certification for it?

  • @saumyajoshi-ym2os
    @saumyajoshi-ym2os ปีที่แล้ว +2

    Any plan for freelancing in future?

  • @hRvlogs921
    @hRvlogs921 ปีที่แล้ว +2

    Please discuss about the number and types of projects that should be
    included in resume as a fresher for data analyst.

    • @techiesaumya
      @techiesaumya  ปีที่แล้ว +2

      Sure

    • @big_youtuber
      @big_youtuber ปีที่แล้ว

      ​@@techiesaumyayeah please also tell us about internship

  • @praveenpraveen-zu8gt
    @praveenpraveen-zu8gt ปีที่แล้ว

    Share your experience...😊

  • @sukanyaaditya
    @sukanyaaditya ปีที่แล้ว +6

    Thank you, can you please tell me how you prepared power bi, tableau, python from which source?

    • @hnsri94
      @hnsri94 ปีที่แล้ว

      For me also

  • @decebreezemen7320
    @decebreezemen7320 ปีที่แล้ว +1

    I spent literally 3 days & i just know one thing that by tapping 2 times left mouse button, it opens😂

  • @BHARATHEEYUDU.
    @BHARATHEEYUDU. 11 หลายเดือนก่อน

    Column sum (vertical sum) for multiple columns diffrent names please explain

  • @vinaym2974
    @vinaym2974 หลายเดือนก่อน

    Hi there, Thank you for the detailed video. did you do any certification in SQL? Kindly suggest any certifications if you have come across for IT professional . Thank you

  • @swatidas7069
    @swatidas7069 ปีที่แล้ว +1

    Please make video from where you have learned power bi and tableu

    • @techiesaumya
      @techiesaumya  ปีที่แล้ว

      Will share this video by Saturday

  • @MuhammadUmairShaykh
    @MuhammadUmairShaykh 2 หลายเดือนก่อน

    Great 🎉

  • @sun2020able
    @sun2020able ปีที่แล้ว +1

    Good one

  • @rahulk3209
    @rahulk3209 ปีที่แล้ว

    Power bi vs Qlik sense
    Which is better?

  • @shafik7043
    @shafik7043 8 หลายเดือนก่อน

    What is will be the starting package for fresher?

  • @shrimantpradhan7860
    @shrimantpradhan7860 ปีที่แล้ว

    I have done BA in English hons in 2022
    How is it ? should I get into this

  • @akshaysha51
    @akshaysha51 ปีที่แล้ว +5

    Can you make a video in Excel? Where to learn and practice

  • @biswamohandwari780
    @biswamohandwari780 ปีที่แล้ว +4

    I learnt all the data structures and also in 12 days. Also I learned SQL in 3 hours from a TH-cam video

    • @ajinkyaladhe
      @ajinkyaladhe ปีที่แล้ว +1

      Man you are a beast 😅

    • @luckydubey5862
      @luckydubey5862 8 หลายเดือนก่อน

      That's simply not possible💀

    • @biswamohandwari780
      @biswamohandwari780 8 หลายเดือนก่อน

      Also I got placed at Amazon and laid off from Amazon. 😎 now an ex-Amazonian