SQL Joins
SQL joins are used to join database tables based on a common field There are different types of SQL joins INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER…
SQL Aggregate Functions
In this lesson we are working with the following tblproduct table It has following fields (ProductID, Category, BrandName, ProductName, Price) SQL Aggregate functions give a single value after processing data…
SQL BETWEEN Operator
SQL BETWEEN Operator is used to select data from a database table based on a given range. In this lesson we are working with the tblproduct table which includes the…
Data Filtering In SQL
In this lesson we are working with the student table which includes the following fields (studentID, FirstName, LastName, state, age) SQL SELECT Statement The select statement is used to fetch…
SQL LIKE Operator
In this lesson we are working with the following student table SQL LIKE Operator LIKE Operator finds data from a column based on a specified pattern Following example finds students’ first…
SQL UPDATE, DELETE Statements
UPDATE Statement Update statement is used to update records which are already in the database table In this lesson we are working with the course table which includes the following…
SQL Stored Procedures
What is a SQL stored procedure? A SQL stored procedure is a group of SQL (Structured query language) statements with a defined name and stored in the database to be…