The effectiveness of SQL queries depends on the database model, the available indexes and the type of information sought. Data analysis is the starting point for any application design using a relational database management system. Modeling, based on the entity-association model, is a simple and effective tool that is widely used by developers. See how to optimize your SQL queries for more efficient applications.
Duration
2 days
Schedule
See training dates for details
Regular fee
$955
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$860
Objectives of the training
To provide the knowledge and skills required to optimize SQL requests in order to significantly improve application performance.
Review of relational database design and normalization
Problems related to collation
The importance of table and column sizing
Operations on tables: DELETE, INSERT, UPDATE
The SELECT query and joins
Sargable vs nonsargable queries
Optimizing predicates: LIKE, BETWEEN, IN, NOT IN, EXISTS and INTERSECT
Operations on groups (GROUP BY and correlated subqueries)
Aggregation functions
Auxiliary tables
Handling views and temporary tables
Optimizing subqueries and group operations
The judicious use of indexes (for sorting and querying)
Code optimization
Cursors: when to use them and how to avoid them
Triggers
Presentation of some advanced techniques
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$860
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
By checking this box, I confirm that I have read and agree to Technologia’s Privacy Policywhich provides information on how my personal information will be used following collection. In the event that you do not consent to the terms of the concerned Privacy Policy, Technologia will not have the information to assess your request, contact you to follow up on your request or provide you with the services.
I would like Technologia to send me commercial communications.
Learn more >
By checking this box, I agree that Technologia may use my personal information to send me commercial communications. I understand that I can withdraw my consent at any time by clicking on the unsubscribe link included in each communication. To learn more about how we manage your personal information, please consult our
Technologia’s Privacy Policy.