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

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

R14,995.00

(pre-paid)

30-Day Money-Back Guarantee

Update:2 March 2025
Skill LevelBeginner

Requirements

Webinar : A laptop, and a stable internet connection. The recommended minimum speed is around 10 Mbps.
Classroom Training : A laptop, please notify us if you are not bringing your own laptop. Please see the calendar below for the schedule

Target Audience

School leavers intending to do one of our Coding Bootcamps.
You have been using spreadsheets, but are getting ready for something bigger and more sustainable, a database!
Junior Developers should know SQL and databases - you cannot develop software without a solid data base foundation
Management / Statisticians that want to get empowered by being able to learn how to use data productively

Postgres SQL Training Course

R14,995.00

(pre-paid)

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

Requirements

Target Audience

More Course By admin

Java Programming Training Course

Advanced Java Programming Training Course

GIT & GITHUB

Postgres SQL Training Course