Oracle Training – SQL Courses
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
2 Days
-
Start date
Different dates available
Delegate pack consisting of course notes and exercises Manual Experienced Instructor Refreshments
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- Management
- Server
- MySQL
- IT
- Database
- SQL
- Database training
- Performance
- IT Management
Course programme
Introduction
Delegates attending this 2-day tutor led training course will get a comprehensive overview of how to write optimal SQL and the key aspects of database troubleshooting & tuning.
Pre-Requisites
There are no pre-requisites for this course.
Who Should Attend
This course is intended for database administrators, database designers and PL/SQL developers.
Course Objectives
Upon completion of this course, candidates should gain knowledge on:
The importance of being able to see the SQL business function & make the SQL easy to read
- How the data volumes and distribution have an important contribution to write efficient SQL
- A strategy for first-cut design of new SQL, and debugging of existing SQL
- Where and why it may be necessary to control the SQL using hints
Course Outline
- Improving performance of a production system
- Attacking inefficient SQL
- Designing a system
- Troubleshooting
- Tuning
- Strategies
- Summary of what the delegates have learned
Additional information
- Gain an understanding of the skills required to produce a well-tuned system
- Identify strategies for dealing with badly performing systems
- Develop knowledge on most commonly occurring issues that affect performance
- Candidates will be able to fix problems once a system has gone into production
- GUARANTEED LOWEST PRICE IN THE INDUSTRY
- Courses delivered by world class training instructors in luxury venues
- Includes material and manuals
- Book Online or Call 01344 203999 to speak to a training advisor today
Oracle Training – SQL Courses