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
    • Mage – Create Data Pipeline in 2 Minutes.
  • Contact
  • About

Blog

MySQL Start Stop

April 14, 2018 Sachin Leave a comment

Check Whether MySQL is running ps aux | grep mysqld OR ps -ef | grep mysqld Start MySQL Instance cd…

Continue Reading →

Mysql – Introduction

Sachin Leave a comment

   MySQL  Open-source license Free to use Uses SQL (Structured Query Language) Supports multiple operating systems (Windows,Linux etc)   Supports…

Continue Reading →

MongoDB RESTORE BACKUP

February 7, 2018 Sachin 1 Comment

SYNTAX mongorestore  –db <databse_name> /<path_of_backup_directory> mongorestore –db testdatabase  /var/backups/mongobackups/ Drop existing database and restore new backup, put –drop option in…

Continue Reading →

Run Postgres Query from Command line or File

February 5, 2018 Sachin Leave a comment

Pass query in command line SYNTAX psql -U <user_name> -p <port> -d <database_name> -c “<query>“ psql -U postgres -p 5432…

Continue Reading →

List MySQL Users

January 24, 2018 Sachin Leave a comment

mysql> select user from mysql.user; +—————+ | user | +—————+ | mysql.session | | mysql.sys | | root | +—————+…

Continue Reading →

MySQL BACKUP

January 23, 2018 Sachin Leave a comment

single database, create the dump and send the output into a file mysqldump database_name > database_name.sql mysqldump -h localhost -u…

Continue Reading →

How to create role

November 15, 2017 Sachin Leave a comment

Continue Reading →

Trigger

November 5, 2017 Sachin Leave a comment

Continue Reading →

Blog Post Title

November 4, 2017 Sachin Leave a comment

What goes into a blog post? Helpful, industry-specific content that: 1) gives readers a useful takeaway, and 2) shows you’re…

Continue Reading →

Post navigation

Page 2 of 2
← Previous 1 2

Follow Me

Contact Us

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