PostGreSql Workshop
Course: PGSQL
Duration: 3 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/PGSQL.html
Course Summary
This workshop uses the 'HANDS ON' approach to teach the participants the essential concepts of Structured Query Language (SQL) using PostGreSql (current or any release).
Topics Covered In This Course
Relational Database overview
POSTGRESQL overview
POSTGRESQL Objects
POSTGRESQL Environment
SQL - Data Manipulation Language
Simple SQL Queries ? SELECT ? FROM ? WHERE
ORDER BY
CASE
Single Value Functions
Grouping Functions ? GROUP BY - HAVING
Subqueries
Joins
UNION
SQL - Data Definition Language
INSERT, UPDATE, DELETE
What You Can Expect
At the end of this course, participants will be able to:
- Understand Relation Database Concepts.
- Use the POSTGRESQL environment.
- Use SQL in all aspects of POSTGRESQL.
Who Should Take This Course
- Application programmers.
- Designers interested in gaining an understanding of SQL.
- Systems programmers.
Training Style
Instructor led with hands on workshops
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.