001-Oracle SQL 12c: Before You Start



1- 001-Oracle SQL 12c: Before You Start


2- 002-Oracle SQL 12c: Course Agenda


3- 003-Oracle SQL 12c: Introduction Part 1


4- 004-Oracle SQL 12c: Introduction Part 2


5- 004.1- Oracle SQL 12c: Oracle history and 12c Architecture


6- 005-Oracle SQL 12c: Installing oracle 12c on windows


7- 006-Oracle SQL 12c: First connection and unlock HR account 1


8- 007-Oracle SQL 12c: First connection and unlock HR account 2


9- 008-Oracle SQL 12c: Basic Select Part 1


10- 009-Oracle SQL 12c: Basic Select Part 2


11- 010-Oracle SQL 12c: Restricting and Sorting part 1


12- 011-Oracle SQL 12c: Restricting and Sorting part 2


13- 012-Oracle SQL 12c: Restricting and Sorting part 3


14- 013-Oracle SQL 12c: Restricting and Sorting part 4


15- 014-Oracle SQL 12c: Substitution variables part 1


16- 015-Oracle SQL 12c: Substitution variables part 2


17- 016-Oracle SQL 12c: Character functions


18- 017-Oracle SQL 12c: Number functions


19- 018-Oracle SQL 12c: Date functions


20- 019-Oracle SQL 12c: Using Conversion Functions 1


21- 020-Oracle SQL 12c: Using Conversion Functions 2


22- 021-Oracle SQL 12c: Using Conversion Functions 3


23- 022-Oracle SQL 12c: Using Conversion Functions 4


24- 023-Oracle SQL 12c: Using Conversion Functions 5


25- 024-Oracle SQL 12c: Using the Group Functions 1


26- 025-Oracle SQL 12c: Using the Group Functions 2


27- 026-Oracle SQL 12c: What is joins and Cartesian Products?


28- 027-Oracle SQL 12c: Types of Joins


29- 028-Oracle SQL 12c: Equijoin


30- 029-Oracle SQL 12c: Nonequijoins


31- 030-Oracle SQL 12c: Outer Join


32- 031-Oracle SQL 12c: Self join and more examples


33- 032-Oracle SQL 12c: 1999 Join syntax part 1


34- 033-Oracle SQL 12c: 1999 Join syntax part 2


35- 034-Oracle SQL 12c: 1999 Join syntax part 3


36- 035-Oracle SQL 12c: Using Subqueries to Solve Queries 1


37- 036-Oracle SQL 12c: Using Subqueries to Solve Queries 2


38- 037-Oracle SQL 12c: Using Subqueries to Solve Queries 3


39- 038-Oracle SQL 12c: Using Subqueries to Solve Queries 4


40- 039-Oracle SQL 12c: Using the Set Operators part 1


41- 040-Oracle SQL 12c: Using the Set Operators part 2


42- 041-Oracle SQL 12c: What is DML and insert rules


43- 042-Oracle SQL 12c: Insert statement


44- 043-Oracle SQL 12c: Common errors insert and creating script


45- 044-Oracle SQL 12c: Update statement part 1


46- 045-Oracle SQL 12c: Update statement part 2


47- 046-Oracle SQL 12c: Delete statement part 1


48- 047-Oracle SQL 12c: Delete statement part 2


49- 048-Oracle SQL 12c: Commit and rollback


50- 049-Oracle SQL 12c: Read Consistency




001-Oracle SQL 12c: Before You Start