Instructors: 247 Learning
4 sections • 22 lectures • 1h 59m total length
Video: MP4 1280x720 44 KHz | English + Sub
Updated 11/2022 | Size: 570 MB

Analyse data in PostgreSQL Database using SQL
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
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
Homepage
Screenshots