Other
Udemy - SQL Tuning
-
-
- Rate this torrent + | -
Torrent info
Torrent Files List
10 HINTS to the database (Size: 648.42 MB) (Files: 67)
10 HINTS to the database
053 Why HINTS.mp4
054 Forcing a specific Join Method.mp4
055 HINTS list.pdf
11 House Keeping
056 Invalid Optimizer Statistics.mp4
057 Checking SQL statements which are performing BAD.mp4
09 Join Methods
052 Sort Merge Join.mp4
051 Hash Join.mp4
049 Join Methods.mp4
050 Nested Loop Join.mp4
12 Design Considerations
059 Separate Tablespace for Data and Index.mp4
060 Index Organized Tables.mp4
058 Effective Schema Design.mp4
061 Partitioned Tables.mp4
062 Bitmap Indexes.mp4
03 Accessing Tables
010 What is my Address.mp4
016 Choosing between FULL and INDEX scan.mp4
013 Table Access by ROWID.mp4
015 Index Range Scan.mp4
011 Types of Table Accesses.mp4
014 Index Unique Scan.mp4
012 Table Access FULL.mp4
quizzes
003 Access Paths.html
04 Explain Plan
017 Execution Plan.mp4
023 Execution Plan Example 1.mp4
018 What should you look for.mp4
021 Traversing through the Tree.mp4
026 Execution Plan Example 4.mp4
024 Execution Plan Example 2.mp4
022 Reading Execution Plan.mp4
020 Rules of Execution Plan Tree.mp4
019 What is COST.mp4
025 Execution Plan Example 3.mp4
06 Index Suppression
033 Use of Arithmetic operators.mp4
030 Index Suppression reasons.mp4
031 Use of operator.mp4
035 Use of operator.mp4
036 Comparing a character column to a numeric value.mp4
037 Use of IS NULL and IS NOT NULL.mp4
032 Use of SUBSTR function.mp4
quizzes
005 Index Suppression SQL.html
038 Function based Indexes.mp4
034 Use of TRUNC function on Date columns.mp4
02 Optimizer and its Execution Plan
005 Cost based Optimization.mp4
007 Execution Plan.mp4
008 SQL Tuning Tools.mp4
009 Running Explain Plan.mp4
quizzes
002 Optimizer statistics.html
006 Gathering Statistics.mp4
05 Simple Tuning Rules
027 SELECT consideration.mp4
028 Using Table Aliases.mp4
029 Using WHERE rather than HAVING.mp4
quizzes
004 Simple Rules.html
01 SQL Tuning Introduction
004 SOFT parse vs HARD parse.mp4
003 SQL Processing.mp4
002 Prerequisites for SQL Tuning.mp4
001 Why SQL Tuning.mp4
quizzes
001 Parsing.html
08 Considerations while using SQL in programming
048 Using BULK COLLECT.mp4
046 Reduce the number of Trips to the database.mp4
047 Issue frequent COMMIT statements.mp4
07 Performance Improvement Considerations
043 Use EXISTS instead of DISTINCT.mp4
039 Use UNION instead of OR.mp4
042 EXISTS vs IN.mp4
040 Use UNION ALL instead of UNION.mp4
045 Use TRUNCATE instead of DELETE.mp4
044 Reading same table multiple times.mp4
041 Minimize Table lookups in a Query.mp4
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch Udemy - SQL Tuning Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
