Author
Released
5/22/2020Skill Level Intermediate
Duration
Views
- [Instructor] Your data is a valuable resource and like anything of value it should be protected and managed with care. A relational database management system like PostgreSQL is your greatest asset when it comes to storing, protecting, validating, and analyzing large amounts of data. PostgreSQL is a free, open source data platform that's trusted with mission-critical information by some of the biggest companies in the world. But its flexibility makes PostgreSQL a great choice for data science researchers and educators, non-profit organizations, and businesses of all sizes, large and small. Hi, my name is Adam Wilbert, and I've spent the last 10 years helping people take their first steps in the world of relational databases. In my LinkedIn Learning course I'll introduce you to the PostgreSQL data platform and show you how to set up your own database server and create a customized relational database that's built just for you. You'll see the features of PostgreSQL that protect your data from unauthorized access, ensure that its accurate, and simplifies the process of retrieving information so that you can make actionable decisions. PostgreSQL is a powerful, robust platform, and I'm excited to show you how it works.
Related Courses
-
Relational Databases Essential Training
with Adam Wilbert2h 12m Intermediate -
SQL: Data Reporting and Analysis
with Emma Saunders2h 17m Intermediate -
Learning SQL Programming
with Scott Simpson1h 27m Beginner
-
Introduction
-
1. Getting Started with PostgreSQL
-
What is PostgreSQL?4m 23s
-
Create objects with pgAdmin8m 38s
-
Solution: Create a table5m 31s
-
-
2. An Introduction to Relational Databases
-
PostgreSQL native data types5m 28s
-
3. Building a Database
-
Organize tables with schemas6m 42s
-
Create a table with pgAdmin9m 26s
-
-
4. Retrieve Information with Queries
-
Import data from a CSV4m 19s
-
-
5. Managing Data
-
Add indexes to a table6m 36s
-
-
6. Database Administration in PostgreSQL
-
User accounts and roles4m 16s
-
Grant privileges to a role5m 52s
-
-
Conclusion
-
Additional resources1m 36s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Manage relational data with PostgreSQL