Practical PostgreSQL

Introduction

This is a 3 day intensive course in skills and methods for PostgreSQL.

 

Course Outline

I. Introduction

1. What is PostgreSQL?

• Open Source Free Version
• PostgreSQL Feature Set
• Where to Proceed from Here

2. Installing PostgreSQL

• Preparing for Installation
• 10 Steps to Installing PostgreSQL

II. Using PostgreSQL

 3. Understanding SQL

• Introduction to SQL
• Introduction to Relational Databases
• SQL Statements
• Data Types
• Tables in PostgreSQL

4. Using SQL with PostgreSQL

• Introduction to psql
• Using Tables
• Adding Data with INSERT and COPY
• Retrieving Rows with SELECT
• Modifying Rows with UPDATE
• Removing Rows with DELETE
• Using Sub-Queries
• Using Views
• Further SQL Application

5. Operators and Functions

• Operators
• Functions

6. PostgreSQL Clients

• The psql Client: Advanced Topics
• PgAccess: A Graphical Client

7. Advanced Features

• Indices
• Advanced Table Techniques
• Arrays
• Automating Common Routines
• Transactions and Cursors
• Extending PostgreSQL

III. Administrating PostgreSQL

 8. Authentication and Encryption

• Client Authentication
• Encrypting sessions

9. Database Management

• Starting and Stopping PostgreSQL
• Initializing the Filesystem
• Creating and Removing a Database
• Maintaining a Database
• Backing Up and Restoring Data

10. User and Group Management

• Managing Users
• Managing Groups
• Granting Privileges

IV. Programming with PostgreSQL

11. PL/pgSQL

• Adding PL/pgSQL to your Database
• Language Structure
• Using Variables
• Controlling Program Flow
• PL/pgSQL and Triggers

12. JDBC

• Building the PostgreSQL JDBC Driver
• Using the PostgreSQL Driver
• Using JDBC
• Issues Specific to PostgreSQL and JDBC

13. LXP

• Why Use LXP?
• Core Features
• Installing and Configuring LXP
• Understanding LXP Mark-Up
• LXP Variables and Objects
• Using Cookies with LXP
• Tag Parsing
• Branching Logic
• Loop Iteration
• Content Inclusion
• Displaying Foreign Tags with

V. PostgreSQL Command Reference

14. PostgreSQL Command Reference

---

User Reviews

Not yet rated. You will need to follow this course before you can write a review.