Tag: sql

Learn the simple steps required to convert a JSON string into a JSON object and then into an SQL query that can insert your data into a database.

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.

These SQL books are the greatest approach to learn whether you're a beginner or advanced user wishing to upgrade your SQL skills!

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.

Learn how to take information stored in a MySQL database and display it on a web page for all to see.

Learn what a database is, and how to work with your own databases using Structured Query Language (SQL).

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.

Learn the basics of MongoDB, the Mongo shell, popular drivers, common database operations and CRUD actions within the Mongo shell.

Importing a large amount of data into Redshift is easy using the COPY command. To demonstrate this, we’ll import a publicly available dataset.

Iain Poulson provides a helpful guide to database query optimization, showing how to track down slow database queries and fix them up.

Parth Modi explains how he discovered that fixing the N + 1 Query Problem isn't always about reducing the number of queries. Sometimes, more queries is better.

NoSQL databases use denormalized data, so relational JOINs are impossible. Craig explains how MongoDB's new $lookup operator overcomes this restriction.

Ben Dickson covers what you need to know about SQL injection and how to protect your site against it.

Most apps will need to store data at some point. In this tutorial, Deivi Taka looks at managing data in iOS with SQLite, an easy and light storage option.

Brij Mishra looks at web app state management, and Microsoft's In-Memory OLTP, to provide ASP.NET with a faster Session State Provider.

Zack Wallace covers three SQL join approaches which can aid you in filtering your data. If you're an SQL newbie, this post will teach you valuable things!

MySQL 5.7 introduced some awkward changes for older codebases and tends to break apps. Here's how to temporarily (or permanently) lower the strictness level

In the continuing SQL vs NoSQL debate, Craig discusses example project scenarios to determine which type of database offers the most benefit.

Are you puzzled by SQL and NoSQL? Are you unsure what to use in your next project? Craig discusses the primary differences in on handy summary.

Shivam Mamgain introduces the basic commands of SQLite3, explaining how to use it from the command line.

Facebook recently released OSQuery - a way to inspect your operating system's state with SQL as if it were a relational database. See how!

If you are developing an Android application, you will likely need to store data somewhere and ORMs, Aldo Ziflaj looks at five of the best to consider.

Taylor Ren introduces PINQ - a PHP library based on LINQ for providing a unified API for querying arrays, iterators and external data sources

In this article, we briefly introduced the basic functionality of PINQ and how to use it in a web app.

This article explores the WordPress database and how things work in the background. It will also help you gain an understanding of the database structure.

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.

Learn about ChromeMyAdmin - a packaged app that lets you manage your MySQL/MariaDB database directly from any instance of your Google Chrome browser

Read How to Explain Your SQL EXPLAIN Queries and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.