Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Up and Running With PostgreSQL 11
Rating: 4.5 out of 5(204 ratings)
4,589 students

Up and Running With PostgreSQL 11

The Modern and Most Used Relational Database
Created byNelson Jamal
Last updated 5/2019
English

What you'll learn

  • What PostgreSQL is
  • SQL
  • SQL Joins and Relationships
  • Aggregate Data
  • Work with SQL Dates
  • Database Constraints
  • How Sequence data type works internally
  • CRUD Operations
  • SQL Error Handling
  • Create and Connect To Database
  • The Right Way To Create Tables
  • Export Query Results to CSV File
  • SQL Arithmetic Operators
  • Data Types

Course content

12 sections • 60 lectures • 4h 14m total length

  • Welcome1:26
  • What is a database2:03
  • SQL and Relational Databases3:53
  • What is PostreSQL AKA Postrgres1:39
  • Postgres Installation (MAC OS)3:31
  • Postgres Installation (Windows)3:20
  • Setting up PSQL (MAC OS)3:42
  • Setting up PSQL (Windows)4:59

Requirements

  • Be able to use computer

Description

Overview

PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system widely used to build back end systems.

Startups including big companies such as Apple, Cisco, Redhat and more use Postgres to drive their business.

The Goal of this course is to help anyone to become familiar with Relational Databases and learn most common used SQL statements, allowing you execute queries agains any relational database.


Course Road Map

  • Introduction to PostgreSQL

  • Setup your environment and get ready to start coding for both MacOS and Windows

  • Create, Read, Update & Delete (CRUD) commands

  • Learn about different ways of filtering data using where clause

  • Work with Date and Timestamps

  • Lean how to to Join and Left Join to combine data from one more tables

  • Postgres extensions and how sequences are managed

  • Learn how to create tables with the right constraints

  • Learn how to export data to CSV files

  • Congratulations. You will be ready to right SQL and have a great understanding of Postgres database

Let's get started now

Who this course is for:

  • Passionate student who want to learn about databases

Report abuse