PostgreSQL For Beginners
4.3 (20 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
784 students enrolled
Wishlisted Wishlist

Please confirm that you want to add PostgreSQL For Beginners to your Wishlist.

Add to Wishlist

PostgreSQL For Beginners

Learn PostgreSQL quickly with Practical Hands-On Easy to Follow Videos
Best Selling
4.3 (20 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
784 students enrolled
Last updated 4/2017
English
Curiosity Sale
Current price: $10 Original price: $165 Discount: 94% off
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • You should be comfortable using a computer
  • You should have an understanding of Database Concepts
  • You should have basic SQL knowledge
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 is the target audience?
  • Beginner Database Administrators
  • Beginner Data Analyst
  • Beginner Data Scientist
  • Beginner Big Data administrator
  • Graduates and IT Professionals who want to learn PostgreSQL
Students Who Viewed This Course Also Viewed
Curriculum For This Course
62 Lectures
06:26:53
+
Installing PostgreSQL Server and Database
10 Lectures 48:46




Verify PostgreSQL installation
04:02

Connecting to PostgreSQL Database
07:30

Installing PostgreSQL on Macs
03:15

What is PostgreSQL
03:44

Who is Using PostgreSQL
06:17

Load sample database
09:26
+
PostgreSQL Server and Database Objects
12 Lectures 45:31
Introduction
01:21

Server service
05:00

Database
03:45

Table
03:54

Schema
03:46

Tablespace
03:30

views
04:18

Functions
04:47

Cast and Operators
02:48

Sequences
06:44

Extensions
04:42

Section Summary
00:56
+
PostgreSQL Fundamentals
11 Lectures 01:14:04
PostgreSQL Data Types
09:48

PostgreSQL UNIQUE Constraint
06:09

Filtering Data with WHERE clause
06:58

Retrieving all Data from Table
06:33

Query Data from specific column
07:41

Removing Duplicate Records
05:00

Sorting Data
08:16

PostgreSQL ORDER BY clause
04:21

PostgreSQL Group By
11:15

PostgreSQL Having
04:11

PostgreSQL Truncate and DROP Table
03:52
+
PostgreSQL CRUD Operations
9 Lectures 59:17
Introduction to PostgreSQL CRUD Operations
00:56

Create a Database with PG4ADMIN
05:40

Create a Table with PG4ADMIN
07:48

PostgreSQL CREATE Table Statement
08:40

PostgreSQL SELECT statement - Reading data
05:10

PostgreSQL Subquery
08:13

PostgreSQL UPDATE
07:48

PostgreSQL DELETE Statement
05:26

PostgreSQL INSERT Statement
09:36
+
PostgreSQL Operators
14 Lectures 01:48:40
PostgreSQL Comparison operators
09:49

PostgreSQL BETWEEN Operator
09:06

PostgreSQL NOT BETWEEN Operator
05:33

PostgreSQL NOT Operator
05:49

Postgres LIKE Operator
11:37

PostgreSQL OR Operator
06:35

PostgreSQL AND Operator
07:07

PostgreSQL combining AND | OR Operator
08:33

PostgreSQL LIMIT Operator
10:05

PostgreSQL IN Operator
10:57

Postgress UNION Operator
04:42

PostgreSQL UNION ALL Operator
03:30

PostgreSQL INTERSECT Operator
06:20

PostgreSQL EXCEPT Operator
08:57
+
Getting Data from Multiple Tables with Table JOINS
6 Lectures 50:35
Introduction to Postgres JOINS
01:06

PostgreSQL Inner Join
10:35

PostgreSQL Left Join
11:17

PostgreSQL Full Outer Join
10:21

PostgreSQL Cross Join
06:49

PostgreSQL Natural Join
10:27
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,577 Reviews
35,183 Students
85 Courses
Learning made simple

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.