Structured Query Language (SQL) is the programming language for databases. It is the language for MySQL database management system. WordPress uses SQL to interact and communicate with its MySQL database. This technical library provides you with practical, hands-on SQL and database projects, insights, master tips, improved documentation, and so much more.
This technical library includes:
- Series and Bootcamps – grouped hands-on building projects and knowledge
- Insights – quick tips, insights, and master tips
- Other Resources – external resources just for you
WordPress interacts with MySQL. You need to learn how to query the database in order to fetch and insert/update the data you need for your projects. Here at Know the Code, you will learn about:
WP_Query- Custom queries using
$wpdb - Post meta and custom fields
- User meta
- Options and settings
- Custom database tables
- and more
- Selecting columns with
SELECT - Table aliases
- Ordering results
- Grouping results
- Joining multiple tables
- Limiting results for pagination
- and more
Series and Bootcamps
These bootcamp labs incrementally, bit-by-bit build up your SQL and Database savvy to help you to do more.
Insights & Quick Tips
PHP-centric quick tips, master tips, and insights just for you.
Get Familiar with WordPress Posts Database Table
Have you ever opened up your database? Have you poked around in there to understand the layout and different buckets of content and information? In today’s quick tip, you’ll look at the wp_posts database table. You’ll learn about basic database terminology, such as record, row, primary key, and columns. You’ll see how the columns within a record relate to the content you see in the WordPress back-end.
Other SQL Resources
A collection of other awesome educational resources.
Introduction to Oracle SQL Course
Ben Brumm‘s course is an excellent introduction to SQL. He introduces you to data selection, filtering, joining tables, operators, sorting, aggregates, subqueries, and much more. I highly recommend this free course.
Learn SQL – Codecademy
Learn SQL is an excellent beginner course to get you started in the SQL language. It’s FREE too.
SQL Essential Training – Lynda.com
SQL Essential Training course provides you with an introduction to SQL and how to use it to manage and interact with your database records.
The Sequel to SQL
Code School provides you with an introduction to SQL with hand-on code challenges. You’ll learn about aggregate functions, table constraints, normalization and relationships, inner joins, aliases, outer joins, and subqueries. This is a good course to level you up in SQL.
Try SQL
Try SQL is a free hands-on code challenge lab where you learn the basics of database manipulation using the SQL programming language.
Database Foundations
Team Treehouse provides a course on the ins and outs of database. It covers a basic introduction, SQL commands, creating tables, manipluating data, and more.
The PHP Practitioner: MySQL 101
Laracasts provides you with an introduction to MySQL in this 16+ minute free video. Jeffrey teaches you about the interacting with MySQL in terminal as well as introducing the GUIs such as Sequel Pro.
