FreeCourseWeb com PostgreSQL Essential Training 2023 | B000FC1B7F3B759EB7B2E30990C40F032EE6FDD7

FreeCourseWeb com PostgreSQL Essential Training 2023

Name	[ FreeCourseWeb.com ] PostgreSQL Essential Training (2023)	DOWNLOAD Copy Link
Total Size	376.6 MB
Total Files	90
Last Seen	2024-11-16 00:10
Hash	B000FC1B7F3B759EB7B2E30990C40F032EE6FDD7

/
Get Bonus Downloads Here.url	0.2 KB
/01 - Introduction/
01 - Manage relational data with PostgreSQL.mp4	3.1 MB
01 - Manage relational data with PostgreSQL.srt	1.6 KB
/.../02 - 1. Getting Started with PostgreSQL/
01 - What is PostgreSQL.mp4	8.6 MB
01 - What is PostgreSQL.srt	9.5 KB
02 - Download and install PostgreSQL.mp4	14.5 MB
02 - Download and install PostgreSQL.srt	13.3 KB
03 - Install PostgreSQL with Docker.mp4	10.5 MB
03 - Install PostgreSQL with Docker.srt	10.9 KB
04 - Connect to the server with psql.mp4	14.7 MB
04 - Connect to the server with psql.srt	14.3 KB
05 - Browse the server with a graphical interface.mp4	10.7 MB
05 - Browse the server with a graphical interface.srt	9.7 KB
06 - Connect pgAdmin to Docker.mp4	8.8 MB
06 - Connect pgAdmin to Docker.srt	8.9 KB
07 - Tour the pgAdmin interface.mp4	10.2 MB
07 - Tour the pgAdmin interface.srt	8.8 KB
08 - Use pgAdmin’s toolset.mp4	12.9 MB
08 - Use pgAdmin’s toolset.srt	10.2 KB
09 - Create objects with pgAdmin's dialog workflows.mp4	11.5 MB
09 - Create objects with pgAdmin's dialog workflows.srt	10.7 KB
/.../03 - 2. An Introduction to Relational Databases/
01 - The structure of a database table.mp4	8.1 MB
01 - The structure of a database table.srt	7.4 KB
02 - PostgreSQL native data types.mp4	12.1 MB
02 - PostgreSQL native data types.srt	11.4 KB
03 - Join tables together with relationships.mp4	4.9 MB
03 - Join tables together with relationships.srt	5.7 KB
04 - Create a table and insert rows of data.mp4	11.5 MB
04 - Create a table and insert rows of data.srt	10.2 KB
05 - Challenge Create a table.mp4	1.2 MB
05 - Challenge Create a table.srt	1.4 KB
06 - Solution Create a table.mp4	10.4 MB
06 - Solution Create a table.srt	9.2 KB
/.../04 - 3. Building a Database/
01 - Organize tables with schemas.mp4	12.7 MB
01 - Organize tables with schemas.srt	12.3 KB
02 - Create a table with pgAdmin.mp4	13.6 MB
02 - Create a table with pgAdmin.srt	13.3 KB
03 - Link primary and foreign keys.mp4	12.9 MB
03 - Link primary and foreign keys.srt	12.4 KB
04 - Enforce referential integrity on related records.mp4	15.0 MB
04 - Enforce referential integrity on related records.srt	11.5 KB
05 - Challenge Execute a command on the Postgres server.mp4	1.5 MB
05 - Challenge Execute a command on the Postgres server.srt	1.6 KB
06 - Solution Execute a command on the Postgres server.mp4	10.9 MB
06 - Solution Execute a command on the Postgres server.srt	9.9 KB
/.../05 - 4. Retrieving Information with Queries/
01 - Import data from a CSV.mp4	8.5 MB
01 - Import data from a CSV.srt	6.8 KB
02 - Retrieve information with a SELECT query.mp4	11.7 MB
02 - Retrieve information with a SELECT query.srt	8.4 KB
03 - Helpful pgAdmin Query Tool interface elements.mp4	8.6 MB
03 - Helpful pgAdmin Query Tool interface elements.srt	6.6 KB
04 - Join tables for additional information.mp4	11.8 MB
04 - Join tables for additional information.srt	8.3 KB
05 - Save a query as a database view.mp4	8.6 MB
05 - Save a query as a database view.srt	5.8 KB
06 - Challenge Import data and write queries.mp4	1.7 MB
06 - Challenge Import data and write queries.srt	1.8 KB
07 - Solution Import data and write queries.mp4	14.8 MB
07 - Solution Import data and write queries.srt	11.8 KB
/.../06 - 5. Managing Data/
01 - Add indexes to a table.mp4	12.1 MB
01 - Add indexes to a table.srt	14.7 KB
02 - Automatically fill in default values.mp4	8.3 MB
02 - Automatically fill in default values.srt	6.7 KB
03 - Constrain acceptable input values.mp4	12.4 MB
03 - Constrain acceptable input values.srt	10.3 KB
04 - Challenge Add data constraints.mp4	1.4 MB
04 - Challenge Add data constraints.srt	1.5 KB
05 - Solution Add data constraints.mp4	14.5 MB
05 - Solution Add data constraints.srt	11.5 KB
/.../07 - 6. Database Administration in PostgreSQL/
01 - User accounts and roles.mp4	9.6 MB
01 - User accounts and roles.srt	9.3 KB
02 - Grant privileges to a role.mp4	10.6 MB
02 - Grant privileges to a role.srt	7.8 KB
03 - Backup and restore a database.mp4	9.9 MB
03 - Backup and restore a database.srt	9.9 KB
04 - Start and stop the server.mp4	9.3 MB
04 - Start and stop the server.srt	7.5 KB
/08 - Conclusion/
01 - Next steps.mp4	2.3 MB
01 - Next steps.srt	2.9 KB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
/.../Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 1/
docker.txt	1.0 KB
psql-complete.txt	0.2 KB
/.../Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 4/
Challenge3-Complete.txt	1.6 KB
Join-Complete.txt	0.3 KB
KinetEco-Departments.csv	0.3 KB
KinetEco-Employees.csv	1.2 KB
KinetEco-NewProducts.csv	1.3 KB
Queries-Complete.txt	0.6 KB
View-Start.txt	0.3 KB
/.../Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 6/
Privileges-Start.txt	0.7 KB
Total files 90