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 tutorials:

  1. Creating a Web App From Scratch Using Python Flask and MySQL: Part 3

    Creating a Web App From Scratch Using Python Flask and MySQL: Part 3

    Tutorial Intermediate

    In the previous part of this tutorial series, we implemented the sign-in and logout functionality for our Bucket List application. In this part of the...

  2. How to Program With Yii2: Blameable Behaviors

    How to Program With Yii2: Blameable Behaviors

    Tutorial Intermediate

    Yii2's behaviors reduce the need to repeat common code. The Blameable Behavior automates the tracking of who created and updated model entries. We'll also...

  3. Moving WordPress: Moving a Site Into a Multisite Network

    Moving WordPress: Moving a Site Into a Multisite Network

    Tutorial Advanced

    In the previous part of this series I showed you how to move a site out of a WordPress Multisite network. In this tutorial I'll show you the reverse—how to...

  4. Moving WordPress: Moving a Site Out of a Multisite Network

    Moving WordPress: Moving a Site Out of a Multisite Network

    Tutorial Advanced

    In the previous part of this series on moving WordPress, I showed you how to move a Multisite Network. But what if you just want to move one site out of a...

  5. Moving WordPress: Moving a Multisite Network

    Moving WordPress: Moving a Multisite Network

    Tutorial Intermediate

    Earlier in this series, I showed you how to move a WordPress site in a few fairly straightforward steps. Here I'll show you how to move WordPress Multisite,...

  6. Creating a Web App From Scratch Using AngularJS and Firebase: Part 6

    Creating a Web App From Scratch Using AngularJS and Firebase: Part 6

    Tutorial Intermediate

    In the previous part of this series, we saw how to create a blog post and display all the blog posts in the welcome page. In this part, we'll implement the...

  7. Moving WordPress: Moving Your Site Manually

    Moving WordPress: Moving Your Site Manually

    Tutorial Intermediate

    Sometimes the way your WordPress site is set up means you can't migrate it using a plugin. Here I'll show you how to move it manually.

  8. Building Your Startup: Access Control, Active Record Relations and Slugs

    Building Your Startup: Access Control, Active Record Relations and Slugs

    Tutorial Intermediate

    Code sprints are fun, but often you have to circle back to polish and integrate feature work. I'll show how frameworks provide infrastructure and support for...

  9. Building REST APIs Using EVE

    Building REST APIs Using EVE

    Tutorial Intermediate

    Python is one of the most easy to read and easy to write programming languages of all times. Over the years, the popularity of Python has only increased and...

  10. How to Program With Yii2: Working With the Database and Active Record

    How to Program With Yii2: Working With the Database and Active Record

    Tutorial Intermediate

    How to use Yii's automated scaffolding generator to build advanced web database applications quickly and easily.

  11. Running Your Own Open Source Email Server

    Running Your Own Open Source Email Server

    Tutorial Intermediate

    Whether for security, privacy, economy, control or just plain geeky reasons, iRedMail with Roundcube makes a compelling choice for running your own mail server.

  12. Building Your Startup With PHP: Feature Requirements and Database Design

    Building Your Startup With PHP: Feature Requirements and Database Design

    Tutorial Intermediate

    Scope out your application features and design a database schema to support it. Use Yii scaffolding to build out most of your CRUD code.