CodeLesson
Instructor-Led Courses

Introduction to PostgreSQL

An instructor-led online course led by Joe Miller.
Instructor
Joe is a software developer based out of Mississauga, ON. He has over 15 years of experience creating applications on a wide variety of RDBMS platforms.
Enroll

Introduction to PostgreSQL

An instructor-led online course

This course is a basic introduction to the PostgreSQL relational database system. In the course you'll gain hands-on experience with using PostgreSQL to store and retrieve relational data, including SQL queries, using full-text search, creating and calling functions, and relational data design.

CodeLesson courses are comprised of readings, weekly hands-on coding assignments evaluated by your instructor, and online Q&A and discussions.

Your course is available 24 hours a day, and your instructor is available to provide assistance if you need it — you're never stuck on your own.

$325.00

Course Description

This course is a basic introduction to the PostgreSQL relational database system. In the course you'll gain hands-on experience with using PostgreSQL to store and retrieve relational data, including SQL queries, using full-text search, creating and calling functions, and relational data design.

Course Outline

Hello, world!

  • History of PostgreSQL project
  • Features
  • Basic SQL

Usage

  • psql
  • Drivers: Perl and Python examples
  • GUIs
  • Documentation

Survey of features

  • Full text search
  • Built-in functions
  • Datatypes
  • Partial indexes and indexes on expressions
  • Transactional DDL

Community

  • Mailing lists & IRC
  • Asking questions
  • Modules, add-ons, tools

Operations

  • System and hardware
  • Installation and configuration
  • Maintenance and operation
  • Replication

Prerequisites

  • Basic PC skills.
  • Access to a desktop personal computer capable of remote access via ssh. (Windows, Macintosh OSX, and Linux computers, among others, all qualify.)

Format

Taught online. Instructor-led. 6 units. What's a unit?

A unit measures the time it takes to complete one of our instructor-led courses. Each unit normally requires about 4-6 hours of effort. We expect you'll do at most one unit per week. You may take more or less time to complete the course. Most of our courses are four units. We offer extended time if you need more time to complete the course.

CodeLesson courses are available to students 24 hours a day while the course is in session. That means you can participate in the course even if you have a busy daytime schedule or if you're located in a different time zone.

Courses are comprised of online and offline readings, weekly quizzes, online discussion topics, and hands-on coding exercises that are evaluated by the instructor. You can post questions about the coursework at any time and the instructor will provide guidance. You're never stuck on your own.

Certification

CodeLesson PostgreSQL Pudding Badge

Students who complete this course receive the PostgreSQL Pudding certification. You can display the certification on your CodeLesson profile as proof you've completed this course.

Copyright © 2010-2013, LessonPlex Inc. Support/Feedback. FAQ.