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).

« Hide The Details

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
Numeric Functions
Character Functions
Date and Time Functions
Data Conversion Functions
NULL Functions
Grouping Functions GROUP BY -- HAVING
AVG, COUNT, MAX, MIN, SUM
Subqueries
Simple Subqueries
Correlated Subqueries
Joins
Inner Join
Outer Join
Analytic Functions
UNION, UNION ALL, INTERSECT, EXCEPT
SQL - Data Definition Language
CREATE, ALTER, DROP
Referential Integrity
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

Audience

Application programmers.
Designers interested in gaining an understanding of SQL.
Systems programmers.

Recommended Prerequisites

None

Training Style

Instructor led with hands on workshops

« Hide The Details

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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]

Privacy Notice