Posts

Showing posts with the label Information Technology

Magento 2x installation guide

Image
Magento 2x installation guide - Download the magento latest version from Archive .   OR   use composer create-project    --  Installation flow diagram shared with corutesy of Magento Post installation steps:       - clear chace       - disable cache       - reindex data       - compile code       - install sample data       - compile code       - reindex data       - deploy static content For further instruction you can visit: - sample data installation    http://devdocs.magento.com/ guides/v2.1/install-gde/ install/sample-data-after- composer.html - Magento command line configuration     http://devdocs.magento.com/ guides/v2.1/config-guide/cli/ config-cli-subcommands.html

sql joins

Image
ASQL Join is an instruction to combine data from two sets of data (tables). SQL is a special-purpose programming language designed for managing information in a relational database management system (RDBMS). The word relational here is key; it specifies that the database management system is organized in such a way that there are clear relations defined between different sets of data. (sql jons description courtesy of   sql-joins ) Different Types of SQL JOINs: (INNER) JOIN: Returns records that have matching values in both tables LEFT (OUTER) JOIN: Return all records from the left table, and the matched records from the right table RIGHT (OUTER) JOIN: Return all records from the right table, and the matched records from the left table FULL (OUTER) JOIN: Return all records when there is a match in either left or right table image courtesy of   imgur

Future IT hot jobs

The labour market is changing faster more then you realize. Demographic changes and technological advancements may lead to net loss of 5 million jobs by 2020.  Most data has been computerized and ERP applications provide all features with security and encryption. That's why new IT jobs specifications has been changed. Future IT jobs will be: - Data Mining     For analyse large data and figure out statistics of data, companies need Data scientists for extract data as they want. - Software Developers - Computer System Analyst - Mobile app Developers - Market Research Analyst - Architect      New requirements need Architect for generate wire frame of  future application -  Information Security Analyst In IT jobs , if you are skillfull then employee don't need degree.They need skillfull persons.