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.

All Databases & SQL content:

  1. Working With IndexedDB - Part 2

    Working With IndexedDB - Part 2

    Tutorial Intermediate

    Welcome to the second part of my IndexedDB article. I strongly recommend reading the first article in this series, as I'll be assuming you are familiar with...

  2. Working With IndexedDB

    Working With IndexedDB

    Tutorial Intermediate

    One of the more interesting developments in web standards lately is the Indexed Database (IndexedDB for short) specification. For a fun time you can read the...

  3. Laravel 4: A Start at a RESTful API (Updated)

    Laravel 4: A Start at a RESTful API (Updated)

    Tutorial Intermediate

    RESTful API's are hard! There are a lot of aspects to designing and writing a successful one. For instance, some of the topics that you may find yourself...

  4. Custom Database Tables: Maintaining the Database

    Custom Database Tables: Maintaining the Database

    Tutorial Intermediate

    Over the lifetime of your custom table you will probably find that you need to make changes to what it stores, or how it stores it. This may be in response...

  5. Getting Started With Parse

    Getting Started With Parse

    Tutorial Intermediate

    I am a big fan of Parse, a technology that makes developing web and mobile apps faster. It lets you store, sync and push data in the cloud without writing a...

  6. PHP Database Access: Are You Doing It Correctly?

    PHP Database Access: Are You Doing It Correctly?

    Tutorial Intermediate

    We've covered PHP's PDO API a couple of times here on Nettuts+, but, generally, those articles focused more on the theory, and less on the application. This...

  7. Persisting a Todo List With MongoDB and Geddy

    Persisting a Todo List With MongoDB and Geddy

    Tutorial Intermediate

    In this three part tutorial, we’ll be diving deep into creating a to do list management app in Node.js and Geddy. This is the last entry in the series, where...

  8. PDO vs. MySQLi: Which Should You Use?

    PDO vs. MySQLi: Which Should You Use?

    Tutorial Intermediate

    When accessing a database in PHP, we have two choices: MySQLi and PDO. So what should you know before choosing one? The differences, database support,...

  9. Turbocharge Your Website With Memcached

    Turbocharge Your Website With Memcached

    Tutorial Intermediate

    Your latest PHP/MySQL website is finally online. And it's awesome. But it's not as fast as you want it to be, because of the many SQL queries running every...

  10. Getting Started With MongoDB: Part 2

    Getting Started With MongoDB: Part 2

    Tutorial Intermediate

    Ready to continue learning about MongoDB, one of the coolest technologies for web developers? In this second part of the series, we move on from the basics,...

  11. Getting Started With MongoDB: Part 1

    Getting Started With MongoDB: Part 1

    Tutorial Intermediate

    Ready to get in and start learning about MongoDB, one of the coolest technologies for web developers? In this new series, you'll go from beginner to...

  12. The Best Way to Learn PHP

    The Best Way to Learn PHP

    Tutorial Beginner

    Learning something from scratch is almost always an arduous affair -- you simply have no idea as to where to start, or not to start, to kick things off. I...