Complete PostgreSQL Course for Beginners - Alter Database in PostgreSQL by Manish Sharma

5.0 (1)

24 learners

What you'll learn

This course includes

4 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

manish sharma rebellion rider Rename database in postgresql alter in postgresql alter table in postgresql alter column in postgresql ddl in postgresql using in postgresql change table in postgresql alter command in postgresql add primary key in postgresql backup and restore in postgresql

Full Transcript

what's up Internet? Manish here from RebellionRider.com. In this tutorial, we'll explore how to modify a database using the "Alter Database" feature in PostgreSQL. We'll cover three common modifications: renaming a database, changing the database owner, and setting or modifying the default tablespace. These actions can be performed using the "Alter Database" statement followed by specific parameters. Renaming a database involves specifying the current name and the desired new name. Changing the database owner requires indicating the current owner and the new owner. Modifying the default tablespace involves specifying the target tablespace. These database modifications are essential tasks for database administrators. I hope you find this tutorial helpful and enjoyable. If you do, please support my channel by giving this video a thumbs up, subscribing, and hitting the bell icon. Thanks for watching. This is Manish from RebellionRider.com. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: Coming Soon Previous Tutorial ► CREATE DATABASE in PostgreSQL https://youtu.be/b7ufNgoIEuQ ► CREATE Tablespace in PostgreSQL https://youtu.be/UKxYCpTmOfk ------------------------------------------------------------------------- ►►►Social Media – Where I sort of Live https://www.instagram.com/RebellionRider/ https://www.facebook.com/TheRebellionRider/ https://twitter.com/RebellionRider https://www.linkedin.com/in/mannbhardwaj/ ------------------------------------------------------------------------- ►►►Books I refer to PL/SQL https://amzn.to/2QE1jX0 Performance Tuning https://amzn.to/2sgiAw4 1z0-071 Exam https://amzn.to/2sgfeJw Python Programming https://amzn.to/305UEbh ------------------------------------------------------------------------- ►►►Camera Gears ► Video Gears That We Use For Creating Our YouTube Video https://www.amazon.in/shop/manishsharma?listId=DU9UM0XL97KM&ref=idea_share_inf ► Work From Home Essential Tech That We Use Daily https://www.amazon.in/shop/manishsharma?listId=XAZ18JLLSNB5&ref=idea_share_inf AFFILIATE DISCLOSURE: Some of the links used in the description will direct you to Amazon.in. As an Amazon Associate, I earn from qualifying purchases at no additional cost to you. #RebellionRider

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

Dance Course For 40+ Age Group

Dance Your Way to Fitness: Join Parveen Sharma's 40+ Age Group Course and Master Moves with Passion and Ease!

⭐ 4.0

4 ratings

16.5 hours

PL/SQL Tutorial for beginners By Manish Sharma RebellionRider

⭐ 4.0

1 ratings

9.5 hours

Business Law I - Professor Gita Sharma (Fall 2015)

Unlock Legal Insights for the Digital Age: Master Business Law with Professor Sharma! Dive into comprehensive lectures on courts, jurisdictions, e-commerce, torts, and liability. Your path to legal expertise starts here—understand, examine, and excel!

⭐ 5.0

2 ratings

16.5 hours