PostGreSql WORKSHOP
Course: PGSQL3
Duration: 3 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/PGSQL3.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
- 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
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.