Postgres SQL Training Course

0 Students Enrolled

Postgres SQL Training Course

Duration: 5 Days Full-time Or 10 Days Morning lectures Learn the fundamentals of SQL Databases and SQL Querying, and how to apply it…

2 March 2025

About Course

Download this page

Duration: 5 Days Full-time

Or 10 Days Morning lectures

Learn the fundamentals of SQL Databases and SQL Querying, and how to apply it practically

Who will benefit

Understand Tables and how to design them, maintain them and query them
How to query single and multiple tables with the SELECT statement
The DELETE and UPDATE statements and how to use them safely
ALTER - how to modify existing tables and databases
Advanced querying functions like GROUP By etc. and when are they useful
Statistic Basics
Data Analysis Fundamentals
Subqueries - when to use and not
Outer Joins - when they are useful
Constraints - why do we need them
UML - how to design a normalised database with UML
Forward Engineering - how to forward engineer a schema from a UML diagram
Reverse Engineering - how to reverse engineer a UML Diagram from an existing schema

Course Content

Databases
Tables
Populating Databases and Tables
Reading Data with SELECT statements
The WHERE clause
Data types in SQL
Importing data into your database
Exporting data from your database
Math Operators
Aggregate Functions

Free

Shopping cart

Postgres SQL Training Course

About Course

Who will benefit

Course Content

Lesson 1 Setting Up

Databases

Tables

Populating Databases and Tables

Reading Data with SELECT statements

The WHERE clause

Data types in SQL

Importing data into your database

Exporting data from your database

Math Operators

Aggregate Functions

Lesson 2

Median

Mode

Relational Database Design

Table Relationships

Join Types to join related tables

Aliases

Table Naming Conventions

Constraints

Query performance

Using indexes to speed up performance

Capstone: Using a public census database, produce summarised reports using Max, min, count and GROUP BY

Lesson 3

Inspecting Datasets to find missing, malformed or inconsistent data

Modifying Data, Tables and Columns

Using Transactions to save and revert back

Statistical funtions: Correlation with corr(X,Y)

Statistical funtions: Predicting values with Regression Analysis

Creating Rankings with rank() and dense_rank

Manipulating dates and times

Working with time zones

Lesson 4

Subqueries

CTE’s

CASE

Text mining for meaningful data

Text Patterns and Regex

Full Text Search

Spatial Data with PostGIS

Two-Dimensional Geometries

Lesson 5

Creating Spatial Objects with PostGIS Functions

GiST indexes

Performing Spatial Joins

Views, Functions and Triggers

SQL from the command line

Database maintenance

Database management

Target Audience

More Course By admin

Python Data Analysis

Laravel Training Course

Full-Stack Web Developer Bootcamp