Practical Analysis with SQL Server and Python

Pubblicato il: 02 giugno 2023
sul canale di: 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

In questa pagina del sito puoi guardare il video online Practical Analysis with SQL Server and Python della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Hashtag Programação 02 giugno 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 16,794 volte e gli è piaciuto 728 spettatori. Buona visione!