Beginner's Guide to PostgreSQL (Udemy.com)

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

( 50 Reviews )

Created by: Miguel Alho

Produced in 2015

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 82 / 100

Course 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>Who this course is for:

Database beginners
Basic database users who want to understand and learn PostgreSQL

Time: 6h

Instructor Details

Miguel Alho

4.1 Rating
50 Reviews

I am currently running my own web-based software development company (mainly .NET based ) building HRIS (Human Resource Information Systems) software for HR teams. I've also been employed as a teacher to 7th and 8th graders in Tec. Ed. classes, and voluntarily accepting 12th grade internships of IT students through local schools.

I am currently finishing a couple of web based projects for one of Sonae's human resources departments - Sonae being the largest private employer in Portugal, after having concluded a project for a Cape Verdian Bank (in colaboration with G333.Net).

When possible, I work on internal R&D projects, namely our devolpment framework, a DSL for code generation, and product ideas. I also colaborate with various local companies and institutions, both professionaly and voluntarily, namely the Santa Casa da Misericrdia da Murtosa.

My colleagues and I are experienced in developing costumized software, service and database solutions for businesses. We work with .Net, PostrgeSQL databases (or others as needed) , Ajax and Javascript based interfaces and our own internal framework for rapid development and maitenance.