ByteByteGo·3yUnderstanding Database Types
A complex application usually uses several different databases, each catering to a specific aspect of the application’s needs. In this comprehensive three-part series, we’ll explore the art of database selection. To make the best decision for our projects, it is essential to understand the various types of databases available in the market.
Amplication·3ySQL Versus NoSQL Databases: Which to Use, When, and Why
The right choice means we can scale up an application quickly and handle increasing user requests without encountering problems. Choosing the right database for your application is no mean feat, given the number of available databases. There are many differences between SQL and NoSQL databases, such as how they handle relational data, their query languages.
ITNEXT·3ySQL performance tuning
Northwind is a simple database often used by people who want to learn SQL and that’s what we are going to use. The dataset consists of 13 tables that can be seen below: Later in this article, I’ll show how you can install this database on your local machine, using SQL Management Studio.
KDnuggets·3yDatabase Optimization: Exploring Indexes in SQL
A similar issue also occurs in SQL Server when it retrieves data from the database. To overcome this, SQL server also uses indexing which speeds up the data retrieval process. We will cover why indexing is needed and how we can effectively create and delete indexes.
Community Picks·3yAwesome SQL Code Review Tools for Developers
SQL (Structured Query Language) is a fundamental tool for managing and manipulating data within relational databases. Writing good SQL code helps you better query the database. Code review is without a doubt one of the crucial parts of software development. It can help developers improve their SQL code quality by detecting potential problems.
freeCodeCamp·3yHow to Perform CRUD Operations – JavaScript and SQL Example
In this article, I'll show you how to connect a back end database to your data collection process. The plan involves tossing some HTML, JavaScript, and the tiny database engine SQLite into a bowl, mixing vigorously, and seeing what comes out. This article comes from my Complete LPI Web Development Essentials Study Guide course.
KDnuggets·3yHow to Optimize SQL Queries for Faster Data Retrieval
How to Optimize SQL Queries for Faster Data Retrieval, we’ll talk about why SQL query optimization is important and which techniques can be used to optimize it. We'll talk about how to optimize the queries for faster data retrieval and how to use these techniques.
KDnuggets·3y7 Best Platforms to Practice SQL
HackerRank’s SQL practice suite has hundreds of questions available for you to practice. You can filter the questions by their difficulty levels: easy, medium, and hard. If you are a Leetcode user, you can practice SQL on it too. LeetCode is quite diverse, with varying difficulty levels and topics.
