MySQL database backup using Command line is very much easy. You just need to follow these simple steps.
Database
Oracle Database Automatic Backup using batch script
Oracle database automatic backup using task scheduler and batch script in windows. You need to create a batch script and task scheduler.
To create a database table in MySQL Server via Command Line
Find very simple steps to create table in MySQL Server from command line. After following these steps we can create database and tables in mysql from command line.
JDBC Connection with MS SQL Server in Java
To create JDBC connection with MS SQL Server we need Microsoft SQL Server JDBC Driver and SQL JDBC Authentication file. Download links of all required files also available.
JDBC Connectivity with Mysql in Java
To connect java with MySQL database using jdbc connection we need MySQL Connector.jar file and MySQL database server.
How to find nth maximum salary from a table
We can use this method to find value on particular position from database table in assending or dessending order like how to find nth maximum salary from a table.
ACID Properties of Database
ACID model is the most important and oldest concept in database theory. In the context of Database Transaction is a single logical operation on data. ACID properties guarantee that database transactions are processed reliably.