Our Courses
PostgreSQL
Terms & Conditions
Charges for the Training is NON REFUNDABLE, NON TRANSFERABLE, NON-EXTENDABLE.
Timings & Dates may vary.
In case of cancellation of Training from our side, the participants of the cancelled Training will be given an option to be upgraded to another Training. If the offer is denied by them, only then will they be considered for a refund.
If In Any Case training is cancelled by Organizers due to any reason, we will refund the fee after deducting Bank Changes.
If you are not satisfied with our teaching,then drop us email at info@smartcodingg.com
Refund will be in 3 stages:
Verification>>Approval>>Bank Credit through the same mode of payment.
Cash refund is NOT possible under any circumstance.
We are not responsible for any software failing to run/install on the participant's laptop owing to different configurations in laptops.
If you are not satisfied with the quality of services provided during the Training, drop us a mail @ info@alvinitsolutions.in
- Live classes will be conduct from Monday-Friday. You Will Also Get Life Time Access of Recorded Sessions.
- Code files will be provided.
- 2+ Live Projects
- Query solving sessions
- Certification of Completion
What you will take after course?
PostgreSQL Syllabus
PostgreSQL is an ORDBMS [Open-Source Object-Relational Database Management System]. It is used to store data securely; supporting best practices, and allow recovering them when the request is processed.
PostgreSQL is initially introduced on 8th July 1996 at the University of California.
It is the first DBMS, which perform MVCC [Multi-Version Concurrency Control] feature, even before Oracle. The multi-version concurrency control attribute is known as snapshot isolation in Oracle.
PostgreSQL
PostgreSQL Syntax
Install PostgreSQL
PostgreSQL Database
Connect to a PostgreSQL DB
PostgreSQL Create DB
PostgreSQL Select Database
PostgreSQL Drop DB
PostgreSQL Table
PostgreSQL Create Table
PostgreSQL Drop Table
PostgreSQL Show Table
PostgreSQL Describe Table
PostgreSQL ALTER table
PostgreSQL ADD Column
PostgreSQL Drop column
Change Column Type
PostgreSQL Rename Column
PostgreSQL Truncate table
PostgreSQL temporary table
PostgreSQL Column Alias
PostgreSQL Sequence
Identity Column
PostgreSQL Upsert
PostgreSQL Subquery
Data Types
PostgreSQL Datatypes
PostgreSQL Numeric
PostgreSQL Character
PostgreSQL Text
PostgreSQL Varchar
PostgreSQL Boolean
PostgreSQL Integer
PostgreSQL SMALLLINT
PostgreSQL BIGINT
PostgreSQL Serial
PostgreSQL Date
PostgreSQL Time
PostgreSQL Timestamp
PostgreSQL Interval
PostgreSQL UUID
PostgreSQL JSON
PostgreSQL hstore
PostgreSQL Array
User-Defined data type
PostgreSQL Schema
PostgreSQL Schema
PostgreSQL Create Schema
PostgreSQL Drop Schema
PostgreSQL ALTER Schema
PostgreSQL Queries
PostgreSQL Insert
PostgreSQL Select
PostgreSQL Update
PostgreSQL Delete
PostgreSQL Clause
PostgreSQL Where
PostgreSQL Order By
PostgreSQL Group By
PostgreSQL Having
PostgreSQL Distinct
PostgreSQL Limit
PostgreSQL Fetch
PostgreSQL Conditions
PostgreSQL Condition
PostgreSQL And
PostgreSQL Or
PostgreSQL And & Or
PostgreSQL Not
PostgreSQL Like
PostgreSQL In
PostgreSQL Not In
PostgreSQL Between
PostgreSQL Exists
PostgreSQL Views
PostgreSQL View
PostgreSQL Join
PostgreSQL Join
PostgreSQL INNER Join
PostgreSQL Left Join
PostgreSQL Right Join
PostgreSQL Full Join
PostgreSQL Cross Join
PostgreSQL Self Join
PostgreSQL Natural Join
PostgreSQL Trigger
PostgreSQL Trigger
Create Trigger
DROP trigger
ALTER trigger
DISABLE trigger
ENABLE trigger
PostgreSQL Indexes
PostgreSQL Indexes
PostgreSQL Create Index
PostgreSQL Drop Index
PostgreSQL List Indexes
PostgreSQL Unique Index
PostgreSQL Index on Expression
PostgreSQL Partial Index
PostgreSQL Reindex
PostgreSQL Multi-column Indexes
Database Constraints
PostgreSQL Constraints
PostgreSQL Primary key
PostgreSQL Foreign Key
Unique Constraint
Check Constraint
Not-Null Constraint
PostgreSQL Advance
PostgreSQL versions
Differences
MongoDB vs PostgreSQL
PostgreSQL vs SQL Server
PostgreSQL vs MariaDB
PostgreSQL vs Oracle
PostgreSQL vs SQLite