Brief Introduction
Learn PostgreSQL quickly with Practical Hands-On Easy to Follow VideosDescription
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 .
Requirements
- Requirements
- You should be comfortable using a computer
- You should have an understanding of Database Concepts
- You should have basic SQL knowledge
Knowledge
- 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
Bluelime Learning Solutions
4.1 Raiting
SQL Masterclass: SQL for Data Analytics
- 4.5
-
![]()
![]()
![]()
![]()
![]()
SQL course covering basic to advanced SQL topics for SQL Database ( PostgreSQL ). Elucidates SQL Database for beginners 6 Reasons why you should choose this SQL course...
The Complete Microsoft SQL Masterclass: Beginner to Expert
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Master course using Microsoft SQL Server 2019. These SQL can also used in Oracle, MySQL, PostgreSQL, SQLite, DB2, etc. Covers different forms of SELECT Statements...
PostgreSQL Database Administration (DBA) for Beginners
- 4
-
![]()
![]()
![]()
![]()
![]()
Learn Practical Database Administration PostgreSQL is commonly known as Postgres and it is also open source database. PostgreSQL is a powerful, open source object-relational database system....
BI Developer : Learn ( Power BI |SSIS |SSRS |SSAS|DW|T-SQL )
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Gain Business Intelligence from Transforming Data Connect to hundreds of data sources and bring your data to life with live dashboards and reports....
