SQL for data Analysis 101.1 | Basics Data Extraction and Aggregation

Поділитися
Вставка
  • Опубліковано 17 лис 2024

КОМЕНТАРІ • 56

  • @aninditamitra8240
    @aninditamitra8240 3 роки тому +44

    Hi Anastasia, This is brilliant! Could you please also make a video like how data analyst uses Python apart from SQL, Tableau in day to day work

  • @ibrahimbadr4327
    @ibrahimbadr4327 2 роки тому

    this is the beautifulest thing I've seen for a while

  • @astronemir
    @astronemir 2 роки тому +1

    Have you thought of running a short boot camp or online skill boosting class in Sweden? Because you are a great lecturer, not wasting time on BS, speak clearly and simply, and you are really good at communicating information. This video was really valuable as a short refresher. Thanks for sharing!

  • @MelanieAlmeida12
    @MelanieAlmeida12 Рік тому

    Thank you for the video, Anastasia!

  • @rban123
    @rban123 3 роки тому +2

    this is so intersting to me as a software engineer who works a lot with databases but from a very different perspective. mostly i work on the IaaC stuff and backend to keep the databases up and running and i spent a lot of time working on designing the database schemas in SQL and deployment pipelines surrounding them and I thought I was pretty good at SQL but from watching your video I realize I am not so good at writing queries haha

  • @bonzolijo
    @bonzolijo 3 роки тому +5

    Hi, just found you channel, its great and at the moment underrated...

  • @anuprai9129
    @anuprai9129 3 роки тому +3

    I like the way you are sharing useful knowledge. I hope you will share some more videos like this.

  • @glstnlev
    @glstnlev 2 роки тому

    Please keep doing videos like this! It’s priceless

  • @cristinaaguilar7877
    @cristinaaguilar7877 3 роки тому

    Wooow! I love your videos, I’m BI Developer and I want to be a Data Scientis 🤘🏻👩🏻‍💻

  • @mzhr72
    @mzhr72 3 роки тому

    Very soothing music in the background, it's a thumbs up for this video!!

  • @seyramadubah-asante9942
    @seyramadubah-asante9942 3 роки тому +1

    Very useful video

  • @ashenwizard8953
    @ashenwizard8953 3 роки тому +1

    This is very helpful Anastasia. I genuinely appreciate your content.

  • @Huss411
    @Huss411 3 роки тому +2

    Hi Anastasia, your videos are top notch 👌 Hoping that you will please do more if possible in the future 🙏

  • @digigoliath
    @digigoliath 3 роки тому

    Nice! TQVM!! I am not new to SQL but you have a new subscriber!

  • @SuperBookMonkey
    @SuperBookMonkey 3 роки тому

    Very useful! I look forward to more videos.

  • @ronaldagamaescobedo3980
    @ronaldagamaescobedo3980 3 роки тому +1

    I love the way you explain. Could you please make more videos like this maybe explaining how to get the new users?
    Greetings from Perú 🇵🇪

  • @priyankjetani1508
    @priyankjetani1508 3 роки тому +1

    yes, this is very help full video... I am Data Science Student and also I have that type of quotation in my mind about SQL and Database. it's good for me.. thanks for making that type video... Great practical stuff.. thank to you.

  • @medeirov
    @medeirov 3 роки тому +4

    This is a very nice video. Enjoyed the pacing of it and the "examples" of those basic notions. Great stuff!

  • @himanshumishra6991
    @himanshumishra6991 3 роки тому

    Great practical stuff that will help anyone who is preparing for an SQL related interview with real time basic as well as important queries for a product based organisation 👍.

  • @alfredopr923
    @alfredopr923 3 роки тому +1

    Great video. Thank you so much for the dedication you put into each video. I am currently a student in Data Science and your videos are really helpful. Wish you the best.

  • @rmanamuli6732
    @rmanamuli6732 2 роки тому

    Hello, great video,... any recommendations about a tutorial to learn?

  • @Nicephore
    @Nicephore 2 роки тому

    Cool video, I like your way of breaking things down. I just hope you'll be able to do more in-depth tutorials soon.

  • @hasanmougharbel8030
    @hasanmougharbel8030 2 роки тому

    Hey dear, god bless your efforts in this channel.
    I have a general enquiry as a new sql learner.
    How could i create a pipeline to extract and load data from existing accounting program into our SQL server instances.
    How can i know if the export mechanism in the software permits me to undertake this extraction process, and how can i know if an application have an api?
    Thanks for taking care of my enquires.
    Looking forward to gain more knowledge from you.

  • @divewithdatascience
    @divewithdatascience 3 роки тому +4

    Nice and informative video and bring more stuff like this , I am preparing for Data Science, your this video of SQL helped me a lot today. Thank you! Stay safe!

  • @alifiaz7792
    @alifiaz7792 3 роки тому

    Very well. In future vids please consider addressing SQL queries optimization.

  • @raiyazkhan1837
    @raiyazkhan1837 2 роки тому

    Hi, excellent video! What song did you use in the background?

  • @scharlesworth93
    @scharlesworth93 3 роки тому

    She speaks truth. LISTEN.

  • @scharlesworth93
    @scharlesworth93 3 роки тому +2

    'SQL is intergalactic dataspeak' - the man Michael Stonebraker

  • @martyboer9740
    @martyboer9740 2 роки тому

    great vid

  • @den2isa388
    @den2isa388 3 роки тому

    Great video!!! btw, what music is this? I like your music choice too :)

  • @tigerrx7
    @tigerrx7 2 роки тому

    Is that how you start your projects? In the text file detailing what you are targeting and the tables you intend to use to achieve the questions? I know it’s a simple question but I’m learning your habits and I like it. I have a bad habit of keeping stuff in my head til after I do my search.

  • @lauradayanadiaz6669
    @lauradayanadiaz6669 3 роки тому

    Thanks for share

  • @raimundoneto4224
    @raimundoneto4224 3 роки тому

    even not being able to understand the half I liked it a lot.
    Thak you.

  • @ikeslo
    @ikeslo 3 роки тому +1

    It would be great if we could follow by doing the exercise too... [ include files ]. Other than that, great video demo.

  • @maclanfonseka5021
    @maclanfonseka5021 3 роки тому

    Thank you very much for this much useful video! ✌🏾

  • @mightynathaniel5355
    @mightynathaniel5355 3 роки тому

    ⚡🙌 Excellent presentation

  • @MO-fo7on
    @MO-fo7on 3 роки тому

    Hi .
    How were you able to get your bigquery to suggest functions as you type like excel?
    Mine doesn't.

  • @Nedwin
    @Nedwin 3 роки тому

    Nice one! Cheers...

  • @kalyanreddy6260
    @kalyanreddy6260 3 роки тому

    How can we show the analysed data in a nee sheet for presentation in sql . Sql is to o run only quarry i mean it wont save in my orginal data what ever i have run and analysis done through quary

  • @matthew_brown
    @matthew_brown 3 роки тому

    I just created a Db using 8 excel spreadsheets with 1M rows and 70+ columns.
    Now My Db structure is 1 table with 77 columns.
    Is this correct or should I have 77 tables?
    I am learning all of this on the fly.

  • @englishbro7436
    @englishbro7436 3 роки тому

    This is a fantastic video! Thanks ☺ Aren't you from a Russian speaking country by any chance?

  • @Dev-Phantom
    @Dev-Phantom 3 роки тому

    love it

  • @yayitsmelody4948
    @yayitsmelody4948 3 роки тому

    loved it!!!!!

  • @imsal1
    @imsal1 Рік тому

    Hi Anasthasia do you teach data analysis? I’m interested to learn in case if you do.

  • @joswarbellidorosas3956
    @joswarbellidorosas3956 3 роки тому

    Love it!

  • @91chaves
    @91chaves 3 роки тому +3

    is there any SQL "dialect" you would recommend? MySQL, SQLite, PostgrSQL, etc.
    And can't you just simply connect R or Python to the Database? I was trying to do that on my internship, but I never had the chance to finished that mini-project.
    Because data manipulation with tidyverse is a whole other thing :)
    Great videos, keep it up!

    • @diegombt
      @diegombt 3 роки тому

      SQL is supposed to be an "Standard", just go ahead and learn the basics, in the road you'll find some differences between engines.
      By the way, some relational engines supports Python as an extension, for example SQL Server form Microsoft. Greetings

    • @EminentJade
      @EminentJade 3 роки тому

      mysql is gd, i have learnt all the basic using it.

  • @deepaknikhil6593
    @deepaknikhil6593 3 роки тому

    hi Anastasia, I want to do masters on data analytics .so which course i have to study for data analyst. And is AI is suitable? because so many universities are offering this course

    • @cyrilfofana7678
      @cyrilfofana7678 3 роки тому +1

      Have a look at Coursera for Data Analytics and Data Science offered by Google and IBM respectively.

  • @КириллЯрусов-ш3ы
    @КириллЯрусов-ш3ы 3 роки тому

    Vnature chetko, Anastasia)

  • @PinoMancinelli
    @PinoMancinelli 3 роки тому

    brava, bella e simpatica...ci sarebbe un modo per ricavare le dipendenze tra variabili in SQL? grazie

  • @yunes7305
    @yunes7305 3 роки тому

    🙂 👍

  • @BhanuPratap-fc5rn
    @BhanuPratap-fc5rn 3 роки тому

    I want to learn and I will but your voice is distracting the process 🤩

  • @christianmoreno7390
    @christianmoreno7390 2 роки тому

    you have such a beautiful energy girl