1) Install twice manually, with and without sample data. Always check the difference between packages of with and without sample data and make sampledata.zip accordingly.
2) Select "Db" for saving session storage while installation on manual.(we had changed session storage to "Files" from magento 2.2.4 as it was giving error on accessing System -> Tools -> Web Setup Wizard (Not required since 2.3.0))
3) Select Timezone America/NewYork
4) Just check that "USING BTREE" should be on the left i.e. not at the end
5) Always check the file permissions
6) Check and copy pub/media/theme folder from manual to zip and check name of the images. It should match with entry in SQL.(without sample data)
7) Check and copy pub/media/* folder from manual to sampledata.zip and check name of the images. It should match with entry in SQL. (with sample data)
8) Take dump using mysql command /usr/local/apps/mysql56/bin/mysqldump --routines -u root -ppass soft_mage282 > mage282.sql
9) set WRITEABLE_DIRECTORY_MODE = 0755; and WRITEABLE_FILE_MODE = 0644; in vendor/magento/framework/Filesystem/DriverInterface.php and then start with manual installation.  (NOT REQUIRED FROM 2.0.7)
10) "hash_config" values in indexer_state table is same for all installation from 2.1.0, hence no need to change this values.
11) We have disabled magento 2.x on windows because icons are not loading properly post login. This is happening because it redirects to symlinks to load all the icons and on windows symlinks are not created and also as per their requirement, magento 2.x is not supported on windows OS.
12) PHP REQUIREMENT LINK: https://devdocs.magento.com/guides/v2.4/install-gde/system-requirements-tech.html
13) Magento 2.2.2 requires Apache mod_version to be enabled.
14) Upgrade is not possible at present because magento2 uses either system's upgrade utility or the command line upgrade. http://devdocs.magento.com/guides/v2.4/comp-mgr/bk-compman-upgrade-guide.html
15) Change "<item name="view_preprocessed" xsi:type="object">Magento\Framework\App\View\Asset\MaterializationStrategy\Symlink</item>" from di.xml "<item name="view_preprocessed" xsi:type="object">Magento\Framework\App\View\Asset\MaterializationStrategy\Copy</item>" to disable symlink, it copies file to required place instead of making symlinks.
16) Move all Triggers and DELIMITERS to the end of sql.
17) Remove DEFINER=`root`@`localhost` from SQL file.
18) [IMPORTANT] We have to maintain two copies of .htaccess i.e. for Apache 2.2 and 2.4:( Not required since 2.3.4 as script has handled the .htaccess code for both the apache versions.)
For Apache 2.2 files will be :
.htaccess -> .htaccess
pub_.htaccess -> pub/.htaccess
pubstatic_.htaccess -> pub/static/.htaccess

For Apache 2.4 files will be :
apache24/.htaccess -> .htaccess
apache24/pub_.htaccess -> pub/.htaccess
apache24/pubstatic_.htaccess -> pub/static/.htaccess

1. Replace :
SetEnv 
with :
<IfModule mod_env.c>
    SetEnv 
</IfModule>

2. Replace :
<IfVersion
</IfVersion>
with :
(For apache 2.2)

order allow,deny
deny from all

(For apache 2.4)
Require all denied