Normalization in DBMS – 1NF, 2NF, 3NF and BCNF

Here you will learn about normalization in dbms with examples. What is Normalization in Database? Most of the projects and websites contain lot of information. They store the data in tables. Since lot of data therefire database contains so many tables. In order to retrieve some information we must go through number of tables which … Read more

How to install Ambari or HDP on Linux

Today we will learn how to install Ambari or HDB on Linux(CentOS): Before installation below are some prerequisite: Check the Maximum Open File Descriptors The recommended maximum number of open file descriptors is 10000, or more. To check the current value set for the maximum number of open file descriptors, execute the following shell commands … Read more

How to do MySQL Server Log Maintenance

MySQL Server Log Maintenance: As a part of database administration, DBA has to take care of sub-components of database like server logs and has to plan for maintenance activity for these components regularly. MySQL has various types of log i.e binary log, error log, slow query log, general log for different purposes. And after certain time these logs … Read more

How to TRUNCATE multiple Tables in MySQL

In this post we will learn about how can we truncate multiple tables in MySQL database management system. Why we cannot TRUNCATE Multiple Tables in MySQL directly: The basic syntax of TRUNCATE is: TRUNCATE TABLE <table_name>; In this case we can truncate only one table at a time from a single database. What if we … Read more

How to install MySQL from Scratch

In this tutorial we will learn about how to install MySQL Database server using the RPM’s on Linux operating system. As we all know MySQL’s community version is free of cost so we will simply download the RPMs from MySQL site and I’ll show you the procedure of installing it on any of your Linux … Read more