SQL with PostgreSQL for Beginners: Analyze | Manipulate Data

Write SQL Queries for Data Analysis and Manipulation on PostgreSQL Databases

Created by: Bluelime Learning Solutions
Making Learning Simple

What Will I 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.

Target audience

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