Try to refresh myself from the keywords of some of technologies which
we use in day to day life.
MYSQL
1. DDL : Data Defination Language -statements are used to build and modify the structure of your tables and other objects in the database. Eg. CREATE/ DROP/ ADD COLUMN
2. DML: Data Manipulation Language- statements are used to work with the data in tables.Eg.
SELECT/INSERT/UPDATE/DELETE.
3.INDEXES: The main purpose of the index is to find rows quickly – without scanning whole
data set.Eg. BTREE:it allows to retrieve data in sorted form.
4. INNODB VS MYISAM:
InnoDB: we usually see clustering by primary key, caching data, higher concurrency.
5.Normalization is usually thought of as a process of applying a set of rules to your database design, mostly to achieve minimum redundancy in the data.
1NF/2NF/3NF.
ER model diagram: Entity Relational Diagrams:graphic that illustrates the interrelationships between entities in a database.
UML:Unified Modeling Language:UML offers a standard way to visualize a system's architectural blueprints.
SOLR/LUCENE
OOPS
PHP
AJAX:Asychorounsly Javascript and XML
No comments:
Post a Comment