001-Oracle SQL 12c- Before You Start

002-Oracle SQL 12c- Course Agenda

003-Oracle SQL 12c: Introduction Part 1

004-Oracle SQL 12c: Introduction Part 2

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

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

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

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

008-Oracle SQL 12c- Basic Select Part 1

009-Oracle SQL 12c: Basic Select Part 2

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

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

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

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

014-Oracle SQL 12c- Substitution variables part 1

015-Oracle SQL 12c- Substitution variables part 2

016-Oracle SQL 12c- Character functions

017-Oracle SQL 12c- Number functions

018-Oracle SQL 12c- Date functions

019-Oracle SQL 12c- Using Conversion Functions 1

021-Oracle SQL 12c- Using Conversion Functions 3

022-Oracle SQL 12c- Using Conversion Functions 4

023-Oracle SQL 12c- Using Conversion Functions 5

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

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

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

027-Oracle SQL 12c- Types of Joins

028-Oracle SQL 12c- Equijoin

029-Oracle SQL 12c- Nonequijoins

030-Oracle SQL 12c- Outer Join

030-Oracle SQL 12c: Outer Join

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

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

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

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

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

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

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

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

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

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

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

042-Oracle SQL 12c- Insert statement

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

044-Oracle SQL 12c- Update statement part 1

045-Oracle SQL 12c- Update statement part 2

046-Oracle SQL 12c- Delete statement part 1

047-Oracle SQL 12c- Delete statement part 2

048-Oracle SQL 12c- Commit and rollback

049-Oracle SQL 12c- Read Consistency

050-Oracle SQL 12c- DML Practice part 1

051-Oracle SQL 12c- DML Practice part 2

052-Oracle SQL 12c: DML Practice part 3

053-Oracle SQL 12c- DB objects and data types

054-Oracle SQL 12c- Schema and create table syntax

055-Oracle SQL 12c- Including Constraints part 1

056-Oracle SQL 12c- Including Constraints part 2

057-Oracle SQL 12c: Create table practice 1

058-Oracle SQL 12c: Create table practice 2

059-Oracle SQL 12c: Creating table using subquery

060-Oracle SQL 12c: Alter table statement

061-Oracle SQL 12c: Set unused option -read only- drop table

062-Oracle SQL 12c: Very nice DDL practice 1

063-Oracle SQL 12c: Very nice DDL practice 2

064-Oracle SQL 12c: Alter table and constraints

065-Oracle SQL 12c: Tips you should know part 1

066-Oracle SQL 12c: Tips you should know part 2

067-Oracle SQL 12c: Tips you should know part 3

068-Oracle SQL 12c: You are ready for EXAM 1Z0-061

069-Oracle SQL 12c: Data Dictionary Views part 1

070-Oracle SQL 12c: Data Dictionary Views part 2

071-Oracle SQL 12c: Data Dictionary Views part 3

072-Oracle SQL 12c: Data Dictionary Views part 4

073-Oracle SQL 12c: Creating Sequences part 1

074-Oracle SQL 12c: Creating Sequences part 2

075-Oracle SQL 12c: Sequences practice 1

076-Oracle SQL 12c: Sequences practice 2

077-Oracle SQL 12c: Creating Synonyms

078-Oracle SQL 12c: Creating Indexes Part 1

079-Oracle SQL 12c: Creating Indexes Part 2

080-Oracle SQL 12c: Indexes Practice تماربن الوحوش

081-Oracle SQL 12c: Creating Views part 1

082-Oracle SQL 12c: Creating Views part 2

083-Oracle SQL 12c: Creating Views part 3اعطيني عملي يابا

084-Oracle SQL 12c: Creating Views part 4هيك صح

086-Oracle SQL 12c: Managing constraints Part 2

087-Oracle SQL 12c: DEFERRABLE Constraints هاي حلوه

088-Oracle SQL 12c: Global Temporary Table

089-Oracle SQL 12c: SQL Loader

090-Oracle SQL 12c: External Tables Part 1

091-Oracle SQL 12c: External Tables Part 2 يا سلام

092-Oracle SQL 12c: Subquery as a source table خد مثال حقيقي

093-Oracle SQL 12c: Multiple Column Subquery لقد وقعنا في الفخ

094- Oracle SQL 12c: Scalar Subquery

095- Oracle SQL 12c: Correlated Subquery Exists not exists

096- Oracle SQL 12c: With Clause اول مره اعرف

097- Oracle SQL 12c: Manipulating Data by Using Subqueries

098- Oracle SQL 12c: Controlling User Access part 1نظري

100- Oracle SQL 12c: Controlling User Access part 3نظري

101- Oracle SQL 12c: Controlling User Access part 4عملي

102- Oracle SQL 12c: Controlling User Access part 5عملي

103- Oracle SQL 12c: Controlling User Access part 6عملي

104- Oracle SQL 12c: Controlling User Access part 7عملي

105- Oracle SQL 12c: Controlling User Access part 8عملي

106- Oracle SQL 12c: Manipulating Data- Introduction

107- Oracle SQL 12c: Manipulating Data- Explicit default value

109- Oracle SQL 12c: Manipulating Data- Pivoting Insert

110- Oracle SQL 12c: Manipulating Data- Merge Statement 1

111- Oracle SQL 12c: Manipulating Data- Merge Statement 2

114- Oracle SQL 12c: Managing Data in Different Time Zones 2

115- Oracle SQL 12c: The End- Thank You