SQL Tutorial: Creating PostgreSQL Databases

Want to learn more? Take the full course at https://learn.datacamp.com/courses/creating-postgresql-databases at your own pace. More than a video, you'll learn hands-on coding & quickly apply skills to your daily work. --- Welcome to Creating PostgreSQL Databases. This is a fundamental topic for anyone who is an administrator or user of PostgreSQL. During this course, we will explore the required commands for creating databases and their underlying components, fundamental data types in PostgreSQL, database normalization, and the management of database access. This course will jump start your journey to becoming an expert PostgreSQL administrator. PostgreSQL is a an object-relational database system. This focus on objects is fundamental to the organization of this software. The components of the software, some of which we will be discussing in this course, are considered objects. The highest level object is the database. PostgreSQL provides a simple command for creating a new, empty database to be populated with data. The command is quite straightforward. The words CREATE and DATABASE are followed by the name of a database and a semicolon to end the command. It is worth noting that the words "CREATE DATABASE" do not need to be capitalized as SQL is not a case-sensitive language. Uppercasing all letters improves readability. "d-b underscore name" represents the name of the database that we are creating. By default database names cannot be longer than 31 characters and must start with a letter or underscore like these examples show. However, database names cannot start with numbers, like this. When might you be interested in creating a new database? You can think of a database as a collection of data that is connected by relationships which exist between the entities represented by the data. For example, if you are a sports fanatic and are interested in doing some analysis on college basketball stats, you might create a database to store data to be analyzed in