LinkedIn Learning - PostgreSQL Essential Training
- CategoryOther
- TypeTutorials
- LanguageEnglish
- Total size298.5 MB
- Uploaded Bycoomster
- Downloads143
- Last checkedJul. 17th '20
- Date uploadedJul. 16th '20
- Seeders 8
- Leechers10
PostgreSQL is one of the world’s most popular open-source database platforms. This highly flexible and scalable relational database management system (RDBMS) supports everything from general purpose databases to machine learning applications and geospatial map servers. In this course, instructor Adam Wilbert helps you get up and running with PostgreSQL. Adam covers the essential first steps of setting up a PostgreSQL server and working with the graphical interface, pgAdmin. He then shows how to work with pgAdmin to create new database objects, populate them with data, and retrieve records from the database. If you're new to the platform (or relational databases in general), this course serves as an entry point and provides a solid foundation for further exploration in database administration.
Files:
LinkedIn Learning - PostgreSQL Essential Training- 30- Solution - Add data constraints.mp4 (22.6 MB)
- 04- Download and install PostgreSQL.mp4 (13.5 MB)
- 06- Browse the server with a graphical interface.en.srt (9.1 KB)
- 06- Browse the server with a graphical interface.mp4 (10.2 MB)
- 08- Challenge - Create a table.en.srt (1.1 KB)
- 08- Challenge - Create a table.mp4 (1.2 MB)
- 09- Solution - Create a table.en.srt (10.6 KB)
- 09- Solution - Create a table.mp4 (12.5 MB)
- 10- The structure of a database table.en.srt (7.1 KB)
- 10- The structure of a database table.mp4 (5.9 MB)
- 11- PostgreSQL native data types.en.srt (9.2 KB)
- 11- PostgreSQL native data types.mp4 (9.3 MB)
- 12- Join tables together with relationships.en.srt (5.4 KB)
- 12- Join tables together with relationships.mp4 (4.9 MB)
- 13- Organize tables with schemas.en.srt (12.4 KB)
- 13- Organize tables with schemas.mp4 (13.5 MB)
- 14- Create a table with pgAdmin.en.srt (16.3 KB)
- 14- Create a table with pgAdmin.mp4 (20.7 MB)
- 15- Link primary and foreign keys.en.srt (13.2 KB)
- 15- Link primary and foreign keys.mp4 (15.1 MB)
- 16- Enforce referential integrity on related records.en.srt (11.4 KB)
- 16- Enforce referential integrity on related records.mp4 (14.2 MB)
- 17- Challenge - Execute a command on the Postgres server.en.srt (1.6 KB)
- 17- Challenge - Execute a command on the Postgres server.mp4 (1.8 MB)
- 18- Solution - Execute a command on the Postgres server.en.srt (11.6 KB)
- 18- Solution - Execute a command on the Postgres server.mp4 (15.5 MB)
- 19- Import data from a CSV.en.srt (7.8 KB)
- 19- Import data from a CSV.mp4 (9.9 MB)
- 20- Retrieve information with a SELECT query.en.srt (7.9 KB)
- 20- Retrieve information with a SELECT query.mp4 (9.3 MB)
- 21- Helpful pgAdmin Query Tool interface elements.en.srt (4.8 KB)
- 21- Helpful pgAdmin Query Tool interface elements.mp4 (5.5 MB)
- 22- Join tables for additional information.en.srt (8.5 KB)
- 22- Join tables for additional information.mp4 (11.8 MB)
- 23- Save a query as a database view.en.srt (6.3 KB)
- 23- Save a query as a database view.mp4 (8.0 MB)
- 24- Challenge - Import data and write queries.en.srt (1.7 KB)
- 24- Challenge - Import data and write queries.mp4 (1.7 MB)
- 25- Solution - Import data and write queries.en.srt (11.0 KB)
- 25- Solution - Import data and write queries.mp4 (15.4 MB)
- 26- Add indexes to a table.en.srt (11.7 KB)
- 26- Add indexes to a table.mp4 (13.6 MB)
- 27- Automatically fill in default values.en.srt (6.5 KB)
- 27- Automatically fill in default values.mp4 (8.9 MB)
- 28- Constrain acceptable input values.en.srt (10.2 KB)
- 28- Constrain acceptable input values.mp4 (12.3 MB)
- 29- Challenge - Add data constraints.mp4 (1.9 MB)
- 30- Solution - Add data constraints.en.srt (17.8 KB)
- 04- Download and install PostgreSQL.en.srt (11.2 KB)
- 31- User accounts and roles.en.srt (7.5 KB)
- 31- User accounts and roles.mp4 (9.2 MB)
- 32- Grant privileges to a role.en.srt (11.0 KB)
- 32- Grant privileges to a role.mp4 (14.5 MB)
- 33- Back up and restore a database.en.srt (8.9 KB)
- 33- Back up and restore a database.mp4 (11.0 MB)
- 34- Start and stop the server.en.srt (1.9 KB)
- 34- Start and stop the server.mp4 (1.7 MB)
- 35- Additional resources.en.srt (3.0 KB)
- 35- Additional resources.mp4 (2.8 MB)
- Ex_Files_PostgreSQL_EssT.zip (5.8 KB)
Code:
- udp://9.rarbg.to:2710/announce
- udp://coppersurfer.tk:6969/announce
- udp://eddie4.nl:6969/announce
- udp://exodus.desync.com:6969/announce
- udp://tracker.coppersurfer.tk:6969/announce
- udp://tracker.cyberia.is:6969/announce
- udp://tracker.internetwarriors.net:1337/announce
- udp://tracker.leechers-paradise.org:6969/announce
- udp://tracker.opentrackr.org:1337/announce
- udp://tracker.zer0day.to:1337/announce