33 docs tagged with "database"

Introduction to SQL

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

JSON Data in SQL

Handling JSON Data Within SQL.

SQL Aggregate Functions

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL Alias

The SQL Alias is used to give a table or a column a temporary name.

SQL ALTER TABLE Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL AND Operator

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL AVG() Function

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL CASE Expression

The SQL CASE expression is used to add conditional logic to SQL queries.

SQL COUNT() Function

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL CREATE DATABASE Statement

The SQL CREATE DATABASE statement is used to create a new database.

SQL CREATE TABLE Statement

The SQL CREATE TABLE statement is used to create a new table in the database.

SQL DELETE Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL DROP DATABASE Statement

The SQL DROP DATABASE statement is used to delete an existing database.

SQL DROP Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL EXISTS Operator

The SQL EXISTS operator is used to check if a subquery returns any results.

SQL GROUP BY Statement

The SQL GROUP BY statement is used to group rows that have the same values in specified columns and apply aggregate functions.

SQL Having Clause

The `HAVING` clause in SQL is used to filter records in combination with the `GROUP BY` clause.

SQL INSERT INTO Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL Joins

SQL Joins are used to combine rows from two or more tables based on a related column between them.

SQL LIKE Operator

The SQL LIKE operator is used to filter data based on patterns.

SQL Logical Operators

SQL logical operators are used to combine multiple conditions in a query.

SQL NOT Operator

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL NULL Functions

SQL NULL functions are used to handle NULL values in SQL queries.

SQL OR Operator

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL ORDER BY

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL SELECT

The SELECT statement retrieves specific data from one or more tables in a database.

SQL SELECT TOP

The SQL SELECT TOP clause is used to limit the number of rows returned in a result set.

SQL Stored Procedures

SQL Stored Procedures are a set of SQL statements that can be stored and reused.

SQL SUM() Function

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL Syntax

SQL statements are commands used to perform tasks such as querying, updating, and managing data in relational databases.

SQL UPDATE Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL Views

SQL Views are virtual tables that represent a saved query in the database.

SQL WHERE Clause

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.