Practical Analysis with SQL Server and Python

Publicado em: 02 Junho 2023
no canal de: 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

Nesta página do site você pode assistir ao vídeo on-line Practical Analysis with SQL Server and Python duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Hashtag Programação 02 Junho 2023, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 16,794 vezes e gostou 728 espectadores. Boa visualização!