PostGresSQL

Course Outline

Day 1

• What is PostGreSQL
• Open source free version
• PostgreSQL feature set
• Where to proceed from here
• Installing PostgreSQL
• Preparing for installation
• Ten Steps to installing PostgreSQL
• Understanding PostGreSQL
• Introduction to SQL
• Introduction to relational Databases
• SQL Statements
• Data Types
• Tables in PostgreSQL
• 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
• Operators and Functions
• Operators
• Functions

Day 2

• PostgreSQL Clients
• The psql clients: Advanced topics
• PgAccess: A graphical client
• JDBC
• Setting up PostgreSQL JDBC driver
• Using the PostgreSQL Driver
• Using JDBC
• Issues Specific to PostgreSQL and JDBC
• ODBC
• Setting up PostgreSQL ODBC driver
• Using the PostgreSQL Driver
• Using ODBC
• Issues Specific to PostgreSQL and ODBC
• Advanced Features
• Indices
• Advanced Table Techniques
• Arrays
• Automating common Routines
• Transactions and cursors
• Extending PostgreSQl

Day 3

• PL/SQL
• Adding PL/pgSQL to your database
• Language structure
• Overview of PL/SQL blocks
• Using variables
• Controlling Program Flow, Loops in PL/SQL
• Cursors, Exception handling
• Creating sequences, procedures, functions
• Creating Schemas (packages) PL/pgSQL and Triggers
• Authentication And Encryption
• Client authentication
• Encrypting Sessions

Day 4

• Database Management
• Starting and Stopping PostgreSQL
• Initializing the file system
• Creating and Removing the Database
• Maintaining a Database
• Backing up and restoring data
• User and Group Management
• Managing Users
• Managing Groups
• Granting Privileges

Advanced Topics

• Database Management
• Setting up and running SLONY-1 Replication System for PostgreSQL
• Object Oriented Database Concepts
• Optimizing PostGresSQL

Hands-on Assignments

The key concepts taught will be immediately followed up by the hands-on assignments in the lab to facilitate ease of understanding.

Back to Course Description  Onsite Training   Class Schedule  Registration