Introduction to SQL
Sign up for this course Sign up for this course
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
PostgreSQL performance tuning
Read morePostgreSQL Support
Our support team consists without exception of experienced employees with at least 10 years of relevant database experience in the PostgreSQL environment!
PostgreSQL consulting
We are one of the leading providers of PostgreSQL, providing professional services and charge some of the lowest rates in the entire industry while maintaining superior quality.