Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL for Data Analysis using PostgreSQL for Beginners
Rating: 3.1 out of 5(5 ratings)
1,212 students

SQL for Data Analysis using PostgreSQL for Beginners

Analyse data in PostgreSQL Database using SQL
Created by247 Learning
Last updated 3/2026
English

What you'll learn

  • Install and connect to PostgreSQL Database Server
  • Restore Sample Database into PostgreSQL Database Server
  • Create Database Tables
  • Insert data into Database Tables
  • Fetch data from Database
  • Analyse data from database using Aggregate Functions
  • Analyse data from database using Analytic Functions

Course content

6 sections • 29 lectures • 2h 15m total length

  • Enhancing Your Learning Experience: Tips for Success in This Course1:39
  • Overview of SQL and its role in data analysis2:20
  • Analysing data with SQL on PostgreSQL3:58
  • Introduction to relational databases and their structure2:26
  • Understanding tables, columns, and rows1:11
  • Basics of SQL syntax and statements1:49

Requirements

  • Basic knowledge of database concepts like database and tables advised but not mandatory

Description

SQL (Structured Query Language) is a programming language designed for managing data in a relational database. It's been around since the 1970s and is the most common method of accessing data in databases today. SQL has a variety of functions that allow its users to read, manipulate, and change data. Though SQL is commonly used by engineers in software development, it's also popular with data analysts. SQL is a standard language for accessing and manipulating databases.



What Can SQL do?


  • SQL can execute queries against a database

  • SQL can fetch and analyse data stored inside  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 create views in a database

  • SQL can set permissions on tables, procedures, and views


PostgreSQL is an advanced, enterprise class open source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system, backed by more than 20 years of community development which has contributed to its high levels of resilience, integrity, and correctness. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.



Who this course is for:

  • Beginners to Data Analysis using SQL on PostgreSQL Database

Report abuse