FreeTutorials Us sql-advanced

1. 01 Course Introduction/001 Introduction.mp46.39MB
2. 02 Software Installation/002 Having The Database with Oracle VirtualBox.mp458.62MB
3. 02 Software Installation/003 Downloading and Installing Oracle Database.mp442.47MB
4. 03 Introducing Database Objects/005 Introducing Database Objects and Reaching Another Users Objects.mp425MB
5. 03 Introducing Database Objects/006 Reaching Another Users Objects.mp418.55MB
6. 04 Data Dictionary Views/009 What Are Data Dictionary Views.mp43.02MB
7. 04 Data Dictionary Views/010 What Is There In Data Dictionary Views.mp42.4MB
8. 04 Data Dictionary Views/011 Dictionary Table.mp413MB
9. 04 Data Dictionary Views/012 Differences Between USER ALL DBA V Prefixes.mp43.7MB
10. 04 Data Dictionary Views/013 USER_OBJECTS ALL_OBJECTS DBA_OBJECTS Views.mp441.48MB
11. 04 Data Dictionary Views/014 USER_TABLES View.mp430.45MB
12. 04 Data Dictionary Views/015 USER_TAB_COLUMNS View.mp418.37MB
13. 04 Data Dictionary Views/016 User Constraints View.mp453.33MB
14. 04 Data Dictionary Views/017 USER_CONS_COLUMNS View.mp419.71MB
15. 04 Data Dictionary Views/018 USER_TAB_COMMENTS USER_COL_COMMENTS Views.mp415.52MB
16. 05 Creating Using and Managing Sequences/019 What is a Sequence and Why is It Used For.mp43.39MB
17. 05 Creating Using and Managing Sequences/020 Creating Sequences.mp417.43MB
18. 05 Creating Using and Managing Sequences/021 Modifying Sequences.mp48.25MB
19. 05 Creating Using and Managing Sequences/022 Dropping Sequences.mp43.58MB
20. 05 Creating Using and Managing Sequences/023 Using Sequences.mp422.44MB
21. 05 Creating Using and Managing Sequences/024 Using Sequences As a Default Value.mp411.04MB
22. 05 Creating Using and Managing Sequences/025 Sequence Caching.mp45.61MB
23. 05 Creating Using and Managing Sequences/026 User Sequences.mp47.85MB
24. 06 Creating Using and Analyzing Synonyms/027 What Is a Synonym and Why Is It Used For.mp45.87MB
25. 06 Creating Using and Analyzing Synonyms/028 Creating Dropping Synonyms.mp421.41MB
26. 06 Creating Using and Analyzing Synonyms/029 Using Synonyms.mp48.9MB
27. 06 Creating Using and Analyzing Synonyms/030 Analyzing USER_SYNONYMS.mp412.74MB
28. 07 Understanding Indexes/031 What is an Index and Why is It Used For.mp47.58MB
29. 07 Understanding Indexes/032 Types of Indexes.mp46.77MB
30. 07 Understanding Indexes/033 Creating Indexes.mp422.43MB
31. 07 Understanding Indexes/034 Creating Index on Table Creation.mp418.52MB
32. 07 Understanding Indexes/035 Function Based Indexes.mp411.11MB
33. 07 Understanding Indexes/036 Multiple Indexes With Same Columns.mp421.66MB
34. 07 Understanding Indexes/037 Dropping Indexes.mp48.13MB
35. 07 Understanding Indexes/038 USER_INDEXES and USER_IND_COLUMNS Views.mp421.45MB
36. 08 Managing Views/039 What is a View and Why Is It Used For.mp47.57MB
37. 08 Managing Views/040 Types Of Views.mp45.67MB
38. 08 Managing Views/041 Creating Simple Views.mp434.07MB
39. 08 Managing Views/042 Creating Complex Views.mp411.02MB
40. 08 Managing Views/043 Modifying Views.mp410.13MB
41. 08 Managing Views/044 Analyzing User Views.mp414.54MB
42. 08 Managing Views/045 Performing DML Operations with Views.mp421.68MB
43. 08 Managing Views/046 Using WITH CHECK OPTION Clause.mp440.08MB
44. 08 Managing Views/047 Preventing DML Operations on A View.mp48.79MB
45. 08 Managing Views/048 Dropping Views.mp45.43MB
46. 09 Materialized Views/049 What is a Materialized View and Why is it Used For.mp414.9MB
47. 09 Materialized Views/050 Creating Materialized Views Part 1.mp418.48MB
48. 09 Materialized Views/051 Creating Materialized Views Part 2.mp412.68MB
49. 09 Materialized Views/052 Complex Materialized Views.mp410.94MB
50. 09 Materialized Views/053 Types of Refreshing Materialized Views.mp428.87MB
51. 09 Materialized Views/054 Refreshing Materialized Views Manually.mp432.42MB
52. 09 Materialized Views/055 Scheduling Periodic Refresh of Materialized Views.mp46.46MB
53. 10 Using Advanced Subqueries/056 Using Subqueries as a Source.mp417.56MB
54. 10 Using Advanced Subqueries/057 Scalar Subqueries.mp424.92MB
55. 10 Using Advanced Subqueries/058 Multiple Column Subqueries.mp419.94MB
56. 10 Using Advanced Subqueries/059 Correlated Subqueries.mp412.06MB
57. 10 Using Advanced Subqueries/060 EXISTS Operator.mp413.46MB
58. 10 Using Advanced Subqueries/061 NOT EXISTS Operator.mp414.79MB
59. 10 Using Advanced Subqueries/062 Using WITH Clause.mp417.45MB
60. 10 Using Advanced Subqueries/063 Using Recursive WITH Clause.mp413.3MB
61. 10 Using Advanced Subqueries/064 Inserting Data By Using a Subquery as a Target.mp417.66MB
62. 10 Using Advanced Subqueries/065 Manipulating Data by Using WITH CHECK OPTION Keyword.mp421.19MB
63. 10 Using Advanced Subqueries/066 Correlated Delete.mp49.22MB
64. 10 Using Advanced Subqueries/067 Correlated Update.mp425.48MB
65. 11 Advanced Data Manipulations/068 Using DEFAULT Keyword on Insert And Update Statements.mp418.92MB
66. 11 Advanced Data Manipulations/069 Multitable Insert Statements.mp43.17MB
67. 11 Advanced Data Manipulations/070 Unconditional Insert Statements.mp417.06MB
68. 11 Advanced Data Manipulations/071 Conditional Insert Statements.mp422.51MB
69. 11 Advanced Data Manipulations/072 Conditional Insert First Statements.mp414.37MB
70. 11 Advanced Data Manipulations/073 Pivoting Insert.mp410.37MB
71. 11 Advanced Data Manipulations/074 Merging Data.mp429.05MB
72. 11 Advanced Data Manipulations/075 Flashback Operations.mp429.67MB
73. 11 Advanced Data Manipulations/076 Purge Operations.mp416.33MB
74. 11 Advanced Data Manipulations/077 Tracking Changes In Data In a Particular Time.mp43.83MB
75. 11 Advanced Data Manipulations/078 FLASHBACK Query.mp414.35MB
76. 11 Advanced Data Manipulations/079 FLASHBACK VERSIONS Query.mp412.83MB
77. 12 Constraints Controlling Schema Objects/080 Adding Constraints.mp417.5MB
78. 12 Constraints Controlling Schema Objects/081 Removing Constraints.mp410.07MB
79. 12 Constraints Controlling Schema Objects/082 On Delete CASCADE On Delete SET NULL.mp429.01MB
80. 12 Constraints Controlling Schema Objects/083 Cascading Constraints.mp410.99MB
81. 12 Constraints Controlling Schema Objects/084 Renaming Constraints.mp46.52MB
82. 12 Constraints Controlling Schema Objects/085 Disabling Constraints.mp47.74MB
83. 12 Constraints Controlling Schema Objects/086 Enabling Constraints.mp46.42MB
84. 12 Constraints Controlling Schema Objects/087 Status Of Constraints.mp48.01MB
85. 12 Constraints Controlling Schema Objects/088 Deferring Constraints.mp437.61MB
86. 12 Constraints Controlling Schema Objects/089 Creating Temporary Tables.mp426.74MB
87. 13 Administering User Privileges and Roles/090 What Are Privileges And Why Are They Used For.mp47.55MB
88. 13 Administering User Privileges and Roles/091 Creating A User.mp410.72MB
89. 13 Administering User Privileges and Roles/092 System Privileges.mp410.29MB
90. 13 Administering User Privileges and Roles/093 Granting System Privileges.mp420.58MB
91. 13 Administering User Privileges and Roles/094 What is A Role and Why is It Used For.mp411.26MB
92. 13 Administering User Privileges and Roles/095 Changing The User Password.mp418.38MB
93. 13 Administering User Privileges and Roles/096 Object Privileges.mp44.77MB
94. 13 Administering User Privileges and Roles/097 Granting Object Privileges.mp433.8MB
95. 13 Administering User Privileges and Roles/098 Revoking Object Privileges.mp48.52MB
96. 13 Administering User Privileges and Roles/099 Searching For Privileges in Data Dictionary Views.mp420.84MB
97. 14 Hierarchical Queries Tree Structure/100 Understanding Hierarchical Retrieval.mp47.55MB
98. 14 Hierarchical Queries Tree Structure/101 Generating Hierarchical Queries.mp49.56MB
99. 14 Hierarchical Queries Tree Structure/102 Walking On The Tree Bottom to Up - Up to Down.mp419.94MB
100. 14 Hierarchical Queries Tree Structure/103 Ranking Rows Using LEVEL Pseudocolumn.mp410.6MB
101. 14 Hierarchical Queries Tree Structure/104 Formatting Tree Structure LEVEL LPAD.mp411.02MB
102. 14 Hierarchical Queries Tree Structure/105 Pruning Branches Of a Tree.mp411.72MB
103. 15 Generating Dynamic SQL Scripts/106 Generating Scripts By Using Data Dictionary Views.mp421.5MB
104. 16 Regular Expressions/107 What is Regular Expressions and Why and Where Do We Use Them.mp46.18MB
105. 16 Regular Expressions/108 What Are Metacharacters.mp442.8MB
106. 16 Regular Expressions/109 Regular Expression Functions.mp47.47MB
107. 16 Regular Expressions/110 Using REGEXP_LIKE function.mp412.15MB
108. 16 Regular Expressions/111 Using REGEXP_REPLACE Function.mp422MB
109. 16 Regular Expressions/112 Using REGEXP_SUBSTR Function.mp416.68MB
110. 16 Regular Expressions/113 Using REGEXP_INSTR Function.mp415.21MB
111. 16 Regular Expressions/114 Using REGEXP_COUNT Function.mp412.07MB
112. 16 Regular Expressions/115 Using REGEX in Constraints.mp411.49MB
113. 17 Analytical Functions New Videos Jun 2017/116 What are the Analytic Functions.mp436.54MB
114. 17 Analytical Functions New Videos Jun 2017/117 ROW_NUMBER Analytic Function.mp413.75MB
115. 17 Analytical Functions New Videos Jun 2017/118 RANK and DENSE_RANK Analytic Functions.mp412.24MB
116. 17 Analytical Functions New Videos Jun 2017/119 LEAD LAG Analytic Functions Next Previous Values.mp417.52MB
117. 17 Analytical Functions New Videos Jun 2017/120 Windowing Clause in Analytic Functions - Part 1.mp423.85MB
118. 17 Analytical Functions New Videos Jun 2017/121 Windowing Clause in Analytic Functions - Part 2.mp419.13MB
119. 17 Analytical Functions New Videos Jun 2017/122 INTERVAL Keyword In Analytic Functions.mp49.46MB
120. 17 Analytical Functions New Videos Jun 2017/123 FIRST_VALUE and LAST_VALUE Analytic Functions...mp414.4MB
121. 17 Analytical Functions New Videos Jun 2017/124 Selecting Top-N Rows with Analytic Functions.mp47.89MB