PostgreSQL Course
PostgreSQL (pronounced as post-gress-Q-L) is an open source relational database management system (DBMS) developed by a worldwide team of volunteers. PostgreSQL is not controlled by any corporation or other private entity and the source code is available free of charge
PostgreSQL supports four standard procedural languages, which allows the users to write their own code in any of the languages and it can be executed by PostgreSQL database server. These procedural languages are - PL/pgSQL, PL/Tcl, PL/Perl and PL/Python. Besides, other non-standard procedural languages like PL/PHP, PL/V8, PL/Ruby, PL/Java, etc., are also supported
Skilled Instructors
Flexible Learning
Interactive Content
Hands-on Experience
Personalized Learning Paths
Career Support
Course Modules
-
PostgreSQL – Overview.
-
PostgreSQL – Environment Setup
-
PostgreSQL – Syntax
-
PostgreSQL – Data Type
-
PostgreSQL – CREATE Database
-
PostgreSQL – SELECT Database
-
PostgreSQL – DROP Database
-
PostgreSQL – CREATE Table
-
PostgreSQL – DROP Table
-
PostgreSQL – Schema
-
PostgreSQL – INSERT Query
-
PostgreSQL – SELECT Query
-
PostgreSQL Arithmetic Operators
-
PostgreSQL Comparison Operators
-
PostgreSQL Logical Operators
-
PostgreSQL Bit String Operators
-
PostgreSQL – Boolean Expressions
-
PostgreSQL – Numeric Expression
-
PostgreSQL – Date Expressions
-
PostgreSQL – WHERE Clause
-
PostgreSQL – AND & OR Conjunctive Operators
-
PostgreSQL – UPDATE Query
-
PostgreSQL – DELETE Query
-
PostgreSQL – LIKE Clause
-
PostgreSQL – LIMIT Clause
-
PostgreSQL – ORDER BY Clause
-
PostgreSQL – GROUP BY
-
PostgreSQL – HAVING Clause
-
PostgreSQL – CONSTRAINTS
-
NOT NULL Constraint
-
UNIQUE Constraint
-
PRIMARY KEY Constraint
-
FOREIGN KEY Constraint
-
CHECK Constraint
-
Dropping Constraints
-
PostgreSQL – JOINS
-
The CROSS JOIN,The INNER JOIN,The LEFT OUTER JOIN,The RIGHT OUTER JOIN,The FULL OUTER JOIN
-
Live Projects
-
Deployments