PostGreSql WORKSHOP

Course:  PGSQL3
Duration:  3 Days
Level:  I
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).

« 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 info@verhoef.com