Introduction to SQL
Dates & Duration
See available dates for this course!
If there is no date and time available for a certain training you are interested in, please contact us.
This course takes 3 days with 8 hours each (on site) or 4 hours each (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.
This workshop has been designed for people who want to get in touch with SQL and PostgreSQL. You will learn how to use PostgreSQL and how to write proper SQL statements.
This course can be held in English, German, Spanish, Polish, Estonian, Ukrainian and Russian.
- Creating / dropping tables
- Using data types
- Intelligent data structures
- ALTER TABLE: Modifying data structures
- Using schemas
- INSERT / UPDATE / DELETE
- Simple SELECT statements
- Sorting data
- Limiting output
- Filtering duplicate entries
- Inner joins
- Outer joins
- NULL values
- Aggregations (sum, count, etc.)
- Understanding HAVING
- Set operations
- Integrity constraints and foreign keys
- Using cursors
- Temporary tables
- Creating indexes
- Speeding up queries using indexes
- Avoiding unnecessary indexes
- ACID transactions
- Data security and consistency
- Transaction Isolation
- Error handling
Other courses that might interest you
PostgreSQL High-Availability & Patroni Cluster Manager
PostgreSQL in Kubernetes
Machine Learning for decision makers
Introduction to Machine Learning
GIS ESSENTIALS – “Getting spatially enabled”
PostgreSQL Administration and Performance Tuning
PostgreSQL for business intelligence and mass data analysis
We offer these services
9/5 Dedicated DBA
CYBERTEC 9/5 Dedicated DBA support service includes a dedicated CYBERTEC expert who remotely takes care of your databases. We will handle any issues before you would even notice them and proactively inform you about possible future problems and needed actions. 9/5 means that your DBA is here for you from Monday to Friday from 9am […]
CYBERTEC Partner Network (CPN)
PostgreSQL expertise for your product portfolio The perfect solution for resellers and software retailers Are you a system house or a software retailer that offers PostgreSQL to its customers instead of or next to other database systems? Do you need a competent partner, with lots of experience, sophisticated services, solutions and products? Join the […]
Support for Reseller
These support packages are intended for resellers only. Please contact us, if you are a reseller and do not find a fitting package for your needs. Contact us >> 3rd-Level Support 3rd-Level Support is addressed to companies who sell products (hardware or software) to their customers that use PostgreSQL as database. This support variant ensures […]