3.5 out of 5
3.5
1 review on Udemy

Database Design with CouchDB and PostgreSQL

Step by step guide for Database Design with CouchDB and PostgreSQL, Relational Database concepts, and the SQL language
Instructor:
SimpliCode Point
6 students enrolled
English [Auto-generated]
This tutorial is designed to give details to PostgreSQL, relational database concepts, and the SQL language.
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.

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

PostgreSQL Tutorials for Beginners

1
Introduction to PostgreSQL
2
Benefits of PostgreSQL
3
Aspect of Database
4
Types of Data
5
Issuing Database Commands
6
Table Structure
7
Inserting Data in Table
8
Retreiving the Data
9
Sorting of Data
10
Analyzing of Various Queries
11
Destroying a Table
12
Customization of Queries
13
Understanding Null Values
14
Performing Complex Clause
15
Uses of Distinct Keyword
16
Set Show and Reset
17
SQL Aggregates
18
Group By and Having Clause
19
Concept of Joining Tables
20
Requirement for Joining Tables
21
Creating Join Tables
22
Inserting Customer Value
23
Three or Four Table Joins
24
Additional Join
25
One to Many Joins
26
Concept of Self Joins
27
Concept of Referential Integrity
28
Numbering Rows
29
Creating Functions for Sequences
30
Combining Selects
31
Understanding Subqueries
32
Executing Subqueries
33
Update with FROM Clause
34
Creating Tables using Select
35
Concept of Performance
36
Understanding PostgreSQL

CouchDB - Mastering Database Design with CouchDB

1
Introduction to Couch DB
2
Understanding SQL and No SQL Databases
3
Environmental SetUp for Couch DB
4
Understanding CURL and Futon
5
HTTP Request Format
6
Understanding JSON
7
Creating a Database in Couch DB
8
Creating a Document using Futon
9
How to Update Document in CouchDB
10
Deleting a Document using CouchDB
11
Attaching File in Couch DB
12
Deleting and Compacting a Database
13
Futon Tools
14
View in Couch Db
15
Map and Reduce Functionality
16
Map and Reduce Functionality Continues
17
Why CouchDB
18
Eventual Consistency in CouchDB
19
Parameter with Replication
20
Creatig Replication in CouchDB
21
Difference of CouchDb with MongoDb
22
Difference of CouchDb with MongoDb Continues
23
Errors in CouchDb
24
Deployment and Performance in CouchDB
25
Configurations in CouchDB
26
Creating First Application in CouchApp
27
Creating First Application in CouchApp Continues
28
Performance in CouchDB
29
Performance in CouchDB Continues
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.5
3.5 out of 5
1 Ratings

Detailed Rating

Stars 5
0
Stars 4
0
Stars 3
1
Stars 2
0
Stars 1
0
f03e0c5b67a4a55d37fc338c51393667
30-Day Money-Back Guarantee

Includes

8 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion