PostgreSQL For Beginners (Udemy.com)
Learn PostgreSQL quickly with Practical Hands-On Easy to Follow Videos
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
Overall Score : 72 / 100
Course Description
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
Instructor Details
- 3.6 Rating
18 Reviews
Bluelime Learning Solutions
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.
More courses by Bluelime Learning Solutions
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) (2021)
3.7 (260 Reviews)
Provider: Udemy
Time: 17h
$11.99
17 Beginner C# Walkthrough Projects step by step (2021)
3.9 (189 Reviews)
Provider: Udemy
Time: 17h
$11.99
PostgreSQL Database Administration (DBA) for Beginners (2018)
3.2 (93 Reviews)
Provider: Udemy
Time: 11.5h
$11.99
Python and Django Full-Stack Web Development for beginners (2021)
4.3 (58 Reviews)
Provider: Udemy
Time: 34.5h
$11.99
Learn Java by building 17 projects step by step (2018)
3.6 (52 Reviews)
Provider: Udemy
Time: 10.5h
$11.99
More postgresql courses
SQL and PostgreSQL: The Complete Developer's Guide (2021)
4.8 (60 Reviews)
Provider: Udemy
Time: 22h
$11.99
Practical SQL Bootcamp for Data Analysts and Data Scientists (2021)
4.8 (50 Reviews)
Provider: Udemy
Time: 3.5h
$11.99
Python 3 Complete Masterclass - Make Your Job Tasks Easier! (2021)
4.7 (414 Reviews)
Provider: Udemy
Time: 15.5h
$11.99














