FreeTutorials Us sql advanced | 50B1DD0A9A9CBA30445C61FDCDDC6AD536AA2315

FreeTutorials Us sql advanced

Name	[FreeTutorials.Us] sql-advanced	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	2.1 GB
Total Files	141
Hash	50B1DD0A9A9CBA30445C61FDCDDC6AD536AA2315

/.../002 Having The Database with Oracle VirtualBox/
Advanced-SQL-Changing-Virtual-Machine-Keyboard-Input-Settings.pdf	792.8 KB
/.../115 Using REGEX in Constraints/
Email-validation-sql-script.sql	0.2 KB
/quizzes/
001 Quiz 1.html	7.1 KB
/quizzes/
002 Quiz 2.html	13.2 KB
/quizzes/
003 Quiz 3.html	10.9 KB
/quizzes/
004 Quiz 4.html	7.5 KB
/quizzes/
005 Quiz 5.html	13.3 KB
/quizzes/
006 Quiz 6.html	12.4 KB
/quizzes/
007 Quiz 7.html	10.5 KB
/quizzes/
008 Quiz 8.html	10.0 KB
/quizzes/
009 Quiz 9.html	12.5 KB
/quizzes/
010 Quiz 10.html	13.4 KB
/quizzes/
011 Quiz 11.html	10.0 KB
/quizzes/
012 Quiz 12.html	4.9 KB
/01 Course Introduction/
001 Introduction.mp4	6.7 MB
/02 Software Installation/
002 Having The Database with Oracle VirtualBox.mp4	61.5 MB
003 Downloading and Installing Oracle Database.mp4	44.5 MB
004 HR Schema Problems Solutions.html	3.1 KB
/03 Introducing Database Objects/
005 Introducing Database Objects and Reaching Another Users Objects.mp4	26.2 MB
006 Reaching Another Users Objects.mp4	19.4 MB
007 Dont Forget to Leave a Rating.html	0.9 KB
008 Code Samples.html	24.0 KB
/04 Data Dictionary Views/
009 What Are Data Dictionary Views.mp4	3.2 MB
010 What Is There In Data Dictionary Views.mp4	2.5 MB
011 Dictionary Table.mp4	13.6 MB
012 Differences Between USER ALL DBA V Prefixes.mp4	3.9 MB
013 USER_OBJECTS ALL_OBJECTS DBA_OBJECTS Views.mp4	43.5 MB
014 USER_TABLES View.mp4	31.9 MB
015 USER_TAB_COLUMNS View.mp4	19.3 MB
016 User Constraints View.mp4	55.9 MB
017 USER_CONS_COLUMNS View.mp4	20.7 MB
018 USER_TAB_COMMENTS USER_COL_COMMENTS Views.mp4	16.3 MB
/05 Creating Using and Managing Sequences/
019 What is a Sequence and Why is It Used For.mp4	3.6 MB
020 Creating Sequences.mp4	18.3 MB
021 Modifying Sequences.mp4	8.6 MB
022 Dropping Sequences.mp4	3.8 MB
023 Using Sequences.mp4	23.5 MB
024 Using Sequences As a Default Value.mp4	11.6 MB
025 Sequence Caching.mp4	5.9 MB
026 User Sequences.mp4	8.2 MB
/06 Creating Using and Analyzing Synonyms/
027 What Is a Synonym and Why Is It Used For.mp4	6.2 MB
028 Creating Dropping Synonyms.mp4	22.5 MB
029 Using Synonyms.mp4	9.3 MB
030 Analyzing USER_SYNONYMS.mp4	13.4 MB
/07 Understanding Indexes/
031 What is an Index and Why is It Used For.mp4	7.9 MB
032 Types of Indexes.mp4	7.1 MB
033 Creating Indexes.mp4	23.5 MB
034 Creating Index on Table Creation.mp4	19.4 MB
035 Function Based Indexes.mp4	11.7 MB
036 Multiple Indexes With Same Columns.mp4	22.7 MB
037 Dropping Indexes.mp4	8.5 MB
038 USER_INDEXES and USER_IND_COLUMNS Views.mp4	22.5 MB
/08 Managing Views/
039 What is a View and Why Is It Used For.mp4	7.9 MB
040 Types Of Views.mp4	5.9 MB
041 Creating Simple Views.mp4	35.7 MB
042 Creating Complex Views.mp4	11.6 MB
043 Modifying Views.mp4	10.6 MB
044 Analyzing User Views.mp4	15.2 MB
045 Performing DML Operations with Views.mp4	22.7 MB
046 Using WITH CHECK OPTION Clause.mp4	42.0 MB
047 Preventing DML Operations on A View.mp4	9.2 MB
048 Dropping Views.mp4	5.7 MB
/09 Materialized Views/
049 What is a Materialized View and Why is it Used For.mp4	15.6 MB
050 Creating Materialized Views Part 1.mp4	19.4 MB
051 Creating Materialized Views Part 2.mp4	13.3 MB
052 Complex Materialized Views.mp4	11.5 MB
053 Types of Refreshing Materialized Views.mp4	30.3 MB
054 Refreshing Materialized Views Manually.mp4	34.0 MB
055 Scheduling Periodic Refresh of Materialized Views.mp4	6.8 MB
/10 Using Advanced Subqueries/
056 Using Subqueries as a Source.mp4	18.4 MB
057 Scalar Subqueries.mp4	26.1 MB
058 Multiple Column Subqueries.mp4	20.9 MB
059 Correlated Subqueries.mp4	12.6 MB
060 EXISTS Operator.mp4	14.1 MB
061 NOT EXISTS Operator.mp4	15.5 MB
062 Using WITH Clause.mp4	18.3 MB
063 Using Recursive WITH Clause.mp4	13.9 MB
064 Inserting Data By Using a Subquery as a Target.mp4	18.5 MB
065 Manipulating Data by Using WITH CHECK OPTION Keyword.mp4	22.2 MB
066 Correlated Delete.mp4	9.7 MB
067 Correlated Update.mp4	26.7 MB
/11 Advanced Data Manipulations/
068 Using DEFAULT Keyword on Insert And Update Statements.mp4	19.8 MB
069 Multitable Insert Statements.mp4	3.3 MB
070 Unconditional Insert Statements.mp4	17.9 MB
071 Conditional Insert Statements.mp4	23.6 MB
072 Conditional Insert First Statements.mp4	15.1 MB
073 Pivoting Insert.mp4	10.9 MB
074 Merging Data.mp4	30.5 MB
075 Flashback Operations.mp4	31.1 MB
076 Purge Operations.mp4	17.1 MB
077 Tracking Changes In Data In a Particular Time.mp4	4.0 MB
078 FLASHBACK Query.mp4	15.0 MB
079 FLASHBACK VERSIONS Query.mp4	13.5 MB
/12 Constraints Controlling Schema Objects/
080 Adding Constraints.mp4	18.3 MB
081 Removing Constraints.mp4	10.6 MB
082 On Delete CASCADE On Delete SET NULL.mp4	30.4 MB
083 Cascading Constraints.mp4	11.5 MB
084 Renaming Constraints.mp4	6.8 MB
085 Disabling Constraints.mp4	8.1 MB
086 Enabling Constraints.mp4	6.7 MB
087 Status Of Constraints.mp4	8.4 MB
088 Deferring Constraints.mp4	39.4 MB
089 Creating Temporary Tables.mp4	28.0 MB
/13 Administering User Privileges and Roles/
090 What Are Privileges And Why Are They Used For.mp4	7.9 MB
091 Creating A User.mp4	11.2 MB
092 System Privileges.mp4	10.8 MB
093 Granting System Privileges.mp4	21.6 MB
094 What is A Role and Why is It Used For.mp4	11.8 MB
095 Changing The User Password.mp4	19.3 MB
096 Object Privileges.mp4	5.0 MB
097 Granting Object Privileges.mp4	35.4 MB
098 Revoking Object Privileges.mp4	8.9 MB
099 Searching For Privileges in Data Dictionary Views.mp4	21.8 MB
/14 Hierarchical Queries Tree Structure/
100 Understanding Hierarchical Retrieval.mp4	7.9 MB
101 Generating Hierarchical Queries.mp4	10.0 MB
102 Walking On The Tree Bottom to Up - Up to Down.mp4	20.9 MB
103 Ranking Rows Using LEVEL Pseudocolumn.mp4	11.1 MB
104 Formatting Tree Structure LEVEL LPAD.mp4	11.6 MB
105 Pruning Branches Of a Tree.mp4	12.3 MB
/15 Generating Dynamic SQL Scripts/
106 Generating Scripts By Using Data Dictionary Views.mp4	22.5 MB
/16 Regular Expressions/
107 What is Regular Expressions and Why and Where Do We Use Them.mp4	6.5 MB
108 What Are Metacharacters.mp4	44.9 MB
109 Regular Expression Functions.mp4	7.8 MB
110 Using REGEXP_LIKE function.mp4	12.7 MB
111 Using REGEXP_REPLACE Function.mp4	23.1 MB
112 Using REGEXP_SUBSTR Function.mp4	17.5 MB
113 Using REGEXP_INSTR Function.mp4	15.9 MB
114 Using REGEXP_COUNT Function.mp4	12.7 MB
115 Using REGEX in Constraints.mp4	12.1 MB
/17 Analytical Functions New Videos Jun 2017/
116 What are the Analytic Functions.mp4	38.3 MB
117 ROW_NUMBER Analytic Function.mp4	14.4 MB
118 RANK and DENSE_RANK Analytic Functions.mp4	12.8 MB
119 LEAD LAG Analytic Functions Next Previous Values.mp4	18.4 MB
120 Windowing Clause in Analytic Functions - Part 1.mp4	25.0 MB
121 Windowing Clause in Analytic Functions - Part 2.mp4	20.1 MB
122 INTERVAL Keyword In Analytic Functions.mp4	9.9 MB
123 FIRST_VALUE and LAST_VALUE Analytic Functions...mp4	15.1 MB
124 Selecting Top-N Rows with Analytic Functions.mp4	8.3 MB
/18 Bonus Section/
125 Bonus Lecture Coupon Code for Become a Certified SQL Developer Course.html	2.9 KB
/
[FreeTutorials.Us].txt	0.1 KB
Freetutorials.Us.url	0.1 KB
Total files 141