46,657 views
Want to know more about our Complete SQL Course? Click the link below to secure your spot in the next class: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE SQL MINI COURSE: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- ► How to Install Power Query in Excel in Older Versions • How to Install Power Query in Excel ... ► First Steps in SQL Server • First Steps in SQL Server ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/i... ----------------------------------------------------------------------- Recommended Video: ► Basic SQL Course: • SQL Fundamentals - SQL Course - A... ----------------------------------------------------------------------- Hey Awesome! In today's class we're going to integrate SQL Server databases with Excel! That's right, we're going to connect SQL Server to Excel so you can search this database and perform the necessary treatments within Excel. This feature of integrating databases with Excel is very useful, because you won't need to store hundreds of tables with thousands or even millions of pieces of information within Excel itself. You should know that this would make the program very slow and almost impossible to use, so we're going to connect SQL Server to Excel. We're going to use Power Query to make this connection, since both programs are from Microsoft, this integration is much easier and faster. Then, just bring in the tables you're going to work with to be able to do your analyses, reports, and dashboards. This way, your Excel file will be much faster, because it will only work with the table you brought in instead of storing all the other tables! ----------------------------------------------------------------------- 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 of the Hashtag Programação channel we teach several Python and SQL tips so that you can develop in programming and database! ----------------------------------------------------------------------- #sql #hashtagprogramacao