Practical Analysis with SQL Server and Python

Veröffentlicht am: 02 Juni 2023
auf dem Kanal: Hashtag Programação

16,794

728

Want to learn more about our Complete SQL Course? Click the link below to secure your spot in the next class:

https://lp.hashtagtreinamentos.com/es...

--------------------------------------------------------------------

TO DOWNLOAD THE FREE SQL MINI-COURSE:

https://pages.hashtagtreinamentos.com...

-----------------------------------------------------------------------

► Introduction to Pandas Python - [GO FROM ZERO IN ONE LESSON]

• Introdução ao Pandas no Python - [SAIA DO ...

-----------------------------------------------------------------------

Recommended Video:

► Basic Course SQL:

• Fundamentos do SQL - Curso de SQL - Aula 1

-----------------------------------------------------------------------

If you prefer the video in text format: https://www.hashtagtreinamentos.com/a...

-----------------------------------------------------------------------

Hey Impressives! In today's lesson, I want to show you how to integrate Python and SQL.

As you may know, SQL doesn't allow the creation of charts or dashboards to visualize this information more clearly.

Therefore, we can integrate Python with SQL or even integrate with Excel or Power BI to visualize the data in a more visual way.

In this case, we will use the Contoso database, which is a free database, but you can use your own database normally. We'll bring only the desired information into Python, allowing us to process data within Python and create graphs to visually represent this information.

You should know that a graph is much easier to understand than simply analyzing a table, which is why it's so important to present this information graphically.

It makes both analysis and decision-making easier!

-----------------------------------------------------------------------

Hashtag Programming

► Subscribe to our channel: http://bit.ly/3c0LJQi
► Activate notifications (click the bell)!

► Like our video!

-----------------------------------------------------------------------

Social Media

► Blog: https://bit.ly/2MRUZs0
► YouTube: http://bit.ly/3c0LJQi
► Instagram: https://bit.ly/3o6dw42
► Facebook: http://bit.ly/3qGtaF2

Here on the Hashtag Programming channel, we teach various Python and SQL tips so you can develop your programming and database skills!

-----------------------------------------------------------------------

Lesson Content

00:00 Introduction
02:16 Contoso Database (free)
02:54 Viewing the database in SQL Server
03:24 Selecting information to import into Python
04:36 Jupyter Notebook
05:06 Installing the pyodbc Library
06:01 Importing the libraries (pyodbc and pandas)
07:16 Connection data
10:20 Creating the connection to the database
11:52 What data will we retrieve from the database?
14:00 Viewing the data
14:48 Grouping information in Python
17:18 Creating a bar chart in Python
18:25 Conclusion

#sql #hashtagprogramacao

Auf dieser Seite können Sie das Online-Video Practical Analysis with SQL Server and Python mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Hashtag Programação 02 Juni 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 16,794 Mal angesehen und es wurde von 728 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!