We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

PostgreSQL Server and Database Training at FuturePoint

ENDED
Online Training by  FuturePoint
Inquire Now
Online / Training

Details

  1. Installing PostgreSQL Server and Database
  • Introduction
  • PostgreSQL Server Minimum Requirements
  • Download PostgreSQL
  • Installing PostgreSQL on Windows
  • Verify PostgreSQL installation
  • Connecting to PostgreSQL Database
  • Installing PostgreSQL on Macs
  • What is PostgreSQL
  • Who is Using PostgreSQL
  • Load sample database
  • 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
    PostgresqlSubQuery
    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
  • Hands-on with Practical’s
  • Q&A

 

 

  1. PostgreSQL Server and Database Objects

Introduction

Server service

Database

Table

Schema

Tablespace

views

Functions

Cast and Operators

Sequences

Extensions

Section Summary

Hands-on with Practical’s

Q&A

 

 

  1. PostgreSQL Fundamentals

PostgreSQL Data Types

PostgreSQL UNIQUE Constraint

Filtering Data with WHERE clause

Retrieving all Data from Table

Query Data from specific column

Removing Duplicate Records

Sorting Data

PostgreSQL ORDER BY clause

PostgreSQL Group By

PostgreSQL Having

PostgreSQL Truncate and DROP Table

Hands-on with Practical’s

Q&A

 

 

  1. PostgreSQL CRUD Operations

Introduction to PostgreSQL CRUD Operations

Create a Database with PG4ADMIN

Create a Table with PG4ADMIN

PostgreSQL CREATE Table Statement

PostgreSQL SELECT statement - Reading data

PostgreSQL Subquery

PostgreSQL UPDATE

PostgreSQL DELETE Statement

PostgreSQL INSERT Statement

Hands-on with Practical’s

Q&A

 

 

  1. PostgreSQL Operators

PostgreSQL Comparison operators

PostgreSQL BETWEEN Operator

PostgreSQL NOT BETWEEN Operator

PostgreSQL NOT Operator

Postgres LIKE Operator

PostgreSQL OR Operator

PostgreSQL AND Operator

PostgreSQL combining AND | OR Operator

PostgreSQL LIMIT Operator

PostgreSQL IN Operator

Postgress UNION Operator

PostgreSQL UNION ALL Operator

PostgreSQL INTERSECT Operator

PostgreSQL EXCEPT Operator

Hands-on with Practical’s

Q&A

 

  1. Getting Data from Multiple Tables with Table JOINS

Introduction to Postgres JOINS

PostgreSQL Inner Join

PostgreSQL Left Join

PostgreSQL Full Outer Join

PostgreSQL Cross Join

PostgreSQL Natural Join

Hands-on with Practical’s

Q&A

 

 

 

 

