{"id":78184,"date":"2025-05-18T19:56:46","date_gmt":"2025-05-18T19:56:46","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=78184"},"modified":"2025-06-22T01:38:21","modified_gmt":"2025-06-22T01:38:21","slug":"data-manipulation-for-ml-and-data-analytics-projects","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=78184","title":{"rendered":"Data Manipulation for ML and Data Analytics Projects."},"content":{"rendered":"\n<p>\u2022MySQL Data Manipulation:<\/p>\n\n\n\n<p>\u2022<a href=\"https:\/\/www.databasejournal.com\/mysql\/mysql-data-manipulation-and-query-statements\/\">https:\/\/www.databasejournal.com\/mysql\/mysql-data-manipulation-and-query-statements\/<\/a><\/p>\n\n\n\n<p>\u2022<a href=\"https:\/\/www.w3schools.com\/sql\/\">https:\/\/www.w3schools.com\/sql\/<\/a><\/p>\n\n\n\n<p>\u2022<a href=\"https:\/\/www.tutorialspoint.com\/sql\/index.htm\">https:\/\/www.tutorialspoint.com\/sql\/index.htm<\/a><\/p>\n\n\n\n<p>\u2022Workbench: <a href=\"https:\/\/www.tutorialspoint.com\/create-a-new-database-with-mysql-workbench\">https:\/\/www.tutorialspoint.com\/create-a-new-database-with-mysql-workbench<\/a><\/p>\n\n\n\n<p>\u2022SQL Server Data Manipulation<\/p>\n\n\n\n<p>\u2022<a href=\"https:\/\/www.tutorialspoint.com\/ms_sql_server\/index.htm\">https:\/\/www.tutorialspoint.com\/ms_sql_server\/index.htm<\/a><\/p>\n\n\n\n<p>\u2022Management Studio:<\/p>\n\n\n\n<p>\u2022<a href=\"https:\/\/www.tutorialspoint.com\/ms_sql_server\/ms_sql_server_management_studio.htm\">https:\/\/www.tutorialspoint.com\/ms_sql_server\/ms_sql_server_management_studio.htm<\/a><\/p>\n\n\n\n<p>\u2022Power BI Data Manipulation<\/p>\n\n\n\n<p>\u2022<a href=\"https:\/\/learn.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-tutorial-importing-and-analyzing-data-from-a-web-page\">https:\/\/learn.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-tutorial-importing-and-analyzing-data-from-a-web-page<\/a><\/p>\n\n\n\n<p>\u2022<strong>Data Manipulation in Python<\/strong><\/p>\n\n\n\n<p>\u2022<a href=\"https:\/\/www.analyticsvidhya.com\/blog\/2021\/06\/data-manipulation-using-pandas-essential-functionalities-of-pandas-you-need-to-know\/\">https:\/\/www.analyticsvidhya.com\/blog\/2021\/06\/data-manipulation-using-pandas-essential-functionalities-of-pandas-you-need-to-know\/<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Data Analytics, Machine Learning, Data Science<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u2022MySQL Data Manipulation: \u2022https:\/\/www.databasejournal.com\/mysql\/mysql-data-manipulation-and-query-statements\/ \u2022https:\/\/www.w3schools.com\/sql\/ \u2022https:\/\/www.tutorialspoint.com\/sql\/index.htm \u2022Workbench: https:\/\/www.tutorialspoint.com\/create-a-new-database-with-mysql-workbench \u2022SQL Server Data Manipulation \u2022https:\/\/www.tutorialspoint.com\/ms_sql_server\/index.htm \u2022Management Studio: \u2022https:\/\/www.tutorialspoint.com\/ms_sql_server\/ms_sql_server_management_studio.htm \u2022Power BI Data Manipulation \u2022https:\/\/learn.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-tutorial-importing-and-analyzing-data-from-a-web-page \u2022Data Manipulation in Python \u2022https:\/\/www.analyticsvidhya.com\/blog\/2021\/06\/data-manipulation-using-pandas-essential-functionalities-of-pandas-you-need-to-know\/ Data Analytics, Machine Learning, Data Science<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1974,1],"tags":[],"class_list":["post-78184","post","type-post","status-publish","format-standard","hentry","category-analytics-and-machine-learning-project-development","category-root","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":78258,"url":"http:\/\/bangla.sitestree.com\/?p=78258","url_meta":{"origin":78184,"position":0},"title":"Tools and Tutorials for Data Manipulation","author":"Sayed","date":"May 22, 2025","format":false,"excerpt":"Join Data from Multiple Sources \u2022Power BI \u2022Python \u2022SQL \u2022Databases and Data Warehouse \u2022https:\/\/durhamcollege.desire2learn.com\/d2l\/le\/content\/467097\/viewContent\/6376898\/View \u2022Data Modeling and SQL \u2022https:\/\/durhamcollege.desire2learn.com\/d2l\/le\/content\/467097\/viewContent\/6376900\/View \u2022Microsoft Power BI \u2022https:\/\/durhamcollege.desire2learn.com\/d2l\/le\/content\/467097\/viewContent\/6377023\/View Tutorials and Examples \u2022MySQL Data Manipulation: \u2022https:\/\/www.databasejournal.com\/mysql\/mysql-data-manipulation-and-query-statements\/ \u2022https:\/\/www.w3schools.com\/sql\/ \u2022https:\/\/www.tutorialspoint.com\/sql\/index.htm \u2022Workbench: https:\/\/www.tutorialspoint.com\/create-a-new-database-with-mysql-workbench \u2022SQL Server Data Manipulation \u2022https:\/\/www.tutorialspoint.com\/ms_sql_server\/index.htm \u2022Management Studio: \u2022https:\/\/www.tutorialspoint.com\/ms_sql_server\/ms_sql_server_management_studio.htm \u2022Power BI Data Manipulation \u2022https:\/\/learn.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-tutorial-importing-and-analyzing-data-from-a-web-page \u2022Data Manipulation in\u2026","rel":"","context":"In &quot;Analytics and Machine Learning Project Development&quot;","block_context":{"text":"Analytics and Machine Learning Project Development","link":"http:\/\/bangla.sitestree.com\/?cat=1974"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":67779,"url":"http:\/\/bangla.sitestree.com\/?p=67779","url_meta":{"origin":78184,"position":1},"title":"How to install and Use MySQL Workbench on the Windows Platform #By Sayed Ahmed #MySQL","author":"Author-Check- Article-or-Video","date":"July 28, 2021","format":false,"excerpt":"How to install and use MySQL Workbench on the Windows Platform [youtube https:\/\/www.youtube.com\/watch?v=g_sGnjXpiEc&w=640&h=360] From: http:\/\/sitestree.com\/?p=3884 Categories:By Sayed Ahmed, MySQLTags:DBMS, MySQL, MYSQL Workbench, My SQL Query Browser, EER Diagram, Database Model Post Data:2016-08-22 17:01:00 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":75826,"url":"http:\/\/bangla.sitestree.com\/?p=75826","url_meta":{"origin":78184,"position":2},"title":"Some Topics to Know and Understand to prepare for a DBMS related Job Interview","author":"Sayed","date":"June 25, 2023","format":false,"excerpt":"Some Topics to Know and Understand to prepare for a DBMS related Job Interview ACID ACID: https:\/\/www.geeksforgeeks.org\/acid-properties-in-dbms Database Normalization 1NF: No repeating groups possible for a cell, PK identified, dependencies mapped 2NF: No Partial Dependence. Non key attributes must have to depend on the full key 3NF: No transitive dependency.\u2026","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22964,"url":"http:\/\/bangla.sitestree.com\/?p=22964","url_meta":{"origin":78184,"position":3},"title":"MySQL Workbench, Git, and Misc #Root #By Sayed Ahmed","author":"Author-Check- Article-or-Video","date":"March 22, 2021","format":false,"excerpt":"MySQL Workbench, Git, and Misc From: http:\/\/sitestree.com\/?p=1635 Categories:Root, By Sayed AhmedTags: Post Data:2014-11-07 19:59:01 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium: https:\/\/medium.com\/@SayedAhmedCanada","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22863,"url":"http:\/\/bangla.sitestree.com\/?p=22863","url_meta":{"origin":78184,"position":4},"title":"MySQL Workbench Create database model and miscellaneous #Root #By Sayed Ahmed","author":"Author-Check- Article-or-Video","date":"March 21, 2021","format":false,"excerpt":"MySQL Workbench Create database model and miscellaneous [youtube http:\/\/www.youtube.com\/watch?v=ntLq9m2CypI?feature=player_detailpage&w=640&h=360] From: http:\/\/sitestree.com\/?p=1597 Categories:Root, By Sayed AhmedTags: Post Data:2014-10-27 19:34:27 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium: https:\/\/medium.com\/@SayedAhmedCanada","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22960,"url":"http:\/\/bangla.sitestree.com\/?p=22960","url_meta":{"origin":78184,"position":5},"title":"Create Database from DB model using MySQL Workbench #Root #By Sayed Ahmed","author":"Author-Check- Article-or-Video","date":"March 22, 2021","format":false,"excerpt":"Create database from db model using MySQL Workbench [youtube http:\/\/www.youtube.com\/watch?v=NWFDzlBE068?feature=player_detailpage&w=640&h=360] From: http:\/\/sitestree.com\/?p=1628 Categories:Root, By Sayed AhmedTags: Post Data:2014-10-30 20:03:26 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium: https:\/\/medium.com\/@SayedAhmedCanada","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78184"}],"version-history":[{"count":3,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78184\/revisions"}],"predecessor-version":[{"id":78307,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78184\/revisions\/78307"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78184"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}