SQL

How to Perform Flask-SQLAlchemy Migrations Using Flask-Migrate — step-by-step Python tutorial on Progressive Robot

How to Perform Flask-SQLAlchemy Migrations Using Flask-Migrate

*The author selected Apache Software Foundation to receive a donation as part of the Write for DOnations program.* Introduction Flask is a lightweight Python web framework that provides valuable tools and features for creating web applications in the Python Language. SQLAlchemy is an SQL toolkit offering efficient and high-performing relational database access. It provides ways […]

Read more
How To Use Comparison and IS NULL Operators in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Use Comparison and IS NULL Operators in SQL

In certain Structured Query Language (SQL) statements, WHERE clauses can be used to limit what rows the given operation will affect. SQL allows users to retrieve granular result sets by providing a variety of different types of predicates, each of which use a specific operator to evaluate rows. This guide will outline two types of predicates and the operators they use: comparison operators and the IS NULL operator.

Read more
SQL Expressions — step-by-step DevOps tutorial on Progressive Robot

SQL Expressions

URL: https://www.progressiverobot.com/sql-expressions/ SQL expression is a combination of one or more values, [operators](/community/tutorials/sql-operators) and SQL functions that results in to a value. These SQL EXPRESSIONs are similar to a formula and they are written in query language. You can also use them to query the database for a specific set of data. SQL Expressions !SQL […]

Read more
How To Use Foreign Keys in SQL — step-by-step Linux tutorial on Progressive Robot

How To Use Foreign Keys in SQL

When working on a large SQL project, you must maintain the accuracy and consistency of data across all tables using foreign keys. This is where referential integrity comes into play. Referential integrity ensures all data references are valid in SQL and prevents inconsistent entries or orphaned records. In this tutorial, you’ll enforce referential integrity with foreign keys on your database.

Read more
SQL IN - SQL NOT IN — step-by-step DevOps tutorial on Progressive Robot

SQL IN – SQL NOT IN

URL: https://www.progressiverobot.com/sql-in-sql-not-in/ SQL IN operator is used along with WHERE clause for providing multiple values as part of the WHERE clause. 1. SQL IN SQL IN operator is almost like having multiple OR operators for the same column. Let's discuss in detail about the SQL IN operator. There are two ways to define IN operator. […]

Read more
How To Use Functions in SQL — step-by-step DevOps tutorial on Progressive Robot

How To Use Functions in SQL

When working with relational databases and Structured Query Language (SQL), you can store, manage, and retrieve data from the relational database management system. SQL can also perform calculations and manipulate data through the use of functions. In this tutorial, you’ll use different SQL functions to perform mathematical calculations, manipulate strings and dates, and calculate summaries using aggregate functions.

Read more
How to INSERT Multiple Records in SQL — step-by-step DevOps tutorial on Progressive Robot

How to INSERT Multiple Records in SQL

URL: https://www.progressiverobot.com/sql-insert-multiple-rows/ Hey, folks! In this article we will be focusing on ways to Insert Multiple rows in SQL. Need of SQL Insert INTO Multiple rows query [SQL INSERT query](/community/tutorials/sql-insert-query) inserts data into the columns of a particular table. The normal SQL INSERT query inputs the data values in a single row. In case when […]

Read more
How to implement the SQL INSTR() function? — step-by-step DevOps tutorial on Progressive Robot

How to implement the SQL INSTR() function?

URL: https://www.progressiverobot.com/sql-instr-function/ Hey, folks! In this article, we will be understanding SQL INSTR() function in detail. Working of SQL INSTR() SQL, being a query language, contains various in-built functions to deal with the String data values of the database. One such interesting function is SQL INSTR() function. SQL INSTR() function detects the first occurrence of […]

Read more
CHAT