Course
Creating PostgreSQL Databases
BasicSkill Level
Updated 01/2025SQLData Preparation4 hr16 videos51 Exercises4,100 XP21,133Statement of Accomplishment
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Loved by learners at thousands of companies
Training 2 or more people?
Try DataCamp for BusinessCourse Description
Learn How the PostgreSQL Create Database Function Works
Have you ever wanted to create and manage your own databases but thought such knowledge is reserved for database administrators? This course teaches you the skills and knowledge necessary create your databases and effectively manage them yourself. You'll cover the structure of PostgreSQL databases, PostgreSQL datatypes, and the normalization of databases to remove data duplication, increase data consistency and improve data organization.Discover the Structure of PostgreSQL Databases and Learn PostgreSQL Data Types
You’ll start this course by exploring the fundamentals of creating a Postgres database by covering databases, tables, and schemas, understanding how each fits into the PostgreSQL object hierarchy. Next, you’ll look at PostgreSQL data types, including text, numeric, temporal, and boolean data. You’ll also learn the appropriate times to use each data type. As you progress, you’ll learn about database normalization, understanding how it maintains the integrity of your data and reduces duplication. Finally, you’ll cover PostgreSQL access control and how you can protect your databases from unauthorized access.Create Your Own Database Using PSQL
As you master the skills to create a PostgreSQL database, you’ll work with real data from the U.S. Small Business Administration (SBA) to guide you through the lessons and provide context for the concepts covered in the course. By the time you've completed this PostgreSQL training, you’ll be able to confidently create your own databases using PostgreSQL. "Prerequisites
Intermediate SQL1
Structure of PostgreSQL Databases
In this chapter, you will be introduced to the fundamental objects in a PostgreSQL database: the database, tables, and schemas. After completing this chapter, you will know how to issue commands to create all three types of objects, and understand how each fits into the hierarchy of PostgreSQL objects.
2
PostgreSQL Data Types
In this chapter, you will be introduced to text, numeric, temporal, and boolean data types in PostgreSQL. After completing this chapter, you will be able to define the appropriate data types for table columns based on the data values to be stored.
3
Database Normalization
In this chapter, database normalization is introduced. Database normalization maintains data integrity and reduces data duplication. 1st, 2nd, and 3rd Normal Form are defined as steps in the process of normalizing a database. Examples to clarify concepts are provided throughout the chapter.
4
Access Control in PostgreSQL
In this chapter, the topic of access control in PostgreSQL is introduced. Access control is presented as granting and revoking privileges to users and groups on database objects. Using these tools, a database and its objects can be protected from unauthorized access, helping to ensure the integrity of the stored data.
Creating PostgreSQL Databases
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
FAQs
What are the prerequisites for this PostgreSQL course?
Intermediate knowledge of SQL is recommended before taking this course. Our Intermediate SQL course will leave you well prepared to get started with creating PostgreSQL databases.
What will I be able to do after completing this PostgreSQL course?
Upon completion of the course, you'll have the skills and knowledge to confidently create and manage your own databases using PostgreSQL.
How do I create a new database in PostgreSQL?
There are several steps you’ll need to take when creating a PostgreSQL database. However, in short, you’ll need to use the CREATE DATABASE command and provide several database settings. This course will take you through the steps in detail.
Which command creates a database in PostgreSQL?
The CREATE DATABASE command creates a new PostgreSQL database.
What is a template database in PostgreSQL?
When you use the CREATE DATABASE command, you’ll create a copy of an existing system database named template1, which is the template from which all databases will be made.
Join over 19 million learners and start Creating PostgreSQL Databases today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.