- Course
- Data
Optimizing SQL Queries in Oracle
This course introduces SQL programmers and new Oracle database administrators to several methods to make SQL queries execute faster.
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.
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
About the author
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!