Conventions used

There are a number of text conventions used throughout this book.

Code in text: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: “We will now introduce a unique identifier (though, in some cases, the combination of StudentID and Course could itself act as a composite primary key).”

A block of code is set as follows:

CREATE SCHEMA IF NOT EXISTS `DesignAndModeling`
DEFAULT CHARACTER SET utf8mb4;
CREATE TABLE `StudentCourses` (
    `StudentID` int unsigned NOT NULL AUTO_INCREMENT,
    `StudentNAME` varchar(45) DEFAULT NULL,
    `Courses` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`StudentID`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

Any command-line input or output is written as follows:

$ mysql –u root –p
mysql> \s

Bold: Indicates a new term, an important word, or words that you see onscreen. For instance, words in menus or dialog boxes appear in bold. Here is an example: “Redis is a popular in-memory key-value store known for its exceptional speed and versatility.”

Tips or important notes

Appear like this.