Level: Intermediate | Genre: eLearning | Language: English
PostgreSQL is trusted with mission critical information by some of the biggest companies in the world. It’s also highly flexible, which makes it a great choice for data science researchers, educators, nonprofit organizations, and businesses of all sizes. In this course, Adam Wilbert, who has spent the last decade helping people take their first steps in the world of relational databases, introduces you to PostgreSQL. Adam nstrates how to set up your own server and create a customized relational database. He shows you the features of PostgreSQL that protect your data from unauthorized access, ensure that it’s accurate, and simplify the process of querying information so that you can make actionable decisions. PostgreSQL is a powerful, robust platform. Get started learning how it works!
If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com
Get More Tutorials and Support Us -->> https://CourseWikia.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/01 - Introduction/01 - Manage relational data with PostgreSQL.mp4
3 MB
~Get Your Files Here !/01 - Introduction/01 - Manage relational data with PostgreSQL.srt
1.5 KB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/01 - What is PostgreSQL.mp4
8.2 MB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/01 - What is PostgreSQL.srt
9.3 KB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/02 - Download and install PostgreSQL.mp4
13.9 MB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/02 - Download and install PostgreSQL.srt
12.9 KB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/03 - Install PostgreSQL with Docker.mp4
10 MB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/03 - Install PostgreSQL with Docker.srt
10.7 KB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/04 - Connect to the server with psql.mp4
14 MB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/04 - Connect to the server with psql.srt
13.9 KB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/05 - Browse the server with a graphical interface.mp4
10.2 MB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/05 - Browse the server with a graphical interface.srt
9.4 KB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/06 - Connect pgAdmin to Docker.mp4
8.4 MB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/06 - Connect pgAdmin to Docker.srt
8.7 KB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/07 - Tour the pgAdmin interface.mp4
9.7 MB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/07 - Tour the pgAdmin interface.srt
8.6 KB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/08 - Use pgAdmin’s toolset.mp4
12.3 MB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/08 - Use pgAdmin’s toolset.srt
9.9 KB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/09 - Create objects with pgAdmin's dialog workflows.mp4
10.9 MB
~Get Your Files Here !/02 - 1. Getting Started with PostgreSQL/09 - Create objects with pgAdmin's dialog workflows.srt
10.5 KB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/01 - The structure of a database table.mp4
7.7 MB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/01 - The structure of a database table.srt
7.3 KB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/02 - PostgreSQL native data types.mp4
11.6 MB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/02 - PostgreSQL native data types.srt
11.2 KB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/03 - Join tables together with relationships.mp4
4.7 MB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/03 - Join tables together with relationships.srt
5.5 KB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/04 - Create a table and insert rows of data.mp4
10.9 MB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/04 - Create a table and insert rows of data.srt
10 KB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/05 - Challenge Create a table.mp4
1.1 MB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/05 - Challenge Create a table.srt
1.4 KB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/06 - Solution Create a table.mp4
9.9 MB
~Get Your Files Here !/03 - 2. An Introduction to Relational Databases/06 - Solution Create a table.srt
8.9 KB
~Get Your Files Here !/04 - 3. Building a Database/01 - Organize tables with schemas.mp4
12.1 MB
~Get Your Files Here !/04 - 3. Building a Database/01 - Organize tables with schemas.srt
12 KB
~Get Your Files Here !/04 - 3. Building a Database/02 - Create a table with pgAdmin.mp4
13 MB
~Get Your Files Here !/04 - 3. Building a Database/02 - Create a table with pgAdmin.srt
13 KB
~Get Your Files Here !/04 - 3. Building a Database/03 - Link primary and foreign keys.mp4
12.3 MB
~Get Your Files Here !/04 - 3. Building a Database/03 - Link primary and foreign keys.srt
12.2 KB
~Get Your Files Here !/04 - 3. Building a Database/04 - Enforce referential integrity on related records.mp4
14.3 MB
~Get Your Files Here !/04 - 3. Building a Database/04 - Enforce referential integrity on related records.srt
11.3 KB
~Get Your Files Here !/04 - 3. Building a Database/05 - Challenge Execute a command on the Postgres server.mp4
1.4 MB
~Get Your Files Here !/04 - 3. Building a Database/05 - Challenge Execute a command on the Postgres server.srt
1.5 KB
~Get Your Files Here !/04 - 3. Building a Database/06 - Solution Execute a command on the Postgres server.mp4
10.4 MB
~Get Your Files Here !/04 - 3. Building a Database/06 - Solution Execute a command on the Postgres server.srt
9.6 KB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/01 - Import data from a CSV.mp4
8.1 MB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/01 - Import data from a CSV.srt
6.7 KB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/02 - Retrieve information with a SELECT query.mp4
11.1 MB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/02 - Retrieve information with a SELECT query.srt
8.2 KB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/03 - Helpful pgAdmin Query Tool interface elements.mp4
8.2 MB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/03 - Helpful pgAdmin Query Tool interface elements.srt
6.4 KB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/04 - Join tables for additional information.mp4
11.3 MB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/04 - Join tables for additional information.srt
8.1 KB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/05 - Save a query as a database view.mp4
8.2 MB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/05 - Save a query as a database view.srt
5.6 KB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/06 - Challenge Import data and write queries.mp4
1.6 MB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/06 - Challenge Import data and write queries.srt
1.7 KB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/07 - Solution Import data and write queries.mp4
14.1 MB
~Get Your Files Here !/05 - 4. Retrieving Information with Queries/07 - Solution Import data and write queries.srt
11.5 KB
~Get Your Files Here !/06 - 5. Managing Data/01 - Add indexes to a table.mp4
11.6 MB
~Get Your Files Here !/06 - 5. Managing Data/01 - Add indexes to a table.srt
14.4 KB
~Get Your Files Here !/06 - 5. Managing Data/02 - Automatically fill in default values.mp4
7.9 MB
~Get Your Files Here !/06 - 5. Managing Data/02 - Automatically fill in default values.srt
6.5 KB
~Get Your Files Here !/06 - 5. Managing Data/03 - Constrain acceptable input values.mp4
11.8 MB
~Get Your Files Here !/06 - 5. Managing Data/03 - Constrain acceptable input values.srt
10 KB
~Get Your Files Here !/06 - 5. Managing Data/04 - Challenge Add data constraints.mp4
1.4 MB
~Get Your Files Here !/06 - 5. Managing Data/04 - Challenge Add data constraints.srt
1.4 KB
~Get Your Files Here !/06 - 5. Managing Data/05 - Solution Add data constraints.mp4
13.8 MB
~Get Your Files Here !/06 - 5. Managing Data/05 - Solution Add data constraints.srt
11.2 KB
~Get Your Files Here !/07 - 6. Database Administration in PostgreSQL/01 - User accounts and roles.mp4
9.1 MB
~Get Your Files Here !/07 - 6. Database Administration in PostgreSQL/01 - User accounts and roles.srt
9.1 KB
~Get Your Files Here !/07 - 6. Database Administration in PostgreSQL/02 - Grant privileges to a role.mp4
10.1 MB
~Get Your Files Here !/07 - 6. Database Administration in PostgreSQL/02 - Grant privileges to a role.srt
7.6 KB
~Get Your Files Here !/07 - 6. Database Administration in PostgreSQL/03 - Backup and restore a database.mp4
9.5 MB
~Get Your Files Here !/07 - 6. Database Administration in PostgreSQL/03 - Backup and restore a database.srt
9.7 KB
~Get Your Files Here !/07 - 6. Database Administration in PostgreSQL/04 - Start and stop the server.mp4
8.9 MB
~Get Your Files Here !/07 - 6. Database Administration in PostgreSQL/04 - Start and stop the server.srt
7.3 KB
~Get Your Files Here !/08 - Conclusion/01 - Next steps.mp4
2.2 MB
~Get Your Files Here !/08 - Conclusion/01 - Next steps.srt
2.9 KB
~Get Your Files Here !/Bonus Resources.txt
386 B
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 1/docker.txt
958 B
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 1/psql-complete.txt
217 B
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 4/Challenge3-Complete.txt
1.5 KB
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 4/Join-Complete.txt
334 B
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 4/KinetEco-Departments.csv
265 B
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 4/KinetEco-Employees.csv
1.2 KB
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 4/KinetEco-NewProducts.csv
1.3 KB
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 4/Queries-Complete.txt
595 B
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 4/View-Start.txt
253 B
~Get Your Files Here !/Ex_Files_PostgreSQL_EssT/Exercise Files/Chapter 6/Privileges-Start.txt