1

001-Oracle SQL 12c- Before You Start

1:43

2

002-Oracle SQL 12c- Course Agenda

7:35

3

003-Oracle SQL 12c: Introduction Part 1

14:11

4

004-Oracle SQL 12c: Introduction Part 2

16:26

5

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

15:45

6

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

18:25

7

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

15:07

8

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

15:46

9

008-Oracle SQL 12c- Basic Select Part 1

19:47

10

009-Oracle SQL 12c: Basic Select Part 2

16:26

11

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

15:13

12

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

19:42

13

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

17:18

14

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

18:13

15

014-Oracle SQL 12c- Substitution variables part 1

8:26

16

015-Oracle SQL 12c- Substitution variables part 2

15:01

17

016-Oracle SQL 12c- Character functions

36:19

18

017-Oracle SQL 12c- Number functions

15:40

19

018-Oracle SQL 12c- Date functions

27:19

20

019-Oracle SQL 12c- Using Conversion Functions 1

10:56

21

021-Oracle SQL 12c- Using Conversion Functions 3

19:57

22

022-Oracle SQL 12c- Using Conversion Functions 4

14:17

23

023-Oracle SQL 12c- Using Conversion Functions 5

15:48

24

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

19:07

25

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

17:28

26

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

10:52

27

027-Oracle SQL 12c- Types of Joins

5:06

28

028-Oracle SQL 12c- Equijoin

16:19

29

029-Oracle SQL 12c- Nonequijoins

11:13

30

030-Oracle SQL 12c- Outer Join

11:28

31

030-Oracle SQL 12c: Outer Join

11:29

32

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

16:00

33

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

19:51

34

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

19:27

35

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

8:01

36

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

12:42

37

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

8:43

38

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

8:11

39

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

18:36

40

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

19:43

41

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

19:36

42

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

12:50

43

042-Oracle SQL 12c- Insert statement

19:32

44

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

20:00

45

044-Oracle SQL 12c- Update statement part 1

16:09

46

045-Oracle SQL 12c- Update statement part 2

15:59

47

046-Oracle SQL 12c- Delete statement part 1

2:42

48

047-Oracle SQL 12c- Delete statement part 2

18:32

49

048-Oracle SQL 12c- Commit and rollback

19:44

50

049-Oracle SQL 12c- Read Consistency

10:18

51

050-Oracle SQL 12c- DML Practice part 1

19:31

52

051-Oracle SQL 12c- DML Practice part 2

4:13

53

052-Oracle SQL 12c: DML Practice part 3

17:48

54

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

17:26

55

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

7:17

56

055-Oracle SQL 12c- Including Constraints part 1

11:25

57

056-Oracle SQL 12c- Including Constraints part 2

10:58

58

057-Oracle SQL 12c: Create table practice 1

11:09

59

058-Oracle SQL 12c: Create table practice 2

14:57

60

059-Oracle SQL 12c: Creating table using subquery

7:06

61

060-Oracle SQL 12c: Alter table statement

16:34

62

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

15:16

63

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

17:54

64

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

8:07

65

064-Oracle SQL 12c: Alter table and constraints

9:05

66

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

18:29

67

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

13:19

68

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

14:56

69

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

10:26

70

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

11:25

71

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

13:16

72

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

11:31

73

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

18:05

74

073-Oracle SQL 12c: Creating Sequences part 1

9:12

75

074-Oracle SQL 12c: Creating Sequences part 2

18:01

76

075-Oracle SQL 12c: Sequences practice 1

12:22

77

076-Oracle SQL 12c: Sequences practice 2

11:21

78

077-Oracle SQL 12c: Creating Synonyms

14:47

79

078-Oracle SQL 12c: Creating Indexes Part 1

14:44

80

079-Oracle SQL 12c: Creating Indexes Part 2

7:05

81

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

19:14

82

081-Oracle SQL 12c: Creating Views part 1

10:55

83

082-Oracle SQL 12c: Creating Views part 2

18:48

84

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

17:48

85

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

13:29

86

086-Oracle SQL 12c: Managing constraints Part 2

18:56

87

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

15:30

88

088-Oracle SQL 12c: Global Temporary Table

8:38

89

089-Oracle SQL 12c: SQL Loader

16:17

90

090-Oracle SQL 12c: External Tables Part 1

8:27

91

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

16:23

92

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

15:13

93

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

10:15

94

094- Oracle SQL 12c: Scalar Subquery

10:10

95

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

12:54

96

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

15:22

97

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

20:19

98

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

10:28

99

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

9:48

100

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

19:48

101

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

12:05

102

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

17:12

103

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

11:33

104

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

14:09

105

106- Oracle SQL 12c: Manipulating Data- Introduction

9:16

106

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

5:41

107

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

13:43

108

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

6:03

109

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

4:21

110

113- Oracle SQL 12c: Managing Data in Different Time Zones 1

15:42

111

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

10:11

112

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

0:08