Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL with PostgreSQL for Beginners: Analyze | Manipulate Data
Rating: 4.4 out of 5(108 ratings)
20,246 students

SQL with PostgreSQL for Beginners: Analyze | Manipulate Data

Write SQL Queries for Data Analysis and Manipulation on PostgreSQL Databases
Created byBluelime Learning Solutions
Last updated 3/2026
English

What you'll learn

  • Create Database and Table
  • Insert data into database
  • Retrieve data from database
  • Update existing data inside database
  • Delete data from database
  • Filter and sort data
  • Aggregate data using aggregate functions
  • Analyse data using analytic functions
  • Truncate and drop tables
  • Perform table join on multiple tables
  • Implement stored procedures

Course content

8 sections • 65 lectures • 7h 5m total length

  • Overview of analyzing and manipulating data with SQL and PostgreSQL2:20
  • Introduction0:27
  • What is SQL3:38
  • What is PostgreSQL3:44
  • PostgreSQL Minimum Installation Requirements3:29
  • Installing PostgreSQL on Windows9:53
  • Installing PostgreSQL on MacOS2:54
  • Installing PostgreSQL on Linux7:17
  • Installing PgAmin on MacOS5:23
  • Installing PgAmin on Linux5:58
  • Connecting to Database Server9:35
  • Download Sample Database11:49
  • Loading Sample Database -Option 2
  • Database Concepts8:57

Requirements

  • A Computer and internet access required.

Description

SQL stands for Structured Query Language. It is one of the most in-demand tech skills in the world.

What Can SQL do?

  • SQL lets you access and manipulate databases

  • SQL can execute queries against a database

  • SQL can retrieve data from a database

  • SQL can insert records in a database

  • SQL can update records in a database

  • SQL can delete records from a database

  • SQL can create new databases

  • SQL can create new tables in a database

  • SQL can create stored procedures in a database

  • SQL can filter data returned from a database

  • SQL can sort data returned by a database.

  • SQL can be used to truncate and drop tables.


PostgreSQL is a powerful, open source object-relational database  management system.

PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.

PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.


What You Will Learn

  • Perform CRUD Operations

  • PostgreSQL Database Objects

  • Database Concepts

  • Creating a database using PostgreSQL GUI

  • Creating tables with PostgreSQL GUI and SQL Commands

  • Inserting Data into tables

  • Query and read data stored inside a table

  • Filter and Sort data from a table

  • Using Sub query to retrieve data

  • Updating existing data stored inside a database

  • Query and eliminate duplicate records

  • Deleting records stored inside database

  • Truncating a database table

  • Dropping a database table

  • Implementing Stored Procedure

  • Joining and querying data from multiple tables

  • Using various aggregate functions and grouping data

  • Using various Operators to query data

  • Using various Analytic Functions




Who this course is for:

  • Beginners to SQL
  • Beginners to PostgreSQL
  • Beginners to Databases

Report abuse