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.
  1. Get Started With CRUD Operations in PHP MySQL Databases

    Get Started With CRUD Operations in PHP MySQL Databases

    Tutorial Beginner

    In this article, we're going to explore how you could use a MySQL database to perform CRUD (create, read, update, and delete) operations with PHP. If you...

  2. Database Handling in Python: SQLite and Redis

    Database Handling in Python: SQLite and Redis

    Tutorial Intermediate

    Python is wonderfully able to interact with databases, and this is what I'm going to show you in this tutorial. You'll learn how to use Python to handle both...

  3. Writing Custom Queries in WordPress

    Writing Custom Queries in WordPress

    Tutorial Intermediate

    With custom queries, you can make any data reading or manipulation you want. This opens up a world of new possibilities.

  4. SQL for Beginners: Part 3 - Database Relationships

    SQL for Beginners: Part 3 - Database Relationships

    Tutorial Beginner

    Today, we continue our journey into the world of SQL and relational database systems. In this part three of the series, we'll learn how to work with multiple...

  5. Using Passport With Sequelize and MySQL

    Using Passport With Sequelize and MySQL

    Tutorial Intermediate

    Passport.js is a Node.js library used for user authentication. It can be used together with Sequelize—a promise-based Node.js ORM for PostgreSQL, MySQL,...

  6. Authenticating Node.js Applications With Passport

    Authenticating Node.js Applications With Passport

    Tutorial Intermediate

    In this article, we are going to develop a basic Express application from scratch and delegate everything related to authentication to Passport, which is...

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

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

    Tutorial Intermediate

    In the previous part of this series, we saw how to get started with Python Flask and MySQL and implemented the user registration portion of our application....

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

    Creating a Web App From Scratch Using Python Flask and MySQL

    Tutorial Intermediate

    In this series, we'll be using Python, Flask, and MySQL to create a simple web application from scratch. It will be a simple bucket list application where...

  9. Why You Should Be Using PHP's PDO for Database Access

    Why You Should Be Using PHP's PDO for Database Access

    Tutorial Intermediate

    Many PHP programmers learned how to access databases by using either the MySQL or MySQLi extensions. Since PHP 5.1, there's a better way. PHP Data Objects...

  10. Create a PHP Login Form

    Create a PHP Login Form

    Tutorial Intermediate

    In this tutorial, you'll learn how to create your own PHP login and registration forms from scratch.

  11. Quickly Build a PHP CRUD Interface With the PDO Advanced CRUD Generator Tool

    Quickly Build a PHP CRUD Interface With the PDO Advanced CRUD Generator Tool

    Tutorial Beginner

    In this article, we’re going to review PDO CRUD—a form builder and database management tool. PDO CRUD helps you build forms for your database tables with...

  12. How to Connect PHP to MySQL

    How to Connect PHP to MySQL

    Tutorial Beginner

    In this article, we’re going to discuss MySQL database connectivity in PHP. It’s aimed at beginners who want to learn how to connect PHP to MySQL and perform...