May 22

Tools and Tutorials for Data Manipulation

Join Data from Multiple Sources

•Power BI

•Python

•SQL

•Databases and Data Warehouse

•https://durhamcollege.desire2learn.com/d2l/le/content/467097/viewContent/6376898/View

•Data Modeling and SQL

•https://durhamcollege.desire2learn.com/d2l/le/content/467097/viewContent/6376900/View

•Microsoft Power BI

•https://durhamcollege.desire2learn.com/d2l/le/content/467097/viewContent/6377023/View

Tutorials and Examples

•MySQL Data Manipulation:

•https://www.databasejournal.com/mysql/mysql-data-manipulation-and-query-statements/

•https://www.w3schools.com/sql/

•https://www.tutorialspoint.com/sql/index.htm

•Workbench: https://www.tutorialspoint.com/create-a-new-database-with-mysql-workbench

•SQL Server Data Manipulation

•https://www.tutorialspoint.com/ms_sql_server/index.htm

•Management Studio:

•https://www.tutorialspoint.com/ms_sql_server/ms_sql_server_management_studio.htm

•Power BI Data Manipulation

•https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-tutorial-importing-and-analyzing-data-from-a-web-page

•Data Manipulation in Python

•https://www.analyticsvidhya.com/blog/2021/06/data-manipulation-using-pandas-essential-functionalities-of-pandas-you-need-to-know/

Data Analytics, Machine Learning, Data Science