Ref: A Book: The Analytics Lifecycle Toolkit A Practical Guide for an Effective Analytics Capability Wiley
Category: Root
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 …
Apr 30
Upgrading Moodle to Newer Versions
[root@vps training]# history | tail -201031 git pull1032 php admin/cli/upgrade.php1033 php admin/cli/maintenance.php –disable1034 git branch -a1035 git branch –track MOODLE_500_STABLE origin/MOODLE_500_STABLE1036 git checkout MOODLE_500_STABLE1037 git commit1038 git checkout MOODLE_500_STABLE1039 php admin/cli/maintenance.php –enable1040 remotes/origin/MOODLE_400_STABLE1041 git commit MOODLE_400_STABLE1042 git branch –track MOODLE_400_STABLE origin/MOODLE_400_STABLE1043 history -101044 history | tail -101045 git checkout MOODLE_400_STABLE1046 php admin/cli/maintenance.php –enable1047 git pull1048 …
