Learn Database Design using PostgreSQL

The Ultimate Guide to master the world most Advance Open Source Database
4.1 (62 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,250 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 28
  • Length 5.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2014 English

Course Description

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

What are the requirements?

  • Basic understanding of web programming
  • Knowledge of HTML

What am I going to get from this course?

  • 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

What is the target audience?

  • Database designers
  • Web Develoeprs
  • Software Architects
  • MySQL developers

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
03:09

Introduction to Database Design Course in PostGreSQL

09:57

Lecture explaining the RDBMS concepts

06:54

Introduction to database concepts in PostgreSQL

10:56

The lecture highlights the main difference between MySQL and PostgreSQL

Section 2: Getting Started with PostGreSQL
09:20

Lecture describes the installation process of PostGreSQL

06:57

Learn to install XAMPP in this lecture

11:10

Learn to use the PSQL command line

09:24

Learn to use the phpPgAdmin to carry out basic operations

Section 3: Database Development
09:50

The lecture describes the naming conventions used for DB design

11:46

Learn the best practices of DB design and Normalization

20:21

Learn to create schematic DB design

20:19

The lecture explains the DB creation and data entry

08:39

Lecture explaining the Database Import and Export

Section 4: Writing SQL
10:43

A quick intro to SQL

10:43

Seletion and Viewing Operations for the DB

05:36

The other CRUD operations in SQL

07:41

Learn the Join operation in SQL with this lecture

24:05

The SQL wrap up lecture

Section 5: SQL functions and operators
13:44

Introduction to String functions in SQL

06:33

Learn the math functions in SQL

14:14

Learn all about the Aggregate functions and Group By operations

11:18

Lecture describing the Union , IN and Concat operations in SQL

Section 6: PHP & PostGres Web Application
20:19

Application UI of a web project

06:53

Connecting our web page to PostGreSQL

12:55

Selection and Display of Data from PostGreSQL

25:40

Adding Data from our Web App to the DB

19:48

Updating and Deletion implementation of the web project

Section 7: Course Summary
03:23

Course Wrap up

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Eduonix Learning Soultions, 1+ Million Students Worldwide | 200+ Courses

Eduonix creates and distributes high quality technology training content. Our team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.

Instructor Biography

Ready to start learning?
Take This Course