PostgreSQL Tutorials For Beginners

It has been prepared for the beginners to help them understand the concepts related to PostgreSQL Database

What you’ll learn

• This tutorial is designed to give details to PostgreSQL, relational database concepts, and the SQL language
• Learn Syntax, Data Types, Create Database, Select Database and Drop Database
• Learn Schema, details about query and clause

Requirements

• Some basic knowledge on DBMS and SQL language.
• No particular programming experience is required.

Description
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 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

Who is the target audience?

• Professionals
• Students

Created by SimpliCode Point
Published 11/2018
English
Size: 1.21 GB