Search results
10/25/2013
Video tutorial
Manipulating Data - Oracle PL SQL Course - Lesson 10
This video shows examples of how to insert the data with and without the columns names, how to update the values of columns with the UPDATE statement and how to remove some rows of the tables with the DELETE statement.
09/27/2013
Video tutorial
Subqueries - Oracle PL SQL Course - Lesson 8
The video explain the context, the details, the requirements and the usage of subqueries with aggregated functions and with the operators IN(), ANY(), and ALL().
09/25/2013
Video tutorial
Output Clause - T-SQL Step by Step Course - Lesson 37
In this video, we will discuss the output clause and the merge statement. SQL Server Books Online defines the output clause as: Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or MERGE statement
06/25/2013
Video tutorial
Views - T-SQL Step by Step Course - Lesson 20
In this video, we will talk about views. SQL Server books online define a view as follows: "A view can be thought of as either a virtual table or a stored query."
06/25/2013
Video tutorial
Subqueries - T-SQL Step by Step Course - Lesson 19
Today, we will talk about subqueries, which are queries within queries. The outermost query is a query which resultset is returned to the caller. It is known as the outer query.