Users Online
· Guests Online: 4
· Members Online: 0
· Total Members: 185
· Newest Member: meenachowdary055
· Members Online: 0
· Total Members: 185
· Newest Member: meenachowdary055
Forum Threads
Newest Threads
No Threads created
Hottest Threads
No Threads created
Latest Articles
DEMO - Optimizing Oracle SQL
DEMO - Optimizing Oracle SQLDatabase Courses |
| Categories | Most Recent | Top Rated | Popular Courses |
 | Uploader | Date Added | Views | Rating |
| Superadmin | 14.03.16 | 713 | No Rating | |
| Description | ||||
| This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster, such as transforming your data to normal form, using more efficient SQL code, and using indexes, as well as how to work with partitions using SQL. Lesson Description Section 1 Optimizing SQL Queries in Oracle Lesson 01 Introduction Lesson 02 Course Overview Lesson 03 Course Contents Lesson 04 Module Contents Lesson 05 Who Will Benefit? Lesson 06 Database Version Lesson 07 Data Used in Course Lesson 08 A Comment about Tablespaces Lesson 09 Oracle Query Optimizer Lesson 10 Oracle and Pluralsight Resources Lesson 11 Your Database Administrator Lesson 12 Summary Section 2 Basic SQL Optimization Part I Lesson 13 Introduction Lesson 14 Module Contents Lesson 15 Primary/Foreign Keys Lesson 16 Normal Forms - Part I Lesson 17 Normal Forms - Part II Lesson 18 Normal Forms - Part III Lesson 19 Primary/Foreign Keys REDUX Lesson 20 Infrequent Columns Lesson 21 NULLs and Space Lesson 22 Summary Section 3 Basic SQL Optimization Part II Lesson 23 Introduction Lesson 24 Module Contents Lesson 25 Neaten Up SQL Code Lesson 26 Restrict Columns/Rows Lesson 27 INTERSECT vs. INNER JOIN Lesson 28 MINUS vs. JOIN Lesson 29 Correlated Subqueries Lesson 30 IN vs. EXISTS Lesson 31 Multi-Column IN vs. ANDs/ORs Lesson 32 The WITH Clause Lesson 33 The APPEND Hint Lesson 34 ON Clause vs. WHERE Clause Lesson 35 Order of Tables on FROM Clause Lesson 36 Cartesian Products Lesson 37 Summary Section 4 Overview of Indexes Lesson 38 Introduction Lesson 39 Module Contents Lesson 40 What is an Index? Lesson 41 B-Tree Indexes Lesson 42 Bitmap Indexes Lesson 43 Function-Based Indexes Lesson 44 Index-Organized Tables Lesson 45 Bitmap Join Indexes Lesson 46 Gathering Statistics Lesson 47 Index/Partition Interaction Lesson 48 Example Lesson 49 Summary Section 5 B-Tree Indexes Lesson 50 Introduction Lesson 51 Module Contents Lesson 52 What is a B-Tree Index? Lesson 53 When do you use a B-Tree Index? Lesson 54 Creating a B-Tree Index Lesson 55 Listing the Indexes on a Table Lesson 56 Dropping a B-Tree Index Lesson 57 Gathering Statistics Lesson 58 Is my Index Being Used? Lesson 59 Summary Section 6 Bitmap Indexes Lesson 60 Introduction Lesson 61 Module Contents Lesson 62 What is a Bitmap Index? Lesson 63 When do you use a Bitmap Index? Lesson 64 Creating a Bitmap Index Lesson 65 Dropping a Bitmap Index Lesson 66 Is my Index Being Used? Lesson 67 Summary Section 7 Additional Index Types Lesson 68 Introduction Lesson 69 Module Contents Lesson 70 Function-Based Indexes Lesson 71 Bitmap Join Indexes Lesson 72 Index-Organized Tables Lesson 73 Summary Section 8 Overview of Partitions Lesson 74 Introduction Lesson 75 Module Contents Lesson 76 What is a Partition? Lesson 77 Varieties of Partitions Lesson 78 Partition-Wise Joins Lesson 79 Partition/Index Interaction Lesson 80 Examples Lesson 81 Summary Section 9 Simple Partitions Lesson 82 Introduction Lesson 83 Module Contents Lesson 84 What is a List Partition? Lesson 85 Creating a List Partition Lesson 86 Examples of List Partitions Lesson 87 Adding to a List Partition Lesson 88 Dropping a List Partition Lesson 89 What is a Range Partition? Lesson 90 Creating a Range Partition Lesson 91 Examples of Range Partitions Lesson 92 Adding to a Range Partition Lesson 93 Dropping a Range Partition Lesson 94 Summary Section 10 Composite Partitions Lesson 95 Introduction Lesson 96 Module Contents Lesson 97 What is a Composite Partition? Lesson 98 Varieties of Composite Partitions Lesson 99 Example #1 - List/List Lesson 100 Example #2 - Range/List Lesson 101 Example #3 - AUTOTRACE Lesson 102 Summary Section 11 Partition/Index Interaction Lesson 103 Introduction Lesson 104 Module Contents Lesson 105 Partition/Index Interaction Lesson 106 Global Non-Partitioned Indexes Lesson 107 Local Partitioned Indexes Lesson 108 Changes in Partitions Affect Indexes Lesson 109 Summary | ||||
Ratings
Comments
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.