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. Writing Blazing Fast MySQL Queries

    Writing Blazing Fast MySQL Queries

    Tutorial Intermediate

    Get the most out of your MySQL server and keep your website running fast by mastering the art of writing fast queries and auditing your app.

  2. Create a Custom Shipping Method in OpenCart: Part Two

    Create a Custom Shipping Method in OpenCart: Part Two

    Tutorial Intermediate

    In this series, we're discussing the implementation of a custom shipping method module in OpenCart. In the first part, we went through the back-end...

  3. Doctrine ORM and Laravel 5

    Doctrine ORM and Laravel 5

    Tutorial Beginner

    Doctrine 2 is an ORM for PHP that provides transparent persistence for PHP objects. In this tutorial, you'll learn how to set up Doctrine ORM with Laravel 5.

  4. Build a Real-Time Chat Application With Modulus and Spring Boot

    Build a Real-Time Chat Application With Modulus and Spring Boot

    Tutorial Intermediate

    Spring Boot is a very popular web development environment that helps you create stand-alone Java web applications easily. In this tutorial, we will develop a...

  5. Build a Real-Time Chat Application With Modulus and Laravel 5

    Build a Real-Time Chat Application With Modulus and Laravel 5

    Tutorial Intermediate

    In this tutorial, I will show you how to implement a real-time chat application with Laravel 5, PostgreSQL, and Pusher. Then we will deploy this application...

  6. Introduction to ProcessWire

    Introduction to ProcessWire

    Tutorial Beginner

    ProcessWire is an open source CMS and CMF. It uses a JQuery-inspired API and uses custom fields to achieve any task thrown at it. In this article I'll give...

  7. Real-Time Chat With Modulus and Node.js

    Real-Time Chat With Modulus and Node.js

    Tutorial Beginner

    In this tutorial, I will show you how to implement a real-time chat application with Node.js, Socket.IO and MongoDB, and then we will deploy this application...

  8. Free Course: Crawl the Web With Python

    Free Course: Crawl the Web With Python

    Tutorial Beginner

    Our latest free course covers the basics of building a simple web crawler and scraper using Python.

  9. Creating a Web App From Scratch Using Python Flask and MySQL: Part 8

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

    Tutorial Intermediate

    In the previous part of this tutorial series, we populated the dashboard page of our application with the wishes created by different users. We also attached...

  10. Creating a Web App From Scratch Using Python Flask and MySQL: Part 7

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

    Tutorial Intermediate

    In the previous part of this series, we implemented image upload functionality for the users while adding a wish. We also added a few more options related to...

  11. Creating a Web App From Scratch Using Python Flask and MySQL: Part 5

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

    Tutorial Intermediate

    In the previous part of this series, we saw how to implement the Edit and Delete wish functionality for our Bucket List Application. In this part we'll...

  12. Creating a Web App From Scratch Using Python Flask and MySQL: Part 4

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

    Tutorial Intermediate

    In the previous part of this tutorial series, we implemented the required functionality for a logged-in user to add a wish. We also saw how to display the...