
Introduction to Database Design Course in PostGreSQL
Lecture explaining the RDBMS concepts
Introduction to database concepts in PostgreSQL
The lecture highlights the main difference between MySQL and PostgreSQL
Lecture describes the installation process of PostGreSQL
Learn to install XAMPP in this lecture
Learn to use the PSQL command line
Learn to use the phpPgAdmin to carry out basic operations
The lecture describes the naming conventions used for DB design
Learn the best practices of DB design and Normalization
Learn to create schematic DB design
The lecture explains the DB creation and data entry
Lecture explaining the Database Import and Export
A quick intro to SQL
Seletion and Viewing Operations for the DB
The other CRUD operations in SQL
Learn the Join operation in SQL with this lecture
The SQL wrap up lecture
Introduction to String functions in SQL
Learn the math functions in SQL
Learn all about the Aggregate functions and Group By operations
Lecture describing the Union , IN and Concat operations in SQL
Application UI of a web project
Connecting our web page to PostGreSQL
Selection and Display of Data from PostGreSQL
Adding Data from our Web App to the DB
Updating and Deletion implementation of the web project
Course Wrap up
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