Learn Database Design using PostgreSQL

Learn Database Design using PostgreSQL, available at $44.99, has an average rating of 3.55, with 29 lectures, based on 155 reviews, and has 1854 subscribers.

You will learn about 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 This course is ideal for individuals who are Database designers or Web Develoeprs or Software Architects or MySQL developers It is particularly useful for Database designers or Web Develoeprs or Software Architects or MySQL developers.

Enroll now: Learn Database Design using PostgreSQL

Summary

Title: Learn Database Design using PostgreSQL

Price: $44.99

Average Rating: 3.55

Number of Lectures: 29

Number of Published Lectures: 29

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Database designers

Web Develoeprs

Software Architects

MySQL developers

Target Audiences

Database designers

Web Develoeprs

Software Architects

MySQL developers

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 Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Lecture 2: Relational Database overview

Lecture 3: PostGreSQL Overview

Lecture 4: MySQL vs PostGreSQL

Chapter 2: Getting Started with PostGreSQL

Lecture 1: Install PostGreSQL and PG Admin

Lecture 2: XAMPP Installation

Lecture 3: PSQL Command Line

Lecture 4: PHPPGAdmin

Chapter 3: Database Development

Lecture 1: Naming Conventions

Lecture 2: Best Practices & Normalization

Lecture 3: Structuring & Diagramming

Lecture 4: Creating and Populating a Database

Lecture 5: Database Import and Export

Chapter 4: Writing SQL

Lecture 1: SQL Fundamentals

Lecture 2: Selecting and Viewing Data

Lecture 3: Inserting Updating & Deleting Data

Lecture 4: Table Joins

Lecture 5: Putting it all together

Chapter 5: SQL functions and operators

Lecture 1: String Functions

Lecture 2: Basic Math Functions

Lecture 3: Aggregate Functions and Group By

Lecture 4: Union, IN & Concat Operators

Chapter 6: PHP & PostGres Web Application

Lecture 1: Application UI

Lecture 2: Connect to PostgreSQL

Lecture 3: Select and Display data

Lecture 4: Adding data

Lecture 5: Update and Delete Data

Chapter 7: Course Summary

Lecture 1: Summary

Lecture 2: Bonus Lecture: More Interesting Stuff, Offers and Discounts

Instructors

Eduonix Learning Solutions
1+ Million Students Worldwide | 200+ Courses

Eduonix-Tech .

Rating Distribution

1 stars: 9 votes

2 stars: 13 votes

3 stars: 28 votes

4 stars: 53 votes

5 stars: 52 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!