Home
All courses
Free Oracle DBA Tutorials
Oracle Database SQL Tuning with Constraints

Oracle Database SQL Tuning with Constraints

Teacher

Categories

Free Oracle DBA Tutorials, Free Oracle Developer Tutorials

Review

No reviews yet.

Free

Learn how to tune SQL – especially in a data warehouse – with CONSTRAINTS. Constraints provide critical information to the Cost Based Optimizer in the Oracle Database. Don’t drop your constraints for query performance! In these 5 lessons, Oracle Certified Master DBA John Watson will demonstrate how constraints – unique, foreign key, not null – improve the execution plan and thus performance of SQL in an Oracle database.

Course Features

Lectures 6
Quizzes 0
Duration 50 hours
Skill level All levels
Language English
Students 0
Certificate No
Assessments Yes

Tutorial Lessons
6
- Lecture1.1
  Agenda
- Lecture1.2
  Introduction 01 min
- Lecture1.3
  SQL Tuning with Foreign Key Constraints 03 min
- Lecture1.4
  SQL Tuning with NOT NULL Constraints 02 min
- Lecture1.5
  SQL Tuning with Unique Constraints 02 min
- Lecture1.6
  Conclusion and Key Takeaways 01 min

https://skillbuilders.com/our_team/john-watson/

Leave A Review

Please provide as much detail as you can to justify your rating and to help others.

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!