Skip to content

Database Tutorial

!! Database Begins Here......
  • Home
  • SQL
    • SQL
      • Introduction
      • SQL – CREATE TABLE
      • SQL – ALTER TABLE
      • SQL – DROP TABLE
      • SQL – DESCRIBE
      • PL/SQL
        • PROCEDURES
        • FUNCTIONS
        • CURSORS
    • PostgreSQL
      • Create Database
      • Postgres Roles
      • Postgres Backup
      • Postgres Locks
      • PostgreSQL Status
      • Trigger
      • Command line
      • PostgreSQL Timezone
      • PostgreSQL Vacuum
      • How to Determine Number of Columns in a PostGreSQL Table
      • PostgreSQL WAL’s Queries
    • mySQL
      • Mysql – Introduction
      • MySQL Installation
      • MySQL Start Stop
      • Basic Commands
      • List MySQL Users
      • CREATE/ DROP
      • MySQL BACKUP
      • Mysql Backup Cronjob
      • Logs
        • LOG DESTINATION
  • NOSQL
    • MongoDB
      • Installation
      • CREATE DATABASE
      • CREATE COLLECTION
      • DROP COLLECTION
      • MONGO INSERT
      • MongoDB SELECT
      • pretty ( )
      • MONGO ROLE ACCESS
      • MONGO BACKUP
      • MONGODB RESTORE BACKUP
      • MongoDB error
      • Authentication
      • MongoDB SERVICE Commands
      • MongoDB Performance
      • MongoDB Replication
    • Neo4j
      • Neo4j Installation
    • Cassandra
    • Hive
      • Hive Installation
      • Hive File Format
    • Hadoop
      • Hadoop commands
    • Kafka
      • Kafka Installation
      • Kafka- Create Topic
  • Linux
    • Linux Commands
    • CAT
    • Cron Tab
  • python
    • Python Variables
    • Python-Mongodb
  • Blog
  • Contact
  • About

Author: Sachin

Create Table in Postgres

May 26, 2018 Sachin Leave a comment

To create table in PostgreSQL “CREATE TABLE” command is used : SYNTAX: CREATE TABLE table_name( column1 datatype, column2 datatype, …..…

Continue Reading →

Installation

May 15, 2018 Sachin Leave a comment

Step 1: Remove any previous repository sudo rm -rf /etc/yum.repos.d/mongod* sudo yum clean all Step 2: create new repo file…

Continue Reading →

MongoDB Replication

May 11, 2018 Sachin Leave a comment

MongoDB Replication on same server with two secondary instances. Requirement : Primary Server (127.0.0.1) – Port : 27017 Secondary server…

Continue Reading →

PostgreSQL Running Status

April 26, 2018 Sachin Leave a comment

pg_isready is utility to check whether postgres is running or not -bash-4.2$ ./pg_isready /tmp:5432 – accepting connections can write shell…

Continue Reading →

Authentication

Sachin Leave a comment

Start MongoDB without authentication 2. Create new role which we will use to login into database > use admin >…

Continue Reading →

Mysql Backup Cronjob

April 23, 2018 Sachin 1 Comment

Problem : We don’t want to give plain password in mysql_dump command so no one can see password while taking…

Continue Reading →

LOG DESTINATION

April 15, 2018 Sachin Leave a comment

Selecting General Query and Slow Query Log Output Destinations Check log_output value (File/csv) mysql> show variables like ‘%log_output%’ ; +—————+——-+…

Continue Reading →

Logs

Sachin Leave a comment

MySQL LOG TYPES Type Log Written to file Error log Problems due to starting, running, or stopping mysqld instances 2. General…

Continue Reading →

MySQL Installation

Sachin Leave a comment

Download and add the repository wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm yum update 2. Install MySQL sudo yum install mysql-server 3.…

Continue Reading →

Create/Drop/List mysql database

April 14, 2018 Sachin Leave a comment

Create Database SYNTAX Create database < database_name> Ex: mysql> Create database sqlnosql ; Query OK, 1 row affected (1.29 sec)…

Continue Reading →

Post navigation

Page 1 of 2
1 2 Next →

Recent Comments

  • umesh on Mysql Backup Cronjob
  • Suraj Marathe on MongoDB RESTORE BACKUP

Recent Posts

  • Create Table in Postgres
  • Installation
  • MongoDB Replication
  • PostgreSQL Running Status
  • Authentication

SQL

PostgreSQL Running Status

Postgres Backup

Follow Me

Contact Us

  • Email
    sachinep84@gmail.com
  • Phone
    +91-9869850432 / 9967982025
Copyright © 2023 Database Tutorial