Category Archives: DB-Class

db-class http://www.db-class.org

PostgreSQL useful tips

I am posting some of the PostgreSQL commands which I use frequently. Create a new database name testdb # createdb <dbname> e.g: Remove a PostgreSQL database # dropdb <dbname> e.g: Backing up a PostgreSQL database Restoring PostgreSQL database from back up dump Writing query output to a CSV file: After this operation all the query results… Read More »

Stanford DB class

Along with my AI class course,  I have also started DB class (Oct-Dec session) from Standford online courses series. Actually, learning DB was long due and this seems to be perfect opportunity. In my professional life I write SQL queries and sometime modify the database schema but that is all job requirement, going through full course content again… Read More »