Beginner's Guide to PostgreSQL

PostgreSQL Tutorial: What you need to know to get started with relational databases in PostgreSQL

4.00 (352 reviews)
Udemy
platform
English
language
Databases
category
instructor
Beginner's Guide to PostgreSQL
1,950
students
6 hours
content
Dec 2015
last update
$54.99
regular price

What you will learn

Understand why databases are useful

Understand how relational databases work

Learn how to install and setup PostgreSQL

Learn how to create databases and database structures

Learn how to insert and manipulate data in a PostgreSQL database

Learn how to write SQL statements for PostgreSQL

Description

PostgreSQL is an awesome open source relational database, that's fast and easy to use. We've used it here at my company in a few large projects with great performance.

In this beginner level PostgreSQL tutorial course I'll be going over all the basic concepts of relational databases and dive into how to use PostgreSQL. No previous database experience is required for this PostgreSQL tutorial course - all the basic concepts like tables and relations are covered. It's thorough and meant to help anyone starting out with databases.

The PostgreSQL tutorial course covers database concepts, database installation and connection, client software used to connect to and manage the database (pgAdminIII) and also the main SQL statements and how they work with PostgreSQL.

This PostgreSQL tutorial course is currently under construction, with close to 5 hours of material already available. Considering that, I'll be offering it at a discounted price. Once finished, it will be priced at $99.

</p>

Content

Introduction

An Introduction to the Course
Database Overview
Identities in database tables
Normalization
Relationships
Relationship Quiz
Relationship Types
Relationship Types Quiz
Database Management Systems
PostgreSQL features
PostgreSQL Windows Installation

Database Usage Basics

Connecting to Database Server with pgAdmin III
Configuring PostgreSQL to Accept External Connections
Creating Databases
Creating Tables
Inserting and viewing data in pgAdmin III
DataTypes Intro
Numeric DataTypes in PostgreSQL
Serial Datatypes For Row Ids
Character Types
The Date Datatype
The time datatype
Timestamps
The boolean datatype
NULL Values
Requirements
Car Repair Shop DB Requirements
Designing the repair shop database Pt1
Designing the repair shop database Pt2
Designing the repair shop database Pt3 - choosing datatypes
Car Repair Shop DB Table and Column Definitions
Building the Database - Part 1
Applying constraints to table columns
Creating relationships between tables in pgAdmin III
Creating the remaining tables
Users and Privileges
Backup and Restore in PostgreSQL with pgAdmin III

SQL in PostgreSQL

Introduction to SQL
The CREATE TABLE command
The CREATE TABLE command with constraints PT 1
The CREATE TABLE command with constraints pt.2
Script: First Two Create Table commands
The CREATE TABLE command with foreign keys PT 1
The CREATE TABLE command with foreign keys PT 2
Scripts: Create Tables with Foreign keys
CREATE TABLE quiz
Drop Table
The Alter Table command
Script: Drop And Alter Table commands
Insert Into SQL Command
Insert scripts used in the previous video
The Update Statement
Update Script file
The DELETE FROM Statement
Deletes with cascades
Script: Delete from commands for the previous videos
The TRUNCATE command
Truncate Script
Filling the database with data
Full Db Script
The SELECT command
pgAdmin III's Graphical Query Builder
The WHERE clause (PT I)
The WHERE clause (PT 2) - BETWEEN and IN
The WHERE clause (PT 3) - IS [NOT] NULL
The WHERE clause (PT 4) - LIKE and ILIKE
The WHERE clause - using the graphical query builder
The WHERE Clause Command Script
The LIMIT and OFFSET clauses
QUIZ - Limits and Offests
The ORDER BY clause
Order By commands
Aggregate functions - Count, Max, Min, Avg
Joins tables in a query through relationships

Reviews

