Optimizing SQL Queries in Oracle
![Pluralsight](https://static.mytechlogy.com/cache/198e0a947da0127606f2749b57b54665_w30_h30_cp_sc.png)
Pluralsight
Course Summary
This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.
-
+
Course 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.
-
+
Course Syllabus
Optimizing SQL Queries in Oracle- 22m 15s
—Introduction 0m 22s
—Course Overview 1m 36s
—Course Contents 3m 30s
—Module Contents 0m 55s
—Who Will Benefit? 1m 10s
—Database Version 0m 38s
—Data Used in Course 4m 36s
—A Comment about Tablespaces 2m 36s
—Oracle Query Optimizer 3m 27s
—Oracle and Pluralsight Resources 1m 32s
—Your Database Administrator 0m 58s
—Summary 0m 49sBasic SQL Optimization Part I- 28m 25s
—Introduction 0m 24s
—Module Contents 1m 42s
—Primary/Foreign Keys 3m 31s
—Normal Forms - Part I 6m 24s
—Normal Forms - Part II 2m 40s
—Normal Forms - Part III 3m 52s
—Primary/Foreign Keys REDUX 5m 43s
—Infrequent Columns 1m 47s
—NULLs and Space 1m 14s
—Summary 1m 3sBasic SQL Optimization Part II- 22m 41sOverview of Indexes- 25m 3sB-Tree Indexes- 30m 18sBitmap Indexes- 11m 58sAdditional Index Types- 19m 15sOverview of Partitions- 16m 3sSimple Partitions- 23m 57sComposite Partitions- 15m 43sPartition/Index Interaction- 10m 58s
This course is listed under
Development & Implementations
, Data & Information Management
and Digital Media & Games
Community
Related Posts: