Course
SQL
32 lessons46 min total
-
Update Query-MySQL
The UPDATE operation on any database updates one or more existing records in the database. The UPDATE statement…
-
Delete Query – MySQL
You must use the DELETE FROM statement to delete records from a MySQL table. To remove specific records,…
-
Drop Table Query – MySQL
The Drop Table query affects the structure of the table rather than the data. It is used to…
-
WHERE Clause – MySQL
In a MySQL database, the where clause is used to filter the data according to the specified conditions.…
-
Order by Clause – MySQL
In MySQL, sorting is primarily accomplished using the ORDER BY clause. That is, one can sort the results…
-
Limit Clause – MySQL
In SQL, the Limit clause is used to restrict or control the number of records in the result…
-
Table Joins – MySQL
JOIN Clause Of SQL: Join allows you to combine two or more tables in SQL, based on the…
-
Introduction to SQL
A programming language called SQL (Structured Query Language) was created specifically for managing and modifying relational databases. It…
-
SQL: create command
The SQL CREATE command is a type of DDL command that is primarily used for creating databases and…
-
SQL Data Types
SQL Data Types are an important component of the attributes present in the tables, as well as the…
-
SQL: ALTER command
The ALTER command is a DDL command that can be used to change the structure of existing tables…
-
SQL: Truncate, Drop, Rename Query
The various DDL commands that are used to redefine the tables will be covered in this tutorial. Truncate…
-
SQL: INSERT Query
Insert is a commonly used command in the Structured Query Language (SQL) data manipulation language (DML) used by…
-
SQL: UPDATE Query
What is an UPDATE QUERY? The SQL UPDATE statement is used to modify the data in tables’ records.…
-
SQL: DELETE Query
What is Delete Query? In SQL, the DELETE Query removes existing records from a table. Depending on the…
-
SQL: TCL Commands
What is TCL? Transactional control commands(TCL) can only be used with DML commands like INSERT, UPDATE, and DELETE.…
-
DCL Commands: GRANT and REVOKE
What is DCL? Data Control Language is known as DCL in SQL. By creating users and granting or…
-
SQL: WHERE clause
When retrieving data from a single table or by joining data from multiple tables, a condition is specified…
-
SQL: LIKE clause
In SQL to filter data based on a specific pattern, the LIKE clause is used in the WHERE…
-
SQL: ORDER BY Clause
What is the ORDER BY Clause? In the SELECT query, the ORDER BY clause can be used to…
-
SQL: Group By Clause
The SQL Group By statement is used to organize similar data into groups. The data is further organized…
-
SQL: HAVING Clause
The HAVING clause in SQL Server includes one or more conditions that must be TRUE for groups of…
-
SQL: DISTINCT keyword
What is the SQL DISTINCT keyword? The SQL DISTINCT keyword is used in conjunction with the SELECT statement…
-
SQL: AND & OR operators
The AND and OR operators are used in SQL to filter data and produce precise results based on…
-
SQL Constraints
What are the SQL Constraints? SQL constraints are rules that limit the types of data that can be…
-
SQL Functions-I
What are SQL Functions? SQL functions are predefined routines that can be invoked by SQL queries to perform…
-
SQL Functions-II
In the previous section we saw Aggregate Functions, in this section let us discuss Scalar Functions. Scalar Function:…
-
SQL Alias – AS Keyword
What is an Alias? An SQL alias is simply an alternative name that can be used to refer…
-
SQL JOIN
What is an SQL Join? The SQL Join clause is used to combine rows from two or more…
-
SQL: SET Operations
SQL set operations combine the output of two or more SELECT statements into a single result set. The…
-
SQL: Sequence
What is an SQL Sequence? Database systems offer sequence to produce unique numeric values in a series according…
-
SQL VIEWS
What are SQL Views? Views are virtual tables in SQL. A view, like every other table in the…