3.85 out of 5
3.85
123 reviews on Udemy

Learn Database Design using PostgreSQL

The Ultimate Guide to master the world most Advance Open Source Database
Instructor:
Eduonix Learning Solutions
1,631 students enrolled
English [Auto-generated]
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

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

Introduction

1
Course Introduction

Introduction to Database Design Course in PostGreSQL

2
Relational Database overview

Lecture explaining the RDBMS concepts

3
PostGreSQL Overview

Introduction to database concepts in PostgreSQL

4
MySQL vs PostGreSQL

The lecture highlights the main difference between MySQL and PostgreSQL

Getting Started with PostGreSQL

1
Install PostGreSQL and PG Admin

Lecture describes the installation process of PostGreSQL

2
XAMPP Installation

Learn to install XAMPP in this lecture

3
PSQL Command Line

Learn to use the PSQL command line

4
PHPPGAdmin

Learn to use the phpPgAdmin to carry out basic operations

Database Development

1
Naming Conventions

The lecture describes the naming conventions used for DB design

2
Best Practices & Normalization

Learn the best practices of DB design and Normalization

3
Structuring & Diagramming

Learn to create schematic DB design

4
Creating and Populating a Database

The lecture explains the DB creation and data entry

5
Database Import and Export

Lecture explaining the Database Import and Export

Writing SQL

1
SQL Fundamentals

A quick intro to SQL

2
Selecting and Viewing Data

Seletion and Viewing Operations for the DB

3
Inserting Updating & Deleting Data

The other CRUD operations in SQL

4
Table Joins

Learn the Join operation in SQL with this lecture

5
Putting it all together

The SQL wrap up lecture

SQL functions and operators

1
String Functions

Introduction to String functions in SQL

2
Basic Math Functions

Learn the math functions in SQL

3
Aggregate Functions and Group By

Learn all about the Aggregate functions and Group By operations

4
Union, IN & Concat Operators

Lecture describing the Union , IN and Concat operations in SQL

PHP & PostGres Web Application

1
Application UI

Application UI of a web project

2
Connect to PostgreSQL

Connecting our web page to PostGreSQL

3
Select and Display data

Selection and Display of Data from PostGreSQL

4
Adding data

Adding Data from our Web App to the DB

5
Update and Delete Data

Updating and Deletion implementation of the web project

Course Summary

1
Summary

Course Wrap up

2
Bonus Lecture: More Interesting Stuff, Offers and Discounts
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.9
3.9 out of 5
123 Ratings

Detailed Rating

Stars 5
42
Stars 4
39
Stars 3
28
Stars 2
8
Stars 1
6
98048d4c26bba5200f14daa73c7f5ea9
30-Day Money-Back Guarantee

Includes

6 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion