Posts

Showing posts with the label SQl

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