Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 32 Minute(s)
Language
English
Rating
Course Overview
The Ultimate Guide to master the world most Advance Open Source Database
PostgreSQL is arguably the most advance and powerful opensource enterprise class relational database system. It is the object relational database system and provides the most standard compliant system for the Database designers. It provides the complete support for reliable transactions that is (ACID complaint) where ACID stands for Atomicity, Consistency, Isolation and Durability.
Its advance underlying technology makes it extremely powerful and programmable. Support for concurrency is one of its key feature. It is one of the most important technology you will learn and will greatly affect the way you work with Databases. It is the ultimate RDBM system which will allow you to create complex web apps which works flawlessly even for very large number of users.
PostgreSQL is the fastest growing RDBMS and with a large and thriving community it is a great asset to learn this amazing technology.
Our course will teach you this complex system in the easiest of ways. It will start with basic intro to RDBMS system with a emphasis on PostgreSQL. We will also discuss the main differences between MySQL and PostGreSQL the two most popular open source RDBMS. By the end of this course you will be able to...
Use PostgreSQL in your projects
Understand the important features of Postgres
Understand the Object Relational model
Master SQL which can be used across DB systems
Build actual web apps using PostgreSQL
So hop on and be the master of one of the hottest RDBM system
Course Content
- 7 section(s)
- 29 lecture(s)
- Section 1 Introduction
- Section 2 Getting Started with PostGreSQL
- Section 3 Database Development
- Section 4 Writing SQL
- Section 5 SQL functions and operators
- Section 6 PHP & PostGres Web Application
- Section 7 Course Summary
What You’ll Learn
- Learn PostgreSQL RDBMS, Learn Object Relational Model of PostgreSQL, Learn to implement web apps using PostgreSQL, Master SQL and use it with PostgreSQL, Learn to build complex systems using PostgreSQL
Reviews
-
WWilli Konrad Schäfer Hennings
There was no hint, that this is an old postgres Version ( 9.x), so you should refund me. Too much weight put on php, whioch I will not use and do not have to know. It is not fun to watch an instructor type in stuff, so this teaching metod is good for nothing. For bloody beginners it might help, but it comes 9 years too late. Thanks for wasting my time, Willi
-
MMichael Bunyan
good broad intro to sql and db concepts with nice ending demo using php could do more on benefits of postgresql be aware these lessons refer to products that are 2 years or more old, but principles remain same
-
CChristoph Odermatt
Very intro. Mostly on database creation and some main SQL queries. Good speed for beginners.
-
AAllen
This course is largely a "look-over-the-shoulder" of a real programmer who is talking through what he is doing as he is doing it, including fixing errors. This was very valuable to me as I was prep'ing a demo of same technologies. You will have to pause / rewind the presentation frequently and code along with the instructor to pick-up what he is putting-down. I took 1/2 star off because the course did not provide the code that was being pasted in during the xampp and phppgadmin installs.
