•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
Category: Root
May 18
How to Report (or Present) the outcome of your Analytics/ML Project
Reporting and Analysis •Examples •Results section: Page 51: STOCK MARKET PREDICTION USING ENSEMBLE OF GRAPHTHEORY, MACHINE LEARNING AND DEEP LEARNING MODELS •https://scholarworks.sjsu.edu/cgi/viewcontent.cgi?article=1692&context=etd_projects •Check Results and Discussion sections •https://arxiv.org/ftp/arxiv/papers/2203/2203.06848.pdf •A Comparative Study on Forecasting of Retail Sales May be complicated: Learning Context-Aware Classifier for Semantic Segmentation •https://arxiv.org/pdf/2303.11633.pdf •Learning Context-Aware Classifier for Semantic Segmentation •Check results section; …
May 17
Data Analytics Concepts and Methods
What is Analysis? [1] • “A comprehensive, data-driven strategy for problem solving” Analytics • “Analytics uses logic, inductive and deductive reasoning, critical thinking, and quantitative methods along with data to examine phenomena and determine its essential features” • “any solution that supports the identification of meaningful patterns and relationships among data.” CONCEPTS [1] Analytics Methods [1]: [1] …
May 14
Some Basic SQLs in Oracle
— Find Tables in a Schema — for SH schema SELECT owner, table_nameFROM all_tableswhere OWNER = ‘SH’; — for HR Schema SELECT owner, table_nameFROM all_tableswhere OWNER = ‘HR’; — Create table based on another table DROP TABLE MyCustomer; — Create the structure but no data create table MyCustomer AS Select Cust_ID, Cust_First_Name, Cust_Last_Name FROM sh.Customers …
May 09
Linux Certification (RedHat, Ubuntu, Generic)
Linux Certification (RedHat, Ubuntu, Generic) For UBUNTU: CUE.01 Linux Quick Certification (QC) CUE.02 Desktop Quick Certification (QC) CUE.03 Server Quick Certification (QC) Ref: https://ubuntu.com/credentials RedHat: Red Hat Certified System Administrator Red Hat Certified Engineer Red Hat Certified Specialist in Containers Red Hat Certified OpenShift Administrator Ref: https://www.redhat.com/en/services/certifications Linux Professional Institute LPIC-1 LPIC-1, LPIC-2, LPIC-3 Ref: …
May 08
PowerShell : Check the Block Size of a Drive
Command: Get-CimInstance -ClassName Win32_Volume | Select-Object Name, FileSystem, Label, Size, BlockSize | Sort-Object Name | Format-Table -AutoSize Sample Output: Needed to format a 1TB Memory Card. 64 KB seemed to be a good Block Size for general use. Windows by default did not give an option to select a smaller block size. Powershell commands could …
May 04
Java Creational Design Patterns
5 types of creational design patterns: For Factory: Simple Factory, Factory Method, Abstract Factory Factory Method: Construction separated from implementation. Objects can be created without defining the exact class of object to be created. Abstract Factory: One layer above Factory Method. Super Factory. Creates other Factories to create objects. Builder Design Patterns: Helps to create complex …
May 04
How to install phpMyAdmin on Linux (AlmaLinux )
How to install phpMyAdmin on Linux (AlmaLinux – CentOs commands will work) dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm dnf install https://rpms.remirepo.net/enterprise/remi-release-8.rpm dnf –enablerepo=remi install phpMyAdmin nano /etc/httpd/conf.d/phpMyAdmin.conf sudo httpd -t systemctl restart httpd Accesss: http://your-server-ip/phpMyAdmin Ref: https://www.liquidweb.com/help-docs/how-to-install-phpmyadmin-on-linux-almalinux/ Commands from this URL worked. In my case, I only executed the above commands.
May 04
Investing in HALAL ETFs
What are your thoughts? It looks like, if I am to invest in Halal ETFs, the best available options are: SPUS, and HLAL – For Equity Part. SPRE and SPSK can be for the fixed income part. However, the performance of SPRE and SPSK is not great – you may also lose money. You will …
