Defining your dataLook at your data in categoriesWhat’s in a database?Your database viewed through x-ray specs...Databases contain connected dataTake command!Setting the table: the CREATE TABLE statementCreating a more complicated tableLook how easy it is to write SQLCreate the my_contacts table, finallyYour table is readyTake a meeting with some data typesYour table, DESCribedYou can’t recreate an existing table or database!Out with the old table, in with the newTo add data to your table, you’ll use the INSERT statementCreate the INSERT statementVariations on an INSERT statementColumns without valuesPeek at your table with the SELECT statementControlling your inner NULLNOT NULL appears in DESCFill in the blanks with DEFAULTYour SQL Toolbox