SKILL: Persistence (Relational) - MySQL (Apprentice Developer)

[PRE-REQUISITES]

• None

[TOPICS]

• SELECT (plus Joins)
• CREATE TABLE
• INSERT and UPDATE
• DELETE
• Transactions and ACID
• Indexes
• Primary Keys
• Foreign Keys (SUPPLEMENTARY)

[RESOURCES]

• Basic MySQLTutorial.org - Sections “Installing MySQL Database Server”, “Downloading MySQL Sample Database”, “Loading the sample Database”, “Using MySQL SELECT statement”, “Joining Tables”, “Inserting Data into Tables using MySQL INSERT statement”, “Updating data using MySQL UPDATE statement”, “Removing Data using MySQL DELETE”, ‘MySQL Transaction”, “Creating a Table using MySQL CREATE TABLE statement”, “MySQL Indexes”, “Primary Key Constraint”, :Foreign Key Constraint”
• Using PHP, MySQL & JavaScript, 4th Edition (O’Reilly) (Book) Sections: “Introduction to MySQL”, “Mastering MySQL”

[BADGES]

• relational-database-user (apprentice)

[EXPERIENCE SUGGESTIONS]

[ADVENTURER NOTES]

[THE CAIRN]