Learn Databases & SQL

Discover how to use databases to manage and manipulate data effectively. Learn the fundamentals of SQL and database design in these tutorials.
Read moreRead less
Tutorials

All Databases & SQL tutorials:

  1. Using New Relic to Monitor WordPress Performance

    Using New Relic to Monitor WordPress Performance

    Tutorial • Intermediate

    If you arrived here from the Optimizing WordPress with Varnish and W3 Total Cache tutorial, you already have a pretty well optimized WordPress installation....

  2. Understanding and Working with Taxonomies and Terms in WordPress

    Understanding and Working with Taxonomies and Terms in WordPress

    Tutorial • Intermediate

    Taxonomies are what takes WordPress beyond a simple blogging platform and into the realms of a CMS. But how are they stored in the database?

  3. Installing and Using PHPMyAdmin for Web Development

    Installing and Using PHPMyAdmin for Web Development

    Tutorial • Intermediate

    The free, web-based database client can simplify web development, testing and site management.

  4. Understanding and Working with Metadata in WordPress

    Understanding and Working with Metadata in WordPress

    Tutorial • Intermediate

    So far in this series, we've looked at the main content types in WordPress. But what about the additional data about all that content? That's where...

  5. Understanding and Working with User Data in WordPress

    Understanding and Working with User Data in WordPress

    Tutorial • Intermediate

    In an earlier tutorial in this series, we looked at the different content types in WordPress, of which user data is one. Here, I'll go into user data in...

  6. Understanding and Working with Posts in WordPress

    Understanding and Working with Posts in WordPress

    Tutorial • Intermediate

    Like so many examples of WordPress terminology, the term 'posts' can be confusing, as it refers to a post type as well as a content type stored in a specific...

  7. Understanding and Working with Content Types in WordPress

    Understanding and Working with Content Types in WordPress

    Tutorial • Intermediate

    In the first two parts of this series, I introduced the WordPress database and its structure and showed how relationships between different content types are...

  8. Understanding and Working with Relationships Between Data in WordPress

    Understanding and Working with Relationships Between Data in WordPress

    Tutorial • Intermediate

    Ever wondered exactly how the relationships between the data in your WordPress site work? In this article, I'll explain in detail how WordPress manages...

  9. Understanding and Working With Data in WordPress

    Understanding and Working With Data in WordPress

    Tutorial • Intermediate

    In this first part of a series on working with data in WordPress, I'll provide an overview of how WordPress stores data and what's stored in which database...

  10. Working With Databases in Symfony 2

    Working With Databases in Symfony 2

    Tutorial • Beginner

    In the last video we learned how to validate and process form submissions in Symfony 2. But we didn't do anything with the submitted form data. Today, we'll...

  11. Understanding and Working with Data in WordPress - Multisite

    Understanding and Working with Data in WordPress - Multisite

    Tutorial • Intermediate

    In the earlier parts of this series, we've worked through the different tables in the WordPress database and examined what data they store, how they interact...

  12. Introduction to the MEAN Stack

    Introduction to the MEAN Stack

    Tutorial • Beginner

    Introducing MEAN, a fullstack platform for quickly building JavaScript web apps.

Related Categories

JavaScript
WordPress
Mobile Development
PHP
Unlimited Downloads
From $16.50/month
Get access to over one million creative assets on Envato.
Over 9 Million Digital Assets
Everything you need for your next creative project.
Create Beautiful Logos, Designs
& Mockups in Seconds
Design like a professional without Photoshop.
Join the Community
Share ideas. Host meetups. Lead discussions. Collaborate.