This VTC course is an introduction to the popular open source and free database management system PostgreSQL. Author Dima Kassab covers the basics needed to create databases and database objects. The course assumes no prior knowledge of database concepts. It sets the groundwork for more advanced topics such as database administration and development. Topics covered include: installations, data types, main database operators/functions, and creating/modifying database objects such as tables, views, indexes, and sequences. To begin learning today, simply click on the movie links.
Regarding Installation on a Server
Stop and Start the Service Locally
Create / Drop / Connect to a Database pt. 1
Create / Drop / Connect to a Database pt. 2
Working with Tables Using pgAdmin pt. 1
Working with Tables Using pgAdmin pt. 2
Retrieving a Portion of the Rows
Inner Joins Between Tables pt. 1
Inner Joins Between Tables pt. 2
Accessing Data Using pgadmin pt. 1
Accessing Data Using pgadmin pt. 2
Creating Views Using Command Line
Starting and Ending a Transaction
Changing a Column Data Type and Default Value
Adding / Removing a Constraint
Modifying Tables Using pgAdmin
Grant / Revoke Privileges on Tables
Grant / Revoke Privileges on Columns
Grant / Revoke Privileges Using pgAdmin
Unique Index and Partial Index
Create and Drop Index Using pgAdmin
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.