Introduction to SQL
Audience
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.
Content
Defining tables
- Creating / dropping tables
- Using data types
- Intelligent data structures
- Normalization
- ALTER TABLE: Modifying data structures
- Using schemas
Simple instructions
- INSERT / UPDATE / DELETE
- Simple SELECT statements
- WHERE-conditions
- Sorting data
- Limiting output
- Filtering duplicate entries
Joins
- Inner joins
- Outer joins
Advanced SQL
- NULL values
- Aggregations (sum, count, etc.)
- Understanding HAVING
- Subselects
- Set operations
- Constraints
- Integrity constraints and foreign keys
- Views
- Using cursors
- Temporary tables
Indexing
- Creating indexes
- Speeding up queries using indexes
- Avoiding unnecessary indexes
Transactions
- ACID transactions
- Data security and consistency
- Locking
- Savepoints
- Transaction Isolation
- Error handling
Other courses that might interest you
We offer these services
High availability with Patroni
Patroni – Protects your database Patroni is an Open Source Cluster-Technology, which takes care of automatic failover and high availability of your PostgreSQL database. Furthermore, Patroni is simple – the Patroni-Clusters are very easy to set up and to use. Ensure high availability of your database with Patroni! Cybertec’s Patroni-Extension “vipmanager” ensures an automatic IP […]
PostgreSQL Product- and 3rd Level Support
Are you using PostgreSQL as database backend for your product? Then we have the ideal solution to save you and your customers from database problems. PostgreSQL is increasingly being used as database for software and hardware solutions. Once they are sold to the customer, you are often left with the question how to offer a […]
PostgreSQL performance tuning
Is your PostgreSQL database slow? Do you see high latency, many slow query entries and are customers already complaining? If you are looking for a performance tuning because you simply want a fast, reliable database, you are on the right website. PostgreSQL Storage Tuning One part of performance tuning is storage tuning. A good storage […]