What is the difference between Microsoft SQL Server and Microsoft Excel?
In this video, we’ll look at when using SQL Server could be better than using Excel – but we’ll also see that they can be used together.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft-sql-server
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpivot-ssas-tabular-dax
—-
My Excel for PC courses are:
Beginner to Excel – https://rebrand.ly/microsoft-excel-specialist
Intermediate to Expert Advanced – https://rebrand.ly/microsoft-excel-expert
Power Table, Get and Transform and Power Pivot – https://rebrand.ly/visualizing-data-excel
VBA macros for Excel – https://rebrand.ly/excel-vba-pc
—-
In this video, we’ll have a look at:
Similarities and differences between Excel and SQL Server, including:
Can you add any data anywhere?
Adding functions into data
Security
How you can use them together? and
How can I learn SQL?
Comments are closed.