186,201 views
CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE PYTHON COURSE: https://lp.hashtagtreinamentos.com/es... TO DOWNLOAD THE FREE SQL MINI COURSE: https://excelparaestagio.klickpages.c... ----------------------------------------------------------------------- ► Files Used in the Video: https://pages.hashtagtreinamentos.com... ► PyCharm Installation Video: • How to Install PyCharm on Windows - ... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/i... ----------------------------------------------------------------------- Today I'm going to show you how to integrate Python and SQL for you who need to update your database or pull information from that database to do your analysis! First I'll show you how to create a database in SQL so that you who don't have any can practice and understand in the same way. Once the database has been created, we can now move on to integrating Python and SQL, and we'll do this with the pyodbc library. To write our code, I'll use the Python editor PyCharm (in the description, there's a link to a video explaining the step-by-step download process). You'll see that integrating SQL with Python is a very simple code, but if you want to give more commands to your database, it's important that you know the programming language so that you can give the commands correctly. So, are you curious to know how to integrate Python with SQL and start automating and analyzing data by pulling it directly from your database? ----------------------------------------------------------------------- Hashtag Programming ► Subscribe to our channel: http://bit.ly/3c0LJQi ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► Blog: https://bit.ly/2MRUZs0 ► YouTube: http://bit.ly/3c0LJQi ► Instagram: https://bit.ly/3o6dw42 ► Facebook: http://bit.ly/3qGtaF2 Here in the videos on the Hashtag Programação channel we teach several Python tips so that you can develop in this programming language! ----------------------------------------------------------------------- #python #hashtagprogramacao