Posts Tagged: SQL

Project — No Comments
19
Sep 11

PSEC: Creating MySQL Tables in WordPress

SUMMARY: A first stab at establishing a workable database schema for storing tasks. Learned how to use WordPress’ dbDelta() function to create and modify tables in the database. Figured out the basic SQL statements to create tables with the appropriate data types and indexes. Continue reading →

Project — No Comments
19
Sep 11

SQL Crash Course

SUMMARY: Reviewing basic SQL by datatypes and built-in functions. Groking joins, indexes, normalization, and syntax. Wrapped head around how a database is implemented and how it’s used. Continue reading →