Courses  Offerings 
      

  • Amazon Web Services
  • Android
  • AIX Administration
  • Business Analyst
  • BIRT Reporting
  • CA Siteminder
  • CCNA, CCNP Security,
  • Citrix  XenApp
  • Cognos 10 BI & Tm1
  • Crystal Reports
  • Data Stage
  • DB2 DBA
  • Dell Bhoomi
  • Dev Ops
  • Dot Net
  • Full Stack Developer
  • Google Web Tool Kit
  • Golden Gate
  • Hadoop
  • Hyperion  Essabase, Planning, HFR , HFM , DRM
  • IBM Websphere Commerce server Admin
  • IBM Lotus Notes (Development) 
  • IBM Lotus Notes Domino Server Administration
  • IBM Message Broker
  • IBM MQ Series Administration
  • IBM Netezza DBA & Development
  • IBM Tivoli Access Manager
  • IBM Web Sphere Application Server Administration (WAS)
  • IBM Websphere Transformation extender (WTX 8.2)
  • IBM Integration BUS  ( IIB )
  • Informatica
  • I Phone
  • Swift Language training
  • Java/J2EE         
  • JAVA UI  
  • Java Apache Wicket
  • JIRA
  • Linux Administration training
  • Mango DB
  • MicroSoft .NET Technologies (VB.NET, C#, ASP.NET, Wcf ,Wpf ,Mvc)
  • Microstrategy
  • MicroSoft Business Intelligence  MSBI
  • MS Power BI
  • OBIEE 11 g , 12c
  • ODI ( Oracle  Data Integrator)
  • Openstack
  • Oracle FUSION APPS   SCm / HCM / Financial
  • Oracle APPS –  HRMS, SCM, Manufacturing , Technical , ASCP .Dmantra
  • Oracle APPS – Project Accounting
  • Oracle APPS  - iProcurement ,  iSupplier, Sourcing
  • OAF
  • Oracle BI Apps  
  • Oracle BI Publisher
  • Oracle DBA  11g
  • Oracle RAC  , Data Guard , Performance Tuning,
  • Oracle Fusion SOA 
  • Oracle SQL , PL SQL
  • People soft Functional and Technical
  • PHP
  • Perl Scripting
  • Qlikview
  • RSA  Archer Security Operations Management (SecOps) Essentials
  • RUBY Cucumber
  • Robotics Automation Process
  • SAP  SD  ,  BO  , FICO , BI / BW , APO , BPC, BASIS , SRM , MM, ISOil, BODS
  • SAP Simple Finance
  • SAS
  • Sales Force CRM
  • Shell Scripting
  • SQL Server DBA
  • Springs and Hibernate
  • Storage Area Network  ( SAN)
  • Tableau
  • Team Foundation Server
  • Tera Data
  • Testing Tools  - QTP, QC, Load Runner, Selenium, ISTQB
  • TIBCO BW,
  • Tivoli Access Manager & Tivoli Storage  Manager
  • Unix & Linux Administration
  • VMWare
  • WCF, WPF, LINQ,  AJAX, SILVER LIGHT
  • Webservices   , SOAP , REST ( JAVA)
  • Windows 2012 server

 

      http://www.futurepointtech.com/postgresql-training.html

Drop a mail [email protected]  we will get in touch with u

Schedules

Aug 22, 2019 - Aug 20, 2020
ENDED
No. of Days: 30
Total Hours: 25
Reviews
Be the first to write a review about this course.
Write a Review

Future Point Technologies is a Thirteen  Years old leading Software Training center based in Hyderabad. The Future Point Technologies is an Institute dedicated to teaching Core Computer Technologies to students and professionals. 

 

FUTUREPOINT  Offers CLASS Room, ONLINE and CORPORATE Trainings.

 

  • ATTEND THE DEMO AND CHECK THE QUALITY OF OUR EXPERIENCED TRAINERS

We offer Online Training , so you get trained from where you are from our experienced trainers, In the weekdays as well as weekends by the Real Time Professionals .
The program is designed to provide rich learning experience for students using Internet .

Courses  Offerings 
      

  • Amazon Web Services
  • Android
  • AIX Administration
  • Business Analyst
  • BIRT Reporting
  • CA Siteminder
  • CCNA, CCNP Security, CCIE , CheckPoint
  • Citrix  XenApp
  • Cognos 10 BI & Tm1
  • Crystal Reports
  • Data Stage
  • DB2 DBA
  • Dell Bhoomi
  • Dev Ops
  • Dot Net
  • Google Web Tool Kit
  • Golden Gate
  • Hadoop
  • Hyperion  Essabase, Planning, HFR , HFM , DRM
  • IBM Websphere Commerce server Admin
  • IBM Lotus Notes (Development) 
  • IBM Lotus Notes Domino Server Administration
  • IBM Message Broker
  • IBM MQ Series Administration ...
FuturePoint Technologies
Plot No:60, 2nd Floor ,Western Hills, Opp: Sri Chaitanya Junior Kalasala Behind Arjuna Theatre, KPHB,Hyderabad - 500072
4040178841
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.