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. An Introduction to Mongoose for MongoDB and Node.js

    An Introduction to Mongoose for MongoDB and Node.js

    Tutorial Beginner

    Learn how Mongoose allows you to create strongly typed schemas and models to simplify integrating MongoDB into your Node.js application.

  2. Getting Started With Realm Mobile Platform for iOS

    Getting Started With Realm Mobile Platform for iOS

    Tutorial Intermediate

    Learn about Realm's elegant and seamless server-side solution for syncing data between our device and the cloud in real time: Realm Mobile Platform.

  3. How to Program With Yii2: ActiveRecord

    How to Program With Yii2: ActiveRecord

    Tutorial Intermediate

    Improve the structure efficiency and security of your database programming. Learn to apply active record patterns with your database programming in Yii2.

  4. Getting Started With Cassandra: CQL Data Types and Using GoCQL

    Getting Started With Cassandra: CQL Data Types and Using GoCQL

    Tutorial Intermediate

    Learn about the various in-built data types and collection types available in Cassandra and their uses. Get acquainted with the Golang client package for...

  5. Getting Started With Cassandra: Using CQL API and CQLSH

    Getting Started With Cassandra: Using CQL API and CQLSH

    Tutorial Beginner

    Learn the basics of Cassandra and how to interact with the database via console as well as API clients.

  6. Building Your Startup: Notifying People of Meeting Updates

    Building Your Startup: Notifying People of Meeting Updates

    Tutorial Intermediate

    When meeting participants make changes, Meeting Planner needs to send notifications but delay long enough to consolidate them. Learn how to architect this.

  7. Full-Text Search in Rails Using Elasticsearch

    Full-Text Search in Rails Using Elasticsearch

    Tutorial Beginner

    In this article I am going to show you how to install Elasticsearch, how to implement full-text search on your Rails site, and how to implement search...

  8. Non-ActiveRecord Models in Rails 4

    Non-ActiveRecord Models in Rails 4

    Tutorial Intermediate

    ActiveRecord comes with a powerful set of validators and other features for attributes of a persisted data model. But what happens when you need a complex...

  9. How to Rewrite Custom URLs in OpenCart

    How to Rewrite Custom URLs in OpenCart

    Tutorial Intermediate

    In this article, we are going to explore how you could create custom SEO-friendly URLs in OpenCart. OpenCart provides it for all core modules, but for custom...

  10. 7 Handy SQL Scripts for SQL Developers

    7 Handy SQL Scripts for SQL Developers

    Tutorial Intermediate

    For completing any task efficiently, having the right tools is very important. The right tools can help make the job at hand less laborious and sometimes can...

  11. Improving the Performance of Your Rails App With Eager Loading

    Improving the Performance of Your Rails App With Eager Loading

    Tutorial Beginner

    Users like blazing fast applications, and then they fall in love with them and make them part of their life. Slow applications, on the other hand, only annoy...

  12. How to Install WordPress: The Server Software

    How to Install WordPress: The Server Software

    Tutorial Beginner

    In this article, we're going to cover each of the three main pieces of software that need to be installed, and then we'll cover the various ways they can be...