Databases
![Data Preprocessing: Exploring the Keys to Data Preparation](https://uploads.sitepoint.com/wp-content/uploads/2023/08/1692062237data-preprocessing.jpg)
Learn what data preprocessing is, why it's important, and techniques for cleaning, transforming, integrating and reducing your data.
![Your 10 Most Common GraphQL Questions Answered](https://uploads.sitepoint.com/wp-content/uploads/2023/03/1680247790qraphql-questions.jpg)
We answer the 10 most asked GraphQL questions, covering pagination, versioning, batch loading, cache handling, file uploads, and more.
![How to Learn SQL in 2023: The Ultimate Guide for Beginners](https://uploads.sitepoint.com/wp-content/uploads/2023/03/1679016264learn-sql.png)
SQL knowledge is essential for anyone who works with data. In this article, we discuss what SQL is, its importance, and how to get started.
![Top 18 Books for SQL Users](https://uploads.sitepoint.com/wp-content/uploads/2023/01/1674105873best-sql-books.jpg)
These SQL books are the greatest approach to learn whether you're a beginner or advanced user wishing to upgrade your SQL skills!
![An Introduction to SQLite with Python](https://uploads.sitepoint.com/wp-content/uploads/2022/10/1666245460sqlite-with-python.jpg)
Learn what SQLite is, how some of its advanced features work, and how you can use it in Python projects with the help of the sqlite3 module.
![Using Redis with Node.js](https://uploads.sitepoint.com/wp-content/uploads/2015/01/1626145324reddis-with-node.png)
Need fast data interactions in your Node app? Learn how Redis speeds caching, message brokering, sessions, analytics, streaming and more.
![How to Use JSON Data Fields in MySQL Databases](https://uploads.sitepoint.com/wp-content/uploads/2016/04/1616284736db.jpg)
MySQL 5.7+ InnoDB databases and PostgreSQL 9.2+ support JSON document types in a single field. We explore the MySQL 8.0 JSON implementation in more detail.
![An Introduction to MongoDB](https://uploads.sitepoint.com/wp-content/uploads/2018/05/1581897968mongodb.png)
Learn the basics of MongoDB, the Mongo shell, popular drivers, common database operations and CRUD actions within the Mongo shell.
![Import Data into Redshift Using the COPY Command](https://uploads.sitepoint.com/wp-content/uploads/2018/01/1515038938chuttersnap-255216.jpg)
Importing a large amount of data into Redshift is easy using the COPY command. To demonstrate this, we’ll import a publicly available dataset.
![Using JOINs in MongoDB NoSQL Databases](https://uploads.sitepoint.com/wp-content/uploads/2016/09/1475221822join.png)
NoSQL databases use denormalized data, so relational JOINs are impossible. Craig explains how MongoDB's new $lookup operator overcomes this restriction.
![How to Protect Your Website Against SQL Injection Attacks](https://uploads.sitepoint.com/wp-content/uploads/2016/09/1473921170injection-attack-feature.jpg)
Ben Dickson covers what you need to know about SQL injection and how to protect your site against it.
Thomas introduces Ecto, Elixir's predominant library for working with databases, building a simple database-driven app using Ecto's four main components.
![Please: Automated CMS and Framework Installs in Vagrant](https://uploads.sitepoint.com/wp-content/uploads/2016/05/1469248691please.jpg)
Jehan introduces Please, a bash script for automating the installations of many CMSs and Frameworks by configuring them automatically into your Vagrant box.
Brij Mishra looks at web app state management, and Microsoft's In-Memory OLTP, to provide ASP.NET with a faster Session State Provider.
Are your MongoDB queries fast and effective regardless of database size? Craig discusses a number of options to consider when your NoSQL queries go quirky.
In the continuing SQL vs NoSQL debate, Craig discusses example project scenarios to determine which type of database offers the most benefit.
Shivam Mamgain introduces the basic commands of SQLite3, explaining how to use it from the command line.
Arno Slatius explains Yii 2.0's ActiveRecord, listing the features, novelties, upgrades and usage examples.
Francesco Malatesta introduces you to FluentPDO - a small and simple PDO library built to solve your data manipulation needs. See what it can do.
Rakhitha Nimesh dissects, explains and implements real time data pagination with cursor based pagination
0xDBE is a new tool by JetBrains made to solve all our database management problems. Soon, we'll be able to leave Workbench behind and work without crashes!
Peter Nijssen activates and demonstrates PhpMyAdmin's additional features - from SQL bookmarking to visual relationships
Google BigQuery now hosts GDELT - the world's largest dataset on human history - and it's free to use.
Taylor Ren explains how you can use Phreeze to autogenerate CRUD applications for your already existing databases - often in already existing apps.
Lukas White wraps up the SOLR series, configuring SOLR and Solarium from scratch and explaining how they work in-depth
This is the third article in a four-part series on using Solarium, in conjunction with Apache’s SOLR search implementation.
This is the second article in a four part series on using Solarium, in conjunction with Apache’s SOLR search implementation.
Lukas White begins a SOLR series, configuring SOLR and Solarium from scratch and explaining how they work in-depth
Lukas White introduces you to Ladder - a database versioning tool which lets you version control your database changes through migration files
Wern Ancheta explains what DBV is and how one can use it to version control a database