Andrew
November 23, 2016
Fascinating!! Thank you for your work!! I really like your explanations and examples!! Please, create new additional advanced lessons to strength our knowledge!
Alexander
October 16, 2016
Your approach is very concise and clear yet easy to follow. For 65 years old like me to understand and easily use it, you must be very good at communicating. Thanks. At 65, it is not easy to learn something new. You sure did wake up my brain by your directness and simplicity. No unexplained terminologies.
Genevieve
August 20, 2016
I have attempted to learn SQL before through books and having people walk me through it with not much success which was not this case with this course. It provides the perfect background of all aspects of database management. It ensures you can not only write your own queries to extract data from a database, but also understand underlying database structures.
Udemy
July 19, 2016
I thought there would be more command line associated with it. There seems to be a heavy emphasis on using pgAdmin III
Geraldo
July 11, 2016
Awesome course for beginners in RDBMS and PostgreSQL. Would advise tuning up the volume of videos a little more, but it wasn't that big of a deal. Thanks.
Patrick
June 22, 2016
The tutor gives very clear slow paced information on the material. During this course the tutor also explain why certain settings are used with added bonus some variation on certain commands and queries.
Errol
May 16, 2016
It has an excellent introduction to database design and the reasoning behind why good database design is important!
Diego
May 14, 2016
Its a realy nice course, but lacks a little of theory behind the normalization process, could be further aproached.
Antonio
March 18, 2016
Very good course, well explained and with a lot of examples taken from a case study that one can install in the computer.
Simon
January 31, 2016
Quite a nice overview of a the main features of postgreSQL with some helpful examples. My only problem was that there was far too much emphasis only the GUI pgadmin3. I don't think it is that helpful a tool, and "real" developers wouldn't use it. Just my thought, it might be right for you!
Bodvar
November 26, 2015
The only downside I have come across so far is that for a foreigner (not natively English speaking) the instructor/lecturer has somewhat unclear pronounciation which, at times, can lead to misunderstanding (rather too common in computer on-line training in general). Please work on that. That would add the sixth star!
Luis
July 29, 2015
The course is very informative and easy to follow, but it seems there are missing some lessons promised by the instructor. Browsing the blog we realize they are already missing for a long time.
Dan
May 11, 2015
As a complete beginner to PostgreSQL, I found this course to be exactly what I needed - a patient walk through and introduction to key concepts. The videos were well done - every step of the way had a patient and slow verbal explanation - there was no assumption on the part of instructor that left me wondering how he was logically progressing. The verbal explanations were succinct, well-thought out, and helpful. My computer science background is limited - I have had a community college course on full stack web development, and I have taken a number of online courses from Codecademy. This is my first Udemy course. So, my expectations were simply that I would come away from the course feeling like I had a grasp on the basics of PostgreSQL. I am very confident in Excel, and knew that SQL variants are also table-based, so knew that if I could apply my general knowledge and implement the appropriate syntax, I would be well-equipped to begin attacking my own database solutions. I consider the course a success in this regard. Regarding Codeacdemy, if you are looking for a course that asks you to solve problems in order to advance, this is not that type of course - it is a course for having PostgreSQL explained to you while you work alongside in the editor. I had my screen split in two, with the Udemy video in one screen, and the database admin program in the other. I typed along with everything in the video, as is my learning style, but you don't have to do that if you don't want to. I now feel confident to Google questions and read the PostgreSQL documentation and go from there. I also appreciated the full walk through of how to install the database admin program. A note on pricing: I purchased this course on a $10 sale. The full price is $49. It was very much worth the $10 - a no-brainer. If you're not in position to wait until it may or may not go on sale again, I would say that $49 is also very much worth the content, expertise, and good instruction in this course.
Justin
January 26, 2014
For someone wanting to lean PostgreSQL, this is basically the only option on Udemy. Despite the fact that there were only a couple of ratings I signed up for the course. I am ~50% through and have found it extremely frustrating so far. I wanted to learn PostgreSQL, but the first half is about setting up the tables. Compare this to Bucky Roberts course where he has the tables already made and hosted for you to download. This would be a nice option that could save 5+ hours for someone looking to learn the "how tos" of data analysis. The other bothersome point for me was the speed at which the narrator breezes through table creation. He rarely announces each step or explains fully what he is doing so it is EXTREMELY difficult to do along with him. I found myself stopping and trying to review the last 30 seconds of the video countless times.
Michael
December 29, 2013
The course does what the title states. It covers the basics in Postgresql and relates these to both gui driven queries and writing the same in SQL. The lectures include the lecturer typing in teh commands concerned. In this way you get a feel for both Postgresql' pgamin3 and the syntax required.

Charts

Price

Beginner's Guide to PostgreSQL - Price chart

Rating

Beginner's Guide to PostgreSQL - Ratings chart

Enrollment distribution

Beginner's Guide to PostgreSQL - Distribution chart
17615
udemy ID
5/11/2012
course created date
4/23/2020
course indexed date
Bot
course submited by