Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)

แชร์
ฝัง
  • เผยแพร่เมื่อ 11 พ.ย. 2024

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

  • @dc3295
    @dc3295 9 วันที่ผ่านมา +1

    she is a great teacher, so clear in her explanations and examples

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

    The best comprehensive introduction to SQL!

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

      Glad you enjoyed it!

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

    This is so enjoyable. The JOIN in SQL seems so much better than what power query would do to join tables

  • @ChampCode
    @ChampCode 28 วันที่ผ่านมา +1

    Thank you for that clear explanation of the group by clause. :) New sub here!

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

    Hi Alice,
    What a great video! I love this bite-size video pack with a lot of nutrients.
    I will definitely check the Restaurant Order project.

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

    Thank Alice 👍 You taught everything is easy to understand. Please publish more advanced courses about SQL in the future.

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

      Glad to hear that! We have an Advanced SQL course (mavenanalytics.io/course/mysql-advanced-queries) coming out in the next few months. Stay tuned!

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

      @@MavenAnalytics Yes, sure, I still wait to join

  • @JustinLo878
    @JustinLo878 19 วันที่ผ่านมา

    Thank you! Learnt so much in such a short amount of time!

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

    Bite-sized and digestible as usual. Thanks Alice!

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

    This was such a good SQL intro! SQL beginner here.

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

      Glad you enjoyed it. Welcome to the world of SQL!

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

    This is an amazing introduction to sql
    You Rock
    You made it look so easy

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

      Thank you! With a bit of practice, it'll feel just as easy for you. 🙂

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

    Wow, all the years of learning sql and I learnt more in these few minutes

  • @MuriLanval
    @MuriLanval 6 วันที่ผ่านมา

    Great work!

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

    Zhao, how do i get more of ur content? I really enjoy listening to you because i get to understand things quickly.

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

      You can find Alice's other videos on the Maven Analytics TH-cam homepage such as these:
      - SQL guided project: th-cam.com/video/JaUKDbCXMX4/w-d-xo.htmlfeature=shared
      - SQL window functions: th-cam.com/video/rIcB4zMYMas/w-d-xo.htmlfeature=shared
      On the Maven Analytics platform, you can find Alice's courses on:
      - Data science in Python: mavenanalytics.io/online-data-analysis-courses?order=release_date%2Cdesc&instructors=Alice+Zhao
      - Advanced SQL (coming soon!): mavenanalytics.io/course/mysql-advanced-queries

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

      @@MavenAnalytics Yes, thanks so much. I have seen the restaurant project and I am anticipating the advance sql video.

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

    Thank you!

  • @andrewjohnson4352
    @andrewjohnson4352 6 วันที่ผ่านมา

    Completely lost. I have MySQL downloaded from the link and have the files from the website. I can see the data in the MySQL workbench window but the lightning button is greyed out.

    • @MavenAnalytics
      @MavenAnalytics  5 วันที่ผ่านมา

      From the link, you'll have downloaded MySQL Workbench (dev.mysql.com/downloads/workbench/), which is a SQL editor.
      In addition, you'll need to download MySQL (dev.mysql.com/downloads/mysql/), which sits behind the SQL editor and actually executes the SQL code. During the installation process, you'll be asked to set a password. Note down the password.
      Next, you'll have to connect MySQL and MySQL Workbench. You can do this by opening MySQL Workbench, and if you double click on the box below MySQL Connections, you'll be prompted for a password, and you can enter in the password you set earlier.
      You'll now be able to open up a new query tab, and at this point, the lightening bolt should no longer be grayed out. You can now run the code from the project files and practice writing SQL queries on your own.
      As an alternative, if you don't want to go through all the installs, you can also practice writing SQL code in the browser with a website like sqliteonline.com/

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

    Have you in program to publish a video regarding the CASE WHEN?…

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

      We cover that in our MySQL Data Analysis course (mavenanalytics.io/course/mysql-data-analysis), but will also add it to our TH-cam video requests list. Thanks for the suggestion!

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

    And also how do i get ur SQL pocket guide?

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

      You can find the SQL Pocket Guide, 4th Edition on Amazon and other online book shops.

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

      @@MavenAnalytics thank you so much

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

    The best comprehensive introduction to SQL!