SQL Fundamentals
A standards-first introduction to SQL on PostgreSQL 18: the relational model, SELECT, joins, aggregation, subqueries, CTEs, and window functions.
Live database training: SQL fundamentals, PostgreSQL administration and development, stored procedures, SQL Server, and managed Postgres on AWS and Azure.
These courses are for developers, analysts, and database administrators who work with SQL, PostgreSQL, and SQL Server. They cover writing queries, building database logic, and running PostgreSQL on your own servers or in the cloud.
Start with SQL Fundamentals. C# and .NET teams can take SQL Server for Developers, which also covers Azure SQL Database. Python developers can take PostgreSQL for Python Programmers, and teams that keep logic in the database can take PostgreSQL Stored Procedures and Functions.
For operations, PostgreSQL for Administrators covers self-managed servers. Amazon RDS for PostgreSQL and Azure PostgreSQL Flexible Server cover the managed services on AWS and Azure.
A standards-first introduction to SQL on PostgreSQL 18: the relational model, SELECT, joins, aggregation, subqueries, CTEs, and window functions.
Use PostgreSQL 18 from Python: SQL, schema design, JSONB, PL/pgSQL, async SQLAlchemy with asyncpg, pandas, and pgvector similarity search.
Write PostgreSQL stored procedures and functions in SQL and PL/pgSQL: parameters, transactions, triggers, dynamic SQL, security, and testing.
Administer PostgreSQL 18: installation, security, tuning, backup and recovery, replication, upgrades, and running in containers and the cloud.
Run PostgreSQL 18 on Amazon RDS: provisioning, security, Database Insights monitoring, RDS Proxy, backups, and Blue/Green upgrades.
Run PostgreSQL 18 on Azure Database for PostgreSQL flexible server: provisioning, Entra ID security, high availability, elastic clusters, and migration.
Build on SQL Server 2025 and Azure SQL: T-SQL, indexes, execution plans, Query Store, transactions, JSON and vector data, security, .NET access, and CI/CD.
Private team training
Pick one course or combine several. We adjust the outline to your tools, stack, and schedule.
Prefer to talk? Call +1 434-509-6890 or email help@cloudcontraptions.com.