SQL | Algo

Introduction to SQL

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

📄️

SQL Statements

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

📄️

SQL Select

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

📄️

SQL WHERE Clause

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 AND Operator

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

📄️

SQL OR Operator

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

📄️

SQL NOT Operator

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

📄️

SQL UPDATE Statement

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

📄️

SQL DELETE Statement

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

📄️

SQL INSERT INTO Statement

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

📄️

SQL ALTER TABLE Statement

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

📄️

SQL DROP Statement

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

📄️

SQL COUNT() Function

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

📄️

SQL SUM() Function

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 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 Having Clause

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

📄️

SQL GROUP BY

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

📄️

SQL SELECT TOP

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

📄️

SQL Alias

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

📄️

SQL Logical Operators

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

📄️

JSON Data in SQL

Handling JSON Data Within SQL.

📄️

SQL CASE

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

📄️

SQL NULL Functions

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

📄️

SQL EXISTS

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

📄️

SQL Stored Procedures

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

📄️

SQL CREATE DATABASE

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

📄️

SQL DROP DATABASE

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

📄️

SQL CREATE TABLE

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

📄️

SQL Views

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

📄️

sql-14

description: "An aggregate function is a function that performs a calculation on a set of values, and returns a single value."