Learn Database Design using PostgreSQL
4.0 (79 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,371 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Database Design using PostgreSQL to your Wishlist.

Add to Wishlist

Learn Database Design using PostgreSQL

The Ultimate Guide to master the world most Advance Open Source Database
4.0 (79 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,371 students enrolled
Last updated 8/2014
English
Price: $40
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • Basic understanding of web programming
  • Knowledge of HTML
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

Who is the target audience?
  • Database designers
  • Web Develoeprs
  • Software Architects
  • MySQL developers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 28 Lectures Collapse All 28 Lectures 05:32:17
+
Introduction
4 Lectures 30:56

Introduction to Database Design Course in PostGreSQL

Preview 03:09

Lecture explaining the RDBMS concepts

Preview 09:57

Introduction to database concepts in PostgreSQL

PostGreSQL Overview
06:54

The lecture highlights the main difference between MySQL and PostgreSQL

MySQL vs PostGreSQL
10:56
+
Getting Started with PostGreSQL
4 Lectures 36:51

Lecture describes the installation process of PostGreSQL

Install PostGreSQL and PG Admin
09:20

Learn to install XAMPP in this lecture

XAMPP Installation
06:57

Learn to use the PSQL command line

PSQL Command Line
11:10

Learn to use the phpPgAdmin to carry out basic operations

PHPPGAdmin
09:24
+
Database Development
5 Lectures 01:10:55

The lecture describes the naming conventions used for DB design

Naming Conventions
09:50

Learn the best practices of DB design and Normalization

Best Practices & Normalization
11:46

Learn to create schematic DB design

Structuring & Diagramming
20:21

The lecture explains the DB creation and data entry

Creating and Populating a Database
20:19

Lecture explaining the Database Import and Export

Database Import and Export
08:39
+
Writing SQL
5 Lectures 58:48

A quick intro to SQL

SQL Fundamentals
10:43

Seletion and Viewing Operations for the DB

Selecting and Viewing Data
10:43

The other CRUD operations in SQL

Inserting Updating & Deleting Data
05:36

Learn the Join operation in SQL with this lecture

Table Joins
07:41

The SQL wrap up lecture

Putting it all together
24:05
+
SQL functions and operators
4 Lectures 45:49

Introduction to String functions in SQL

String Functions
13:44

Learn the math functions in SQL

Basic Math Functions
06:33

Learn all about the Aggregate functions and Group By operations

Aggregate Functions and Group By
14:14

Lecture describing the Union , IN and Concat operations in SQL

Union, IN & Concat Operators
11:18
+
PHP & PostGres Web Application
5 Lectures 01:25:35

Application UI of a web project

Application UI
20:19

Connecting our web page to PostGreSQL

Connect to PostgreSQL
06:53

Selection and Display of Data from PostGreSQL

Select and Display data
12:55

Adding Data from our Web App to the DB

Adding data
25:40

Updating and Deletion implementation of the web project

Update and Delete Data
19:48
+
Course Summary
1 Lecture 03:23

Course Wrap up

Summary
03:23
About the Instructor
Eduonix Learning Solutions
4.3 Average rating
39,466 Reviews
710,677 Students
167 Courses
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.

Eduonix-Tech .
4.3 Average rating
37,746 Reviews
688,862 Students
141 Courses