Database DesignRelational DatabasesRelationship TypesOne-to-one relationshipsOne-to-many relationshipsMany-to-many relationshipsNormalizationForms of NormalizationFirst Normal FormSecond Normal FormThird Normal FormColumn Data TypesBacking Up and Restoring DataCopying Database FilesThe mysqldump CommandBacking upRestoring a MySQL backupWorking with other formatsThe mysqlimport commandBackup best practicesAdvanced SQLIndexesWhen indexes are usedWhere to specify the indexMulticolumn indexesThe EXPLAIN keywordSelecting with the LEFT JOIN ON ClauseSelecting with GROUP BYUsing Database FunctionsString functionsConcatenationConcatenation with a predefined separatorCalculate a string lengthChanging strings to upper- or lowercaseTrimming and padding stringsString location and positionCutting up stringsSearch and replaceDate and time functionsDays, weeks, months, and yearsHours, minutes, and secondsDates and times arithmeticThe NOW functionFormatting for displayUnix timestamp conversionTransactions Questions