Workshop: Hands-on PostgreSQL
![](https://www.socallinuxexpo.org/sites/default/files/styles/square_thumbnail/public/speakers/Screen%20Shot%202018-10-31%20at%202.23.56%20PM.png?itok=WX0A8y6M)
Audience:
Topic:
A hands-on tutorial designed to quickstart anyone looking to work directly in PostgreSQL.
The tutorial will first lay the groundwork for the hands-on session by covering fundamential concepts:
- Quick introduction of relational theory
- The SQL programming language
- PostgreSQL software and community
We will then dive into creating, modifying, and querying databases hands-on. Topics will include:
- Creating a database
- Creating and modifying tables
- Writing data into the database
- Writing queries
- Exporting data out of the database
We will wrap-up by introducing some of the more advanced features that build on the hands-on experience participants have just gained, including:
- Triggers
- Stored Procedures
- Functions
- Views and Materialzied Views
- Foreign Data Wrappers
Room:
Room 104
Time:
Thursday, March 5, 2020 - 09:30 to 12:15