SQL Tutorial: Creating PostgreSQL Databases

Key Takeaways

welcome to creating postgres sql databases this is a fundamental topic for anyone who is an administrator or user of postgres sql during this course we'll explore the required commands for creating databases and their underlying components fundamental data types in postgres sql database normalization and the management of database access this course will jump start your journey to becoming an expert postgres sql administrator postgresql is 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 a 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 db 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're a sports fanatic and are interested in doing some analysis on college basketball stats you might create a database to store the data to be analyzed in a database named ncaa underscore bb this database might contain data for players games and colleges or maybe as an owner of a car dealership you want to keep track of the inventory on your lot former prospective customers and salespeople on your team in a database named auto underscore depot perhaps you were starting a company to produce podcasts you might want to organize your podcast by characteristics such as host topic delivery platform and subscribers this database can be called pod as you can see there are many possible reasons for wanting to create and maintain a database before moving on to discussion of setting up other objects in postgres sql databases let's practice using the create database command