Microsoft SQL Server is a relational database management system developed by Microsoft.
Transact-SQL (T-SQL) is Microsoft’s proprietary extension to the SQL (Structured Query Language) used to interact with relational databases
MySQL is a DBMS, or database management system. It is developed, supported and distributed by Oracle, but since it is open-source it is freely available to anyone under the GPL. MySQL databases are relational, meaning that the data is split up between tables. MySQL is very fast and lightweight so you can run it alongside your other applications on a desktop or laptop. It can also be scaled up to take advantage of all the CPU power and memory available on a dedicated machine.
PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.
Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.
Power BI is Microsoft’s interactive data visualization and analytics tool for business intelligence (BI).
Tableau is a powerful and fastest data visualization tool used in the Business Intelligence Industry. It helps in simplifying raw data in a very easily understandable format.
In this course we will be performing data analysis and business intelligence using MySQL, SQL, Microsoft SQL ,PostgreSQL , Excel, Power BI and Tableau.