PostgreSQL Server and Database Training at FuturePoint
Details
- 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
- 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
- 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
- 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
- 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
- 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
No. of Days: | 30 |
Total Hours: | 25 |
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 ...