SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. It is used to insert, update, and retrieve data from a database. SQL commands include SELECT, INSERT, UPDATE, DELETE, and CREATE, among others. SQL is a standard language for interacting with relational databases, and is supported by a wide variety of database management systems, including MySQL, PostgreSQL, and Microsoft SQL Server.
Basics:
- Structured Query Language
- SQL | Datatypes
- SQL | DDL, DML, TCL and DCL
- SQL | TRANSACTIONS
- SQL | VIEWS
- SQL | Comments
- SQL | Constraints
- SQL | Creating Roles
Clauses / Operators:
- SQL | WITH clause
- SQL | With Ties Clause
- SQL | Arithmetic Operators
- SQL | Wildcard operators
- SQL | Intersect & Except clause
- SQL | USING Clause
- SQL | MERGE Statement
- MERGE Statement in SQL Explained
- SQL | DDL, DML, DCL and TCL Commands
- SQL | CREATE DOMAIN
- SQL | DESCRIBE Statement
- SQL | Case Statement
- SQL | UNIQUE Constraint
- SQL | Create Table Extension
- SQL | ALTER (RENAME)
- SQL | ALTER (ADD, DROP, MODIFY)
- SQL | LIMIT Clause
- SQL | INSERT IGNORE Statement
- SQL | LIKE
- SQL | SOME
- SQL | OFFSET-FETCH Clause
- SQL | Except Clause
- Combining aggregate and non-aggregate values in SQL using Joins and Over clause
- SQL | ALL and ANY
SQL-Injection:
- SQL Injection
- How to use SQLMAP to test a website for SQL Injection vulnerability
Functions:
- SQL | Mathematical functions (SQRT, PI, SQUARE, ROUND, CEILING & FLOOR)
- SQL | Conversion Function
- SQL general functions | NVL, NVL2, DECODE, COALESCE, NULLIF, LNNVL and NANVL
- SQL | Conditional Expressions
- SQL | Character Functions with Examples
- SQL | Date Functions (Set-1)
- SQL | Date Functions (Set-2)
Queries:
- SQL | Joining three or more tables
- SQL | How to Get the names of the table
- SQL | Sub queries in From Clause
- SQL | Correlated Subqueries
- SQL | Top-N Queries
PL/SQL:
- PL/SQL Introduction
- Cursors in PL/SQL
- Sum Of Two Numbers in PL/SQL
- Reverse a number in PL/SQL
- Factorial of a number in PL/SQL
- Print Patterns in PL/SQL
- Decision Making in PL/SQL
- Oracle SQL | Pseudocolumn
- SQL | Procedures in PL/SQL
- Print different star patterns in SQL
- GCD of two numbers in PL/SQL
- Centered triangular number in PL/SQL
- Floyd’s triangle in PL/SQL
- Convert distance from km to meters and centimeters in PL/SQL
MySQL:
- MySQL | Regular expressions(Regexp)
- MySQL | Grant/Revoke Privileges
- MySQL | DATABASE() and CURRENT_USER() Functions
- MySQL | BIN() Function
- MySQL | IFNULL
- MySQL | LAST_DAY() Function
- MySQL | RENAME USER
- MySQL | DROP USER
- MySQL | CREATE USER Statement
- MySQL | Change User Password
SQL Server:
- SQL SERVER | Conditional Statements
- SQL Server Identity
