Home
Videos uploaded by user “Gaivota OracleSQL Lessons”
How to unlock the HR schema, and How to create HR connection in Oracle SQL
 
05:42
In this video i am going to show you How to unlock the HR schema, and How to create the HR connection in the Oracle SQL developer
How to work with large databases, linesize, pagesize in Oracle SQL
 
04:45
In this video i will show you how to configure window size and how to work with large databases in Oracle SQL
CONCATENATION OPERATOR, TO_CHAR CURRENCY, MONEY SYMBOL in oracle SQL
 
04:56
How to use concatenation operator, to_char, currency symbol, display money
DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL
 
05:44
Oracle SQL tutorials, How to DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in oracle sql
RENAME COLUMN, DROP COLUMN in Oracle SQL
 
03:31
Oracle SQL tutorials, How to RENAME COLUMN, DROP COLUMN
IS NOT NULL, IS NULL, NVL FUNCTION in oracle sql
 
03:04
Oracle sql tutorial, How to select, retrieve rows with null values, not null values and NVL function in oracle SQL
How to Install Oracle Database 11g Express Edition on Windows 7 ( 64 bits) PART 1
 
07:21
This video will show you, how to Install Oracle Databases 11g express edition on windows 7 ( 64 bits), i also will give a brief explanation about the installation. This is part 1, there is a PART 2 video which shows how to install SQL Developer and also how to create a connection between both programs
ADD DATE COLUMN DATATYPE, INSERT DATE VALUES in Oracle SQL
 
03:48
Oracle SQL tutorials, How to add date datatype, insert date datatype values
CREATE TABLE, INSERT VALUES, SELECT statement in Oracle SQL
 
05:07
How to CREATE TABLE, INSERT values, SELECT statement in oracle SQL
ADD CONSTRAINT FOREIGN KEY, INSERT VALUES in Oracle SQL
 
06:50
Oracle SQL tutorials, How to ADD CONSTRAINT FOREIGN KEY, INSERT INTO statement
HAVING BY, GROUP BY, MIN, MAX, AVG FUNCTIONS in Oracle SQL
 
03:22
Oracle SQL Tutorials, How to select statements with having by, group by, min, max, avg functions in Oracle SQL
How to Install SQL DEVELOPER on Windows 7 ( 64 bits) in Oracle PART 2
 
10:33
This video will show you how to Install SQL Developer on Windows 7 ( 64 bits) PART 2, it will show you how to connect to oracle databases 11g express edition, make sure you watch my previous video for a full understanding of the subject
BETWEEN, IN, LIKE functions in Oracle SQL
 
04:49
Oracle SQL tutorials, How to use a select statement with BETWEEN, IN, LIKE operators in Oracle SQL
WHERE, ORDER BY, GROUP BY statement in oracle SQL
 
04:59
Oracle SQL tutorials, How to select using where, order by, group by comands and using alias
INNER JOIN, LEFT OUTER JOIN in the Oracle SQL
 
07:14
This video will show you how to retrieve data from more than one table using INNER JOIN and LEFT OUTER JOIN in Oracle SQL,
CORRELATED SUBQUERY PART 2 in oracle SQL
 
09:58
How to create a subquery from three tables, also subquery with HAVING FUNCTION
CORRELATED SUBQUERY PART 1 in oracle SQL
 
04:45
How to create a subquery from one table or from two tables
RIGHT OUTER JOIN, FULL OUTER JOIN in Oracle SQL
 
04:53
This video will show you how to retrieve data from more than one table using RIGHT OUTER JOIN and FULL OUTER JOIN in Oracle SQL,
ADD COLUMN, UPDATE COLUMN in Oracle SQL
 
03:51
Oracle SQL tutorials, How to ADD COLUMN STATEMENT, UPDATE COLUMN in oracle sql