- Course
Optimizing SQL Queries in Oracle
This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.
Intermediate
- Course
Optimizing SQL Queries in Oracle
This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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.
Optimizing SQL Queries in Oracle
Intermediate
Table of contents
-
Introduction | 22s
-
Course Overview | 1m 36s
-
Course Contents | 3m 30s
-
Module Contents | 55s
-
Who Will Benefit? | 1m 10s
-
Database Version | 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 | 58s
-
Summary | 49s
Scott is a statistical computer programmer specializing in SAS and SQL. An admitted dilettante, Scott occupies his time learning various programming languages such as Java, Android, C#, C, PL/SQL, R, SPSS, to name a few. Scott becomes visibly upset if you don't line up your code syntax!