Creating PostgreSQL Databases
Learn how to create a PostgreSQL database and explore the structure, data types, and how to normalize databases.
Comece O Curso Gratuitamente4 horas16 vídeos51 exercícios14.223 aprendizesDeclaração de Realização
Crie sua conta gratuita
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.Treinar 2 ou mais pessoas?
Tentar DataCamp for BusinessAmado por alunos de milhares de empresas
Descrição do 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. "Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
SQL para administradores de banco de dados
Ir para a trilha- 1
Structure of PostgreSQL Databases
GratuitoIn 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.
Introduction to PostgreSQL data types50 xpMatching data representations and categories100 xpChoosing data types at table creation100 xpDefining text columns50 xpMatching text types100 xpSBA appeals table100 xpDefining numeric data columns50 xpUsing integer types100 xpSupporting an SBA marketing campaign100 xpDefining boolean and temporal data columns50 xpRevisiting the appeals table100 xpBoolean defaults100 xpChoosing data types representations100 xp - 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.
The importance of data normalization50 xpReasons for normalizing databases50 xpReducing data redundancy100 xpImproving object-to-data mapping100 xp1st Normal Form50 xpSimplifying database records100 xpToo much normalization100 xp2nd Normal Form50 xpDesigning a course table100 xpStreamlining meal options100 xp3rd Normal Form50 xpIdentifying transitive dependencies50 xpTable definitions for 3rd Normal Form100 xpWorking through the normalization process100 xp - 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.
Introduction to access control50 xpCreating a new user100 xpUpdating user passwords100 xpPostgreSQL access privileges50 xpGranting user privileges100 xpUsing the granted privileges100 xpHierarchical access control50 xpWorking with users and groups100 xpSchema privileges100 xpRemoving access50 xpRemoving user privileges100 xpRescinding group membership100 xpImplementing access control for teams100 xpCourse wrap-up50 xp
Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
SQL para administradores de banco de dados
Ir para a trilhacolaboradores
pré-requisitos
Intermediate SQLDarryl Reeves Ph.D
Ver MaisIndustry Assistant Professor, NYU Tandon School of Engineering
O que os outros alunos têm a dizer?
Junte-se a mais de 15 milhões de alunos e comece Creating PostgreSQL Databases hoje mesmo!
Crie sua conta gratuita
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.