Database Design with CouchDB and PostgreSQL

PostgreSQL is a powerful, open source object-relational database system. This tutorial is designed to give details to PostgreSQL, relational database concepts, and the SQL language. It has been prepared for the beginners to help them understand the concepts related to PostgreSQL Database. The PostgreSQL training will include the following;

• Overview

• Environment Setup

• Syntax

• Data Types

• Create Database

• Select Database

• Drop Database

• Create Table

• Drop Table

• Schema

• Insert Query

• Select Query

• Operators

• Expressions

• Where Clause

• AND & OR Clauses

• Update Query

• Delete Query

• Like Clause

• Limit Clause

• Order By Clause

• Group By

• With Clause

• Having Clause

• Distinct Keyword

Apache CouchDB is open source database software and these tutorials are for you to gain a quick overview of the same. This training is to learn about CouchDB, the processes to set it up, and the ways to interact with CouchDB server using cURL and Futon. We will learn how to create, update and delete databases and documents. The training will include the following;

• Introduction

• Difference between SQL and nosql databases

• Environmental Setup

• Curl and Futon

• Creating your first Couch DB database

• Introduction to Json

• HTTP API

• Creating a document

• Updating a document

• Deleting a document

• Deleting a database

• Attaching files

• Introduction to couchDb Views

• Mechanics of CouchDb deployment