Learn Databases & SQL
All Databases & SQL content:
-
Understanding and Working With the WordPress Options Table
Tutorial • IntermediateIn the earlier parts of this series, we looked at the tables in the WordPress database and the relationships between them. In this part I'll cover a...
-
Android From Scratch: How to Store Application Data Locally
Tutorial • BeginnerWhen it comes to persisting application data locally, Android developers are definitely spoiled for choice. In this tutorial, I'll show you how to make use...
-
Build a Newsletter System With PHP and MySQL
Tutorial • AdvancedToday, we are going to be building a newsletter system using PHP with a MySQL database. The tutorial will cover building a system that allows for multiple...
-
10 Essential SQL Tips for Developers
Tutorial • IntermediateSQL is yet another essential language for developers wishing to create data-driven websites. In this post, I'll show you ten essential tips.
-
How to Create a PHP/MySQL Powered Forum From Scratch
Tutorial • IntermediateIn this tutorial, we're going to build a PHP/MySQL powered forum from scratch. This tutorial is perfect for getting used to basic PHP and database usage....
-
Full-Text Search in MongoDB
Tutorial • IntermediateIn this article, we are going to explore full-text search functionalities in MongoDB using Text Indexes. Full-text search allows you to efficiently search...
-
Real-World OOP With PHP and MySQL
Tutorial • IntermediateToday, we're going to discuss the basics of object-oriented programming in PHP and MySQL. We'll build a class which is capable of performing the CRUD...
-
Using Illuminate Database With Eloquent in Your PHP App Without Laravel
Tutorial • IntermediateIn this tutorial, we are going to build the back end for a question and answer app with PHP, Illuminate Database, and the Eloquent ORM.
-
Getting Started With MySQL
Tutorial • IntermediateIn this article, you'll learn everything you need for getting started with MySQL, an open-source database that powers content management systems like...
-
Mapping Relational Databases and SQL to MongoDB
Tutorial • BeginnerNoSQL databases have emerged tremendously in the last few years owing to their less constrained structure, scalable schema design, and faster access compared...
-
SQL for Beginners
Tutorial • BeginnerMost modern web applications today interact with databases, usually with a language called SQL. Luckily for us, this language is quite easy to learn. In this...
-
Relational Databases for Dummies
Tutorial • BeginnerIn this article, I'll show you what a relational database is, and how to properly design your database to store your app's information.