Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Database Articles
Page 323 of 547
Running a SQL query from specific month in SAP DB
When your T0.name is char filed, you should replace Order By as below −order by case when cast(left (T0.Name,2) as int)>=8 then cast(left (T0.Name,2) as int)-8 else cast(left (T0.Name,2) as int)+4 end
Read MoreImportant MYSQL Performance Tuning and Settings after Installation
In this article, we will learn and discuss some important performance tuning settings for MySQL which we need to implement after the MySQL Installation better and speedy performance.Pre-requisitesAssuming that we have already installed the MySQL, I am providing some tips before we start to know about Performance tuning settings for MySQL.Even experienced IT persons may make some mistakes which will lead to many problems, so before we apply any recommendations which are shown in this article, we will keep the below items in mind to avoid issues or problems.We will apply only one setting at a time so that we ...
Read MoreCareers in BigData? – A Big Leap Forward
Big Data is everywhere and there is an urgent need to collect and preserve whatever data has been generated. We also find that there is a greater fear of missing something, which is important. Big Data Analytics has become crucial, it helps improve business, decision making and offers the biggest edge over the competitors.What does the term Big Data mean?The term big data can be described as something large volume of data which is both structured and unstructured, that inundates a business on a day-to-day basis. Data is available everywhere but how can organizations capitalize on that is the big ...
Read MoreBusiness Intelligence as a Career Option?
Business intelligence is an umbrella term, which includes infrastructure, applications, tools and best practices that enable analytics of data and information in order to improve and optimize decision making and managing corporate performance. There are a lot of tools and technologies which are built on this concept.BI as a DisciplineBusiness Intelligence is made up of several related activities, which includes Data mining, Online analytical processing, Reporting, and Querying.Why Companies Prefer to use BI?Helps improve predictive mechanism through decision makingReduces costHelps identify new business opportunitiesIn the modern world, business operations are getting more complex with each passing day, hence there is ...
Read MorePrint all odd numbers and their sum from 1 to n in PL/SQL
In this problem, we are given a number n and we have to print all odd numbers from 1 to n and also print the sum of numbers from 1 to n in PL/SQL.PL/SQL is a procedural language extension to SQL. The code is a sequence of instructions that are ground in a block with all related declarations and instructions.Let’s see an example of our problem −Input: 7 Output: odd numbers are: 1, 3, 5, 7 Sum of odd numbers is 16To solve this problem, we will take a number and initialize it to 1 and a sum variable with ...
Read MoreHow to Migrate MySQL to MariaDB on Linux?
This article will help you to migrate the database from MySQL to MariaDB as the binary compatibility of MySQL-to-MariaDB in the migration process is very much straightforward.After the Oracle’s acquisition of MySQL, the community has driven an outcome of such movement and developed a new database called MariaDB. MariaDB is the open-source and its compatibility with MySQL. Most of the Linux distributions (RH, CentOS, Fedora) have already started to use the support of MariaDB as a drop-in replacement of MySQL.If we want to migrate the database from MySQL to MariaDB then this article will help.Preparing a MySQL Database and TablesWe ...
Read MoreInsert NULL value into database field with char(2) as type in MySQL?
Let us first create a table −mysql> create table DemoTable658(FirstName varchar(100),value char(2)); Query OK, 0 rows affected (0.95 sec)Insert some records in the table using insert command −mysql> insert into DemoTable658(FirstName) values('John') ; Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable658(value,FirstName) values(default(value),'Sam'); Query OK, 1 row affected (0.23 sec)Display all records from the table using select statement −mysql> select *from DemoTable658;This will produce the following output −+-----------+-------+ | FirstName | value | +-----------+-------+ | John | NULL | | Sam | NULL | +-----------+-------+ 2 rows in set (0.00 sec)
Read MoreQuery non-empty values of a row first in ascending order and then display NULL values
For this, use ORDER BY ISNULL(). Let us first create a table −mysql> create table DemoTable669 ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentScore int ); Query OK, 0 rows affected (0.55 sec)Insert some records in the table using insert command −mysql> insert into DemoTable669(StudentScore) values(45) ; Query OK, 1 row affected (0.80 sec) mysql> insert into DemoTable669(StudentScore) values(null); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable669(StudentScore) values(89); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable669(StudentScore) values(null); Query OK, 1 row affected (0.15 sec)Display all records from the table using select ...
Read MoreHow to Create a RAID 5 Storage Array with 'mdadm' on Ubuntu 16.04
In this article, we will learn how to create a RAID 5 Array configuration using the ‘mdadm’ utility.The ‘mdadm’ is a utility which is used to create and manage storage arrays on Linux with RAID capability where the administrators are having great flexibility in managing the individual storages devices and creating the logical storage with a high performance and redundancy.RAID 5 Array is a type where we implement by striping the data across the total available devices. Every component of the each stripe is calculated by parity block. If any device fails the parity block, it will use the remaining ...
Read MoreHow to Create a RAID 0 Storage Array with 'mdadm' on Ubuntu 16.04
In this article, we will learn how to create a RAID 0 Array configuration using the ‘mdadm’ utility.The ‘mdadm’ is a utility which is used to create and manage storage arrays on Linux with RAID capability where the administrators are having a great flexibility in managing the individual storage devices and creating the logical storage with a high performance and redundancy.RAID 0 array will work by dividing the data into small chunks and strips that data across the available storage disks, which means that each and every storage disk will contain a portion of data and when retrieving the data ...
Read More