{"id":1414,"date":"2016-11-13T06:51:27","date_gmt":"2016-11-13T06:51:27","guid":{"rendered":"http:\/\/www.quartzbd.com\/?post_type=product&p=1414"},"modified":"2016-11-13T06:51:27","modified_gmt":"2016-11-13T06:51:27","slug":"pluralsight-optimizing-sql-queries-in-oracle","status":"publish","type":"product","link":"http:\/\/www.quartzbd.com\/?product=pluralsight-optimizing-sql-queries-in-oracle","title":{"rendered":"Pluralsight Optimizing SQL Queries in Oracle"},"content":{"rendered":"

\"pluralsight-optimizing-sql-queries-in-oracle\"<\/a><\/p>\n

Pluralsight Optimizing SQL Queries in Oracle – DVD<\/span><\/p>\n

Optimizing SQL Queries in Oracle<\/p>\n

Introduction<\/p>\n

Course Overview<\/p>\n

Course Contents<\/p>\n

Module Contents<\/p>\n

Who Will Benefit?<\/p>\n

Database Version<\/p>\n

Data Used in Course<\/p>\n

A Comment about Tablespaces<\/p>\n

Oracle Query Optimizer<\/p>\n

Oracle and Pluralsight Resources<\/p>\n

Your Database Administrator<\/p>\n

Summary<\/p>\n

Basic SQL Optimization Part I<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

Primary\/Foreign Keys<\/p>\n

Normal Forms – Part I<\/p>\n

Normal Forms – Part II<\/p>\n

Normal Forms – Part III<\/p>\n

Primary\/Foreign Keys REDUX<\/p>\n

Infrequent Columns<\/p>\n

NULLs and Space<\/p>\n

Summary<\/p>\n

Basic SQL Optimization Part II<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

Neaten Up SQL Code<\/p>\n

Restrict Columns\/Rows<\/p>\n

INTERSECT vs. INNER JOIN<\/p>\n

MINUS vs. JOIN<\/p>\n

Correlated Subqueries<\/p>\n

IN vs. EXISTS<\/p>\n

Multi-Column IN vs. ANDs\/ORs<\/p>\n

The WITH Clause<\/p>\n

The APPEND Hint<\/p>\n

ON Clause vs. WHERE Clause<\/p>\n

Order of Tables on FROM Clause<\/p>\n

Cartesian Products<\/p>\n

Summary<\/p>\n

Overview of Indexes<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

What is an Index?<\/p>\n

B-Tree Indexes<\/p>\n

Bitmap Indexes<\/p>\n

Function-Based Indexes<\/p>\n

Index-Organized Tables<\/p>\n

Bitmap Join Indexes<\/p>\n

Gathering Statistics<\/p>\n

Index\/Partition Interaction<\/p>\n

Example<\/p>\n

Summary<\/p>\n

B-Tree Indexes<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

What is a B-Tree Index?<\/p>\n

When do you use a B-Tree Index?<\/p>\n

Creating a B-Tree Index<\/p>\n

Listing the Indexes on a Table<\/p>\n

Dropping a B-Tree Index<\/p>\n

Gathering Statistics<\/p>\n

Is my Index Being Used?<\/p>\n

Summary<\/p>\n

Bitmap Indexes<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

What is a Bitmap Index?<\/p>\n

When do you use a Bitmap Index?<\/p>\n

Creating a Bitmap Index<\/p>\n

Dropping a Bitmap Index<\/p>\n

Is my Index Being Used?<\/p>\n

Summary<\/p>\n

Additional Index Types<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

Function-Based Indexes<\/p>\n

Bitmap Join Indexes<\/p>\n

Index-Organized Tables<\/p>\n

Summary<\/p>\n

Overview of Partitions<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

What is a Partition?<\/p>\n

Varieties of Partitions<\/p>\n

Partition-Wise Joins<\/p>\n

Partition\/Index Interaction<\/p>\n

Examples<\/p>\n

Summary<\/p>\n

Simple Partitions<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

What is a List Partition?<\/p>\n

Creating a List Partition<\/p>\n

Examples of List Partitions<\/p>\n

Adding to a List Partition<\/p>\n

Dropping a List Partition<\/p>\n

What is a Range Partition?<\/p>\n

Creating a Range Partition<\/p>\n

Examples of Range Partitions<\/p>\n

Adding to a Range Partition<\/p>\n

Dropping a Range Partition<\/p>\n

Summary<\/p>\n

Composite Partitions<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

What is a Composite Partition?<\/p>\n

Varieties of Composite Partitions<\/p>\n

Example #1 – List\/List<\/p>\n

Example #2 – Range\/List<\/p>\n

Example #3 – AUTOTRACE<\/p>\n

Summary<\/p>\n

Partition\/Index Interaction<\/strong><\/p>\n

Introduction<\/p>\n

Module Contents<\/p>\n

Partition\/Index Interaction<\/p>\n

Global Non-Partitioned Indexes<\/p>\n

Local Partitioned Indexes<\/p>\n

Changes in Partitions Affect Indexes<\/p>\n

Summary<\/p>\n","protected":false},"excerpt":{"rendered":"

Delivery system
\n===============
\nFace to face from our office
\nDownload from Dropbox link
\nCourier Service<\/p>\n

Payment system
\n==============
\nFace to Face
\nbkash-01716197088 ( Personal )<\/p>\n

Contact
\n========
\n01919197088
\n01716197088-bkash ( Personal )
\n01552551768-office
\nqrtzcom@gmail.com
\nFreelancer.com profile page: https:\/\/www.freelancer.com.bd\/u\/qrtzcom.html
\nwww.quartzbd.com
\nwww.facebook.com\/quartz.bd
\nskype: quartzcom<\/p>\n","protected":false},"featured_media":1415,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_cat":[227,54,58,66,68],"product_tag":[],"class_list":{"0":"post-1414","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-june-2016","7":"product_cat-all-video-tutorials","8":"product_cat-pluralsight","9":"product_cat-oracle","10":"product_cat-oracle-video-tutorials","12":"first","13":"instock","14":"shipping-taxable","15":"purchasable","16":"product-type-simple"},"_links":{"self":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/product\/1414"}],"collection":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/product"}],"about":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1414"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/media\/1415"}],"wp:attachment":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1414"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_cat&post=1414"},{"taxonomy":"product_tag","embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_tag&post=1414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}