Getting Your Hands Dirty with PostgreSQL and MySQL

This practical chapter will focus on giving you hands-on experience with using PostgreSQL and MySQL. This chapter covers essential topics, including setting up your environment, creating and managing databases, and providing a SQL crash course with a command-line interface (CLI). You will also learn about database design tools and how to use them to create their first schema.

We’ll begin by setting up your environment, which involves setting up a local environment for PostgreSQL and MySQL. You will learn how to install and configure the databases on your local machine and how to set up user accounts with the necessary permissions.

Next, we’ll cover creating and managing databases, which focuses on creating and managing databases using the CLI. You will learn how to create new databases, tables, and users and how to modify existing ones. You will also learn how to perform basic database administration tasks such...