Categories

Web DevelopmentProgrammingDatabaseWindowsLinuxNetworkingMobile DevicesRaspberry PiPythonCJavaOtherSponsored

DATABASE Articles

MongoDB Cheat Sheet - Essential MongoDB Shell Commands

MongoDB Cheat Sheat - A quick reference of Mongo shell commands and usage example needed to perform most of the common tasks in MongoDB.

Disable remote access to MySQL database.

This article illustrates how to disable remote access for etiher root users or for all users.

How to change the name of a Oracle Database

How to easily change the name(DBNAME) and unique id(DBID) of an Oracle database using DBNEWID utility.

Oracle DBA Cheat Sheet

This Oracle DBA cheat sheet is an essential guide for Oracle Database Administrators to perform day-to-day administration tasks

How to select random records from a database

Learn how to select random rows from a database table in MySQL, Oracle and MS SQL Server. Also learn how to retrieve random documents from a MongoDB collection.

Creating Oracle databases using DBCA

This article explains how to create, configure and delete Oracle databases using the graphical tool Database configuration Assistant (DBCA)

Gracefully terminating sessions in Oracle

How to terminate user sessions in Oracle without losing data.

Relocating and Renaming Datafiles in a Oracle Tablespace

This article explains how to relocate or rename the datafiles of a Oracle tablespace in a few easy steps

How to copy a database table

How to clone a table, copy some or all of the data from one table to another or copy just the table structure using SQL.

Recover MySQL root password in five simple steps

How to recover a lost MySQL root password in five easy steps on Windows and Linux platforms.