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

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

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

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

    The best comprehensive introduction to SQL!

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

      Glad you enjoyed it!

  • @dc3295
    @dc3295 22 วันที่ผ่านมา +2

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

  • @hasnat6976
    @hasnat6976 5 วันที่ผ่านมา +1

    Bro, I am gonna share this video to my friends who didn't study for the exam after 2 hours . Hats off to you

  • @osvaldo81
    @osvaldo81 3 ชั่วโมงที่ผ่านมา

    Thanks for this amazing instruction, lady :)

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

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

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

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

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

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

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

    Bite-sized and digestible as usual. Thanks Alice!

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

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

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

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

  • @carlosserra1588
    @carlosserra1588 2 หลายเดือนก่อน +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.

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

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

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

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

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

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

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

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

    • @MavenAnalytics
      @MavenAnalytics  2 หลายเดือนก่อน +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 2 หลายเดือนก่อน

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

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

    Great work!

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

    Thank you!

  • @momohtimothy6898
    @momohtimothy6898 2 หลายเดือนก่อน +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 หลายเดือนก่อน +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 2 หลายเดือนก่อน

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

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

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

    • @MavenAnalytics
      @MavenAnalytics  2 หลายเดือนก่อน +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!

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

    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  18 วันที่ผ่านมา

      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/

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

    And also how do i get ur SQL pocket guide?

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

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

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

      @@MavenAnalytics thank you so much

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

    The best comprehensive introduction to SQL!