Posts

Inheritance-Object Oriented Programming (OOPs) concept in python

Image
  Inheritance                       Inheritance is the most important aspect of object-oriented programming.  It provides the re-usability of the code.                     Parent class :It is base class  , child class :another class and also called child class Types of Inheritance:                    Single inheritance                     Multilevel inheritance                     Multiple inheritance                     Hierarchical inheritance                     Hybrid inheritance The Single Inheritance            ...

Server Startup programs in MySQL

Startup programs                             mysqld                              mysqld_safe                              mysql.server                              mysqld_multi mysqld :                   mysqld is the server daemon.                    mysqld must be started and be running at all the times expect for maintenance.                    mysqld is a single  multithreaded program                   ...

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...