Programming
Databases

PostgreSQL Essential Training

Created By
Adam Wilbert via LinkedIn Learning
  • 2-3 hours worth of material
  • LinkedIn Learning
  • English
PostgreSQL Essential Training

Course Overview

Learn how to set up and work with PostgreSQL, one of the world’s most popular open-source database platforms. Learn how to build a database, retrieve data with queries, and more.

Course Circullum

Introduction
  • Manage relational data with PostgreSQL
  • Using the exercise files
1. Getting Started with PostgreSQL
  • What is PostgreSQL?
  • Download and install PostgreSQL
  • Connect to the server with psql
  • Browse the server with a graphical interface
  • Create objects with pgAdmin
  • Challenge: Create a table
  • Solution: Create a table
2. An Introduction to Relational Databases
  • The structure of a database table
  • PostgreSQL native data types
  • Join tables together with relationships
3. Building a Database
  • Organize tables with schemas
  • Create a table with pgAdmin
  • Link primary and foreign keys
  • Enforce referential integrity on related records
  • Challenge: Execute a command on the Postgres server
  • Solution: Execute a command on the Postgres server
4. Retrieve Information with Queries
  • Import data from a CSV
  • Retrieve information with a SELECT query
  • Helpful pgAdmin Query Tool interface elements
  • Join tables for additional information
  • Save a query as a database view
  • Challenge: Import data and write queries
  • Solution: Import data and write queries
5. Managing Data
  • Add indexes to a table
  • Automatically fill in default values
  • Constrain acceptable input values
  • Challenge: Add data constraints
  • Solution: Add data constraints
6. Database Administration in PostgreSQL
  • User accounts and roles
  • Grant privileges to a role
  • Back up and restore a database
  • Start and stop the server
Conclusion
  • Additional resources
out of 5.0
5 Star 85%
4 Star 75%
3 Star 53%
1 Star 20%

Item Reviews - 3

Submit Reviews

Free Trial Available

Enroll Now
This Course Include:
Introduction
  • Manage relational data with PostgreSQL
  • Using the exercise files
1. Getting Started with PostgreSQL
  • What is PostgreSQL?
  • Download and install PostgreSQL
  • Connect to the server with psql
  • Browse the server with a graphical interface
  • Create objects with pgAdmin
  • Challenge: Create a table
  • Solution: Create a table
2. An Introduction to Relational Databases
  • The structure of a database table
  • PostgreSQL native data types
  • Join tables together with relationships
3. Building a Database
  • Organize tables with schemas
  • Create a table with pgAdmin
  • Link primary and foreign keys
  • Enforce referential integrity on related records
  • Challenge: Execute a command on the Postgres server
  • Solution: Execute a command on the Postgres server
4. Retrieve Information with Queries
  • Import data from a CSV
  • Retrieve information with a SELECT query
  • Helpful pgAdmin Query Tool interface elements
  • Join tables for additional information
  • Save a query as a database view
  • Challenge: Import data and write queries
  • Solution: Import data and write queries
5. Managing Data
  • Add indexes to a table
  • Automatically fill in default values
  • Constrain acceptable input values
  • Challenge: Add data constraints
  • Solution: Add data constraints
6. Database Administration in PostgreSQL
  • User accounts and roles
  • Grant privileges to a role
  • Back up and restore a database
  • Start and stop the server
Conclusion
  • Additional resources
  • Provider:LinkedIn Learning
  • Certificate:Certificate Available
  • Language:English
  • Duration:2-3 hours worth of material
  • Language CC:

Do You Have Questions ?

We'll help you to grow your career and growth.
Contact Us Today