SQL with PostgreSQL for Beginners: Analyze | Manipulate Data
Write SQL Queries for Data Analysis and Manipulation on PostgreSQL Databases
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
Requirements
-
A Computer and internet access required.
Who this course is for:
- Beginners to SQL
- Beginners to PostgreSQL
- Beginners to Databases