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.
10/08/2013
Article
Identifing deadlocks in SQL Server
In this article we will describe the details about dead locks in SQL server DB. Dead lock is one of the important areas where every data base developer should pay more attention.
10/01/2013
Article
Map Reduce programming in java
In this article we will discuss about java map reduce programming. Map reduce is a special type of programming framework which is generally used for parallel processing of huge amount of data.
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
08/14/2013
Online Course
Oracle PL SQL Course
In this course we will talk about the Oracle PLSQL, the Oracle is one of the leaders in the database market. With years of industry experience and a solid technology.
07/04/2013
Article
Oracle Data Concurrency and Consistency
We will learn that data concurrency means that many users can approach data at the same time and data consistency means that each user sees a consistent view of the data, including visible changes made by the users own transactions and transactions of other users.