Posts

Showing posts from January, 2021

50-Basic commands in linux

Basic commands of linux pwd command:                                 A path of the current working directory (folder) you’re in syntax:   pwd cd command :                                   change the current directory syntax : cd /var/log grep command:                                     The 'grep' stands for "global regular expression print.                                  find the text in file . syntax: grep pattern <file> sudo command:                          If you just need...

Object-oriented programming (OOPs)-python

 OOPs Concepts:                  An object-oriented programming is to design the program using classes and objects.     The object is related to real-word entities such as book, house, pencil, etc.     OOPs concept code writing is reusable code Principles of OOPs:                  C lass       Object       Method       Inheritance       Polymorphism       Data Abstraction       Encapsulation Class:         Class can be define as collection of object. The class have some specific attributes and methods.   For example: If you have school class, The it must contain an attribute and method     i.e an student name,roll num,email id,age, DOB Example:               ...

What is InnoDB - Why InnoDB use - ACID properties

InnoDB innodb is a storage engine database management system (DBMS) MySQL and MariaDB InnoDB release on MySQL 5.5.5 in 2010 its provide ACID-compliant transaction features what is InnoDB in MySQL InnoDB has evolved from being a storage subsystem to a general-purpose storage engine for MySQL.                  Its combination of high performance and high reliability,                  It was made the default storage engine from Version 5.6 onwards.                MySQL can handle large volumes of reads and writes                A DBMS is a tool that allows you to store, index, and retrieve data in a table ACID:                  Atomicity, consistency, isolation, durability is a set of properties of data...

CORE FEATURES IN MySQL

  STRUCTURED DATABASE                                                       Structured database are traditional database that have used in many enterprises for more than 40 years , However data volume becoming bigger and bigger common need have take place data analytics.                                            Basically data in a structured database has fixed filed, a dates, time, addresses, currencies  and so on Release  version 5.0 GA on 19th oct,2005   version 5.1 GA on 14th nov,2008   version 5.5 GA on 3th dec,2010  version 5.6 GA on 5th feb,2013  version 5.7 GA on 21th oct,2015 MySQL 8annouuced on 12th sep 201...

MYSQL

  MYSQL               Introduction of mysql                             MYSQL was owned and sponsored by swedish comany  MYSQLAB, which was brought by sun microsystem and now oracle coporation, mysqlab is a creater of  relational database management system.                            mysql  is an open  source relational database management system ( RDBMS ), mysql co-founder Michael widenius ,initial release 23 may 1995 nearly 25 years ago, operating system are linux, macOS, windows, solaris. written by c,c++ language  fast reliable ,easiness to use. In current market many application are provide  mysql  including giant industries such as twitter , facebook and service based application such as youtube, twitter many more. Relational database management system.     ...