Postgres SQL Training Course - Code College

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

30-Day Money-Back Guarantee

Show More

Postgres SQL Training Course

R14,995.00

©2025. All rights reserved by Code College