Saltar al contenido principal
InicioSQLCreating PostgreSQL Databases

Creating PostgreSQL Databases

Learn how to create a PostgreSQL database and explore the structure, data types, and how to normalize databases.

Comience El Curso Gratis
4 horas16 vídeos51 ejercicios
13.420 aprendicesTrophyDeclaración de cumplimiento

Crea Tu Cuenta Gratuita

GoogleLinkedInFacebook

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.
Group¿Entrenar a 2 o más personas?Pruebe DataCamp para empresas

Preferido por estudiantes en miles de empresas


Descripción del curso

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. "
Empresas

Group¿Entrenar a 2 o más personas?

Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y más
Pruebe DataCamp Para EmpresasPara obtener una solución a medida, reserve una demostración.

En las siguientes pistas

SQL para Administradores de Bases de Datos

Ir a la pista
  1. 1

    Structure of PostgreSQL Databases

    Gratuito

    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.

    Reproducir Capítulo Ahora
    Creating a database
    50 xp
    New database creation
    50 xp
    Motivation for a new database
    50 xp
    Creating tables
    50 xp
    Name that table
    100 xp
    Two tables and a foreign key connection
    100 xp
    Creating schemas
    50 xp
    User-level schemas
    100 xp
    The public schema
    100 xp
    Creating tables in existing schemas
    100 xp
  2. 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.

    Reproducir Capítulo Ahora
  3. 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.

    Reproducir Capítulo Ahora
Empresas

Group¿Entrenar a 2 o más personas?

Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y más

En las siguientes pistas

SQL para Administradores de Bases de Datos

Ir a la pista

colaboradores

Collaborator's avatar
Maggie Matsui
Collaborator's avatar
David Venturi

requisitos previos

Intermediate SQL
Darryl Reeves Ph.D HeadshotDarryl Reeves Ph.D

Industry Assistant Professor, NYU Tandon School of Engineering

Ver Más

¿Qué tienen que decir otros alumnos?

¡Únete a 14 millones de estudiantes y empieza Creating PostgreSQL Databases hoy mismo!

Crea Tu Cuenta Gratuita

GoogleLinkedInFacebook

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.