MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

PostgreSQL 9 with PHP Essential Training

Course Summary

Shows how to architect PostgreSQL databases and integrate them into web applications using PHP.       

  • +

    Course Syllabus

       Using the exercise files
       Installing PostgreSQL on a Mac
       Installing PostgreSQL on a PC
       Installing PostgreSQL on Ubuntu Linux
       Installing XAMPP and SID on a Mac
       Installing XAMPP and SID on a PC
    1. Quick Start
       Getting the most out of the Quick Start
       Creating a database
       Creating a table
       Inserting data into a table
       Getting data from a table
       Updating data in a table
       Deleting data from a table
       Creating a database library
    2. Creating a Database
       Understanding databases and tables in PostgreSQL
       Creating a database
       Defining a table in SQL
       Creating a table in PHP
       Creating indexes
       Indexing ID fields
    3. Data Types
       Understanding data types
       Storing numbers with INTEGER
       Storing decimal numbers with NUMERIC
       Storing floating-point numbers with REAL
       Storing text
       Storing Boolean values
       Storing dates and times
    4. Storing and Reading Data
       Storing and deleting data with INSERT, UPDATE, and DELETE
       Reading data with SELECT
       Reading with JOIN
    5. SQL Expressions
       Understanding SQL expressions
       Matching patterns with LIKE
       Choosing from multiple conditions with the CASE expression
       Using casts to force type
    6. Mathematical Functions and Operators
       Using operators for simple arithmetic
       Using math functions
    7. String Functions and Operators
       Finding the length of a string
       Concatenating strings
       Returning parts of a string
       Replacing strings within strings
       Trimming and padding strings
       Converting numbers
    8. Date and Time Functions and Operators
       Getting the current time and date
       Specifying a specific time zone with AT TIME ZONE
       Performing date and time arithmetic
       Getting parts of a timestamp with EXTRACT
    9. PHP Interfaces
       Choosing an interface
       Using the PHP PostgreSQL extension interface
       Using the PDO interface
       Creating a library
    10. Web Applications
       Defining CRUD
       Using PHP to insert, read, update, and delete rows in a PostgreSQL database
       Installing the testimonials database
       An overview of the testimonials application
       Managing the database in PHP
       Displaying the testimonials using PHP


Course Fee:
USD 25

Course Type:


Course Status:



5 - 6 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top