Interactive Course

Creating PostgreSQL Databases

This course teaches you the skills and knowledge necessary to create and manage your own PostgreSQL databases.

  • 4 hours
  • 16 Videos
  • 51 Exercises
  • 391 Participants
  • 4,100 XP

Loved by learners at thousands of top companies:

rei-grey.svg
axa-grey.svg
intel-grey.svg
lego-grey.svg
ebay-grey.svg
roche-grey.svg

Course Description

You have experience working with databases or, perhaps, you have heard how useful databases can be for organizing your data. Have you ever wanted to create and manage your own databases but thought such knowledge is reserved for database administrators? Well, it is not! This course teaches you the skills and knowledge necessary to create and manage your own PostgreSQL databases. Topics that will be covered include the structure of PostgreSQL databases, PostgreSQL datatypes, and normalization of databases to efficiently store data and avoid data loss. These topics will be taught using data from the U.S. Small Business Administration (SBA) to guide the lessons and provide context for the concepts covered in the course.

  1. 1

    Chapter 1: Structure of PostgreSQL Databases

    Free

    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. Chapter 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.

  3. Chapter 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.

  4. 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.

  1. 1

    Chapter 1: Structure of PostgreSQL Databases

    Free

    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. Chapter 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. Chapter 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. 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.

What do other learners have to say?

Devon

“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group

Louis

“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden

Harvard Business School

Ronbowers

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Darryl Reeves
Darryl Reeves

Assistant Professor, Long Island University - Brooklyn

Darryl is a computational scientist with expertise in utilizing data-driven approaches to solve complex problems in both academic and business settings. He worked for a number of years in a variety of technical roles including software development and technology-based client services mostly within start-up organizations in the finance and online advertising industries. He has a love for technology and education and enjoys solving interesting problems across diverse domains.

See More
Collaborators
  • Maggie Matsui

    Maggie Matsui

  • David Venturi

    David Venturi

Prerequisites
Icon Icon Icon professional info