PostgreSQL For Beginners (Udemy.com)

Learn PostgreSQL quickly with Practical Hands-On Easy to Follow Videos

( 18 Reviews )

Created by: Bluelime Learning Solutions

Produced in 2017

What you will learn

Use
Filter Data with WHERE clause
Retrieve Data from multiples using Table Joins
Implement Constraint on table columns
Use wildcards to search data patterns
Perform CRUD operation on PostgreSQL Database
Build complex PostgreSQL statement using Subqueries
DROP Tables
Truncate Tables
Sort Data returned by SELECT statement
GROUP Data
Query all Data from a Table
Query specific data from a Table

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 72 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a postgresql course? Or looking for more detail on Bluelime Learning Solutions's PostgreSQL For Beginners? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

PostgreSQL is commonly known as Postgres and it is also open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more.

The course also covers the basics of creating tables, storing data with data types, and working with expressions, operators, and strings.
Topics include:
Installing PostgreSQL
Verify postgresql installation
postgresql INSERT Statement
Postgres UNIQUE Constraints
Postgres Truncate statement
Postgres UPDATE
Postgresql INNER JOIN
Removing Duplicate Records
Postgres LIKE Operator
Postgresql OR Operator
Sorting Data
Server service
Sequences
Schema
Retrieving all Data from Table
Query Data fro specific column
Loading sample database
Postgresql DELETE Statement
Postgresql DATA Types
Postgresql CREATE Table Statement
Postgresql SubQuery
Postgresql UNION Operator
PostgreSQL ORDER BY clause
PostgreSQL UNION ALL Operator
PostgreSQL GROUP BY clause
PostgreSQL FULL OUTER JOIN
PostgreSQL CROSS JOIN
PostgreSQL combining AND | OR Operator
PostgreSQL AND Operator
PostgreSQL BETWEEN Operator
PostgreSQL NATURAL JOIN Operator
PostgreSQL SELECT statement
CRUD Operations
PostgreSQL EXCEPT Operator
Create a Database with PG4ADMIN
Create a Table with PG4ADMIN
PostgreSQL NOT Operator
PostgreSQL NOT BETWEEN Operator
PostgreSQL LIMIT Operator
PostgreSQL INTERSECT Operator
PostgreSQL Left Join
PostgreSQL IN Operator
PostgreSQL HAVING clause
Comparison operators
Cast and Operators
Filtering Data with WHERE clause

This is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL .

Who this course is for:

Beginner Database Administrators
Beginner Data Analyst
Beginner Data Scientist
Beginner Big Data administrator
Graduates and IT Professionals who want to learn PostgreSQL

Time: 6.5h

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

Bluelime Learning Solutions

3.6 Rating
18 Reviews

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Reviews

3.6

18 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Prasanth P on

practical exercises are the one i am expecting more, and here i cant find any till now

By Shrinivas Dharmadhikari on

Total lack of on line guidance

By Glynn Bailey on

Very beginner focused, but a very complete intorduction of PostgreSQL and the SQL language.

By Dheeraj on

Good, what I expected

By shashidhar sunkari on

it is clear and interesting

By Ershov Sergey on

Very informative and easy to understand!

By Paul Swithers on

The delivery is very dry. Fortunately, I'm drinking coffee or I'd be falling asleep by now (even the coffee wasn't enough at times). A lot of time wasted showing us over and over how to find pgAdmin and enter the password. Some of his explanations miss the point. For example, the "CROSS JOIN" lecture never explains what a cartesian product is and the repeated emphasis on combining all of the columns, rather than rows, gives an incorrect impression at best. The examples are trivial and meaningless for the most part. These constructs are useful to answer real business problems and make more sense when illustrated in that manner. The amount of information you actually get from this course could be covered in a an hour or two. The delivery is slow, boring, and uninformative. Except for one or two concepts that are unique to Postgres, this is a poor intro to SQL course. There are much better courses (see Khan Academy) which may or may not use Postgres for their examples. At this level, the database is largely immaterial. Don't waste your time and money on this course.

By Brian Marshall on

Enjoyed the course and found it very informative, I have never used PostgreSQL before so found the information very helpful.

By William Shively on

This course is absolute beginner level, which is fine. It will not be useful to someone who already has some SQL experience who e.g. needs to know what is particular to PostgreSQL, and many important details are glossed over or not mentioned. (e.g. subtleties of different data types, why you would choose some over others for certain purposes; how do different versions of SQL vary on certain clauses, functions; how to deal with temporal data; no mention of WITH clauses; etc.)The videos really needed to be edited, some parts better organized. All of the videos appear to have been made in one take with no edits. Some typos. Unnecessary repetition between videos. Presentation is very slow; I had to watch it at 1.5x and 2.0x speed. Even so I did learn some things about pgAdmin and aspects of SQL that I rarely use.

By Marcos Branco on

COMO LEIGO ESTOU CONSEGUINDO ACOMPANHAR TOTALMENTE.

By James L on

The explanation is very shallow and uninsightful. Many times the teacher just rephrases the names of the things on the screen without useful explanation. For example, even at chapter 2, he hasn't explained what are scripts, dependencies, and "schemas" is sorely lacking: what's a "logical container"? What does he mean by "other database objects"?I will most likely request for a refund if the remaining videos do not reflect a higher quality of content. I am learning PostgreSQL completely from scratch, but I've learned basic SQL functions before.

By Leonardo Vega on