How To Connect To Microsoft Azure SQL Database And Query Records Using Python

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 ม.ค. 2023
  • In this tutorial, we will learn how to connect to an Azure SQL Database and query records using Python.
    📺 Set up and create an Azure SQL Database: • Set Up Microsoft Azure...
    📑 Download latest ODBC driver: learn.microsoft.com/en-us/sql...
    ► Buy Me a Coffee? Your support is much appreciated!
    -------------------------------------------------------------------------------------------
    ☕ Paypal: www.paypal.me/jiejenn/5
    ☕ Venmo: @Jie-Jenn
    💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC
    ► Support my channel so I can continue making free contents
    ---------------------------------------------------------------------------------------------------------------
    🛒 By shopping on Amazon → amzn.to/2JkGeMD
    👩‍💻 Follow me on Linked: / jiejenn
    🌳 Becoming a Patreon supporter: / jiejenn
    ✉️ Business Inquiring: TH-cam@LearnDataAnalysis.org
    #azure #azuresql #sqlserver #python #azuredatabase

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

  • @DanielOliveira-qs2cm
    @DanielOliveira-qs2cm ปีที่แล้ว +1

    de todos os videos que eu já vi este foi o único que me ensinou, valeu cara🤚🤚

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

    Thank you for this. This helped my app designing

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

    that's helped me a lot. Thanks buddy

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

    Thanks for great video

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

    Great Video !

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

    Why did you change the interpreter path and which one should I use?

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

    How to use Azure DB using Managed Identity? Can anyone please guide me?

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

    I keep getting an error message: UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.

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

      Hi Antonio, your question is pretty specific. I would make a post on Stack Overflow or Google it first.

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

      Doesn’t look like you have the sql alchemy library installed

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

    Where can i find the username & password in azure portal 😢

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

      You don't need username and password, just client secret is sufficient.

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

      Where can I find it?
      But in credential file u entered username & password right...

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

      Oh I see. You haven't set up your instance I presume? I would recommend you refer to this video first th-cam.com/video/-jrj6difTp4/w-d-xo.html